QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
txbd_det
Tax Base Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txbd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txbd__qad01
 
 
x(8)
 
 
txbd__qad02
 
 
x(8)
 
 
txbd_base
Tax Base
 
x(8)
 
 
txbd_domain
Domain
 
x(8)
 
 
txbd_tax_type
Tax Type
 
x(16)
 
 
txbd_user1
Ufld1
 
x(8)
 
 
txbd_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txbd_det
yes
oid_txbd_det
yes
no
txbd_base_type
yes
txbd_domain
yes
no
 
 
 
txbd_base
yes
no
 
 
 
txbd_tax_type
yes
no
txcl_mstr
Tax Class Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txcl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txcl__qadc01
 
 
x(24)
 
 
txcl__qadc02
 
 
x(24)
 
 
txcl_mod_date
Modified Date
Mod Date
99/99/99
 
 
txcl_mod_userid
User ID
 
x(8)
 
 
txcl_tax_cls
Tax Class
 
x(8)
 
 
txcl_tax_desc
Description
 
x(24)
 
 
txcl_user1
User Field Character 1
 
x(24)
 
 
txcl_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txcl_mstr
yes
oid_txcl_mstr
yes
no
txcl_tax_cls
yes
txcl_tax_cls
yes
no
txc_ctrl
Tax Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txc__chr01
 
 
x(8)
 
 
txc__chr02
 
 
x(8)
 
 
txc__dec01
 
 
->>>,>>>,>>9.99
10
 
txc__dec02
 
 
->>>,>>>,>>9.99
10
 
txc__dte01
 
 
99/99/99
 
 
txc__log01
 
 
yes/no
 
 
txc__qad01
 
 
x(8)
 
 
txc__qad02
 
 
x(8)
 
 
txc__qad03
 
 
yes/no
 
 
txc__qad04
 
 
->>>,>>>,>>9.99
10
 
txc__qad05
 
 
99/99/99
 
 
txc_ar_taxexcl
Customer Invoice Total Excludes Tax
 
yes/no
 
 
txc_by_line
Tax-By-Line
 
yes/no
 
 
txc_comment_type
Tax Comment Type
 
x(2)
 
 
txc_ctry_code
Country Code
Ctry
x(3)
 
 
txc_default_taxable
Taxable
 
yes/no
 
 
txc_detrp
Display Detail on Reports
 
yes/no
 
 
txc_domain
Domain
 
x(8)
 
 
txc_edit_hist
Update History Allowed
 
yes/no
 
 
txc_index1
Index
 
>>>>>9
 
 
txc_inv_disc
Discount Tax at Invoice
 
yes/no
 
 
txc_inv_hist
Keep Tax History
Hist
yes/no
 
 
txc_is_tax_confirmed
 
 
yes/no
 
 
txc_method
Tax Method
 
x(2)
 
 
txc_non_commercial
Tax on Non-Commercial Trans
 
yes/no
 
 
txc_pmt_disc
Discount Tax at Payment
 
yes/no
 
 
txc_prt_vat_reg
Print VAT Registration
Prt!VAT
yes/no
 
 
txc_rcpt_tax_point
Accrue Tax at Receipt
Accrue!Receipt
yes/no
 
 
txc_round
Rounding Method
R
x(1)
 
 
txc_tax_accrual_glcode
 
 
x(8)
 
 
txc_tax_code
Last Tax Code
 
x(8)
 
 
txc_tax_env
Tax Environment
 
x(16)
 
 
txc_tax_in_city
In City
 
yes/no
 
 
txc_tax_zone
Tax Zone
 
x(16)
 
 
txc_update_tax
Update Tax Allowed
 
yes/no
 
 
txc_usage_tax_point
Accrue Tax At Usage
Accrue Tax!At Usage
yes/no
 
 
txc_user1
Ufld1
 
x(8)
 
 
txc_user2
Ufld2
 
x(8)
 
 
txc_val_vat_reg
Validate VAT Registration
Val!VAT
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txc_ctrl
yes
oid_txc_ctrl
yes
no
txc_index1
yes
txc_domain
yes
no
txed_det
Tax Environment Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txed_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txed__log01
 
 
yes/no
 
 
txed__qad01
 
 
x(8)
 
 
txed__qad02
 
 
x(8)
 
 
txed__qad03
 
 
yes/no
 
 
txed__qadc01
 
 
x(24)
 
 
txed_round
Rounding Method
R
x(1)
 
 
txed_seq
Sequence
Sq
>9
 
 
txed_tax_env
Tax Environment
Tax Env
x(16)
 
 
txed_tax_type
Tax Type
 
x(16)
 
 
txed_user1
Ufld1
 
x(8)
 
 
txed_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txed_det
yes
oid_txed_det
yes
no
 
txed_seq
no
txed_tax_env
yes
no
 
 
 
txed_seq
yes
no
txed_tax_env
yes
txed_tax_env
yes
no
 
 
 
txed_tax_type
yes
no
txenv_mstr
Tax Class Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txenv_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txenv__qadc01
 
 
x(24)
 
 
txenv__qadc02
 
 
x(24)
 
 
txenv_mod_date
Modified Date
Mod Date
99/99/99
 
 
txenv_mod_userid
User ID
 
x(8)
 
 
txenv_tax_desc
Description
 
x(24)
 
 
txenv_tax_env
Tax Environment
Code
x(16)
 
 
txenv_user1
User Field Character 1
 
x(24)
 
 
txenv_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txenv_mstr
yes
oid_txenv_mstr
yes
no
txenv_tax_env
yes
txenv_tax_env
yes
no
txe_mstr
Tax Environment Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txe_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txe__log01
 
 
yes/no
 
 
txe__qad01
Description
 
x(24)
 
 
txe__qad02
 
 
x(8)
 
 
txe__qad03
 
 
yes/no
 
 
txe__qadc01
 
 
x(24)
 
 
txe_desc
Tax Environment
Tax Env
x(16)
 
 
txe_tax_env
Tax Environment
Tax Env
x(16)
 
 
txe_user1
Ufld1
 
x(8)
 
 
txe_user2
Ufld2
 
x(8)
 
 
txe_zone_from
Ship-From Tax Zone
Ship-From Zone
x(16)
 
 
txe_zone_to
Ship-To Tax Zone
Ship-To Zone
x(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txe_mstr
yes
oid_txe_mstr
yes
no
 
txe_desc
no
txe_desc
yes
no
txe_tax_env
yes
txe_tax_env
yes
no
 
txe_to_from
yes
txe_zone_to
yes
no
 
 
 
txe_zone_from
yes
no
txfsd_det
Tax Usage for Call Routines
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txfsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txfsd__qadc01
QAD Character Field 1
 
x(24)
 
 
txfsd__qadc02
QAD Character Field 2
 
x(24)
 
 
txfsd__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
2
 
txfsd__qadt01
QAD Date Field 1
 
99/99/99
 
 
txfsd_domain
Domain
 
x(8)
 
 
txfsd_fcg_code
Charge Code
 
x(8)
 
 
txfsd_fpst_status
Return Status
 
x(8)
 
 
txfsd_fsc_code
Service Category
 
x(8)
 
 
txfsd_mod_date
Modified Date
Mod Date
99/99/99
 
 
txfsd_mod_userid
User ID
 
x(8)
 
 
txfsd_tax_usage
Tax Usage
 
x(8)
 
 
txfsd_user1
User Field Character 1
 
x(24)
 
 
txfsd_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txfsd_det
yes
oid_txfsd_det
yes
no
txfsd_fsc_code
yes
txfsd_domain
yes
no
 
 
 
txfsd_fsc_code
yes
no
 
 
 
txfsd_fcg_code
yes
no
 
 
 
txfsd_fpst_status
yes
no
txhd_det
Tax History Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txhd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txhd__chr01
 
 
x(8)
 
 
txhd__chr02
 
 
x(8)
 
 
txhd__dec01
 
 
->>>,>>>,>>9.99
10
 
txhd__dec02
 
 
->>>,>>>,>>9.99
10
 
txhd__dte01
 
 
99/99/99
 
 
txhd__log01
 
 
yes/no
 
 
txhd__qad01
 
 
x(8)
 
 
txhd__qad02
 
 
x(8)
 
 
txhd__qad03
 
 
yes/no
 
 
txhd__qad04
 
 
->>>,>>>,>>9.99
10
 
txhd__qad05
 
 
->>>,>>>,>>9.99
10
 
txhd__qad06
 
 
99/99/99
 
 
txhd_chg_date
Date Last Changed
Chg Date
99/99/99
 
 
txhd_comm_code
Commodity Code
Com Code
x(8)
 
 
txhd_container
Container Indicator
C
x(1)
 
 
txhd_curr
Currency
Cur
x(3)
 
 
txhd_cust_ctry
Cust Tax Reg Ctry
Cust Country
x(3)
 
 
txhd_cust_num
Cust Tax Reg Nbr
Customer TRN
x(15)
 
 
txhd_db_export
Date Exported From Database
DBE Date
99/99/99
 
 
txhd_del_terms
Terms of Delivery
T D
x(3)
 
 
txhd_desdis_ctry
Destination/Dispatch Country
D C
x(3)
 
 
txhd_desdis_port
Destination/Dispatch Port
D P
x(8)
 
 
txhd_domain
Domain
 
x(8)
 
 
txhd_edit_hist
Editable Record
E
yes/no
 
 
txhd_effdate
Effective
 
99/99/99
 
 
txhd_enter_date
Date Entered
Date Ent
99/99/99
 
 
txhd_fiscal_class
Fiscal Class
 
x(18)
 
 
txhd_flow_in
Flow Indicator
FI
yes/no
 
 
txhd_inv_value
Invoice Value
 
->>>>,>>>,>>>,>>9.99
10
 
txhd_line
Line
 
>>>>9
 
 
txhd_nbr
Number
 
x(8)
 
 
txhd_net_wt
Net Weight
Net Wt
->>>>>>>9
 
 
txhd_orig_ctry
Country of Origin
C O
x(3)
 
 
txhd_posted
Posted in Tax Book
P
yes/no
 
 
txhd_proc_ind
Process Indicator
PI
yes/no
 
 
txhd_program
Program
 
x(12)
 
 
txhd_ref
Reference
Ref
x(8)
 
 
txhd_site
Site
 
x(8)
 
 
txhd_stat_proc
Statistical Procedure
SP
x(2)
 
 
txhd_stat_submit
Statistical Submit Date
StatDate
99/99/99
 
 
txhd_stat_value
Statistical Value
 
->>>>,>>>,>>>,>>9.99
10
 
txhd_suppl_unit
Supplementary Units
Sup Units
>>>>>>>>9
 
 
txhd_taric
Taric Code
T C
x(3)
 
 
txhd_tax_code
Tax Code
 
x(8)
 
 
txhd_tax_ctry
Tax Registration Country
TRC
x(3)
 
 
txhd_tax_nbr
Tax Registration Number
TRN
x(15)
 
 
txhd_tax_usage
Nature of Operation
Nature
x(8)
 
 
txhd_td_stat_in
Included in Trade Statistics
S
yes/no
 
 
txhd_tr_nbr
Transaction Number
Tran Nbr
>>>>>>>>>9
 
 
txhd_tr_type
Transaction Type
TT
x(2)
 
 
txhd_tran_mode
Mode of Transportation
MT
x(1)
 
 
txhd_trans_ref
Original Transaction Reference
Orig Ref
x(14)
 
 
txhd_transh_port
Transhipment Port
T P
x(8)
 
 
txhd_trl
Trailer
Trlr
x(4)
 
 
txhd_user_id
User ID Entered
User ID
x(8)
 
 
txhd_user1
Ufld1
 
x(8)
 
 
txhd_user2
Ufld2
 
x(8)
 
 
txhd_usr_id_chg
Last Change User ID
Chg User
x(8)
 
 
txhd_vat_sl_date
VAT Sales List Submit Date
VSL Date
99/99/99
 
 
txhd_vat_sl_in
Included in VAT Sales List
V
yes/no
 
 
txhd_vat_value
Value of Goods
 
->>>>,>>>,>>>,>>9.99
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txhd_det
yes
oid_txhd_det
yes
no
 
txhd_fiscal_class
no
txhd_domain
yes
no
 
 
 
txhd_fiscal_class
yes
no
 
 
 
txhd_tr_type
yes
no
 
 
 
txhd_ref
yes
no
 
 
 
txhd_nbr
yes
no
 
 
 
txhd_line
yes
no
 
txhd_post_type
no
txhd_domain
yes
no
 
 
 
txhd_posted
yes
no
 
 
 
txhd_tr_type
yes
no
 
 
 
txhd_ref
yes
no
 
 
 
txhd_nbr
yes
no
 
 
 
txhd_line
yes
no
 
txhd_ref_nbr
yes
txhd_domain
yes
no
 
 
 
txhd_ref
yes
no
 
 
 
txhd_nbr
yes
no
 
 
 
txhd_line
yes
no
 
 
 
txhd_trl
yes
no
 
 
 
txhd_tr_type
yes
no
 
 
 
txhd_tax_code
yes
no
txhd_tr_nbr
yes
txhd_domain
yes
no
 
 
 
txhd_tr_nbr
yes
no
txty_mstr
Tax Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txty_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txty__qadc01
 
 
x(24)
 
 
txty__qadc02
 
 
x(24)
 
 
txty_legal_group
Legal Group
 
x(8)
 
 
txty_mod_date
Modified Date
Mod Date
99/99/99
 
 
txty_mod_userid
User ID
 
x(8)
 
 
txty_tax_desc
Description
 
x(24)
 
 
txty_tax_type
Code
Code
x(16)
 
 
txty_user1
User Field Character 1
 
x(24)
 
 
txty_user2
User Field Character 2
 
x(24)
 
 
txty_wt_type
Withholding Tax Type
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txty_mstr
yes
oid_txty_mstr
yes
no
 
txty_legal_group
no
txty_legal_group
yes
no
txty_tax_type
yes
txty_tax_type
yes
no
txud_det
Tax Usage Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txud_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txud__qadc01
 
 
x(24)
 
 
txud__qadc02
 
 
x(24)
 
 
txud__qadd01
 
 
->>>,>>>,>>9.99<<
10
 
txud_ap
No AP Accounting
 
Yes/No
 
 
txud_ap_acct
Account
 
x(8)
 
 
txud_ap_cc
Cost Center
 
x(4)
 
 
txud_ap_sub
Sub-Account
 
x(8)
 
 
txud_cfop_comp
CFOP Complement
 
x(12)
 
 
txud_cfop_dig2
Second CFOP Digit
 
9
 
 
txud_cfop_dig3
Third CFOP Digit
 
9
 
 
txud_cfop_dig4
Fourth CFOP Digit
 
9
 
 
txud_domain
Domain
 
x(8)
 
 
txud_end_cons
End Consumer
 
X(1)
 
 
txud_fb_remarks
Remarks
 
x(50)
 
 
txud_fb_suffix
Suffix
 
x(2)
 
 
txud_fut_shp
Future Delivery
 
x(1)
 
 
txud_mod_date
Modified Date
Mod Date
99/99/99
 
 
txud_mod_userid
User ID
 
x(8)
 
 
txud_nfe_usage
NFe Usage
 
x(1)
 
 
txud_op
Operation
 
>9
 
 
txud_service
Service
 
Yes/No
 
 
txud_simp_inv
Simple Invoicing
 
Yes/No
 
 
txud_sort
Sort Name
 
x(24)
 
 
txud_tax_usage
Tax Usage
 
x(8)
 
 
txud_user1
User Field Character 1
 
x(24)
 
 
txud_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txud_det
yes
oid_txud_det
yes
no
txud_tax_usg
yes
txud_domain
yes
no
 
 
 
txud_tax_usage
yes
no
txu_mstr
Tax Usage Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txu_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txu__qadc01
 
 
x(24)
 
 
txu__qadc02
 
 
x(24)
 
 
txu_mod_date
Modified Date
Mod Date
99/99/99
 
 
txu_mod_userid
User ID
 
x(8)
 
 
txu_phy_mov
Physical Move
 
X(1)
 
 
txu_tax_desc
Description
 
x(24)
 
 
txu_tax_usage
Tax Usage
Tax Use
x(8)
 
 
txu_user1
User Field Character 1
 
x(24)
 
 
txu_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txu_mstr
yes
oid_txu_mstr
yes
no
txu_tax_usg
yes
txu_tax_usage
yes
no
txz_mstr
Tax Zone Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_txz_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
txz__log01
 
 
yes/no
 
 
txz__qad01
Sums-Into Tax Zone
Sums-Into!Tax Zone
x(16)
 
 
txz__qad02
Use Sums-Into
Use!Sums
x(4)
 
 
txz__qad03
Subtotal This Level
Sub
yes/no
 
 
txz__qadc01
 
 
x(24)
 
 
txz_city
City
 
x(20)
 
 
txz_county
County
 
x(20)
 
 
txz_ctry_code
Country Code
Ctry
x(3)
 
 
txz_desc
Description
 
x(24)
 
 
txz_state
State
St
x(4)
 
 
txz_tax_zone
Tax Zone
 
x(16)
 
 
txz_user1
Ufld1
 
x(8)
 
 
txz_user2
Ufld2
 
x(8)
 
 
txz_zip
Post
 
x(10)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_txz_mstr
yes
oid_txz_mstr
yes
no
 
txz_ctry_state
yes
txz_ctry_code
yes
no
 
 
 
txz_state
yes
no
 
 
 
txz_county
yes
no
 
 
 
txz_city
yes
no
 
 
 
txz_zip
yes
no
 
txz_desc
no
txz_desc
yes
no
txz_tax_zone
yes
txz_tax_zone
yes
no
typ_mstr
Fixed Asset Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_typ_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
typ__qad01
 
 
yes/no
 
 
typ__qad02
 
 
x(8)
 
 
typ__qad03
 
 
x(8)
 
 
typ_desc
Description
 
x(24)
 
 
typ_method
Depreciation Method
Depr!Method
x(8)
 
 
typ_type
Type
T
x(2)
 
 
typ_user1
Ufld1
 
x(8)
 
 
typ_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_typ_mstr
yes
oid_typ_mstr
yes
no
typ_type
yes
typ_type
yes
no
tzod_det
Service/Support Time Zone Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tzod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tzod__chr01
Character Field 1
 
X(8)
 
 
tzod__chr02
Character Field 2
 
X(8)
 
 
tzod__dte01
Date Field 1
 
99/99/99
 
 
tzod__dte02
Date Field 2
 
99/99/99
 
 
tzod__int01
Integer Field 1
 
->,>>>,>>9
 
 
tzod__int02
Integer Field 2
 
->,>>>,>>9
 
 
tzod__log01
Logical Field 1
 
yes/no
 
 
tzod__log02
Logical Field 2
 
yes/no
 
 
tzod__qadc01
QAD Character Field 1
 
X(8)
 
 
tzod__qadc02
QAD Character Field 2
 
X(8)
 
 
tzod__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
tzod__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
tzod__qadl01
QAD Logical Field 1
 
yes/no
 
 
tzod__qadl02
QAD Logical Field 2
 
yes/no
 
 
tzod__qadt01
QAD Date Field 1
 
99/99/99
 
 
tzod__qadt02
QAD Date Field 2
 
99/99/99
 
 
tzod_desc
Time Zone Description
 
X(60)
 
 
tzod_eday
Ending Day
 
>9
 
 
tzod_eyear
End Year
 
9999
 
 
tzod_hour
Hours
 
>9
 
 
tzod_min
Minutes
 
>9
 
 
tzod_mod_date
Modified Date
Mod Date
99/99/99
 
 
tzod_mod_userid
User ID
 
X(8)
 
 
tzod_month
Start Period Month
 
>9
 
 
tzod_offset
GMT Offset
 
+99999
 
 
tzod_sday
Start Period Day
 
>9
 
 
tzod_std_day
Time Period
 
X(3)
 
 
tzod_syear
Start Year
 
9999
 
 
tzod_tzone
Time Zone
 
X(8)
 
 
tzod_user1
Ufld1
 
X(8)
 
 
tzod_user2
Ufld2
 
X(8)
 
 
tzod_wday
Weekday
 
X
 
 
tzod_week
 
 
9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tzod_det
yes
oid_tzod_det
yes
no
tzod_tzond
yes
tzod_tzone
yes
no
 
 
 
tzod_std_day
yes
no
 
 
 
tzod_syear
yes
no
 
 
 
tzod_eyear
yes
no
tzo_mstr
Service/Support Time Zone Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tzo_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tzo__chr01
Character Field 1
 
X(8)
 
 
tzo__dte01
Date Field 1
 
99/99/99
 
 
tzo__int01
Integer Field 1
 
->,>>>,>>9
 
 
tzo__log01
Logical Field 1
 
yes/no
 
 
tzo__qadc01
QAD Character Field 1
 
X(8)
 
 
tzo__qadi01
QAD Integer Field 1
 
->,>>>,>>9
 
 
tzo__qadl01
QAD Logical Field 1
 
yes/no
 
 
tzo__qadt01
QAD Date Field 1
 
99/99/99
 
 
tzo_area
Area
 
X(8)
 
 
tzo_auto_adj
Auto Period Adjust
 
yes/no
 
 
tzo_desc
Description
 
X(40)
 
 
tzo_label
Time Zone
 
X(8)
 
 
tzo_mod_date
Modified Date
Mod Date
99/99/99
 
 
tzo_mod_userid
User ID
 
X(8)
 
 
tzo_tzone
Time Zone Tindex
 
X(20)
 
 
tzo_user1
Ufld1
 
X(8)
 
 
tzo_user2
Ufld2
 
X(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tzo_mstr
yes
oid_tzo_mstr
yes
no
 
tzo_area
no
tzo_area
yes
no
tzo_label
yes
tzo_label
yes
no
 
 
 
tzo_area
yes
no
UDCConfig
User-Defined Component configuration
 
 
Field Name
Label
Col-Label
Format
Dec
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
UDCConfig_ID
record ID
 
-99999999999
 
 
UDCConfigCode
UDC Config Code
 
x(20)
 
 
UDCConfigHasCreate
Has Create Activity
 
yes/no
 
 
UDCConfigHasDelete
Has Delete Activity
 
yes/no
 
 
UDCConfigHasMaintain
Has Maintain Activity
 
yes/no
 
 
UDCConfigHasModify
Has Modify Activity
 
yes/no
 
 
UDCConfigHasView
Has View Activity
 
yes/no
 
 
UDCConfigLabel
UDC Config Label
 
x(40)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CodeAK
yes
UDCConfigCode
yes
no
 
LabelAK
yes
UDCConfigLabel
yes
no
 ∗
prim
yes
UDCConfig_ID
yes
no
udd_det
User Domain Detail.
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_udd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
udd__qadc01
 
 
x(24)
 
 
udd__qadc02
 
 
x(24)
 
 
udd_domain
Domain
 
x(8)
 
 
udd_groups
Roles
 
x(189)
 
 
udd_mod_date
Modified Date
Mod Date
99/99/99
 
 
udd_mod_userid
User ID
 
x(8)
 
 
udd_primary
Default Domain
 
yes/no
 
 
udd_user1
User Field Character 1
 
x(24)
 
 
udd_user2
User Field Character 2
 
x(24)
 
 
udd_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_udd_det
yes
oid_udd_det
yes
no
 
udd_domain
no
udd_domain
yes
no
 
udd_primary
no
udd_userid
yes
no
 
 
 
udd_primary
yes
no
udd_userid
yes
udd_userid
yes
no
 
 
 
udd_domain
yes
no
ufd_det
User Function Key Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ufd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ufd__qadc01
 
 
x(8)
 
 
ufd_exec
Execution File
 
x(14)
 
 
ufd_fkey
Function Key
Key
>>9
 
 
ufd_label
Label
 
x(40)
 
 
ufd_nbr
Menu
 
x(16)
 
 
ufd_nbrsel
Menu/Sel
 
x(12)
 
 
ufd_select
Selection
Select
>9
 
 
ufd_seq
Sequence
Seq
>>9
 
 
ufd_user1
Ufld1
 
x(8)
 
 
ufd_user2
Ufld2
 
x(8)
 
 
ufd_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ufd_det
yes
oid_ufd_det
yes
no
 
ufd_label
no
ufd_userid
yes
no
 
 
 
ufd_label
yes
no
 
ufd_nbrsel
no
ufd_userid
yes
no
 
 
 
ufd_nbrsel
yes
no
ufd_ufs
yes
ufd_userid
yes
no
 
 
 
ufd_fkey
yes
no
 
 
 
ufd_seq
yes
no
UMGroupD
Warehousing Unit of Measure Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowSplit
Allow Split
Split
yes/no
 
 
AltUM
Alternative UM
Alt UM
x(2)
 
 
Conv
Conversion
 
>>>>9.9999<<<<
10
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
IDQty
ID Quantity
ID!Qty
>>>9
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_UMGroupD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PrintID
Print ID
Print!ID
yes/no
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
UMGroup
UM Group
Group
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
GroupUM
yes
Domain
yes
no
 
 
 
UMGroup
yes
no
 
 
 
AltUM
yes
no
 
oid_UMGroupD
yes
oid_UMGroupD
yes
no
 
UMGroup
yes
Domain
yes
no
 
 
 
AltUM
yes
no
 
 
 
UMGroup
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
UMGroupM
Warehousing Unit of Measure Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_UMGroupM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
UM
UM
 
x(2)
 
 
UMGroup
UM Group
Group
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_UMGroupM
yes
oid_UMGroupM
yes
no
 ∗
UMGroup
yes
Domain
yes
no
 
 
 
UMGroup
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
umsg_det
User Message Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_umsg_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
umsg__qadc01
 
 
x(8)
 
 
umsg_addr
Address
 
x(8)
 
 
umsg_call_pgm
Calling Program
 
x(14)
 
 
umsg_domain
Domain
 
x(8)
 
 
umsg_exec_pgm
Execution File
Exec File
x(14)
 
 
umsg_lang
Language
 
x(2)
 
 
umsg_level
Severity
 
9
 
 
umsg_nbr
Message Number
Msg
>>>>9
 
 
umsg_seq
Message Sequence
 
>>9
 
 
umsg_site
Site
 
x(8)
 
 
umsg_user1
Ufld1
 
x(8)
 
 
umsg_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_umsg_det
yes
oid_umsg_det
yes
no
 
umsg_call
yes
umsg_domain
yes
no
 
 
 
umsg_call_pgm
yes
no
 
 
 
umsg_lang
yes
no
 
 
 
umsg_site
yes
no
 
 
 
umsg_addr
yes
no
 
 
 
umsg_nbr
yes
no
 
 
 
umsg_seq
yes
no
umsg_cm
yes
umsg_domain
yes
no
 
 
 
umsg_lang
yes
no
 
 
 
umsg_site
yes
no
 
 
 
umsg_addr
yes
no
 
 
 
umsg_call_pgm
yes
no
 
 
 
umsg_nbr
yes
no
 
 
 
umsg_seq
yes
no
um_mstr
Unit of Measure Conversion Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_um_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
um__chr01
 
 
x(8)
 
 
um__chr02
 
 
x(8)
 
 
um__chr03
 
 
x(8)
 
 
um__chr04
 
 
x(8)
 
 
um__chr05
 
 
x(8)
 
 
um__chr06
 
 
x(8)
 
 
um__dec01
 
 
>>>,>>>,>>9.99
10
 
um__dec02
 
 
>>>,>>>,>>9.99
10
 
um__dte01
 
 
99/99/99
 
 
um__dte02
 
 
99/99/99
 
 
um__log01
 
 
yes/no
 
 
um__log02
 
 
yes/no
 
 
um_alt_qty
UM Qty
 
>>>>9.9<<<<
10
 
um_alt_um
Alternate UM
Alt
x(2)
 
 
um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
um_decimals
Decimals
 
-9
 
 
um_desc
Description
 
x(24)
 
 
um_domain
Domain
 
x(8)
 
 
um_part
Item Number
 
x(18)
 
 
um_um
Unit of Measure
UM
x(2)
 
 
um_user1
Ufld1
 
x(8)
 
 
um_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_um_mstr
yes
oid_um_mstr
yes
no
 
um_part
yes
um_domain
yes
no
 
 
 
um_part
yes
no
 
 
 
um_um
yes
no
 
 
 
um_alt_um
yes
no
um_um_alt_pt
yes
um_domain
yes
no
 
 
 
um_um
yes
no
 
 
 
um_alt_um
yes
no
 
 
 
um_part
yes
no