QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ded_det
Data Entry Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ded__qadc01
 
 
x(24)
 
 
ded__qadc02
 
 
x(24)
 
 
ded_document
Document
 
x(16)
 
 
ded_domain
Domain
 
x(8)
 
 
ded_field_name
Field
 
x(24)
 
 
ded_field_value
Value
 
x(40)
 
 
ded_key1
Key 1
 
x(16)
 
 
ded_key2
Key 2
 
x(16)
 
 
ded_line_nbr1
Line 1
 
>>9
 
 
ded_line_nbr2
Line 2
 
>>9
 
 
ded_mod_date
Modified Date
Mod Date
99/99/99
 
 
ded_mod_userid
User ID
 
x(8)
 
 
ded_user1
User Field Character 1
 
x(24)
 
 
ded_user2
User Field Character 2
 
x(24)
 
 
oid_ded_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ded_keys_fld
yes
ded_domain
yes
no
 
 
 
ded_document
yes
no
 
 
 
ded_key1
yes
no
 
 
 
ded_key2
yes
no
 
 
 
ded_line_nbr1
yes
no
 
 
 
ded_line_nbr2
yes
no
 
 
 
ded_field_name
yes
no
 
oid_ded_det
yes
oid_ded_det
yes
no
deed_det
Data Entry Extension Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
deed__qadc01
 
 
x(24)
 
 
deed__qadc02
 
 
x(24)
 
 
deed_document
Document
 
x(16)
 
 
deed_domain
Domain
 
x(8)
 
 
deed_extension
Extension
 
x(16)
 
 
deed_mod_date
Modified Date
Mod Date
99/99/99
 
 
deed_mod_userid
User ID
 
x(8)
 
 
deed_profile
Profile
 
x(16)
 
 
deed_user1
User Field Character 1
 
x(24)
 
 
deed_user2
User Field Character 2
 
x(24)
 
 
oid_deed_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
deed_ext_prof
yes
deed_domain
yes
no
 
 
 
deed_document
yes
no
 
 
 
deed_extension
yes
no
 
 
 
deed_profile
yes
no
 
oid_deed_det
yes
oid_deed_det
yes
no
dee_mstr
Data Entry Extension Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dee__qadc01
 
 
x(24)
 
 
dee__qadc02
 
 
x(24)
 
 
dee_desc
Description
 
x(40)
 
 
dee_document
Document
 
x(16)
 
 
dee_domain
Domain
 
x(8)
 
 
dee_extension
Extension
 
x(16)
 
 
dee_mod_date
Modified Date
Mod Date
99/99/99
 
 
dee_mod_userid
User ID
 
x(8)
 
 
dee_user1
User Field Character 1
 
x(24)
 
 
dee_user2
User Field Character 2
 
x(24)
 
 
oid_dee_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dee_ext
yes
dee_domain
yes
no
 
 
 
dee_document
yes
no
 
 
 
dee_extension
yes
no
 
oid_dee_mstr
yes
oid_dee_mstr
yes
no
defc_det
Data Entry Frame Sequence Condition Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
defc__qadc01
 
 
x(24)
 
 
defc__qadc02
 
 
x(24)
 
 
defc_cond_nbr
Condition
Cnd
>>9
 
 
defc_cond_set_nbr
Condition Set
Set
>>9
 
 
defc_desc
Description
 
x(40)
 
 
defc_direction
Direction
 
Backward/Forward
 
 
defc_document
Document
 
x(16)
 
 
defc_domain
Domain
 
x(8)
 
 
defc_field_name
Field Name
 
x(24)
 
 
defc_field_value
Field Value
 
x(40)
 
 
defc_frame_nbr
Frame Number
Frm
>>9
 
 
defc_mod_date
Modified Date
Mod Date
99/99/99
 
 
defc_mod_userid
User ID
 
x(8)
 
 
defc_profile
Profile
 
x(16)
 
 
defc_user1
User Field Character 1
 
x(24)
 
 
defc_user2
User Field Character 2
 
x(24)
 
 
defc_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
defc_useri01
User Field Integer 1
 
->>>>>>>9
 
 
defc_userl01
User Field Logical 1
 
yes/no
 
 
defc_usert01
User Field Date 1
 
99/99/99
 
 
oid_defc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
defc_cond
yes
defc_domain
yes
no
 
 
 
defc_document
yes
no
 
 
 
defc_profile
yes
no
 
 
 
defc_frame_nbr
yes
no
 
 
 
defc_direction
yes
no
 
 
 
defc_cond_set_nbr
yes
no
 
 
 
defc_cond_nbr
yes
no
 
oid_defc_det
yes
oid_defc_det
yes
no
defd_det
Data Entry Frame Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
defd__qadc01
 
 
x(24)
 
 
defd__qadc02
 
 
x(24)
 
 
defd_document
Document
 
x(16)
 
 
defd_domain
Domain
 
x(8)
 
 
defd_frame_nbr
Frame Number
Frm
>>9
 
 
defd_mod_date
Modified Date
Mod Date
99/99/99
 
 
defd_mod_userid
User ID
 
x(8)
 
 
defd_profile
Profile
 
x(16)
 
 
defd_title_term
Frame Title Term
 
x(40)
 
 
defd_user1
User Field Character 1
 
x(24)
 
 
defd_user2
User Field Character 2
 
x(24)
 
 
oid_defd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
defd_prof_frm
yes
defd_domain
yes
no
 
 
 
defd_document
yes
no
 
 
 
defd_profile
yes
no
 
 
 
defd_frame_nbr
yes
no
 
oid_defd_det
yes
oid_defd_det
yes
no
deff_det
Data Entry Frame Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
deff__qadc01
 
 
x(24)
 
 
deff__qadc02
 
 
x(24)
 
 
deff_default_value
Default Value
 
x(40)
 
 
deff_display_related
Display Related Field
Rel
yes/no
 
 
deff_document
Document
 
x(16)
 
 
deff_domain
Domain
 
x(8)
 
 
deff_field_name
Field Name
 
x(24)
 
 
deff_field_nbr
Field Number
Fld
>>9
 
 
deff_frame_nbr
Frame Number
Frm
>>9
 
 
deff_hide_label
Hide Label
 
yes/no
 
 
deff_mod_date
Modified Date
Mod Date
99/99/99
 
 
deff_mod_userid
User ID
 
x(8)
 
 
deff_profile
Profile
 
x(16)
 
 
deff_required
Required
 
yes/no
 
 
deff_skip_lines
Skip Lines
 
>9
 
 
deff_updateable
Updateable
 
yes/no
 
 
deff_user1
User Field Character 1
 
x(24)
 
 
deff_user2
User Field Character 2
 
x(24)
 
 
deff_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
deff_useri01
User Field Integer 1
 
->>>>>>>9
 
 
deff_userl01
User Field Logical 1
 
yes/no
 
 
deff_usert01
User Field Date 1
 
99/99/99
 
 
deff_validated
Validated
 
yes/no
 
 
oid_deff_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
deff_fld
yes
deff_domain
yes
no
 
 
 
deff_document
yes
no
 
 
 
deff_profile
yes
no
 
 
 
deff_frame_nbr
yes
no
 
 
 
deff_field_nbr
yes
no
 
oid_deff_det
yes
oid_deff_det
yes
no
defl_det
Data Entry Field Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
defl__qadc01
 
 
x(24)
 
 
defl__qadc02
 
 
x(24)
 
 
defl_active
Active
 
yes/no
 
 
defl_default_value
Default Value
 
x(40)
 
 
defl_document
Document
 
x(16)
 
 
defl_domain
Domain
 
x(8)
 
 
defl_extension
Extension
 
x(16)
 
 
defl_field_name
Field Name
 
x(24)
 
 
defl_format
Format
 
x(40)
 
 
defl_label_term
Label Term
 
x(40)
 
 
defl_maintainable
Maintainable
 
yes/no
 
 
defl_mod_date
Modified Date
Mod Date
99/99/99
 
 
defl_mod_userid
User ID
 
x(8)
 
 
defl_required
Required
 
yes/no
 
 
defl_temporary
Temporary
 
yes/no
 
 
defl_type
Type
 
x(12)
 
 
defl_updateable
Updateable
 
yes/no
 
 
defl_user1
User Field Character 1
 
x(24)
 
 
defl_user2
User Field Character 2
 
x(24)
 
 
defl_userc03
User Field Character 3
 
x(24)
 
 
defl_userc04
User Field Character 4
 
x(24)
 
 
defl_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
defl_userd02
User Decimal Field 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
defl_useri01
User Field Integer 1
 
->>>>>>>9
 
 
defl_useri02
User Field Integer 2
 
->>>>>>>9
 
 
defl_userl01
User Field Logical 1
 
yes/no
 
 
defl_userl02
User Field Logical 2
 
yes/no
 
 
defl_usert01
User Field Date 1
 
99/99/99
 
 
defl_usert02
User Field Date 2
 
99/99/99
 
 
oid_defl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
defl_ext_fld
no
defl_domain
yes
no
 
 
 
defl_document
yes
no
 
 
 
defl_extension
yes
no
 
 
 
defl_field_name
yes
no
defl_fld
yes
defl_domain
yes
no
 
 
 
defl_document
yes
no
 
 
 
defl_field_name
yes
no
 
oid_defl_det
yes
oid_defl_det
yes
no
defr_det
Service Contract Deferred/Accrued Revenue Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
defr__qadc01
 
 
x(24)
 
 
defr__qadc02
 
 
x(24)
 
 
defr__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
defr__qadi01
 
 
->>>>>>>9
 
 
defr__qadl01
 
 
yes/no
 
 
defr__qadt01
 
 
99/99/99
 
 
defr_accr_amt
Accrued Amount
 
->>>>,>>>,>>9.99<
10
 
defr_acct
Deferred Revenue
Deferred
x(8)
 
 
defr_amt_type
Amount Type
AT
x(1)
 
 
defr_bill_to
Bill To
 
x(8)
 
 
defr_cc
Deferred Revenue CC
 
x(4)
 
 
defr_curr
Currency
Cur
x(3)
 
 
defr_cust
Customer
 
x(8)
 
 
defr_domain
Domain
 
x(8)
 
 
defr_dsc_acct
Discount Acct
 
x(8)
 
 
defr_dsc_cc
Discount CC
 
x(4)
 
 
defr_dsc_project
Project
 
x(8)
 
 
defr_dsc_sub
Discount Sub-Acct
 
x(8)
 
 
defr_eff_date
Effective Date
Eff Date
99/99/99
 
 
defr_entity
Entity
Enty
x(20)
 
 
defr_eu_nbr
End User
 
x(8)
 
 
defr_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
defr_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
defr_ex_ratetype
Rate Type
 
x(8)
 
 
defr_exru_seq
Sequence
 
>>>>>>>>9
 
 
defr_for
Supported Item
Item
x(18)
 
 
defr_inv_amt
Invoiced Amount
 
->>>>,>>>,>>9.99<
10
 
defr_inv_nbr
Invoice
 
x(22)
 
 
defr_line
Contract Line
Con Line
>>>>>>>9
 
 
defr_mod_date
Modified Date
Mod Date
99/99/99
 
 
defr_mod_userid
User ID
 
x(8)
 
 
defr_nbr
Contract
 
x(8)
 
 
defr_per_period_amt
Per Period Amount
 
->>>>,>>>,>>9.99<
10
 
defr_per_prd_dsc_amt
Per Period Dsc Amount
 
->>>>,>>>,>>9.99<
10
 
defr_period_curr_amt
Period Cur Amount
 
->>>>,>>>,>>9.99<
10
 
defr_period_remain
Period Rem
 
->>>9.9<<<
10
 
defr_prd_dsc_curr_amt
Period Dsc Cur Amount
 
->>>>,>>>,>>9.99<
10
 
defr_prefix
Pf
 
x(1)
 
 
defr_project
Project
 
x(8)
 
 
defr_rec_amt
Recognized Amount
 
->>>>,>>>,>>9.99<
10
 
defr_rev_amt
Revenue Amount
 
->>>>,>>>,>>9.99<
10
 
defr_sls_acct
Sales Acct
 
x(8)
 
 
defr_sls_cc
Sales CC
 
x(4)
 
 
defr_sls_sub
Sales Sub-Acct
 
x(8)
 
 
defr_sub
Deferred Revenue Sub-Acct
 
x(8)
 
 
defr_user1
User Field Character 1
 
x(24)
 
 
defr_user2
User Field Character 2
 
x(24)
 
 
defr_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.99<<<<<<<<
10
 
defr_useri01
User Field Integer 1
 
->>>>>>>9
 
 
defr_userl01
User Field Logical 1
 
yes/no
 
 
defr_usert01
User Field Date 1
 
99/99/99
 
 
oid_defr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
defr_nbrln
yes
defr_domain
yes
no
 
 
 
defr_nbr
yes
no
 
 
 
defr_prefix
yes
no
 
 
 
defr_line
yes
no
 
 
 
defr_inv_nbr
yes
no
 
oid_defr_det
yes
oid_defr_det
yes
no
defs_det
Data Entry Frame Sequence Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
defs__qadc01
 
 
x(24)
 
 
defs__qadc02
 
 
x(24)
 
 
defs_cond_set_nbr
Condition Set
Cnd Set
>>9
 
 
defs_desc
Description
 
x(40)
 
 
defs_direction
Direction
 
Backward/Forward
 
 
defs_document
Document
 
x(16)
 
 
defs_domain
Domain
 
x(8)
 
 
defs_frame_nbr
Frame Number
Frm
>>9
 
 
defs_mod_date
Modified Date
Mod Date
99/99/99
 
 
defs_mod_userid
User ID
 
x(8)
 
 
defs_next_frame_nbr
Next Frame Number
Nxt Frm
>>9
 
 
defs_next_profile
Next Profile
Nxt Prf
x(16)
 
 
defs_next_program
Next Program
Nxt Prog
x(12)
 
 
defs_profile
Profile
 
x(16)
 
 
defs_user1
User Field Character 1
 
x(24)
 
 
defs_user2
User Field Character 2
 
x(24)
 
 
defs_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
defs_useri01
User Field Integer 1
 
->>>>>>>9
 
 
defs_userl01
User Field Logical 1
 
yes/no
 
 
defs_usert01
User Field Date 1
 
99/99/99
 
 
oid_defs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
defs_cond_set
yes
defs_domain
yes
no
 
 
 
defs_document
yes
no
 
 
 
defs_profile
yes
no
 
 
 
defs_frame_nbr
yes
no
 
 
 
defs_direction
yes
no
 
 
 
defs_cond_set_nbr
yes
no
 
oid_defs_det
yes
oid_defs_det
yes
no
DeliveryCond
Delivery Condition
 
 
Field Name
Label
Col-Label
Format
Dec
 
DeliveryCond_ID
Record ID
 
-99999999999
 
 
DeliveryCondCode
Code
 
x(20)
 
 
DeliveryCondDescription
Description
 
x(40)
 
 
DeliveryCondIsActive
Active
 
yes/no
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified 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
DeliveryCondCode
yes
no
 ∗
Prim
yes
DeliveryCond_ID
yes
no
 
ViewIndex
no
DeliveryCondIsActive
yes
no
 
 
 
DeliveryCondCode
yes
no
delt_mstr
Delivery Time Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
delt__qadc01
 
 
x(24)
 
 
delt__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
delt__qadi01
 
 
->>>>>>>9
 
 
delt__qadl01
 
 
yes/no
 
 
delt__qadt01
 
 
99/99/99
 
 
delt_city
To City
City
x(20)
 
 
delt_ctry
To Country Code
Country
x(3)
 
 
delt_domain
Domain
 
x(8)
 
 
delt_method
Delivery Method
Method
x(8)
 
 
delt_mod_date
Modified Date
Mod Date
99/99/99
 
 
delt_mod_userid
User ID
 
x(8)
 
 
delt_site
From Site
Site
x(8)
 
 
delt_state
To State
State
x(4)
 
 
delt_transit
Transit Days
Transit
>>9
 
 
delt_use_category
Use Category
Use
x(2)
 
 
delt_userc01
User Field 1
 
x(24)
 
 
delt_userc02
User Field 2
 
x(24)
 
 
delt_userd01
User Field Decimal 1
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
delt_useri01
User Field Integer 1
 
->>>>>>9
 
 
delt_userl01
User Field Logical
 
yes/no
 
 
delt_usert01
User Field Date 1
 
99/99/99
 
 
oid_delt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
delt_site
yes
delt_domain
yes
no
 
 
 
delt_site
yes
no
 
 
 
delt_ctry
yes
no
 
 
 
delt_state
yes
no
 
 
 
delt_city
yes
no
 
 
 
delt_use_category
yes
no
 
 
 
delt_method
yes
no
delt_use_category
yes
delt_domain
yes
no
 
 
 
delt_use_category
yes
no
 
 
 
delt_site
yes
no
 
 
 
delt_ctry
yes
no
 
 
 
delt_state
yes
no
 
 
 
delt_city
yes
no
 
 
 
delt_method
yes
no
 
oid_delt_mstr
yes
oid_delt_mstr
yes
no
dep_mstr
Data Entry Profile Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
dep__qadc01
 
 
x(24)
 
 
dep__qadc02
 
 
x(24)
 
 
dep_canrun[15]
Roles
 
x(60)
 
 
dep_default
Default Profile
 
yes/no
 
 
dep_desc
Description
 
x(40)
 
 
dep_document
Document
 
x(16)
 
 
dep_domain
Domain
 
x(8)
 
 
dep_mod_date
Modified Date
Mod Date
99/99/99
 
 
dep_mod_userid
User ID
 
x(8)
 
 
dep_profile
Profile
 
x(16)
 
 
dep_user1
User Field Character 1
 
x(24)
 
 
dep_user2
User Field Character 2
 
x(24)
 
 
oid_dep_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
dep_prof
yes
dep_domain
yes
no
 
 
 
dep_document
yes
no
 
 
 
dep_profile
yes
no
 
oid_dep_mstr
yes
oid_dep_mstr
yes
no
deu_det
Data Entry User Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
deu__qadc01
 
 
x(24)
 
 
deu__qadc02
 
 
x(24)
 
 
deu_document
Document
 
x(16)
 
 
deu_domain
Domain
 
x(8)
 
 
deu_id_type
ID Type
 
Role/User
 
 
deu_mod_date
Modified Date
Mod Date
99/99/99
 
 
deu_mod_userid
User ID
 
x(8)
 
 
deu_profile
Default Profile
 
x(16)
 
 
deu_user1
User Field Character 1
 
x(24)
 
 
deu_user2
User Field Character 2
 
x(24)
 
 
deu_userid
User/Role ID
 
x(20)
 
 
oid_deu_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
deu_profile
no
deu_domain
yes
no
 
 
 
deu_document
yes
no
 
 
 
deu_profile
yes
no
 
 
 
deu_id_type
yes
no
 
 
 
deu_userid
yes
no
deu_user
yes
deu_domain
yes
no
 
 
 
deu_document
yes
no
 
 
 
deu_id_type
yes
no
 
 
 
deu_userid
yes
no
 
oid_deu_det
yes
oid_deu_det
yes
no
de_mstr
Data Entry Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
de__qadc01
 
 
x(24)
 
 
de__qadc02
 
 
x(24)
 
 
de_create_date
Create Date
 
99/99/99
 
 
de_create_duration
Create Duration
 
>>>>>>>9
 
 
de_create_time
Create Time
 
99:99:99
 
 
de_create_userid
Created By
 
x(8)
 
 
de_document
Document
 
x(16)
 
 
de_domain
Domain
 
x(8)
 
 
de_key1
Key 1
 
x(16)
 
 
de_key2
Key 2
 
x(16)
 
 
de_mod_count
Modified Count
Mod Count
>>>>>>>9
 
 
de_mod_date
Modified Date
Mod Date
99/99/99
 
 
de_mod_duration
Modified Duration
Mod Duration
>>>>>>>9
 
 
de_mod_time
Modified Time
Mod Time
99:99:99
 
 
de_mod_userid
Modified By
Mod By
x(8)
 
 
de_status
Status
 
x(2)
 
 
de_user1
User Field Character 1
 
x(24)
 
 
de_user2
User Field Character 2
 
x(24)
 
 
de_userc03
User Field Character 3
 
x(24)
 
 
de_userc04
User Field Character 4
 
x(24)
 
 
de_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
de_userd02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
de_useri01
User Field Integer 1
 
->>>>>>>9
 
 
de_useri02
User Field Integer 2
 
->>>>>>>9
 
 
de_userl01
User Field Logical 1
 
yes/no
 
 
de_userl02
User Field Logical 2
 
yes/no
 
 
de_usert01
User Field Date 1
 
99/99/99
 
 
de_usert02
User Field Date 2
 
99/99/99
 
 
oid_de_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
de_keys
yes
de_domain
yes
no
 
 
 
de_document
yes
no
 
 
 
de_key1
yes
no
 
 
 
de_key2
yes
no
 
oid_de_mstr
yes
oid_de_mstr
yes
no
df_mstr
Document Print Format Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
df__qadc01
 
 
x(8)
 
 
df_desc
Description
 
x(30)
 
 
df_domain
Domain
 
x(8)
 
 
df_form_code
Form Code
Form Cd
x(2)
 
 
df_format
Document Format
Format
x(8)
 
 
df_inv
Invoice
 
yes/no
 
 
df_ld_form_code
LD Form Code
 
x(2)
 
 
df_ld_max_item
LD Max Item
 
>>9
 
 
df_type
Document Type
 
x(3)
 
 
df_user1
Ufld1
 
x(8)
 
 
df_user2
Ufld2
 
x(8)
 
 
oid_df_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
df_format
yes
df_domain
yes
no
 
 
 
df_type
yes
no
 
 
 
df_format
yes
no
 
oid_df_mstr
yes
oid_df_mstr
yes
no
DHist
Customer Balance History
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Link to Company
 
-99999999999
 
 
CostCentre_ID
Link to CostCentre
 
-99999999999
 
 
Currency_ID
Link to Currency
 
-99999999999
 
 
DBalance_ID
Link to DBalance
 
-99999999999
 
 
Debtor_ID
Link to Debtor
 
-99999999999
 
 
DHist_ID
Record ID
 
-99999999999
 
 
DHistBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DHistBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DHistBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossCredNoteCC
SC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossCredNoteLC
BC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossCredNoteTC
TC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossInvoiceCC
SC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossInvoiceLC
BC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistGrossInvoiceTC
TC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementCreditCC
SC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementCreditLC
BC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementCreditTC
TC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementDebitCC
SC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementDebitLC
BC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
DHistMovementDebitTC
TC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoCredNoteCC
SC Net Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoCredNoteLC
BC Net to Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoCredNoteTC
TC Net Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoInvoiceCC
SC Net Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoInvoiceLC
BC Net to Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistNettoInvoiceTC
TC Net Invoice
 
->>>,>>>,>>>,>>9.99
4
 
DHistYearPeriodFrom
From Year GL Period
 
->,>>>,>>9
 
 
DHistYearPeriodTill
To Year GL Period
 
->,>>>,>>9
 
 
Division_ID
Link to Division
 
-99999999999
 
 
GL_ID
Link to GL
 
-99999999999
 
 
Journal_ID
Link to Journal
 
-99999999999
 
 
Project_ID
Link to Project
 
-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
 
CostCentre
no
CostCentre_ID
yes
no
 
Currency
no
Currency_ID
yes
no
 
CyDebtorYearPeriodFrom
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DHistYearPeriodFrom
yes
no
 
CyDebtorYearPeriodTill
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DHistYearPeriodTill
yes
no
 
CyYearPeriodFrom
no
Company_ID
yes
no
 
 
 
DHistYearPeriodFrom
yes
no
 
CyYearPeriodTill
no
Company_ID
yes
no
 
 
 
DHistYearPeriodTill
yes
no
 
DBalance
no
DBalance_ID
yes
no
 
Debtor
no
Debtor_ID
yes
no
 
Division
no
Division_ID
yes
no
 
GL
no
GL_ID
yes
no
 
Journal
no
Journal_ID
yes
no
 ∗
Prim
yes
DHist_ID
yes
no
 
Project
no
Project_ID
yes
no
 
UniqueKey
yes
Company_ID
yes
no
 
 
 
DHistYearPeriodFrom
yes
no
 
 
 
Currency_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
GL_ID
yes
no
 
 
 
Project_ID
yes
no
 
 
 
CostCentre_ID
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
Division_ID
yes
no
DInvoice
Customer Invoice
 
 
Field Name
Label
Col-Label
Format
Dec
 
Bill_ID
Link to Bill
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
ControlGL_ID
Account
 
-99999999999
 
 
CostCentre_ID
Cost Center
 
-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
 
CustomDecimal10
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal11
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal12
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal13
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal14
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
Link to Debtor
 
-99999999999
 
 
DebtorVatNumber_ID
Link to VatNumber
 
-99999999999
 
 
DeliveryCond_ID
Link to DeliveryCond
 
-99999999999
 
 
DInvoice_ID
Record ID
 
-99999999999
 
 
DInvoiceBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceCreditCC
SC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceCreditLC
BC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceCreditTC
TC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceDebitCC
SC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceDebitLC
BC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceDebitTC
TC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceBatch
Batch Number
 
x(8)
 
 
DInvoiceBillDate
Bill Date
 
99/99/9999
 
 
DInvoiceCCRate
SC Rate
 
->,>>>,>>9.9999999999
10
 
DInvoiceCCScale
SC Rate Scale
 
->,>>>,>>9.9999999999
10
 
DInvoiceClosingDate
Closing Date
 
99/99/9999
 
 
DInvoiceCombinedStatus
Status
 
x(20)
 
 
DInvoiceComm1
% Commission
% Commission 1
>>9.99
2
 
DInvoiceComm2
% Commission
% Commission 2
>>9.99
2
 
DInvoiceComm3
% Commission
% Commission 3
>>9.99
2
 
DInvoiceComm4
% Commission
% Commission 4
>>9.99
2
 
DInvoiceCommentNote
Comments
 
x(2000)
 
 
DInvoiceContact
Contact
 
x(40)
 
 
DInvoiceCreationDate
Creation Date
 
99/99/9999
 
 
DInvoiceCreationTimeString
Creation Time
 
x(10)
 
 
DInvoiceCurrency_ID
Currency Code
Curr
-99999999999
 
 
DInvoiceCustomsOfficeDocNbrIN
Customs Office Document Number (IN)
 
x(20)
 
 
DInvoiceDate
Invoice Date
Inv Date
99/99/9999
 
 
DInvoiceDebtorVatNumber
Customer Tax Number
 
x(40)
 
 
DInvoiceDescription
Description
 
x(40)
 
 
DInvoiceDiscountDueDate
Discount Due Date
 
99/99/9999
 
 
DInvoiceDiscPercentage
Discount Percentage
 
->>9.99
2
 
DInvoiceDIText
Description
 
x(40)
 
 
DInvoiceDueDate
Due Date
 
99/99/9999
 
 
DInvoiceEInvoiceNumberIN
E-Invoice Number (IN)
 
x(20)
 
 
DInvoiceEInvoiceStatusIN
E-Invoice Status (IN)
 
x(20)
 
 
DInvoiceExchangeRate
Exchange Rate
 
->,>>>,>>9.9999999999
10
 
DInvoiceExportDateIN
Export Date (IN)
 
99/99/9999
 
 
DInvoiceExportIDIN
Export ID (IN)
 
x(20)
 
 
DInvoiceGoldenTaxInvoiceList
Golden Tax Invoices
GT Invoices
x(255)
 
 
DInvoiceGraceDays
Grace Days
 
->,>>>,>>9
 
 
DInvoiceGTVatTransType
Golden Tax Transaction Type
 
x(40)
 
 
DInvoiceInvCertCertificate
Invoice Certificate
 
x(16)
 
 
DInvoiceInvCertKey
Invoice Certification Key
 
x(128)
 
 
DInvoiceInvCertSignatureCurr
Signature Current Invoice
 
x(256)
 
 
DInvoiceInvCertSignaturePrev
Signature Previous Invoice
 
x(256)
 
 
DInvoiceInvCertSignatureShort
Signature
 
x(4)
 
 
DInvoiceInvCertVersion
Version
 
x(8)
 
 
DInvoiceIsDiscTaxAtInv
Discount Tax at Invoice
 
yes/no
 
 
DInvoiceIsDiscTaxAtPaym
Discount Tax at Payment
 
yes/no
 
 
DInvoiceIsEInvoiceIN
E-Invoice (IN)
 
yes/no
 
 
DInvoiceIsExternal
External
External Invoice
yes/no
 
 
DInvoiceIsOpen
Open
 
yes/no
 
 
DInvoiceIsPaymentAllowed
CN Payment Allowed
 
yes/no
 
 
DInvoiceIsReportedIN
Reported (IN)
 
yes/no
 
 
DInvoiceIsSelected
Selected
Sel
yes/no
 
 
DInvoiceIsTaxable
Taxable
 
yes/no
 
 
DInvoiceIsTaxExcluded
Tax Excluded
Tax Excl
yes/no
 
 
DInvoiceIsVatDelay
Tax Delay
 
yes/no
 
 
DInvoiceIsWithBank
With Bank
 
yes/no
 
 
DInvoiceIsWithDeduction
With Deduction
 
yes/no
 
 
DInvoiceLastFinChargeDate
Last Finance Charge Date
 
99/99/9999
 
 
DinvoiceLastReminderDate
Last Reminder Date
 
99/99/9999
 
 
DInvoiceLateInt
Late Interest
 
->>9.99
2
 
DInvoiceLegalDocumentList
Legal Documents
 
x(255)
 
 
DInvoiceMarginAmountTC
Margin Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceNewTaxPointDateIN
New Tax Point Date (IN)
 
99/99/9999
 
 
DInvoiceNonDiscAmtCC
SC Non-disc Amt
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceNonDiscAmtLC
BC Non-disc Amt
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceNonDiscAmtTC
TC Non-disc Amt
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalCreditCC
SC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalCreditLC
BC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalCreditTC
TC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalDebitCC
SC Invoice Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalDebitLC
BC Invoice Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOriginalDebitTC
TC Invoice Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceOwnVatNumber
Own Tax Number
 
x(40)
 
 
DInvoicePaymentDate
Expected Payment Date
 
99/99/9999
 
 
DInvoicePostingDate
Posting Date
 
99/99/9999
 
 
DInvoicePostingPeriod
GL Period
 
99
 
 
DInvoicePostingYear
Year
 
9999
 
 
DInvoicePostingYearPeriod
Year/GL Period
GL Cal Yr/GL Pd
999999
 
 
DInvoicePurchaseOrder
Purchase Order
 
x(22)
 
 
DInvoiceRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
DInvoiceReconciliationKey
Invoice Reconciliation Key
 
x(40)
 
 
DInvoiceReminderCount
Reminder Counter
 
->,>>>,>>9
 
 
DInvoiceReportingDateIN
Reporting Date (IN)
 
99/99/9999
 
 
DInvoiceSalesAmt
Sales Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceSalesOrderList
Sales Orders
 
x(255)
 
 
DInvoiceShipperList
Shippers
 
x(255)
 
 
DInvoiceShipToCode
Ship-To Code
 
x(8)
 
 
DInvoiceSlsPsn1
Salesperson 1
 
x(8)
 
 
DInvoiceSlsPsn2
Salesperson 2
 
x(8)
 
 
DInvoiceSlsPsn3
Salesperson 3
 
x(8)
 
 
DInvoiceSlsPsn4
Salesperson 4
 
x(8)
 
 
DInvoiceTaxPointDate
Tax Point Date
 
99/99/9999
 
 
DInvoiceTSMNumber
Payment Reference
 
x(40)
 
 
DInvoiceType
Type
 
x(20)
 
 
DInvoiceVatBaseCreditCC
SC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatBaseCreditLC
BC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatBaseCreditTC
TC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatBaseDebitCC
SC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatBaseDebitLC
BC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatBaseDebitTC
TC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatCreditCC
SC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatCreditLC
BC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatCreditTC
TC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatDebitCC
SC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatDebitLC
BC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatDebitTC
TC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceVatExchangeRate
Tax Exchange Rate
 
->,>>>,>>9.9999999999
10
 
DInvoiceVatRateScale
Tax Rate Scale
 
->,>>>,>>9.9999999999
10
 
DInvoiceVoucher
Voucher
 
999999999
 
 
Division_ID
Sub-Account
Sub-Acct
-99999999999
 
 
Journal_ID
Daybook Code
 
-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)
 
 
LinkedDInvoice_ID
Voucher
 
-99999999999
 
 
NormalPaymentCondition_ID
Credit Terms Code
Cred Trm
-99999999999
 
 
OwnVatNumber_ID
Link to VatNumber
 
-99999999999
 
 
Period_ID
Link to Period
 
-99999999999
 
 
Project_ID
Project
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Reason_ID
Invoice Status Code
 
-99999999999
 
 
ShipFromAddress_ID
Address
 
-99999999999
 
 
ShipToAddress_ID
City
 
-99999999999
 
 
SoldToDebtor_ID
Customer Code
 
-99999999999
 
 
TransactionEndCountry_ID
Country Code
Country
-99999999999
 
 
TransactionStartCountry_ID
Country Code
Country
-99999999999
 
 
VatCurrency_ID
Tax Declaration Currency
Tax Currency
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BillIdx
no
Bill_ID
yes
no
 
CCIdx
no
CostCentre_ID
yes
no
 
CombinedStatus
no
DInvoiceCombinedStatus
yes
no
 
Company
no
Company_ID
yes
no
 
CompanyClosingDate
no
Company_ID
yes
no
 
 
 
DInvoiceClosingDate
yes
no
 
ControlGL
no
ControlGL_ID
yes
no
 
CyDebInvDate
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DInvoiceDate
yes
no
 
CyDebtorClosingDate
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DInvoiceClosingDate
yes
no
 
CyJrnlDateIdx
no
Company_ID
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
DInvoicePostingDate
yes
no
 
CyPeriodYearPeriod
no
Company_ID
yes
no
 
 
 
DInvoicePostingYearPeriod
yes
no
 
Debtor
no
Debtor_ID
yes
no
 
DebtorVatNumber
no
DebtorVatNumber_ID
yes
no
 
Deduct
no
DInvoiceIsWithDeduction
yes
no
 
DelCondIdx
no
DeliveryCond_ID
yes
no
 
DInvoiceCurrency
no
DInvoiceCurrency_ID
yes
no
 
DInvoiceDITextIdx
no
DInvoiceDIText
yes
no
 
DInvoicePostingYear
no
DInvoicePostingYear
yes
no
 
Division
no
Division_ID
yes
no
 
EndCountryIdx
no
TransactionEndCountry_ID
yes
no
 
InvoiceDateIDX
no
DInvoiceDate
yes
no
 
IsOpen
no
DInvoiceIsOpen
yes
no
 
IsSelected
no
DInvoiceIsSelected
yes
no
 
IsWithBank
no
DInvoiceIsWithBank
yes
no
 
Journal
no
Journal_ID
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
LinkedDInvoice
no
LinkedDInvoice_ID
yes
no
 
NormPayCondIdx
no
NormalPaymentCondition_ID
yes
no
 
OwnVatIdx
no
OwnVatNumber_ID
yes
no
 
Period
no
Period_ID
yes
no
 
POIdx
no
DInvoicePurchaseOrder
yes
no
 
PostingDateIDX
no
DInvoicePostingDate
yes
no
 ∗
Prim
yes
DInvoice_ID
yes
no
 
Project
no
Project_ID
yes
no
 
ReasonIdx
no
Reason_ID
yes
no
 
ShipFrom
no
ShipFromAddress_ID
yes
no
 
ShipTo
no
SoldToDebtor_ID
yes
no
 
ShipToIdx
no
ShipToAddress_ID
yes
no
 
StartCountryIdx
no
TransactionStartCountry_ID
yes
no
 
TSMIdx
no
DInvoiceTSMNumber
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
DInvoicePostingYear
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
DInvoiceVoucher
yes
no
 
VatCurrency
no
VatCurrency_ID
yes
no
 
ViewIndex
no
Company_ID
yes
no
 
 
 
DInvoicePostingYear
yes
no
 
 
 
DInvoicePostingPeriod
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
DInvoiceVoucher
yes
no
 
Voucher
no
DInvoiceVoucher
yes
no
DInvoiceBank
Customer Invoice Bank Records
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankNumber_ID
Formatted Bank Account No
Formatted Number
-99999999999
 
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceBank_ID
Record ID
 
-99999999999
 
 
DInvoiceBankToPayTC
TC Payment Amount
 
->>>,>>>,>>>,>>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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankNumber
no
BankNumber_ID
yes
no
 
DInvoice
no
DInvoice_ID
yes
no
 ∗
Prim
yes
DInvoiceBank_ID
yes
no
 
UniqueIdx
yes
DInvoice_ID
yes
no
 
 
 
BankNumber_ID
yes
no
DInvoiceBankPayCode
Customer Invoice Bank Payment Code
 
 
Field Name
Label
Col-Label
Format
Dec
 
DInvoiceBank_ID
Link to DInvoiceBank
 
-99999999999
 
 
DInvoiceBankPayCode_ID
Record ID
 
-99999999999
 
 
DInvoiceBankPayCodeValue
Value
 
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)
 
 
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
 
DIBank
no
DInvoiceBank_ID
yes
no
 
PFCodeIdx
no
PayFormatCode_ID
yes
no
 
PFGrpIdx
no
PayFormatGroup_ID
yes
no
 ∗
Prim
yes
DInvoiceBankPayCode_ID
yes
no
DInvoiceDeduction
Deduction of Invoice
 
 
Field Name
Label
Col-Label
Format
Dec
 
ApprovePosting_ID
Link to ApprovePosting
 
-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)
 
 
DeductionCatLine_ID
Link to DeductionCatLine
 
-99999999999
 
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceDeduction_ID
Record ID
 
-99999999999
 
 
DInvoiceDeductionApRejCom
Approve/Reject Comment
 
x(80)
 
 
DInvoiceDeductionApRejDate
Approve/Reject Date
Mod Date
99/99/9999
 
 
DInvoiceDeductionCC
Deduction SC
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceDeductionComment
Comment
 
x(2000)
 
 
DInvoiceDeductionCreateDate
Create Date
Mod Date
99/99/9999
 
 
DInvoiceDeductionCustRef
Customer Reference
 
x(20)
 
 
DInvoiceDeductionLC
Deduction BC
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceDeductionPromotionCode
Promotion Code
 
x(20)
 
 
DInvoiceDeductionSequence
Sequence
 
9999999999
 
 
DInvoiceDeductionStatus
Deduction Status
 
x(40)
 
 
DInvoiceDeductionTC
Deduction TC
 
->>>,>>>,>>>,>>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)
 
 
PaidDInvoice_ID
Link to PaidDInvoice
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
RejectPosting_ID
Link to RejectPosting
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ApPost
no
ApprovePosting_ID
yes
no
 
Deduct
no
DeductionCatLine_ID
yes
no
 
DI
no
DInvoice_ID
yes
no
 
PaidDI
no
PaidDInvoice_ID
yes
no
 ∗
Prim
yes
DInvoiceDeduction_ID
yes
no
 
RePost
no
RejectPosting_ID
yes
no
 
UniIdx
yes
DInvoice_ID
yes
no
 
 
 
DeductionCatLine_ID
yes
no
 
 
 
PaidDInvoice_ID
yes
no
 
 
 
DInvoiceDeductionSequence
yes
no
DInvoiceMovement
Customer Invoice Movements
 
 
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)
 
 
Debtor_ID
Link to Debtor
 
-99999999999
 
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceMovement_ID
Record ID
 
-99999999999
 
 
DInvoiceMovementDiscountTC
TC Discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceMovementIsForDraft
For Draft
 
yes/no
 
 
DInvoiceMovementPostDate
Posting Date
 
99/99/9999
 
 
DInvoiceMovementType
Type
 
x(20)
 
 
DInvoiceMovementYearPeriod
Year/GL Period
 
999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Period_ID
Link to Period
 
-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
 
Company
no
Company_ID
yes
no
 
CyDate
no
Company_ID
yes
no
 
 
 
DInvoiceMovementPostDate
yes
no
 
CyDebtDate
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DInvoiceMovementPostDate
yes
no
 
CyDebYearPd
no
Company_ID
yes
no
 
 
 
Debtor_ID
yes
no
 
 
 
DInvoiceMovementYearPeriod
yes
no
 
Debtor
no
Debtor_ID
yes
no
 
DIMovYearPd
no
DInvoiceMovementYearPeriod
yes
no
 
DInvoice
no
DInvoice_ID
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
Period
no
Period_ID
yes
no
 
PostingLine
no
PostingLine_ID
yes
no
 ∗
Prim
yes
DInvoiceMovement_ID
yes
no
DInvoiceOpInfo
Customer Invoice Operational Info
 
 
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)
 
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceOpInfo_ID
Record ID
 
-99999999999
 
 
DInvoiceOpInfoCode
Identifier
 
x(20)
 
 
DInvoiceOpInfoDescription
Description
 
x(40)
 
 
DInvoiceOpInfoGTDocNbr
Golden Tax Document Number
Golden Tax Doc Nbr
x(20)
 
 
DInvoiceOpInfoGTUpdateType
Golden Tax Update Type
 
x(20)
 
 
DInvoiceOpInfoType
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
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
DInvoiceOpInfo_ID
yes
no
 
TypeCode
no
DInvoiceOpInfoType
yes
no
 
 
 
DInvoiceOpInfoCode
yes
no
 
UniqueIdx
yes
DInvoice_ID
yes
no
 
 
 
DInvoiceOpInfoType
yes
no
 
 
 
DInvoiceOpInfoCode
yes
no
DInvoicePosting
Customer Invoice Posting Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoicePosting_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)
 
 
Posting_ID
Link to Posting
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
Posting
no
Posting_ID
yes
no
 ∗
Prim
yes
DInvoicePosting_ID
yes
no
DInvoiceShipper
Customer Invoice Shipper References
 
 
Field Name
Label
Col-Label
Format
Dec
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceShipper_ID
Record ID
 
-99999999999
 
 
DInvoiceShipperCode
Shipper Code
 
x(20)
 
 
DInvoiceShipperDescription
Shipper Description
 
x(40)
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
DIShipperCode
no
DInvoiceShipperCode
yes
no
 ∗
Prim
yes
DInvoiceShipper_ID
yes
no
DInvoiceStage
Customer Invoice Stage Payment
 
 
Field Name
Label
Col-Label
Format
Dec
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
DInvoiceStage_ID
Record ID
 
-99999999999
 
 
DInvoiceStageAmountCC
SC Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceStageAmountLC
BC Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceStageAmountTC
TC Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceStageAmtAppliedTC
TC Applied Amount
 
->>>,>>>,>>>,>>9.99
4
 
DInvoiceStageDiscDate
Discount Date
 
99/99/9999
 
 
DInvoiceStageDiscPerc
Discount Percentage
 
->,>>>,>>9.99
3
 
DInvoiceStageDueDate
Due Date
 
99/99/9999
 
 
DInvoiceStageIsSelected
Selected
 
yes/no
 
 
DInvoiceStagePercentage
Percentage
%
->,>>>,>>9.99
10
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PaymentConditionStaged_ID
Credit Terms Code
Cred Trm
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
DueDate
no
DInvoiceStageDueDate
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
PayCondStageIdx
no
PaymentConditionStaged_ID
yes
no
 ∗
Prim
yes
DInvoiceStage_ID
yes
no
 
UniqueIdx
yes
DInvoiceStageDueDate
yes
no
 
 
 
DInvoice_ID
yes
no