|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Link to CostCentre
|
|
-99999999999
|
|
|
|
CyExclCC_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CyExclCCComment
|
Comment
|
|
x(40)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCIdx
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
CyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CyExclCC_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CyExclGL_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CyExclGLComment
|
Comment
|
|
x(40)
|
|
|
|
GL_ID
|
Link to GL
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
GLIdx
|
no
|
GL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CyExclGL_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
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)
|
|
|
|
CyGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CyGroupCode
|
Company Group
|
|
x(20)
|
|
|
|
CyGroupDescription
|
Description
|
Company Group Description
|
x(40)
|
|
|
|
CyGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CodeIdx
|
yes
|
CyGroupCode
|
yes
|
no
|
|
|
IsActIdx
|
no
|
CyGroupIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CyGroup_ID
|
yes
|
no
|
|
|
ViewIdx
|
no
|
CyGroupIsActive
|
yes
|
no
|
|
|
|
|
CyGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
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)
|
|
|
|
CyGroup_ID
|
Link to CyGroup
|
|
-99999999999
|
|
|
|
CyGroupCompany_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CyCgroupIdx
|
no
|
CyGroup_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
CyGroupCompany_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
CyGroup_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
DBalance_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DBalanceCC
|
SC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DBalanceLC
|
BC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DBalanceTC
|
TC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
Debtor_ID
|
Link to Debtor
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
DebtorAndCurrAndComp
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DBalance_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CreationUsr_ID
|
Link to Usr
|
|
-99999999999
|
|
|
|
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)
|
|
|
|
DCollection_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DCollectionBalanceCC
|
SC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceCreditCC
|
SC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceCreditLC
|
BC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceCreditTC
|
TC Credit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceDebitCC
|
SC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceDebitLC
|
BC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceDebitTC
|
TC Debit Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceLC
|
BC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBalanceTC
|
TC Balance
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionBankFileFormat
|
Bank File Format
|
|
x(20)
|
|
|
|
DCollectionCreationDate
|
Creation Date
|
|
99/99/9999
|
|
|
|
DCollectionCreationTime
|
Creation Time
|
|
99999
|
|
|
|
DCollectionIncSelCodeList
|
Customer Payment Selection Code
|
|
X(2000)
|
|
|
|
DCollectionIsAutomatic
|
Automatic
|
|
yes/no
|
|
|
|
DCollectionIsExecuted
|
Executed
|
|
yes/no
|
|
|
|
DCollectionIsOpen
|
Open
|
|
yes/no
|
|
|
|
DCollectionName
|
Name
|
|
x(40)
|
|
|
|
DCollectionNumber
|
Number
|
|
->,>>>,>>9
|
|
|
|
DCollectionOrigCreditCC
|
SC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionOrigCreditLC
|
SC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionOrigCreditTC
|
TC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionOrigDebitCC
|
SC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionOrigDebitLC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionOrigDebitTC
|
TC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DCollectionReference
|
1099 Box Reference
|
Reference
|
x(40)
|
|
|
|
DCollectionRequestedDate
|
Requested Date
|
|
99/99/9999
|
|
|
|
DCollectionYear
|
Year/Customer Payment Selection Code
|
Year
|
->,>>>,>>9
|
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
GL_ID
|
GL Account
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CreationUsr
|
no
|
CreationUsr_ID
|
yes
|
no
|
|
|
DCollRef
|
no
|
DCollectionReference
|
yes
|
no
|
|
|
DPaySel
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
IsExec
|
no
|
DCollectionIsExecuted
|
yes
|
no
|
|
|
IsOpen
|
no
|
DCollectionIsOpen
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DCollection_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
DCollectionYear
|
yes
|
no
|
|
|
|
|
DCollectionNumber
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DCollection_ID
|
Link to DCollection
|
|
-99999999999
|
|
|
|
DCollectionExport_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DCollectionExportDate
|
Export Date
|
|
99/99/9999
|
|
|
|
DCollectionExportFile
|
File Name
|
|
x(255)
|
|
|
|
DCollectionExportFolder
|
Folder
|
|
x(255)
|
|
|
|
DCollectionExportIsDuplic
|
Duplicate
|
|
yes/no
|
|
|
|
DCollectionExportSpilDate
|
Requested Date
|
|
99/99/9999
|
|
|
|
DCollectionExportTime
|
Export Time
|
|
->,>>>,>>9
|
|
|
|
DCollectionExportType
|
Type
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Usr_ID
|
Login
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DCollection
|
no
|
DCollection_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DCollectionExport_ID
|
yes
|
no
|
|
|
Usr
|
no
|
Usr_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dc__chr01
|
|
|
x(8)
|
|
|
|
dc__chr02
|
|
|
x(8)
|
|
|
|
dc__qadc01
|
|
|
x(8)
|
|
|
|
dc__qadc02
|
|
|
x(8)
|
|
|
|
dc__qadl01
|
|
|
yes/no
|
|
|
|
dc__qadl02
|
|
|
yes/no
|
|
|
|
dc_active
|
Active
|
Act
|
yes/no
|
|
|
|
dc_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
dc_desc
|
Description
|
|
x(24)
|
|
|
|
dc_dir
|
Database Directory
|
|
x(50)
|
|
|
|
dc_host
|
Host
|
|
x(24)
|
|
|
|
dc_name
|
Database Name
|
DB name
|
x(8)
|
|
|
|
dc_network
|
Network
|
|
x(8)
|
|
|
|
dc_parmfile
|
Parameter File
|
ParmFile
|
x(8)
|
|
|
|
dc_phy_name
|
Physical Database Name
|
Phys DB Name
|
x(12)
|
|
|
|
dc_server
|
Server
|
|
x(24)
|
|
|
|
dc_type
|
Type
|
|
x(8)
|
|
|
|
dc_use_app
|
Use AppServer
|
|
yes/no
|
|
|
|
dc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
dc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_dc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
dc_name
|
yes
|
dc_name
|
yes
|
no
|
|
|
oid_dc_mstr
|
yes
|
oid_dc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DDocInvoiceXrefStage_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DDocInvoiceXrefStageAlloTC
|
Stage TC Allocated
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocInvoiceXrefStageDiscTC
|
Stage TC Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocInvoiceXrefStagePaidAmtTC
|
TC Paid Amount
|
Paid TC
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocument_ID
|
Link to DDocument
|
|
-99999999999
|
|
|
|
DDocumentInvoiceXref_ID
|
Link to DDocumentInvoiceXref
|
|
-99999999999
|
|
|
|
DInvoiceStage_ID
|
Link to DInvoiceStage
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DDoc
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
DIStage
|
no
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
InvXref
|
no
|
DDocumentInvoiceXref_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocInvoiceXrefStage_ID
|
yes
|
no
|
|
|
UniqueId
|
yes
|
DDocumentInvoiceXref_ID
|
yes
|
no
|
|
|
|
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankNumber_ID
|
Link to BankNumber
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CreationUsr_ID
|
Login
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
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)
|
|
|
|
DCollection_ID
|
Link to DCollection
|
|
-99999999999
|
|
|
|
DDocument_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DDocumentBankImpRef
|
Bank Importing Reference
|
|
x(255)
|
|
|
|
DDocumentCCRate
|
SC Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DDocumentCCScale
|
SC Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DDocumentClosingDate
|
Closing Date
|
|
99/99/9999
|
|
|
|
DDocumentCreationDate
|
Creation Date
|
|
99/99/9999
|
|
|
|
DDocumentCreationTime
|
Creation Time
|
|
99999
|
|
|
|
DDocumentDueDate
|
Due Date
|
|
99/99/9999
|
|
|
|
DDocumentExchangeRate
|
Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DDocumentIncassoSelectCode
|
Payment Selection Code (Incasso)
|
|
x(20)
|
|
|
|
DDocumentIsOpen
|
Open
|
|
yes/no
|
|
|
|
DDocumentLastPrintDate
|
Last Printed Date
|
|
99/99/9999
|
|
|
|
DDocumentNumber
|
Payment Number
|
Payment Number
|
999999999
|
|
|
|
DDocumentOriginalCreditBC
|
BC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalCreditCC
|
SC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalCreditLC
|
BC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalCreditTC
|
TC Original Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalDebitBC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalDebitCC
|
SC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalDebitLC
|
BC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOriginalDebitTC
|
TC Original Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentOverPaymentDiffTC
|
TC Over Payment Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentRateScale
|
Scale Factor
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DDocumentReference
|
Reference
|
|
x(40)
|
|
|
|
DDocumentReportingDateIN
|
Reporting Date (IN)
|
|
99/99/9999
|
|
|
|
DDocumentShortPaymentDiffTC
|
TC Short Payment Difference
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentStatus
|
Status
|
|
x(20)
|
|
|
|
DDocumentSubType
|
Subtype
|
|
x(20)
|
|
|
|
DDocumentTimesPrinted
|
Times Printed
|
|
>>9
|
|
|
|
DDocumentTransTpStat
|
Transaction Type Status
|
|
x(20)
|
|
|
|
DDocumentType
|
Payment Instrument
|
|
x(20)
|
|
|
|
DDocumentValueDays
|
Value Days
|
|
>>9
|
|
|
|
DDocumentYear
|
Year
|
Year
|
9999
|
|
|
|
Debtor_ID
|
Customer
|
|
-99999999999
|
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
GL_ID
|
Bank Account
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankNumIdx
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
ClosingDate
|
no
|
DDocumentClosingDate
|
yes
|
no
|
|
|
CollectionIdx
|
no
|
DCollection_ID
|
yes
|
no
|
|
|
CompanyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
CreationUsr
|
no
|
CreationUsr_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
CyCrDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
DDocumentCreationDate
|
yes
|
no
|
|
|
CyDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
DDocumentClosingDate
|
yes
|
no
|
|
|
CyDebCrDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
DDocumentCreationDate
|
yes
|
no
|
|
|
CyDebDateIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
DDocumentClosingDate
|
yes
|
no
|
|
|
DebtorIdx
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
DpaySelIdx
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
GLIdx
|
no
|
GL_ID
|
yes
|
no
|
|
|
IncassoSelCode
|
no
|
DDocumentIncassoSelectCode
|
yes
|
no
|
|
|
IsOpenIdx
|
no
|
DDocumentIsOpen
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocument_ID
|
yes
|
no
|
|
|
Reference
|
no
|
DDocumentReference
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
DDocumentType
|
yes
|
no
|
|
|
|
|
DDocumentYear
|
yes
|
no
|
|
|
|
|
DDocumentNumber
|
yes
|
no
|
|
|
YrIdx
|
no
|
DDocumentYear
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DDocument_ID
|
Link to DDocument
|
|
-99999999999
|
|
|
|
DDocumentInvoiceXref_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DDocumentInvoiceXrefAlloCrDr
|
DR/CR
|
|
x(2)
|
|
|
|
DDocumentInvoiceXrefAlloTC
|
TC Allocated Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentInvoiceXrefDiscTC
|
TC Discount Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentInvoiceXrefIntTC
|
TC Interest Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DDocumentInvoiceXrefPaidAmtTC
|
TC Paid Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Document
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
Invoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocumentInvoiceXref_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DDocument_ID
|
Link To DDocument
|
|
-99999999999
|
|
|
|
DDocumentPayCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
PayFormatCode_ID
|
Link to PayFormatCode
|
|
-99999999999
|
|
|
|
PayFormatGroup_ID
|
Link to PayFormatGroup
|
|
-99999999999
|
|
|
|
PayFormatTypeCode
|
Payment Form Code
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DDocument
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
PFCodeIdx
|
no
|
PayFormatCode_ID
|
yes
|
no
|
|
|
PFGrpIdx
|
no
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
PFTypeIdx
|
no
|
PayFormatTypeCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocumentPayCode_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DDocument_ID
|
Link to DDocument
|
|
-99999999999
|
|
|
|
DDocumentPostingLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DDocumentStatus
|
Customer Payment Status
|
|
x(20)
|
|
|
|
PostingLine_ID
|
Link to PostingLine
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DDoc
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
PostLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocumentPostingLine_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
DDocument_ID
|
yes
|
no
|
|
|
|
|
PostingLine_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankGL_ID
|
Bank Account Code
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
DDocumentStatus_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DDocumentStatusDefValDays
|
Default Value Days
|
|
>>9
|
|
|
|
DDocumentStatusDocType
|
Payment Instrument
|
|
x(20)
|
|
|
|
DDocumentStatusStatus
|
Status
|
|
x(20)
|
|
|
|
GL_ID
|
GL Account
|
|
-99999999999
|
|
|
|
Journal_ID
|
Daybook Code
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankGL
|
no
|
BankGL_ID
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DDocumentStatus_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
DDocumentStatusDocType
|
yes
|
no
|
|
|
|
|
DDocumentStatusStatus
|
yes
|
no
|
|
|
|
|
BankGL_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AccruedRevRecGLProfile_ID
|
Link to Accrued Rev Rec Profile
|
|
-99999999999
|
|
|
|
BillSchedule_ID
|
Link to BillSchedule
|
|
-99999999999
|
|
|
|
BillToDebtor_ID
|
Bill-To Customer
|
Bill-To
|
-99999999999
|
|
|
|
BLWIGroup_ID
|
BLWI Group Code
|
BLWI Group
|
-99999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
Business Relation Code
|
-99999999999
|
|
|
|
CnControlGLProfile_ID
|
Control GL Profile (Credit Note)
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
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
|
|
-99999999999
|
|
|
|
DebtorAROverPayTolAmtTC
|
TC Over Tolerance Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorAROverPayTolPct
|
Over Tolerance Percent
|
|
->>9.9999
|
4
|
|
|
DebtorARShortPayTolAmtTC
|
TC Short Tolerance Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorARShortPayTolPct
|
Short Tolerance Percent
|
|
->>9.9999
|
4
|
|
|
DebtorCode
|
Customer Code
|
|
x(8)
|
|
|
|
DebtorCommentNote
|
Comment Note
|
|
x(2000)
|
|
|
|
DebtorCreditRating_ID
|
Credit Rating
|
|
-99999999999
|
|
|
|
DebtorDBNumber
|
Credit Agency Reference
|
Credit Agency Ref
|
x(12)
|
|
|
|
DebtorEInvoiceRegisterDateIN
|
Electronic invoice Registration Date (IN)
|
|
99/99/9999
|
|
|
|
DebtorFixedCredLimTC
|
Fixed Credit Limit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorGTVatTransType
|
Golden Tax Transaction Type
|
|
x(40)
|
|
|
|
DebtorHighCredit
|
High Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DebtorHighCreditDate
|
High Credit Date
|
|
99/99/9999
|
|
|
|
DebtorIsActive
|
Active
|
|
yes/no
|
|
|
|
DebtorIsAutoCreateRRContract
|
Auto Create Rev Rec Contracts
|
|
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
|
|
|
|
DebtorIsEInvoiceIN
|
Apply Electronic Invoice (IN)
|
|
yes/no
|
|
|
|
DebtorIsFinanceCharge
|
Finance Charge
|
|
yes/no
|
|
|
|
DebtorIsFixedCredLim
|
Apply Fixed Ceiling
|
|
yes/no
|
|
|
|
DebtorIsInclDeductionCredLim
|
Include Deductions
|
|
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
|
|
|
|
DebtorIsReportedIN
|
Reported (IN)
|
|
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
|
|
|
|
DebtorIsToleranceFromOwnBank
|
Default From Own Bank
|
|
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
|
|
|
DebtorRRAutogenRevReq
|
Review Required for Auto-Generated Contracts
|
|
x(20)
|
|
|
|
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
|
|
-99999999999
|
|
|
|
DeductionCtrlGLProfile_ID
|
Link to Deduction Profile
|
|
-99999999999
|
|
|
|
DeferredRevRecGLProfile_ID
|
Link to Deferred Rev Rec Profile
|
|
-99999999999
|
|
|
|
DeliveryCond_ID
|
Link to DeliveryCond
|
|
-99999999999
|
|
|
|
DivisionProfile_ID
|
Sub-Account Profile
|
|
-99999999999
|
|
|
|
DomiciliationNumber
|
Domiciliation Number
|
|
999999999999
|
|
|
|
Employee_ID
|
Link to Employee
|
|
-99999999999
|
|
|
|
FinChgGLProfile_ID
|
Finance Charge Profile
|
|
-99999999999
|
|
|
|
InvControlGLProfile_ID
|
Control GL Profile (Invoice)
|
|
-99999999999
|
|
|
|
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
|
-99999999999
|
|
|
|
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
|
|
-99999999999
|
|
|
|
PaymentGroup_ID
|
Payment Group
|
|
-99999999999
|
|
|
|
PrePayControlGLProfile_ID
|
Control GL Profile (Pre-payment)
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reason_ID
|
Invoice Status Code
|
|
-99999999999
|
|
|
|
RRRule_ID
|
Link to Rev Rec Rule
|
|
-99999999999
|
|
|
|
SalesAccountGLProfile_ID
|
Sales Account GL Profile
|
|
-99999999999
|
|
|
|
SalesCode_ID
|
Link to SalesCode
|
|
-99999999999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
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
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DebtorCreditRating_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DebtorCreditRatingCode
|
Code
|
|
x(8)
|
|
|
|
DebtorCreditRatingDescript
|
Description
|
|
x(40)
|
|
|
|
DebtorCreditRatingIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
DebtorCreditRatingCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DebtorCreditRating_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Address_ID
|
City
|
|
-99999999999
|
|
|
|
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)
|
|
|
|
Debtor_ID
|
Customer Code
|
|
-99999999999
|
|
|
|
DebtorEndUser_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DebtorEndUserCode
|
End User Code
|
|
x(8)
|
|
|
|
DebtorEndUserIsDebtor
|
Link to Customer
|
|
yes/no
|
|
|
|
DebtorEndUserIsShipTo
|
Link to Ship-to Address
|
|
yes/no
|
|
|
|
DebtorEndUserName
|
End User Name
|
|
x(36)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Address
|
no
|
Address_ID
|
yes
|
no
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DebtorEndUser_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DebtorEndUserCode
|
yes
|
no
|
|
|
|
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Debtor_ID
|
Link to Debtor
|
|
-99999999999
|
|
|
|
DebtorSafDefault_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DebtorSafDefault_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafConcept
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
SafConcept_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Address_ID
|
City
|
|
-99999999999
|
|
|
|
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)
|
|
|
|
Debtor_ID
|
Customer Code
|
|
-99999999999
|
|
|
|
DebtorEndUser_ID
|
End User Code
|
|
-99999999999
|
|
|
|
DebtorShipTo_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DebtorShipToCode
|
Ship-To Code
|
|
x(8)
|
|
|
|
DebtorShipToIsDebtor
|
Link to Another Customer
|
|
yes/no
|
|
|
|
DebtorShipToName
|
Ship-To Name
|
|
x(36)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Address
|
no
|
Address_ID
|
yes
|
no
|
|
|
Debtor
|
no
|
Debtor_ID
|
yes
|
no
|
|
|
EndUser
|
no
|
DebtorEndUser_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DebtorShipTo_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DebtorShipToCode
|
yes
|
no
|
|
|
|
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DebtorType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DebtorTypeCode
|
Code
|
|
x(4)
|
|
|
|
DebtorTypeDescription
|
Description
|
|
x(40)
|
|
|
|
DebtorTypeIsActive
|
Active
|
|
yes/no
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
DebtorTypeIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DebtorType_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DebtorTypeCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
DebtorTypeIsActive
|
yes
|
no
|
|
|
|
|
DebtorTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
decl__qadc01
|
|
|
x(24)
|
|
|
|
decl__qadc02
|
|
|
x(24)
|
|
|
|
decl_addr
|
Declarant
|
|
x(8)
|
|
|
|
decl_affiliation
|
Affiliation
|
|
x(1)
|
|
|
|
decl_agent
|
Agent
|
|
x(8)
|
|
|
|
decl_branch
|
Branch ID
|
|
x(5)
|
|
|
|
decl_company_id
|
Company ID Number
|
|
x(14)
|
|
|
|
decl_ctry_code
|
Country Code
|
|
x(3)
|
|
|
|
decl_curr
|
Currency
|
|
x(3)
|
|
|
|
decl_domain
|
Domain
|
|
x(8)
|
|
|
|
decl_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
decl_intr_division
|
Intrastat Division
|
Div
|
x(3)
|
|
|
|
decl_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
decl_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
decl_net_wt_min
|
Intrastat Net Weight Minimum
|
|
>>>,>>>,>>9.99
|
10
|
|
|
decl_obligation_level
|
Declaration Level
|
|
x(1)
|
|
|
|
decl_program
|
Program
|
|
x(12)
|
|
|
|
decl_region
|
Declaration Region
|
|
x(6)
|
|
|
|
decl_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
decl_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
decl_validation_code
|
Validation Code
|
|
x(8)
|
|
|
|
oid_decl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
decl_addr
|
yes
|
decl_domain
|
yes
|
no
|
|
|
|
|
decl_addr
|
yes
|
no
|
|
|
oid_decl_mstr
|
yes
|
oid_decl_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ApprovedDeductionReason_ID
|
Link to ApprovedDeductionReason
|
|
-99999999999
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
DeductionCat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DeductionCatCode
|
Deduction Category Code
|
County
|
x(20)
|
|
|
|
DeductionCatDescription
|
Description
|
|
x(40)
|
|
|
|
DeductionCatIsActive
|
Active
|
|
yes/no
|
|
|
|
DeductionCatIsAllowCredit
|
Approve Credit
|
|
yes/no
|
|
|
|
DeductionCatIsAllowWriteOff
|
Approve Write-off
|
|
yes/no
|
|
|
|
DeductionCatType
|
Type
|
County
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PendingDeductionReason_ID
|
Link to PendingDeductionReason
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RejectedDeductionReason_ID
|
Link to RejectedDeductionReason
|
|
-99999999999
|
|
|
|
Role_ID
|
Link to Role
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ApReason
|
no
|
ApprovedDeductionReason_ID
|
yes
|
no
|
|
|
Code
|
yes
|
DeductionCatCode
|
yes
|
no
|
|
|
IsActive
|
no
|
DeductionCatIsActive
|
yes
|
no
|
|
|
PeReason
|
no
|
PendingDeductionReason_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DeductionCat_ID
|
yes
|
no
|
|
|
ReReason
|
no
|
RejectedDeductionReason_ID
|
yes
|
no
|
|
|
RoleIdx
|
no
|
Role_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentre_ID
|
Link to CostCentre
|
|
-99999999999
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
DeductionCat_ID
|
Link to DeductionCat
|
|
-99999999999
|
|
|
|
DeductionCatLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DeductionCatLineIsAutoWOff
|
Auto Write-off
|
|
yes/no
|
|
|
|
DeductionCatLineWOffLimit
|
Write-off Limit
|
County
|
->,>>>,>>9.99
|
4
|
|
|
Division_ID
|
Link to Division
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link to Doamin
|
|
-99999999999
|
|
|
|
ExpenseJournal_ID
|
Link to ExpenseJournal
|
|
-99999999999
|
|
|
|
GL_ID
|
Link to GL
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RechargeJournal_ID
|
Link to RechargeJournal
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
WriteOffCompany_ID
|
Link to WriteOff Company
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Cat
|
no
|
DeductionCat_ID
|
yes
|
no
|
|
|
CC
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Cy
|
no
|
WriteOffCompany_ID
|
yes
|
no
|
|
|
Div
|
no
|
Division_ID
|
yes
|
no
|
|
|
DomIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
ExpJrnl
|
no
|
ExpenseJournal_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DeductionCatLine_ID
|
yes
|
no
|
|
|
RecJrnl
|
no
|
RechargeJournal_ID
|
yes
|
no
|
|
|
SafStr
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
DeductionCat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
DeductionCatLine_ID
|
Link to DeductionCatLine
|
|
-99999999999
|
|
|
|
DeductionCatLineSaf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CLine
|
no
|
DeductionCatLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DeductionCatLineSaf_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
DeductionCatLine_ID
|
yes
|
no
|
|
|
|
|
Saf_ID
|
yes
|
no
|