|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BillSchedule_ID
|
Link to BillSchedule
|
|
9999999999
|
|
|
|
BillToDebtor_ID
|
Bill-To Customer
|
Bill-To
|
9999999999
|
|
|
|
BLWIGroup_ID
|
BLWI Group Code
|
BLWI Group
|
9999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
Business Relation Code
|
9999999999
|
|
|
|
CnControlGLProfile_ID
|
Control GL Profile (Credit Note)
|
|
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)
|
|
|
|
Debtor_ID
|
Record ID
|
|
9999999999
|
|
|
|
DebtorCode
|
Customer Code
|
|
x(8)
|
|
|
|
DebtorCommentNote
|
Comment Note
|
|
x(2000)
|
|
|
|
DebtorCreditRating_ID
|
Credit Rating
|
|
9999999999
|
|
|
|
DebtorDBNumber
|
Credit Agency Reference
|
Credit Agency Ref
|
x(12)
|
|
|
|
DebtorFixedCredLimTC
|
Fixed Credit Limit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorHighCredit
|
High Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorHighCreditDate
|
High Credit Date
|
|
99/99/9999
|
|
|
|
DebtorIsActive
|
Active
|
|
yes/no
|
|
|
|
DebtorIsCheckAftDICredLim
|
Calculate after Invoice Entry
|
|
yes/no
|
|
|
|
DebtorIsCheckAftSOCredLim
|
Calculate after Order Entry
|
|
yes/no
|
|
|
|
DebtorIsCheckBefDICredLim
|
Calculate before Invoice Entry
|
|
yes/no
|
|
|
|
DebtorIsCheckBefSOCredLim
|
Calculate before Order Entry
|
|
yes/no
|
|
|
|
DebtorIsFinanceCharge
|
Finance Charge
|
|
yes/no
|
|
|
|
DebtorIsFixedCredLim
|
Apply Fixed Ceiling
|
|
yes/no
|
|
|
|
DebtorIsInclDraftCredLim
|
Include Drafts
|
|
yes/no
|
|
|
|
DebtorIsInclOpenItmCredLim
|
Include Open Items
|
|
yes/no
|
|
|
|
DebtorIsInclSOCredLim
|
Include Sales Orders
|
|
yes/no
|
|
|
|
DebtorIsInvoiceByAuth
|
Invoice by Authorization
|
|
yes/no
|
|
|
|
DebtorIsLockedCredLim
|
Credit Hold
|
|
yes/no
|
|
|
|
DebtorIsMaxDaysDueCredLim
|
Maximum Days Overdue
|
|
yes/no
|
|
|
|
DebtorIsOverruleDICredLim
|
Overrule Allowed
|
|
yes/no
|
|
|
|
DebtorIsOverruleSOCredLim
|
Overrule Allowed
|
|
yes/no
|
|
|
|
DebtorIsPrintBillWithItemDet
|
Bill With Item Details
|
|
yes/no
|
|
|
|
DebtorIsPrintReminder
|
Print Reminder
|
|
yes/no
|
|
|
|
DebtorIsPrintStatement
|
Print Statement
|
|
yes/no
|
|
|
|
DebtorIsTaxable
|
Taxable Customer
|
|
yes/no
|
|
|
|
DebtorIsTaxInCity
|
Tax in City
|
|
yes/no
|
|
|
|
DebtorIsTaxIncluded
|
Tax Is Included
|
|
yes/no
|
|
|
|
DebtorIsToBeLockedCredLim
|
Credit Hold on Overrun
|
|
yes/no
|
|
|
|
DebtorIsTurnOverCredLim
|
Apply % of Turnover
|
|
yes/no
|
|
|
|
DebtorIsWithPreInvGroup
|
Customer is Member of Pre-Invoice Group
|
|
yes/no
|
|
|
|
DebtorLastCreditReview
|
Last Credit Review
|
|
99/99/9999
|
|
|
|
DebtorLastCreditUpdate
|
Last Credit Update
|
|
99/99/9999
|
|
|
|
DebtorLastFinChargeDate
|
Last Finance Charge Date
|
|
99/99/9999
|
|
|
|
DebtorLastPayment
|
Last Payment Date
|
|
99/99/9999
|
|
|
|
DebtorLastSale
|
Last Sale Date
|
|
99/99/9999
|
|
|
|
DebtorMaxNumDaysCredLim
|
Maximum Number of Days
|
|
>>9
|
|
|
|
DebtorPercTurnOverCredLim
|
Percentage of Turnover
|
|
->,>>>,>>9.99
|
2
|
|
|
DebtorPercWarningCredLim
|
Warning Ceiling %
|
|
->,>>>,>>9.99
|
2
|
|
|
DebtorSalesOrderBalance
|
Sales Order Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorStatementCycle
|
Statement Cycle
|
|
x(4)
|
|
|
|
DebtorTaxDeclaration
|
Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
DebtorTaxIDFederal
|
Federal Tax
|
|
x(18)
|
|
|
|
DebtorTaxIDMisc1
|
Miscellaneous Tax 1
|
|
x(18)
|
|
|
|
DebtorTaxIDMisc2
|
Miscellaneous Tax 2
|
|
x(18)
|
|
|
|
DebtorTaxIDMisc3
|
Miscellaneous Tax 3
|
|
x(18)
|
|
|
|
DebtorTaxIDState
|
State Tax
|
|
x(18)
|
|
|
|
DebtorTotalDaysLate
|
Total Days Late
|
|
->,>>>,>>9
|
|
|
|
DebtorTotalNbrOfInvoices
|
Nbr of Paid Invoices
|
|
->,>>>,>>9
|
|
|
|
DebtorType_ID
|
Customer Type
|
|
9999999999
|
|
|
|
DeductionCtrlGLProfile_ID
|
Link to Deduction Profile
|
|
9999999999
|
|
|
|
DeliveryCond_ID
|
Link to DeliveryCond
|
|
9999999999
|
|
|
|
DivisionProfile_ID
|
Sub-Account Profile
|
|
9999999999
|
|
|
|
DomiciliationNumber
|
Domiciliation Number
|
|
999999999999
|
|
|
|
Employee_ID
|
Link to Employee
|
|
9999999999
|
|
|
|
FinChgGLProfile_ID
|
Finance Charge Profile
|
|
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 Code
|
Cred Trm
|
9999999999
|
|
|
|
ObsoleteCheckAftPICredLim
|
Check after Pre-Invoice Entry
|
|
yes/no
|
|
|
|
ObsoleteCheckBefPICredLim
|
Check before Pre-Invoice Entry
|
|
yes/no
|
|
|
|
ObsoleteGroupingSOOnPreInv
|
Group Customer's SO on Pre-Invoice
|
Group on Pre-Invoice
|
yes/no
|
|
|
|
ObsoleteInclPreInvCredLim
|
Include Pre-Invoices
|
|
yes/no
|
|
|
|
ObsoleteOverrulePICredLim
|
Overrule Allowed
|
|
yes/no
|
|
|
|
ObsoletePreInvGroup_ID
|
Link to PreInvGroup
|
|
9999999999
|
|
|
|
PaymentGroup_ID
|
Payment Group
|
|
9999999999
|
|
|
|
PrePayControlGLProfile_ID
|
Control GL Profile (Pre-payment)
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reason_ID
|
Invoice Status Code
|
|
9999999999
|
|
|
|
SalesAccountGLProfile_ID
|
Sales Account GL Profile
|
|
9999999999
|
|
|
|
SalesCode_ID
|
Link to SalesCode
|
|
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)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BillSchedIdx
|
no
|
BillSchedule_ID
|
yes
|
no
|
|
|
BillToIdx
|
no
|
BillToDebtor_ID
|
yes
|
no
|
|
|
CnGLControl
|
no
|
CnControlGLProfile_ID
|
yes
|
no
|
|
|
Code
|
no
|
DebtorCode
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DebRatingIdx
|
no
|
DebtorCreditRating_ID
|
yes
|
no
|
|
|
DebtorType
|
no
|
DebtorType_ID
|
yes
|
no
|
|
|
DeductProfile
|
no
|
DeductionCtrlGLProfile_ID
|
yes
|
no
|
|
|
DelCondIdx
|
no
|
DeliveryCond_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
DivisionProfile_ID
|
yes
|
no
|
|
|
EmplIdx
|
no
|
Employee_ID
|
yes
|
no
|
|
|
FinChrgIdx
|
no
|
FinChgGLProfile_ID
|
yes
|
no
|
|
|
InvGLControl
|
no
|
InvControlGLProfile_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
NormPayCondIdx
|
no
|
NormalPaymentCondition_ID
|
yes
|
no
|
|
|
PayGrpIdx
|
no
|
PaymentGroup_ID
|
yes
|
no
|
|
|
PrepayProfile
|
no
|
PrePayControlGLProfile_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Debtor_ID
|
yes
|
no
|
|
|
ReasionIdx
|
no
|
Reason_ID
|
yes
|
no
|
|
|
Relation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
SalesCodeIdx
|
no
|
SalesCode_ID
|
yes
|
no
|
|
|
SalesGLIdx
|
no
|
SalesAccountGLProfile_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
DebtorCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
DebtorIsActive
|
yes
|
no
|
|
|
|
|
DebtorCode
|
yes
|
no
|