|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankNumber_ID
|
Link to BankNumber
|
|
9999999999
|
|
|
|
CCollection_ID
|
Link to CCollection
|
|
9999999999
|
|
|
|
CDocument_ID
|
Record ID
|
|
9999999999
|
|
|
|
CDocumentBankChargeAmountCC
|
SC Bank Charge Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankChargeAmountLC
|
BC Bank Charge Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankChargeAmountTC
|
TC Bank Charge Amt
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankChargeTaxAmountCC
|
SC Bank Charge Tax
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankChargeTaxAmountLC
|
BC Bank Charge Tax
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankChargeTaxAmountTC
|
TC Bank Charge Tax
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
CDocumentCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CDocumentCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CDocumentClosingDate
|
Closing Date
|
|
99/99/9999
|
|
|
|
CDocumentCreationDate
|
Creation Date
|
|
99/99/9999
|
|
|
|
CDocumentCreationTime
|
Creation Time
|
|
99999
|
|
|
|
CDocumentDueDate
|
Due Date
|
|
99/99/9999
|
|
|
|
CDocumentExchangeRate
|
Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CDocumentIsOpen
|
Open
|
|
yes/no
|
|
|
|
CDocumentLastPrintDate
|
Last Printed Date
|
|
99/99/9999
|
|
|
|
CDocumentNumber
|
Payment Number
|
Payment Number
|
999999999
|
|
|
|
CDocumentOriginalCreditBC
|
BC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalCreditCC
|
SC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalCreditLC
|
BC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalCreditTC
|
TC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalDebitBC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalDebitCC
|
SC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalDebitLC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentOriginalDebitTC
|
TC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
CDocumentPrePrintedNumber
|
Preprinted Number
|
|
>>>>>>>>>>>>9
|
|
|
|
CDocumentRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
CDocumentReference
|
Reference
|
|
x(40)
|
|
|
|
CDocumentStatus
|
Status
|
|
x(20)
|
|
|
|
CDocumentSubType
|
Subtype
|
|
x(20)
|
|
|
|
CDocumentTimesPrinted
|
Times Printed
|
|
>>9
|
|
|
|
CDocumentTransTpStat
|
Transaction Type Status
|
|
->>>,>>>,>>>,>>9.99
|
|
|
|
CDocumentType
|
Payment Instrument
|
|
x(20)
|
|
|
|
CDocumentValueDays
|
Value Days
|
|
>>9
|
|
|
|
CDocumentYear
|
Year
|
Year
|
9999
|
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CreationUsr_ID
|
Link to Usr
|
|
9999999999
|
|
|
|
Creditor_ID
|
Supplier
|
|
9999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
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
|
|
|
|
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
|
|
|
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)
|
|
|
|
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)
|
|
|
|
GL_ID
|
Bank Account
|
|
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)
|
|
|
|
PaySel_ID
|
Code
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BnkIdx
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
CDocRef
|
no
|
CDocumentReference
|
yes
|
no
|
|
|
ClosingDate
|
no
|
CDocumentClosingDate
|
yes
|
no
|
|
|
CollectionIdx
|
no
|
CCollection_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CreationUsr
|
no
|
CreationUsr_ID
|
yes
|
no
|
|
|
CreditorIdx
|
no
|
Creditor_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyCrDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
CDocumentCreationDate
|
yes
|
no
|
|
|
CyCredCrDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Creditor_ID
|
yes
|
no
|
|
|
|
|
CDocumentCreationDate
|
yes
|
no
|
|
|
CyCredDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Creditor_ID
|
yes
|
no
|
|
|
|
|
CDocumentClosingDate
|
yes
|
no
|
|
|
CyDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
CDocumentClosingDate
|
yes
|
no
|
|
|
GLidx
|
no
|
GL_ID
|
yes
|
no
|
|
|
IsOpenIdx
|
no
|
CDocumentIsOpen
|
yes
|
no
|
|
|
PaySelIdx
|
no
|
PaySel_ID
|
yes
|
no
|
|
|
PrePrintIdx
|
no
|
CDocumentPrePrintedNumber
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CDocument_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
CDocumentType
|
yes
|
no
|
|
|
|
|
CDocumentYear
|
yes
|
no
|
|
|
|
|
CDocumentNumber
|
yes
|
no
|