|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BLWIGroup_ID
|
BLWI Group
|
|
9999999999
|
|
|
|
BusinessRelation_ID
|
Name
|
|
9999999999
|
|
|
|
CnControlGLProfile_ID
|
Control GL Profile (Credit Note)
|
|
9999999999
|
|
|
|
Creditor_ID
|
Record ID
|
|
9999999999
|
|
|
|
CreditorBirthCity
|
Birth City
|
|
x(20)
|
|
|
|
CreditorBirthDate
|
Birth Date
|
|
99/99/9999
|
|
|
|
CreditorCocNumber
|
Chamber of Commerce Number
|
|
x(8)
|
|
|
|
CreditorCode
|
Supplier Code
|
Supplier
|
x(8)
|
|
|
|
CreditorCommentNote
|
Comment Note
|
|
x(2000)
|
|
|
|
CreditorDBNumber
|
Credit Agency Reference
|
|
x(16)
|
|
|
|
CreditorDebtorNumber
|
External Customer Number
|
|
x(10)
|
|
|
|
CreditorForeignFiscalCode
|
Foreign Fiscal Code
|
|
x(18)
|
|
|
|
CreditorIsActive
|
Active
|
|
yes/no
|
|
|
|
CreditorIsBearBankCharge
|
Pays Bank Charge
|
|
yes/no
|
|
|
|
CreditorIsIndividualPaymnt
|
Individual Payments
|
|
yes/no
|
|
|
|
CreditorIsSendRemittance
|
Send Remittance
|
|
yes/no
|
|
|
|
CreditorIsTaxable
|
Taxable Supplier
|
|
yes/no
|
|
|
|
CreditorIsTaxConfirmed
|
Tax Confirmed
|
|
yes/no
|
|
|
|
CreditorIsTaxInCity
|
Tax in City
|
|
yes/no
|
|
|
|
CreditorIsTaxIncluded
|
Tax Is Included
|
|
yes/no
|
|
|
|
CreditorIsTaxReport
|
Tax Report
|
|
yes/no
|
|
|
|
CreditorIsWHT
|
Withholding Tax
|
|
yes/no
|
|
|
|
CreditorTaxDeclaration
|
Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
CreditorTaxIDFederal
|
Federal Tax
|
|
x(18)
|
|
|
|
CreditorTaxIDFiscalCode
|
Tax ID / Fiscal Code
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc1
|
Miscellaneous Tax 1
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc2
|
Miscellaneous Tax 2
|
|
x(18)
|
|
|
|
CreditorTaxIDMisc3
|
Miscellaneous Tax 3
|
|
x(18)
|
|
|
|
CreditorTaxIDState
|
State Tax
|
|
x(18)
|
|
|
|
CreditorTIDNotice
|
TID Notice
|
|
x(1)
|
|
|
|
CreditorType_ID
|
Supplier Type
|
|
9999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate5
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate6
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate7
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate8
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate9
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal5
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal6
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal7
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal8
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal9
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DeliveryCond_ID
|
Link to DeliveryCond
|
|
9999999999
|
|
|
|
DivisionProfile_ID
|
Sub-Account Profile
|
|
9999999999
|
|
|
|
FinChgGLProfile_ID
|
Finance Charge GL Profile ID
|
|
9999999999
|
|
|
|
InvControlGLProfile_ID
|
Control GL Profile (Invoice)
|
|
9999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
NormalPaymentCondition_ID
|
Credit Terms
|
|
9999999999
|
|
|
|
PaymentGroup_ID
|
Payment Group
|
|
9999999999
|
|
|
|
PrePayControlGLProfile_ID
|
Control GL Profile (Pre-payment)
|
|
9999999999
|
|
|
|
PurchaseCode_ID
|
Link to PurchaseCode
|
|
9999999999
|
|
|
|
PurchaseGLProfile_ID
|
Purchases Account GL Profile
|
|
9999999999
|
|
|
|
PurchaseType_ID
|
Purchase Type
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reason_ID
|
Invoice Status Code
|
|
9999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
9999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
TxzTaxZone
|
Tax Zone
|
|
x(16)
|
|
|
|
VatDeliveryType
|
Tax Nature
|
|
x(20)
|
|
|
|
VatPercentageLevel
|
Tax Level
|
|
x(20)
|
|
|
|
WHTCertFormat_ID
|
Link to Withholding Tax Certificate Format
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankChrgIdx
|
no
|
CreditorIsBearBankCharge
|
yes
|
no
|
|
|
CnGLControl
|
no
|
CnControlGLProfile_ID
|
yes
|
no
|
|
|
Code
|
no
|
CreditorCode
|
yes
|
no
|
|
|
CreditorTax
|
no
|
CreditorTaxIDFederal
|
yes
|
no
|
|
|
|
|
CreditorIsTaxReport
|
yes
|
no
|
|
|
CreditorType
|
no
|
CreditorType_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DelCondIdx
|
no
|
DeliveryCond_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
DivisionProfile_ID
|
yes
|
no
|
|
|
FinChgIdx
|
no
|
FinChgGLProfile_ID
|
yes
|
no
|
|
|
InvGLControl
|
no
|
InvControlGLProfile_ID
|
yes
|
no
|
|
|
IsWHT
|
no
|
CreditorIsWHT
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
NormPayCondIdx
|
no
|
NormalPaymentCondition_ID
|
yes
|
no
|
|
|
PaymentGroup
|
no
|
PaymentGroup_ID
|
yes
|
no
|
|
|
PrePayProfile
|
no
|
PrePayControlGLProfile_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Creditor_ID
|
yes
|
no
|
|
|
PurchCodeIdx
|
no
|
PurchaseCode_ID
|
yes
|
no
|
|
|
PurchGLIdx
|
no
|
PurchaseGLProfile_ID
|
yes
|
no
|
|
|
PurchTypeIdx
|
no
|
PurchaseType_ID
|
yes
|
no
|
|
|
ReasonIdx
|
no
|
Reason_ID
|
yes
|
no
|
|
|
Relation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CreditorCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
CreditorIsActive
|
yes
|
no
|
|
|
|
|
CreditorCode
|
yes
|
no
|
|
|
WHTCert
|
no
|
WHTCertFormat_ID
|
yes
|
no
|