|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|