Field
|
Name
|
M
|
Type
|
Description
|
CardCode
|
Card Code
|
X
|
nvarchar(15)
|
|
CardType
|
Card Type
|
|
char(1)
|
|
CardName
|
Name
|
|
nvarchar(100)
|
|
CardFName
|
Foreign name
|
|
nvarchar(100)
|
|
GroupCode
|
Group
|
|
smallint(2)
|
|
Currency
|
Currency
|
|
nvarchar(3)
|
|
LicTradNum
|
Federal tax ID
|
|
nvarchar(32)
|
|
Balance
|
Account balance
|
|
numeric(4)
|
|
DNotesBal
|
Goods receipt POs
|
|
numeric(4)
|
|
OrdersBal
|
Purchase orders
|
|
numeric(4)
|
|
Phone1
|
Phone 1
|
|
nvarchar(20)
|
|
Phone2
|
Phone 2
|
|
nvarchar(20)
|
|
Cellular
|
Cellular
|
|
nvarchar(50)
|
|
Fax
|
Fax
|
|
nvarchar(20)
|
|
E_Mail
|
E_Mail
|
|
nvarchar(100)
|
|
IntrntSite
|
Web site
|
|
nvarchar(100)
|
|
ShipType
|
Shipping type
|
|
smallint(2)
|
|
PASSWORD
|
Password
|
|
nvarchar(32)
|
|
Indicator
|
Factoring indicator
|
|
nvarchar(2)
|
|
ProjectCod
|
BP Project
|
|
nvarchar(20)
|
|
IndustryC
|
Industry
|
|
int(4)
|
|
CmpPrivate
|
Business partner type
|
|
char(1)
|
|
CntctPrsn
|
Contact person
|
|
nvarchar(90)
|
|
AddID
|
ID No. 2
|
|
nvarchar(64)
|
|
Notes
|
Notes
|
|
nvarchar(100)
|
|
SlpCode
|
Buyer
|
|
int(4)
|
|
AliasName
|
Alias Name
|
|
ntext(8)
|
|
GlblLocNum
|
GLN
|
|
nvarchar(50)
|
|
ValidFrom
|
Active from
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ValidTo
|
Active to
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ValidComm
|
Active remarks
|
|
nvarchar(30)
|
|
frozenFrom
|
Inactive from
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
frozenTo
|
Inactive to
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
FrozenComm
|
Inactive remarks
|
|
nvarchar(30)
|
|
BlockComm
|
Block Sending Marketing content
|
|
char(1)
|
|
Address
|
Address
|
|
nvarchar(100)
|
|
StreetNo
|
StreetNo
|
|
nvarchar(100)
|
|
Block
|
Block
|
|
nvarchar(100)
|
|
City
|
City
|
|
nvarchar(100)
|
|
ZipCode
|
Zip Code
|
|
nvarchar(20)
|
|
County
|
County
|
|
nvarchar(100)
|
|
State1
|
State1
|
|
nvarchar(3)
|
|
State2
|
State2
|
|
nvarchar(3)
|
|
Country
|
Country
|
|
nvarchar(3)
|
|
Building
|
Building / Floor / Room
|
|
ntext(8)
|
|
GroupNum
|
Payment terms
|
|
smallint(2)
|
|
IntrstRate
|
Interest on Arrears %
|
|
numeric(4)
|
|
ListNum
|
Price list
|
|
smallint(2)
|
|
DISCOUNT
|
Total discount %
|
|
numeric(4)
|
|
CreditLine
|
Credit limit
|
|
numeric(4)
|
|
DebtLine
|
Commitment limit
|
|
numeric(4)
|
|
DunTerm
|
DunTerm
|
|
nvarchar(25)
|
|
DiscRel
|
Effective discount groups
|
|
char(1)
|
|
BankCountr
|
Bank country
|
|
nvarchar(3)
|
|
BankCode
|
Bank name
|
|
nvarchar(30)
|
|
DflAccount
|
Account
|
|
nvarchar(50)
|
|
DflSwift
|
BIC / SWIFT code
|
|
nvarchar(50)
|
|
DflBranch
|
Branch
|
|
nvarchar(50)
|
|
BankCtlKey
|
Ctrl. Int. ID
|
|
nvarchar(2)
|
|
DflIBAN
|
IBAN
|
|
nvarchar(50)
|
|
MandateID
|
Mandate ID
|
|
nvarchar(35)
|
|
SignDate
|
Date of signature
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
CreditCard
|
Credit Card
|
|
smallint(2)
|
|
CrCardNum
|
CrCardNum
|
|
nvarchar(64)
|
|
CardValid
|
CardValid
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
OwnerIdNum
|
OwnerIdNum
|
|
nvarchar(15)
|
|
OwnerCode
|
OwnerCode
|
|
int(4)
|
|
AvrageLate
|
Average delay
|
|
smallint(2)
|
|
priority
|
Priority
|
|
int(4)
|
|
IBAN
|
Default IBAN
|
|
nvarchar(50)
|
|
HldCode
|
Holidays
|
|
nvarchar(20)
|
|
PartDelivr
|
Allow partial delivery of Sales Order
|
|
char(1)
|
|
BackOrder
|
Allow partial delivery per row
|
|
char(1)
|
|
NoDiscount
|
Do not apply discount groups
|
|
char(1)
|
|
HousBnkCry
|
House bank - Country
|
|
nvarchar(3)
|
|
HouseBank
|
House bank - Bank
|
|
nvarchar(30)
|
|
HousBnkAct
|
House bank - Account
|
|
nvarchar(50)
|
|
HousBnkBrn
|
House bank - Branch
|
|
nvarchar(50)
|
|
HsBnkIBAN
|
House bank - IBAN
|
|
nvarchar(50)
|
|
HsBnkSwift
|
House bank - Swift
|
|
nvarchar(50)
|
|
HousCtlKey
|
House bank - Control No.
|
|
nvarchar(2)
|
|
PaymBlock
|
Payment block
|
|
char(1)
|
|
PyBlckDesc
|
Payment block description
|
|
int(4)
|
|
SinglePaym
|
Single payment
|
|
char(1)
|
|
BCACode
|
Bank charges allocation code
|
|
nvarchar(3)
|
|
FatherCard
|
Consolidating BP
|
|
nvarchar(15)
|
|
FatherType
|
Consolidation Type
|
|
char(1)
|
|
BlockDunn
|
BlockDunn
|
|
char(1)
|
|
FormCode
|
1099 Form
|
|
int(4)
|
|
Box1099
|
1099 Box
|
|
nvarchar(20)
|
|
ConnBP
|
Connected customer
|
|
nvarchar(15)
|
|
PlngGroup
|
Planning group
|
|
nvarchar(10)
|
|
Affiliate
|
Affiliate
|
|
char(1)
|
|
Free_Text
|
Remarks
|
|
ntext(8)
|
|
VatStatus
|
VatStatus
|
|
char(1)
|
|
MailZipCod
|
Mail zip code
|
|
nvarchar(20)
|
|
ValidUntil
|
Deduction valid until
|
|
datetime(8)
|
|
OrderBalFC
|
Open orders balance
|
|
numeric(4)
|
|
Commission
|
Commission percent
|
|
numeric(4)
|
|
CommGrCode
|
Commission group code
|
|
smallint(2)
|
|
RateDifAct
|
Rate Diff Account
|
|
nvarchar(15)
|
|
MailCounty
|
Mail county
|
|
nvarchar(100)
|
|
DdctOffice
|
Deduction office
|
|
nvarchar(10)
|
|
DscntRel
|
Discount Relations
|
|
char(1)
|
|
DscntObjct
|
Discount base object
|
|
smallint(2)
|
|
MinIntrst
|
Min interest
|
|
numeric(4)
|
|
OprCount
|
Open oportunities
|
|
int(4)
|
|
ExemptNo
|
Exempt number
|
|
nvarchar(50)
|
|
ValidFor
|
Active for
|
|
char(1)
|
|
frozenFor
|
Inactive for
|
|
char(1)
|
|
DdgKey
|
Withholding tax deduction group
|
|
int(4)
|
|
DebPayAcct
|
Account Recivable Payables
|
|
nvarchar(15)
|
|
ShipToDef
|
Ship to default
|
|
nvarchar(50)
|
|
MailBlock
|
Mail Address
|
|
nvarchar(100)
|
|
DunnLevel
|
Dunning level
|
|
int(4)
|
|
DunnDate
|
Dunning date
|
|
datetime(8)
|
|
CollecAuth
|
Collection authorization
|
|
char(1)
|
|
InstrucKey
|
Instruction key
|
|
nvarchar(30)
|
|
ISRBillId
|
ISR Biller ID
|
|
nvarchar(9)
|
|
RefDetails
|
Reference details
|
|
nvarchar(20)
|
|
DeferrTax
|
Deferred tax
|
|
char(1)
|
|
LetterNum
|
Tax exemption letter number
|
|
nvarchar(50)
|
|
MaxAmount
|
Max amount of exemption
|
|
numeric(4)
|
|
WTLiable
|
Subject to withholding tax
|
|
char(1)
|
|
CrtfcateNO
|
Crtfcate number
|
|
nvarchar(20)
|
|
AccCritria
|
Accrual criteria
|
|
char(1)
|
|
Equ
|
Equalization
|
|
char(1)
|
|
TypWTReprt
|
Type report
|
|
char(1)
|
|
OtrCtlAcct
|
Other receivable payable
|
|
nvarchar(15)
|
|
MailBuildi
|
Ship to building floor room
|
|
ntext(8)
|
|
BoEDiscnt
|
Customer bill of exchange Discount
|
|
nvarchar(15)
|
|
BoEOnClct
|
Bill of exchange on collection
|
|
nvarchar(15)
|
|
DfTcnician
|
Default technician
|
|
int(4)
|
|
BillToDef
|
Bill to default
|
|
nvarchar(50)
|
|
DpmClear
|
Down payment clear act
|
|
nvarchar(15)
|
|
LangCode
|
Language code
|
|
int(4)
|
|
CDPNum
|
Closing date procedure number
|
|
smallint(2)
|
|
DflBankKey
|
Default bank code
|
|
int(4)
|
|
RegNum
|
Company registration number
|
|
nvarchar(32)
|
|
VerifNum
|
Verification number
|
|
nvarchar(32)
|
|
InsurOp347
|
Insurance operation 347
|
|
char(1)
|
|
ThreshOver
|
Threshold overlook
|
|
char(1)
|
|
SurOver
|
Surcharge overlook
|
|
char(1)
|
|
OpCode347
|
Operation code 347
|
|
char(1)
|
|
SefazReply
|
SefazReply
|
|
nvarchar(254)
|
|
SefazDate
|
SefazDate
|
|
datetime(8)
|
|
U_beas_spr
|
U_beas_spr
|
|
nvarchar(20)
|
|
U_ECNA_001
|
U_ECNA_001
|
|
nvarchar(10)
|
|
U_XXX
|
U_XXX
|
|
nvarchar(10)
|
|