|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AbsRetTaxDivision_ID
|
Absorbed Tax Sub-Account
|
Abs Tax Sub-Acct
|
-99999999999
|
|
|
|
AbsRetTaxGL_ID
|
Absorbed Tax Account
|
Abs Tax Account
|
-99999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
-99999999999
|
|
|
|
DInvoiceVat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DInvoiceVatIsAbsRet
|
Absorbed
|
|
yes/no
|
|
|
|
DInvoiceVatIsAccrRcpUs
|
Accrue at Receipt/Usage
|
|
yes/no
|
|
|
|
DInvoiceVatIsRevCharge
|
Reverse Charge
|
Rev Charge
|
yes/no
|
|
|
|
DInvoiceVatIsSuspDel
|
Suspended Tax
|
Susp Tax
|
yes/no
|
|
|
|
DInvoiceVatIsTaxable
|
Taxable
|
|
yes/no
|
|
|
|
DInvoiceVatIsUpdAllow
|
Upd Allow
|
|
yes/no
|
|
|
|
DInvoiceVatNTBaseCreditTC
|
Non-taxable Credit (TC)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatNTBaseDebitTC
|
Non-taxable Debit (TC)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatSequence
|
Sequence
|
|
9999999999
|
|
|
|
DInvoiceVatSuspDelTaxAmtTC
|
Tax Amount on Suspended Account (TC)
|
Tax Amount on Susp Acct (TC)
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatTaxTrType
|
Tax Transaction Type
|
Tax Tr Type
|
x(2)
|
|
|
|
DInvoiceVatUILinkedRowID
|
Linked Row
|
|
x(30)
|
|
|
|
DInvoiceVatVatBaseCreditCC
|
SC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseCreditLC
|
BC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseCreditTC
|
TC Base Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitCC
|
SC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitLC
|
BC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatBaseDebitTC
|
TC Base Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditCC
|
SC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditLC
|
BC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatCreditTC
|
TC Tax Amount (CR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitCC
|
SC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitLC
|
BC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DInvoiceVatVatDebitTC
|
TC Tax Amount (DR)
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
NormalTaxDivision_ID
|
Normal Tax Sub-Account
|
Normal Tax Sub-Acct
|
-99999999999
|
|
|
|
NormalTaxGL_ID
|
Normal Tax Account
|
|
-99999999999
|
|
|
|
PostingVat_ID
|
Link to PostingVat
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SuspDelTaxDivision_ID
|
Suspended Tax Sub-Account
|
Susp Tax Sub-Acct
|
-99999999999
|
|
|
|
SuspDelTaxGL_ID
|
Suspended Tax Account
|
Susp Tax Acct
|
-99999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxenvTaxEnv
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
TxtyTaxType
|
Tax Type
|
|
x(16)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
Vat_ID
|
Domain
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AbsRetDivIdx
|
no
|
AbsRetTaxDivision_ID
|
yes
|
no
|
|
|
AbsRetGLIdx
|
no
|
AbsRetTaxGL_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
NormDivIdx
|
no
|
NormalTaxDivision_ID
|
yes
|
no
|
|
|
NormGLIdx
|
no
|
NormalTaxGL_ID
|
yes
|
no
|
|
|
PostingVatIdx
|
no
|
PostingVat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DInvoiceVat_ID
|
yes
|
no
|
|
|
SuspDelDivIdx
|
no
|
SuspDelTaxDivision_ID
|
yes
|
no
|
|
|
SuspDelGLIdx
|
no
|
SuspDelTaxGL_ID
|
yes
|
no
|
|
|
UniqueTax
|
yes
|
DInvoice_ID
|
yes
|
no
|
|
|
|
|
TxuTaxUsage
|
yes
|
no
|
|
|
|
|
TxclTaxCls
|
yes
|
no
|
|
|
|
|
TxenvTaxEnv
|
yes
|
no
|
|
|
|
|
Vat_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BudgetGroup_ID
|
Link to BudgetGroup
|
|
-99999999999
|
|
|
|
COAMaskDivProfile_ID
|
COA Mask Profile
|
|
-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)
|
|
|
|
Division_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DivisionCode
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
DivisionDescription
|
Description
|
|
x(24)
|
|
|
|
DivisionIsActive
|
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
|
|
|
|
SharedSet_ID
|
Link to SharedSet
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BudgetGroup
|
no
|
BudgetGroup_ID
|
yes
|
no
|
|
|
COAMaskProfileIdx
|
no
|
COAMaskDivProfile_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Division_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
SharedSetAndCode
|
yes
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
DivisionCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
DivisionIsActive
|
yes
|
no
|
|
|
|
|
DivisionCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dmw__char01
|
|
|
x(8)
|
|
|
|
dmw__char02
|
|
|
x(8)
|
|
|
|
dmw__char03
|
|
|
x(8)
|
|
|
|
dmw__char04
|
|
|
x(8)
|
|
|
|
dmw__char05
|
|
|
x(8)
|
|
|
|
dmw__dte01
|
|
|
99/99/99
|
|
|
|
dmw__log01
|
|
|
yes/no
|
|
|
|
dmw_amt
|
Amount
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
dmw_appl
|
Applied Amt
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
dmw_bank
|
Bank
|
|
x(8)
|
|
|
|
dmw_bill
|
Bill-To
|
|
x(8)
|
|
|
|
dmw_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
dmw_date
|
Date
|
|
99/99/99
|
|
|
|
dmw_disc
|
Discount
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
dmw_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
dmw_entity
|
Entity
|
Enty
|
x(20)
|
|
|
|
dmw_nbr
|
Reference
|
|
x(8)
|
|
|
|
dmw_sel
|
Sel
|
|
x(1)
|
|
|
|
dmw_type
|
Type
|
T
|
x(1)
|
|
|
|
dmw_user1
|
Ufld1
|
|
x(8)
|
|
|
|
dmw_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_dmw_wkfl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
dmw_bill
|
no
|
dmw_bill
|
yes
|
no
|
|
|
|
|
dmw_entity
|
yes
|
no
|
|
|
|
|
dmw_curr
|
yes
|
no
|
|
∗
|
dmw_nbr
|
yes
|
dmw_nbr
|
yes
|
no
|
|
|
|
|
dmw_bill
|
yes
|
no
|
|
|
|
|
dmw_sel
|
yes
|
no
|
|
|
oid_dmw_wkfl
|
yes
|
oid_dmw_wkfl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dohd__qadc01
|
|
|
X(24)
|
|
|
|
dohd__qadc02
|
|
|
X(24)
|
|
|
|
dohd_dataset
|
Data Set
|
|
x(12)
|
|
|
|
dohd_detail
|
Detail
|
|
x(24)
|
|
|
|
dohd_domain
|
Domain
|
|
x(8)
|
|
|
|
dohd_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
dohd_line
|
Line/ID
|
|
x(8)
|
|
|
|
dohd_line2
|
Reference
|
|
x(8)
|
|
|
|
dohd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
dohd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
dohd_nbr
|
Order
|
|
x(18)
|
|
|
|
dohd_part
|
Item Number
|
|
x(18)
|
|
|
|
dohd_qty
|
Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
dohd_site
|
Site
|
|
x(8)
|
|
|
|
dohd_type
|
Order Type
|
|
x(8)
|
|
|
|
dohd_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
dohd_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
oid_dohd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
dohd_det_dataset
|
yes
|
dohd_domain
|
yes
|
no
|
|
|
|
|
dohd_dataset
|
yes
|
no
|
|
|
|
|
dohd_part
|
yes
|
no
|
|
|
|
|
dohd_nbr
|
yes
|
no
|
|
|
|
|
dohd_line
|
yes
|
no
|
|
|
|
|
dohd_line2
|
yes
|
no
|
|
|
dohd_det_site_part
|
no
|
dohd_domain
|
yes
|
no
|
|
|
|
|
dohd_site
|
yes
|
no
|
|
|
|
|
dohd_part
|
yes
|
no
|
|
|
|
|
dohd_due_date
|
yes
|
no
|
|
|
|
|
dohd_dataset
|
yes
|
no
|
|
|
|
|
dohd_nbr
|
yes
|
no
|
|
|
|
|
dohd_line
|
yes
|
no
|
|
|
|
|
dohd_line2
|
yes
|
no
|
|
|
oid_dohd_det
|
yes
|
oid_dohd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dohh__qadc01
|
|
|
X(24)
|
|
|
|
dohh__qadc02
|
|
|
X(24)
|
|
|
|
dohh_horizon_days
|
Horizon Days
|
|
>,>>>,>>>
|
|
|
|
dohh_horizon_demand_qty
|
Horizon Demand Qty
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
dohh_horizon_work_days
|
Horizon Work Days
|
|
->,>>>,>>>
|
|
|
|
dohh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
dohh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
dohh_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
dohh_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
oid_doh_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_dohh_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
dohh_det
|
yes
|
oid_doh_mstr
|
yes
|
no
|
|
|
|
|
dohh_horizon_days
|
yes
|
no
|
|
|
oid_dohh_det
|
yes
|
oid_dohh_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
doh__qadc01
|
|
|
X(24)
|
|
|
|
doh__qadc02
|
|
|
X(24)
|
|
|
|
doh_cost
|
Cost
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
doh_date
|
Date
|
|
99/99/99
|
|
|
|
doh_days_on_hand
|
Days On Hand
|
|
>,>>>,>>>
|
|
|
|
doh_domain
|
Domain
|
|
x(8)
|
|
|
|
doh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
doh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
doh_part
|
Item Number
|
|
x(18)
|
|
|
|
doh_pqoh
|
Projected QOH
|
|
->>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
doh_sfty_stk_days_on_hand
|
Safety Stock DOH
|
|
>,>>>,>>>
|
|
|
|
doh_site
|
Site
|
|
x(8)
|
|
|
|
doh_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
doh_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
oid_doh_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
doh_mstr_part_site
|
no
|
doh_domain
|
yes
|
no
|
|
|
|
|
doh_part
|
yes
|
no
|
|
|
|
|
doh_site
|
yes
|
no
|
|
|
|
|
doh_date
|
yes
|
no
|
|
∗
|
doh_mstr_site_part
|
yes
|
doh_domain
|
yes
|
no
|
|
|
|
|
doh_site
|
yes
|
no
|
|
|
|
|
doh_part
|
yes
|
no
|
|
|
|
|
doh_date
|
yes
|
no
|
|
|
oid_doh_mstr
|
yes
|
oid_doh_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Currency_ID
|
Base Currency
|
Curr
|
-99999999999
|
|
|
|
DeductPaymentCondition_ID
|
Non-Staged Deduction Payment Condition
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-99999999999
|
|
|
|
DomainProperty_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DomainPropertyCodePage
|
Domain Code Page
|
|
x(16)
|
|
|
|
DomainPropertyExceptList
|
Domain Exception List
|
|
x(100)
|
|
|
|
DomainPropertyIsAddWHTNumber
|
Additional WHT Numbering
|
|
yes/no
|
|
|
|
DomainPropertyIsAllCredInRM
|
Include All Suppliers In Receiver Matching
|
Include All Suppliers in RM
|
yes/no
|
|
|
|
DomainPropertyIsChronolNr
|
Chronological Invoice Numbering
|
|
yes/no
|
|
|
|
DomainPropertyIsConsecutNr
|
Consecutive Invoice Numbering
|
|
yes/no
|
|
|
|
DomainPropertyIsConsumptionVat
|
Use Consumption Tax
|
|
yes/no
|
|
|
|
DomainPropertyIsInvCertific
|
Invoice Certification
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskCC
|
Cost Center COA Mask
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskCCAll
|
Cost Center All-Range Mask By Default
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskDiv
|
Sub-Account COA Mask
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskDivAll
|
Sub-Account All-Range Mask By Default
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskPrjAll
|
Project All-Range Mask By Default
|
|
yes/no
|
|
|
|
DomainPropertyIsMaskProj
|
Project COA Mask
|
|
yes/no
|
|
|
|
DomainPropertyIsPIBFLogEnabled
|
Enable Incoming Bank File Log
|
|
yes/no
|
|
|
|
DomainPropertyIsPopupInvNr
|
Show Supplier Invoice Number in Pop-up After Save
|
|
yes/no
|
|
|
|
DomainPropertyIsSetupCompl
|
Setup Complete
|
|
yes/no
|
|
|
|
DomainPropertyIsStatutory
|
Statutory Currency Enabled
|
|
yes/no
|
|
|
|
DomainPropertyIsTaxValid
|
Tax Validation
|
|
yes/no
|
|
|
|
DomainPropertyIsWHT
|
Use Withholding Tax
|
|
yes/no
|
|
|
|
DomainPropertyName
|
Name
|
|
x(28)
|
|
|
|
DomainPropertyNonChronErr
|
Action on Non-Chronological Number
|
|
x(20)
|
|
|
|
DomainPropertySearchName
|
Search Name
|
|
x(14)
|
|
|
|
DomainPropertyWHTDueMoment
|
WHT Due at
|
|
x(20)
|
|
|
|
IntercoAPGL_ID
|
Account Payable GL Account
|
AP Account
|
-99999999999
|
|
|
|
IntercoARGL_ID
|
Account Receivable GL Account
|
AR Account
|
-99999999999
|
|
|
|
IntercoFAGL_ID
|
Fixed Asset GL Account
|
FA Account
|
-99999999999
|
|
|
|
IntercoICGL_ID
|
Inter Company GL Account
|
IC Account
|
-99999999999
|
|
|
|
IntercoJEGL_ID
|
Manual Journal Entry GL Account
|
JE Account
|
-99999999999
|
|
|
|
ObsoleteDomPropGLMaskGL
|
Account GL Mask
|
|
yes/no
|
|
|
|
PrepayPaymentCondition_ID
|
Non-Staged Prepayment Payment Condition
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
StatutoryCurrency_ID
|
Statutory Currency
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
IdxStatCurr
|
no
|
StatutoryCurrency_ID
|
yes
|
no
|
|
|
Name
|
yes
|
DomainPropertyName
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DomainProperty_ID
|
yes
|
no
|
|
|
SearchName
|
yes
|
DomainPropertySearchName
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Domain_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DomainCode
|
Domain
|
|
x(8)
|
|
|
|
DomainDatabase
|
Database
|
|
x(8)
|
|
|
|
DomainIsActive
|
Active
|
|
yes/no
|
|
|
|
DomainPropath
|
Propath
|
|
x(500)
|
|
|
|
DomainTimeZone
|
Time Zone
|
|
x(8)
|
|
|
|
DomainType
|
Type
|
|
x(8)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Lng_ID
|
Language
|
|
-99999999999
|
|
|
|
PrimaryCompany_ID
|
Primary Entity
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Domain_PK
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
DomainCode
|
yes
|
DomainCode
|
yes
|
no
|
|
|
Lng_FK
|
no
|
Lng_ID
|
yes
|
no
|
|
|
PrimaryCompany_FK
|
no
|
PrimaryCompany_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Domain_ID
|
Domain
|
|
-99999999999
|
|
|
|
DomainSharedSet_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
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DOMAINS
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
DomainSS_PK
|
yes
|
DomainSharedSet_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dom__qadc01
|
|
|
x(24)
|
|
|
|
dom__qadc02
|
|
|
x(24)
|
|
|
|
dom_active
|
Active
|
|
yes/no
|
|
|
|
dom_data_cpg
|
Domain Codepage
|
Domain Codepage
|
x(16)
|
|
|
|
dom_db
|
Database
|
|
x(8)
|
|
|
|
dom_domain
|
Domain
|
|
x(8)
|
|
|
|
dom_expt_lst
|
Exceptional Domain List
|
Exceptional Domain List
|
x(100)
|
|
|
|
dom_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
dom_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
dom_name
|
Name
|
|
x(28)
|
|
|
|
dom_propath
|
Propath
|
|
x(2000)
|
|
|
|
dom_sname
|
Short Name
|
|
x(14)
|
|
|
|
dom_type
|
Domain Type
|
|
x(8)
|
|
|
|
dom_tzdb
|
Time Zone DB
|
|
x(16)
|
|
|
|
dom_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
dom_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_dom_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
dom_domain
|
yes
|
dom_domain
|
yes
|
no
|
|
|
dom_name
|
yes
|
dom_name
|
yes
|
no
|
|
|
oid_dom_mstr
|
yes
|
oid_dom_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
dosr__qadc01
|
|
|
x(24)
|
|
|
|
dosr__qadc02
|
|
|
x(24)
|
|
|
|
dosr_act_date
|
Actual Date
|
|
99/99/99
|
|
|
|
dosr_domain
|
Domain
|
|
x(8)
|
|
|
|
dosr_est_date
|
Estimated Date
|
|
99/99/99
|
|
|
|
dosr_itm_line
|
Line
|
|
>>9
|
|
|
|
dosr_itm_nbr
|
Depot Order
|
Order
|
x(8)
|
|
|
|
dosr_line
|
Line
|
|
>>9
|
|
|
|
dosr_loc
|
Location
|
|
x(8)
|
|
|
|
dosr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
dosr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
dosr_qty
|
Quantity
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
dosr_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
dosr_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
dosr_site
|
Site
|
|
x(8)
|
|
|
|
dosr_trans_type
|
Transaction Type
|
|
x(20)
|
|
|
|
dosr_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
dosr_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_dosr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
dosr_itm_nbr
|
yes
|
dosr_domain
|
yes
|
no
|
|
|
|
|
dosr_itm_nbr
|
yes
|
no
|
|
|
|
|
dosr_itm_line
|
yes
|
no
|
|
|
|
|
dosr_line
|
yes
|
no
|
|
|
oid_dosr_det
|
yes
|
oid_dosr_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CDocument_ID
|
Link to CDocument
|
|
-99999999999
|
|
|
|
DDocument_ID
|
Link to DDocument
|
|
-99999999999
|
|
|
|
DInvoice_ID
|
Link to DInvoice
|
|
-99999999999
|
|
|
|
DPay_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPayConfirmType
|
Confirm Message Type
|
|
x(20)
|
|
|
|
DPayTransTpStat
|
Transaction Type Status
|
|
x(20)
|
|
|
|
DPayTypeCode
|
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)
|
|
|
|
PaySelLine_ID
|
Link to PaySelLine
|
|
-99999999999
|
|
|
|
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
|
|
|
CDocument
|
no
|
CDocument_ID
|
yes
|
no
|
|
|
DDocument
|
no
|
DDocument_ID
|
yes
|
no
|
|
|
DInvoice
|
no
|
DInvoice_ID
|
yes
|
no
|
|
|
PaySelLineIdx
|
no
|
PaySelLine_ID
|
yes
|
no
|
|
|
PayTypeCode
|
no
|
DPayTypeCode
|
yes
|
no
|
|
|
PostingLine
|
no
|
PostingLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPay_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankPayFormat_ID
|
Link to BankPayFormat
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
DPaySel_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPaySelCode
|
Payment Selection
|
|
x(20)
|
|
|
|
DPaySelDate
|
Date
|
|
99/99/9999
|
|
|
|
DPaySelIsDocPerDueDate
|
Create Payment Per Due Date
|
|
yes/no
|
|
|
|
DPaySelStatus
|
Status
|
|
x(20)
|
|
|
|
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
|
|
|
BankPayIdx
|
no
|
BankPayFormat_ID
|
yes
|
no
|
|
|
Code
|
no
|
DPaySelCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CyDPaySelDate
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
DPaySelDate
|
yes
|
no
|
|
|
CyGLDPaySelCode
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
GL_ID
|
yes
|
no
|
|
|
|
|
DPaySelCode
|
yes
|
no
|
|
|
DPaySelDate
|
no
|
DPaySelDate
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPaySel_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DPaySelCode
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BankNumber_ID
|
Link to Bank Number
|
|
-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)
|
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
DPaySelLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPaySelLineAmountTC
|
TC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineDiscountTC
|
TC Discount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineIntAmtTC
|
TC Interest Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineIntRate
|
Interest Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DPaySelLineIsRefInFile
|
Is contained in export file
|
|
yes/no
|
|
|
|
DPaySelLineObjectType
|
Object Type
|
|
x(20)
|
|
|
|
DPaySelLineParentObject_ID
|
Reference ID of the caller
|
|
-99999999999
|
|
|
|
DPaySelLineStatus
|
Status
|
|
x(20)
|
|
|
|
DPaySelLineWHTAmtCC
|
SC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineWHTAmtLC
|
BC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineWHTAmtTC
|
TC WHT Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelPayFormatTypeCode
|
Payment Format
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BankNbr
|
no
|
BankNumber_ID
|
yes
|
no
|
|
|
DPaySel
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
ObjectType
|
no
|
DPaySelLineObjectType
|
yes
|
no
|
|
|
Parent
|
no
|
DPaySelLineParentObject_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPaySelLine_ID
|
yes
|
no
|
|
|
TypeCode
|
no
|
DPaySelPayFormatTypeCode
|
yes
|
no
|
|
|
UniIdx
|
yes
|
DPaySel_ID
|
yes
|
no
|
|
|
|
|
DPaySelLineParentObject_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoiceStage_ID
|
Link to CInvoiceStage
|
|
-99999999999
|
|
|
|
DInvoiceStage_ID
|
Link to DInvoiceStage
|
|
-99999999999
|
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
DPaySelLine_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
DPaySelLineStg_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPaySelLineStgDiscAmtTC
|
TC Discount Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineStgIntRate
|
Interest Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
DPaySelLineStgOpenAmtTC
|
TC Open Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineStgOrigAmtTC
|
TC Orig Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineStgPaymAmtTC
|
TC Payment Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
DPaySelLineStgStatus
|
Status
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CInvoiceStg
|
no
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
DInvoiceStg
|
no
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
DPaySel
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
DPaySelLine
|
no
|
DPaySelLine_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPaySelLineStg_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
DPaySelLine_ID
|
yes
|
no
|
|
|
|
|
DInvoiceStage_ID
|
yes
|
no
|
|
|
|
|
CInvoiceStage_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
DPaySelPayCode_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPaySelPayCodeValue
|
Value
|
|
x(40)
|
|
|
|
PayFormatCode_ID
|
Link to PayFormatCode
|
|
-99999999999
|
|
|
|
PayFormatGroup_ID
|
Link to PayFormatGroup
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DPaySel
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
PFCodeIdx
|
no
|
PayFormatCode_ID
|
yes
|
no
|
|
|
PFGrpIdx
|
no
|
PayFormatGroup_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPaySelPayCode_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DPaySel_ID
|
yes
|
no
|
|
|
|
|
PayFormatGroup_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DPaySel_ID
|
Link to DPaySel
|
|
-99999999999
|
|
|
|
DPaySelLine_ID
|
Link to DPaySelLine
|
|
-99999999999
|
|
|
|
DPaySelLineStg_ID
|
Link to DPaySelLineStage
|
|
-99999999999
|
|
|
|
DPaySelPayRef_ID
|
Record ID
|
|
-99999999999
|
|
|
|
DPaySelPayRefBankRef
|
Bank Reference
|
|
x(45)
|
|
|
|
DPaySelPayRefCode
|
Payment Reference Code
|
|
x(10)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DPaySel
|
no
|
DPaySel_ID
|
yes
|
no
|
|
|
DPaySelLine
|
no
|
DPaySelLine_ID
|
yes
|
no
|
|
|
DPaySelLineStg
|
no
|
DPaySelLineStg_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
DPaySelPayRef_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
DPaySelPayRefCode
|
yes
|
no
|