QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
DInvoiceVat
Customer Invoice Tax Records
 
 
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
Division
Sub-Account
 
 
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
dmw_wkfl
Draft Management Work Table
 
 
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
dohd_det
Days On Hand Demand Detail
 
 
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
dohh_det
Average Daily Demand Detail
 
 
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
doh_mstr
Days On Hand Analysis Master
 
 
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
DomainProperty
Domain Property
 
 
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
Domains
Domain
 
 
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
DomainSharedSet
Domain Shared Set
 
 
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
dom_mstr
Domain Master
 
 
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
dosr_det
Depot Order Shipment/Receipt Table
 
 
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
DPay
Customer Payment
 
 
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
DPaySel
Customer Payment Selection
 
 
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
DPaySelLine
Customer Payment Selection Payment Code
 
 
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
DPaySelLineStg
Customer Payment Selection Payment Code
 
 
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
DPaySelPayCode
Customer Payment Selection Payment Code
 
 
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
DPaySelPayRef
Customer Payment Selection Payment Code
 
 
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