QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
asbh_hist
Self-Billing Accrual History Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbh__qadc01
 
 
x(24)
 
 
asbh__qadc02
 
 
x(24)
 
 
asbh__qadc03
 
 
x(8)
 
 
asbh__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbh__qadi01
 
 
->,>>>,>>9
 
 
asbh__qadl01
 
 
yes/no
 
 
asbh__qadt01
 
 
99/99/99
 
 
asbh_amt
Amount
Amount
>>>>,>>>,>>9.99<<<
10
 
asbh_base_amt
Base Amount
Base Amount
>>>>,>>>,>>9.99<<<
10
 
asbh_cr_acct
Credit Account
Cr Acct
x(8)
 
 
asbh_cr_cc
Credit Cost Center
CC
x(4)
 
 
asbh_cr_project
Credit Project
Project
x(8)
 
 
asbh_cr_sub
Credit Sub-Account
Sub-Acct
x(8)
 
 
asbh_curr
Currency
Curr
x(3)
 
 
asbh_cust
Sold-To
Sold-To
x(8)
 
 
asbh_cust_line
Customer Line
Cust Ln
>>9
 
 
asbh_cust_part
Customer Item
Customer Item
x(30)
 
 
asbh_date
Date
Date
99/99/99
 
 
asbh_db_acct
Debit Account
Dr Acct
x(8)
 
 
asbh_db_cc
Debit Cost Center
CC
x(4)
 
 
asbh_db_project
Debit Project
Project
x(8)
 
 
asbh_db_sub
Debit Sub-Account
Sub-Acct
x(8)
 
 
asbh_domain
Domain
Domain
x(8)
 
 
asbh_eff_date
Effective Date
Effective Date
99/99/99
 
 
asbh_ex_rate
Exchange Rate 1
Ex rate 1
>>,>>9.99999<<<<<
10
 
asbh_ex_rate2
Exchange Rate 2
Ex Rate 2
>>,>>9.99999<<<<<
10
 
asbh_gl_ref
GL Trans
GL Trans
x(14)
 
 
asbh_match_addr
Customer Matching Address
Match Addr
x(8)
 
 
asbh_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbh_mod_userid
User ID
 
x(8)
 
 
asbh_nbr
Self-Billing Invoice
Self-Billing Invoice
x(20)
 
 
asbh_part
Item Number
Item Number
x(18)
 
 
asbh_prev_price
Old Price
Old Price
->>>>,>>>,>>9.99<<<
10
 
asbh_price
Price
Price
->>>>,>>>,>>9.99<<<
10
 
asbh_qty
Quantity
Qty
->,>>>,>>9.9<<<
10
 
asbh_ran
RAN Number
RAN Number
x(13)
 
 
asbh_sc_amt
Statutory Amount
Statutory Amount
->>,>>>,>>9.99<<<
10
 
asbh_sc_ex_rate
SC Exchange Rate 1
SC Ex rate 1
>>,>>9.99999<<<<<
10
 
asbh_sc_ex_rate2
SC Exchange Rate 2
SC Ex Rate 2
>>,>>9.99999<<<<<
10
 
asbh_ship_ref
Shipment Ref
Shipment Ref
x(20)
 
 
asbh_shipto
Ship-To
Ship-To
x(8)
 
 
asbh_time
Time
Time
>>,>>>,>>9
 
 
asbh_trnbr
Transaction Nbr
Trans Nbr
>>>>>>>>
 
 
asbh_type
Transaction Type
Trans Type
x(8)
 
 
asbh_user1
User Field Character 1
 
x(24)
 
 
asbh_user2
User Field Character 2
 
x(24)
 
 
oid_asbh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbh_trnbr
yes
asbh_domain
yes
no
 
 
 
asbh_trnbr
yes
no
 
oid_asbh_hist
yes
oid_asbh_hist
yes
no
asbivx_ref
Self-Billing Cross-reference Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbivx__qadc01
 
 
x(24)
 
 
asbivx__qadc02
 
 
x(24)
 
 
asbivx__qadc03
 
 
x(8)
 
 
asbivx__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbivx__qadi01
 
 
->,>>>,>>9
 
 
asbivx__qadl01
 
 
yes/no
 
 
asbivx__qadt01
 
 
99/99/99
 
 
asbivx_curr
Currency
Curr
x(3)
 
 
asbivx_cust
Sold-To
 
x(8)
 
 
asbivx_cust_part
Customer Item
 
x(30)
 
 
asbivx_domain
Domain
 
x(8)
 
 
asbivx_fifo_qty_inv
FIFO Pending Qty Inv
 
->,>>>,>>9.9<<<
10
 
asbivx_fifo_qty_ship
FIFO Pending Qty Ship
 
->,>>>,>>9.9<<<
10
 
asbivx_line
Invoice Line
 
>>>>>9
 
 
asbivx_match_addr
Customer Matching Address
 
x(8)
 
 
asbivx_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbivx_mod_userid
User ID
 
x(8)
 
 
asbivx_nbr
Self-Billing Invoice
Self-Billing Inv
x(20)
 
 
asbivx_ran
RAN Number
 
x(13)
 
 
asbivx_ship_ref
Shipment Ref
 
x(20)
 
 
asbivx_shipto
Ship-To
 
x(8)
 
 
asbivx_site
Ship From
 
x(8)
 
 
asbivx_type
Matching Type
 
x(8)
 
 
asbivx_user1
User Field Character 1
 
x(24)
 
 
asbivx_user2
User Field Character 2
 
x(24)
 
 
oid_asbivx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
asbivx_asn
no
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_cust
yes
no
 
 
 
asbivx_shipto
yes
no
 
 
 
asbivx_ship_ref
yes
no
 
 
 
asbivx_ran
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
 
 
asbivx_match_addr
yes
no
 
asbivx_invoices
no
asbivx_domain
yes
no
 
 
 
asbivx_cust
yes
no
 
 
 
asbivx_nbr
yes
no
 
 
 
asbivx_line
yes
no
 
 
 
asbivx_match_addr
yes
no
 
asbivx_mtch_cpart
no
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_match_addr
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
asbivx_mtch_ran
no
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_cust
yes
no
 
 
 
asbivx_match_addr
yes
no
 
 
 
asbivx_ran
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
asbivx_mtch_sh_ran
no
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_cust
yes
no
 
 
 
asbivx_match_addr
yes
no
 
 
 
asbivx_ship_ref
yes
no
 
 
 
asbivx_ran
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
asbivx_mtch_ship
no
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_match_addr
yes
no
 
 
 
asbivx_ship_ref
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
asbivx_nbr
no
asbivx_domain
yes
no
 
 
 
asbivx_nbr
yes
no
 
 
 
asbivx_line
yes
no
asbivx_shipments
yes
asbivx_domain
yes
no
 
 
 
asbivx_site
yes
no
 
 
 
asbivx_cust
yes
no
 
 
 
asbivx_shipto
yes
no
 
 
 
asbivx_ship_ref
yes
no
 
 
 
asbivx_ran
yes
no
 
 
 
asbivx_cust_part
yes
no
 
 
 
asbivx_curr
yes
no
 
 
 
asbivx_match_addr
yes
no
 
 
 
asbivx_nbr
yes
no
 
 
 
asbivx_line
yes
no
 
asbivx_type
no
asbivx_domain
yes
no
 
 
 
asbivx_type
yes
no
 
oid_asbivx_ref
yes
oid_asbivx_ref
yes
no
asbpc_hist
Shipment Price List Update History Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbpc__qadc01
 
 
x(24)
 
 
asbpc__qadc02
 
 
x(24)
 
 
asbpc__qadc03
 
 
x(8)
 
 
asbpc__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbpc__qadi01
 
 
->,>>>,>>9
 
 
asbpc__qadl01
 
 
yes/no
 
 
asbpc__qadt01
 
 
99/99/99
 
 
asbpc_chg_nbr
Change Number
 
>>>>>>>>
 
 
asbpc_curr
Currency
 
x(3)
 
 
asbpc_cust
Sold-To
Sold-To
x(8)
 
 
asbpc_cust_part
Customer Item
 
x(30)
 
 
asbpc_domain
Domain
Domain
x(8)
 
 
asbpc_expire
Expire Date
 
99/99/99
 
 
asbpc_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbpc_mod_userid
User ID
 
x(8)
 
 
asbpc_part
Item Number
Item Number
x(18)
 
 
asbpc_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
asbpc_processed
Processed
 
yes/no
 
 
asbpc_shipto
Ship-To
Ship-To
x(8)
 
 
asbpc_site
Site
Site
x(8)
 
 
asbpc_start
Start Date
 
99/99/99
 
 
asbpc_tr_date
Tr Date
 
99/99/99
 
 
asbpc_tr_time
Tr Time
 
->,>>>,>>9
 
 
asbpc_um
UM
 
x(2)
 
 
asbpc_user1
User Field Character 1
 
x(24)
 
 
asbpc_user2
User Field Character 2
 
x(24)
 
 
oid_asbpc_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbpc_hist_idx
yes
asbpc_domain
yes
no
 
 
 
asbpc_site
yes
no
 
 
 
asbpc_shipto
yes
no
 
 
 
asbpc_cust_part
yes
no
 
 
 
asbpc_curr
yes
no
 
 
 
asbpc_start
yes
no
 
 
 
asbpc_expire
yes
no
 
 
 
asbpc_chg_nbr
yes
no
 
asbpc_processed
no
asbpc_domain
yes
no
 
 
 
asbpc_processed
yes
no
 
 
 
asbpc_site
yes
no
 
 
 
asbpc_shipto
yes
no
 
 
 
asbpc_cust_part
yes
no
 
 
 
asbpc_curr
yes
no
 
 
 
asbpc_start
yes
no
 
 
 
asbpc_expire
yes
no
 
asbpc_u_date
no
asbpc_domain
yes
no
 
 
 
asbpc_mod_userid
yes
no
 
 
 
asbpc_tr_date
yes
no
 
 
 
asbpc_tr_time
yes
no
 
oid_asbpc_hist
yes
oid_asbpc_hist
yes
no
asbpl_det
Self-Billing Product Line Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbpl__qadc01
 
 
x(24)
 
 
asbpl__qadc02
 
 
x(24)
 
 
asbpl__qadc03
 
 
x(8)
 
 
asbpl__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbpl__qadi01
 
 
->,>>>,>>9
 
 
asbpl__qadl01
 
 
yes/no
 
 
asbpl__qadt01
 
 
99/99/99
 
 
asbpl_domain
Domain
 
x(8)
 
 
asbpl_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbpl_mod_userid
User ID
 
x(8)
 
 
asbpl_prod_line
Product Line
Line
x(4)
 
 
asbpl_sls_accr_acct
Self-Billing Sales Accrual Acct
 
x(8)
 
 
asbpl_sls_accr_cc
Self-Billing Sales Accrual CC
 
x(4)
 
 
asbpl_sls_accr_project
Self-Billing Sales Accrual Project
 
x(8)
 
 
asbpl_sls_accr_sub
Self-Billing Sales Accrual Sub-Acct
 
x(8)
 
 
asbpl_user1
User Field Character 1
 
x(24)
 
 
asbpl_user2
User Field Character 2
 
x(24)
 
 
oid_asbpl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbpl_prod_line
yes
asbpl_domain
yes
no
 
 
 
asbpl_prod_line
yes
no
 
oid_asbpl_det
yes
oid_asbpl_det
yes
no
asbps_mstr
Self Billing Pending Shipments Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbps__qadc01
 
 
x(24)
 
 
asbps__qadc02
 
 
x(24)
 
 
asbps__qadc03
 
 
x(8)
 
 
asbps__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbps__qadi01
 
 
->,>>>,>>9
 
 
asbps__qadl01
 
 
yes/no
 
 
asbps__qadt01
 
 
99/99/99
 
 
asbps_amt_inv
Amount Invoiced
 
>>>>,>>>,>>9.99
10
 
asbps_amt_ship
Amount Shipped
 
>>>>,>>>,>>9.99<<<
10
 
asbps_ar_acct
AR Accrual Acct
 
x(8)
 
 
asbps_ar_cc
AR Accrual CC
 
x(4)
 
 
asbps_ar_project
AR Accrual Project
 
x(8)
 
 
asbps_ar_sub
AR Accrual Sub-Acct
 
x(8)
 
 
asbps_curr
Currency
Curr
x(3)
 
 
asbps_cust
Sold-To
 
x(8)
 
 
asbps_cust_part
Customer Item
 
x(30)
 
 
asbps_domain
Domain
 
x(8)
 
 
asbps_ex_rate
Exchange Rate
 
>>,>>9.99999<<<<<
10
 
asbps_ex_rate2
Exchange Rate2
 
>>,>>9.99999<<<<<
10
 
asbps_force_match
Force Matched
Force Matched
yes/no
 
 
asbps_force_match_date
Forced Match Date
Forced Match Date
99/99/99
 
 
asbps_force_match_user
Forced Match User
Forced Match User
x(8)
 
 
asbps_inv_mov
Inventory Movement Code
Inv Mov
x(8)
 
 
asbps_line
SO Line
 
>>>9
 
 
asbps_list_price
Customer List Price
 
->>>>,>>>,>>9.99<<<
10
 
asbps_match_addr
Customer Matching Address
 
x(8)
 
 
asbps_matched
Matched
 
yes/no
 
 
asbps_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbps_mod_userid
User ID
 
x(8)
 
 
asbps_nbr
Sales Order
 
x(8)
 
 
asbps_orig_ship
Orig ShipID
 
x(20)
 
 
asbps_part
Item Number
 
x(18)
 
 
asbps_po
Purchase Order
 
x(22)
 
 
asbps_price
Ship Price
 
->>>>,>>>,>>9.99<<<
10
 
asbps_processed
Processed
 
yes/no
 
 
asbps_qty_inv
Qty Invoiced
 
->,>>>,>>9.9<<<
10
 
asbps_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<
10
 
asbps_ran
RAN Number
 
x(13)
 
 
asbps_sc_ex_rate
SC Exchange Rate
 
>>,>>9.99999<<<<<
10
 
asbps_sc_ex_rate2
SC Exchange Rate2
 
>>,>>9.99999<<<<<
10
 
asbps_ship_date
Ship Date
 
99/99/99
 
 
asbps_ship_ref
Shipment Ref
 
x(20)
 
 
asbps_shipto
Ship-To
 
x(8)
 
 
asbps_site
Ship From
 
x(8)
 
 
asbps_sls_acct
Sales Accrual Acct
 
x(8)
 
 
asbps_sls_cc
Sales Accrual CC
 
x(4)
 
 
asbps_sls_project
Sales Accrual Project
 
x(8)
 
 
asbps_sls_sub
Sales Accrual Sub-Acct
 
x(8)
 
 
asbps_trnbr
Trans Nbr
 
>>>>>>>>
 
 
asbps_trnbrs
Transaction Numbers
 
x(8)
 
 
asbps_um
UM
 
x(2)
 
 
asbps_user1
User Field Character 1
 
x(24)
 
 
asbps_user2
User Field Character 2
 
x(24)
 
 
oid_asbps_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
asbps_force_match
no
asbps_domain
yes
no
 
 
 
asbps_force_match
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_cust
yes
no
 
 
 
asbps_shipto
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_matched
no
asbps_domain
yes
no
 
 
 
asbps_matched
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_ship_ref
yes
no
 
 
 
asbps_ran
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_mtch_cpart
no
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
 
 
asbps_matched
yes
no
 
asbps_mtch_ran
no
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_ran
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_mtch_sh_ran
no
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_ship_ref
yes
no
 
 
 
asbps_ran
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_mtch_shipref
no
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_ship_ref
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_nbr
no
asbps_domain
yes
no
 
 
 
asbps_nbr
yes
no
 
asbps_rec_proc
yes
asbps_domain
yes
no
 
 
 
asbps_processed
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_cust
yes
no
 
 
 
asbps_shipto
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_ship_ref
yes
no
 
 
 
asbps_ran
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
asbps_ref
yes
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_cust
yes
no
 
 
 
asbps_shipto
yes
no
 
 
 
asbps_match_addr
yes
no
 
 
 
asbps_ship_ref
yes
no
 
 
 
asbps_ran
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_sbpc
no
asbps_domain
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_shipto
yes
no
 
 
 
asbps_cust_part
yes
no
 
 
 
asbps_curr
yes
no
 
asbps_ship_proc
no
asbps_domain
yes
no
 
 
 
asbps_processed
yes
no
 
 
 
asbps_site
yes
no
 
 
 
asbps_ship_ref
yes
no
 
asbps_trnbr
no
asbps_domain
yes
no
 
 
 
asbps_trnbr
yes
no
 
oid_asbps_mstr
yes
oid_asbps_mstr
yes
no
asbse_mstr
Shipper Exclusion Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbse__qadc01
 
 
x(24)
 
 
asbse__qadc02
 
 
x(24)
 
 
asbse__qadc03
 
 
x(8)
 
 
asbse__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbse__qadi01
 
 
->,>>>,>>9
 
 
asbse__qadl01
 
 
yes/no
 
 
asbse__qadt01
 
 
99/99/99
 
 
asbse_cmmt
Comments
Comments
x(60)
 
 
asbse_cust
Customer
Customer
x(8)
 
 
asbse_domain
Domain
Domain
x(8)
 
 
asbse_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbse_mod_userid
User ID
 
x(8)
 
 
asbse_shipper
Shipper
Shipper
x(20)
 
 
asbse_user1
User Field Character 1
 
x(24)
 
 
asbse_user2
User Field Character 2
 
x(24)
 
 
oid_asbse_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbse_cust
yes
asbse_domain
yes
no
 
 
 
asbse_cust
yes
no
 
 
 
asbse_shipper
yes
no
 
oid_asbse_mstr
yes
oid_asbse_mstr
yes
no
atcatx_ref
Category XRef table
 
 
Field Name
Label
Col-Label
Format
Dec
 
atcatx__qadc01
 
 
x(24)
 
 
atcatx__qadc02
 
 
x(24)
 
 
atcatx__qadc03
 
 
x(24)
 
 
atcatx__qadc04
 
 
x(24)
 
 
atcatx__qadc05
 
 
x(24)
 
 
atcatx__qadl01
 
 
yes/no
 
 
atcatx__qadl02
 
 
yes/no
 
 
atcatx_category
Category
 
x(18)
 
 
atcatx_domain
Domain
 
x(8)
 
 
atcatx_mod_date
Modified Date
Mod Date
99/99/99
 
 
atcatx_mod_userid
User ID
 
x(8)
 
 
atcatx_user1
User Field Character 1
 
x(24)
 
 
atcatx_user2
User Field Character 2
 
x(24)
 
 
atcatx_userc03
User Field Character 3
 
x(24)
 
 
atcatx_userc04
User Field Character 4
 
x(24)
 
 
atcatx_userl01
User Field Logical 1
 
yes/no
 
 
atcatx_userl02
User Field Logical 2
 
yes/no
 
 
oid_atcat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_atcatx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_attrpfd_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atcatx_cat_parent
yes
oid_atcat_mstr
yes
no
 
 
 
oid_attrpfd_det
yes
no
 
atcatx_oid_par_cat
no
oid_attrpfd_det
yes
no
 
 
 
atcatx_category
yes
no
 
oid_atcatx_ref
yes
oid_atcatx_ref
yes
no
atcat_mstr
Item Attribute Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
atcat__qadc01
 
 
x(24)
 
 
atcat__qadc02
 
 
x(24)
 
 
atcat_cat
Category
 
x(18)
 
 
atcat_desc
Description
 
x(24)
 
 
atcat_domain
Domain
 
x(8)
 
 
atcat_fnc
Function Name
Function
x(20)
 
 
atcat_label_term
Label Term
 
x(35)
 
 
atcat_mod_date
Modified Date
 
99/99/99
 
 
atcat_mod_userid
User ID
 
x(8)
 
 
atcat_user1
User Field Character 1
 
x(24)
 
 
atcat_user2
User Field Character 2
 
x(24)
 
 
oid_atcat_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atcat_category
yes
atcat_domain
yes
no
 
 
 
atcat_cat
yes
no
 
oid_atcat_mstr
yes
oid_atcat_mstr
yes
no
atdcd_det
Audit Trail Database Connection Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
atdcd__qadc01
 
 
x(24)
 
 
atdcd__qadc02
 
 
x(24)
 
 
atdcd_begin_date
Begin Date
 
99/99/99
 
 
atdcd_end_date
End Date
 
99/99/99
 
 
atdcd_mod_date
Modified Date
Mod Date
99/99/99
 
 
atdcd_mod_userid
User ID
 
x(8)
 
 
atdcd_type
Type
 
x(8)
 
 
atdcd_used
Used
 
yes/no
 
 
atdcd_user1
User Field Character 1
 
x(24)
 
 
atdcd_user2
User Field Character 2
 
x(24)
 
 
oid_atdc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_atdcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atdcd_begin_date
yes
atdcd_type
yes
no
 
 
 
atdcd_begin_date
no
no
 
atdcd_oid_atdc_mstr
yes
oid_atdc_mstr
yes
no
 
 
 
atdcd_type
yes
no
 
oid_atdcd_det
yes
oid_atdcd_det
yes
no
atdc_mstr
Audit Trail Database Connection Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
atdc__qadc01
 
 
x(24)
 
 
atdc__qadc02
 
 
x(24)
 
 
atdc__qadt01
 
 
99/99/99
 
 
atdc__qadt02
 
 
99/99/99
 
 
atdc_desc
Description
 
x(24)
 
 
atdc_dir
Database Directory
 
X(50)
 
 
atdc_host
Host
 
X(24)
 
 
atdc_mod_date
Modified Date
Mod Date
99/99/99
 
 
atdc_mod_userid
User ID
 
x(8)
 
 
atdc_name
Database Name
DB Name
x(8)
 
 
atdc_network
Network
 
x(8)
 
 
atdc_online
Database Online
Online
yes/no
 
 
atdc_parmfile
Parameter File
ParmFile
x(32)
 
 
atdc_phy_name
Physical Database Name
Phys DB Name
x(32)
 
 
atdc_server
Server
 
x(24)
 
 
atdc_type
Type
 
X(8)
 
 
atdc_user1
User Field Character 1
 
x(24)
 
 
atdc_user2
User Field Character 2
 
x(24)
 
 
oid_atdc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atdc_name
yes
atdc_name
yes
no
 
oid_atdc_mstr
yes
oid_atdc_mstr
yes
no
atdext_det
Attribute value extension for additional application data
 
 
Field Name
Label
Col-Label
Format
Dec
 
atdext__qadc01
 
 
x(24)
 
 
atdext__qadc02
 
 
x(24)
 
 
atdext__qadc03
 
 
x(24)
 
 
atdext__qadc04
 
 
x(24)
 
 
atdext__qadc05
 
 
x(24)
 
 
atdext__qadl01
 
 
yes/no
 
 
atdext__qadl02
 
 
yes/no
 
 
atdext_mod_date
Modified Date
Mod Date
99/99/99
 
 
atdext_mod_userid
User ID
 
x(8)
 
 
atdext_seq
Sequence
 
>>>>>>>9
 
 
atdext_um_desc
Measurement
 
x(12)
 
 
atdext_user1
User Field Character 1
 
x(24)
 
 
atdext_user2
User Field Character 2
 
x(24)
 
 
atdext_userc03
User Field Character 3
 
x(24)
 
 
atdext_userc04
User Field Character 4
 
x(24)
 
 
atdext_userl01
User Field Logical 1
 
yes/no
 
 
atdext_userl02
User Field Logical 2
 
yes/no
 
 
atdext_value_entered
Entered
 
yes/no
 
 
oid_atdext_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_attrd_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atdext_oid_attrd
yes
oid_attrd_det
yes
no
 
oid_atdext_det
yes
oid_atdext_det
yes
no
atg_mstr
Audit Trail Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
atg__qadc01
 
 
x(24)
 
 
atg__qadc02
 
 
x(24)
 
 
atg_group_desc
Description
 
X(24)
 
 
atg_group_name
Group Name
Group
X(8)
 
 
atg_group_type
Group Type
Type
X(2)
 
 
atg_mod_date
Modified Date
Mod Date
99/99/99
 
 
atg_mod_userid
User ID
 
x(8)
 
 
atg_origin
Origin
 
X(2)
 
 
atg_user1
User Field Character 1
 
x(24)
 
 
atg_user2
User Field Character 2
 
x(24)
 
 
oid_atg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
atg_type_name
yes
atg_group_type
yes
no
 
 
 
atg_group_name
yes
no
 
oid_atg_mstr
yes
oid_atg_mstr
yes
no
atp_det
Available-to-Promise Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
atp__qad01
 
 
x(18)
 
 
atp__qad02
 
 
99/99/99
 
 
atp__qad03
 
 
x(8)
 
 
atp__qad04
 
 
x(18)
 
 
atp_date
Date
Date
99/99/99
 
 
atp_domain
Domain
 
x(8)
 
 
atp_id_num
 
 
>>>>>>9
 
 
atp_part
Item Number
 
x(18)
 
 
atp_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
atp_site
Site
 
x(8)
 
 
atp_user1
Ufld1
 
x(8)
 
 
atp_user2
Ufld2
 
x(8)
 
 
oid_atp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
atp_id_num
yes
atp_domain
yes
no
 
 
 
atp_id_num
yes
no
atp_part
yes
atp_domain
yes
no
 
 
 
atp_part
yes
no
 
 
 
atp_site
yes
no
 
 
 
atp_date
yes
no
 
 
 
atp_id_num
yes
no
 
oid_atp_det
yes
oid_atp_det
yes
no
attrdh_hist
Attribute Detail History
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrdh__qadc01
 
 
x(24)
 
 
attrdh__qadc02
 
 
x(24)
 
 
attrdh_actual_value
Actual Value
 
x(50)
 
 
attrdh_attr_name
Attribute ID
 
x(32)
 
 
attrdh_domain
Domain
 
x(8)
 
 
attrdh_existing_value_char
Existing Value
 
x(50)
 
 
attrdh_incoming_value
New Value
 
x(50)
 
 
attrdh_loc
Location
 
x(8)
 
 
attrdh_lot
Lot
 
x(18)
 
 
attrdh_mod_date
Modified Date
 
99/99/99
 
 
attrdh_mod_time
Modified Time
 
->,>>>,>>9
 
 
attrdh_mod_userid
User ID
 
x(8)
 
 
attrdh_parent_table
Parent Table
 
x(14)
 
 
attrdh_part
Item Number
 
x(18)
 
 
attrdh_seq
Sequence
 
>>>>>>>9
 
 
attrdh_site
Site
 
x(8)
 
 
attrdh_sublot
Sublot
 
x(18)
 
 
attrdh_timestamp
Date Time
 
99/99/9999 HH:MM:SS.SSS
 
 
attrdh_trnbr
Trans
 
>>>>>>>>>>
 
 
attrdh_um_desc
Measurement
 
x(12)
 
 
attrdh_user1
User Field Character 1
 
x(24)
 
 
attrdh_user2
User Field Character 2
 
x(24)
 
 
oid_attrdh_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_parent
Parent OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrdh_oid_parent
no
oid_parent
yes
no
attrdh_site_part
yes
attrdh_domain
yes
no
 
 
 
attrdh_part
yes
no
 
 
 
attrdh_lot
yes
no
 
 
 
attrdh_sublot
yes
no
 
 
 
attrdh_site
yes
no
 
 
 
attrdh_loc
yes
no
 
 
 
attrdh_attr_name
yes
no
 
 
 
attrdh_trnbr
yes
no
 
attrdh_trnbr_time
no
attrdh_domain
yes
no
 
 
 
attrdh_trnbr
yes
no
 
 
 
attrdh_timestamp
yes
no
 
oid_attrdh_hist
yes
oid_attrdh_hist
yes
no
attrd_det
Attribute detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrd__qadc01
 
 
x(24)
 
 
attrd__qadc02
 
 
x(24)
 
 
attrd_assigned
Assigned
 
yes/no
 
 
attrd_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrd_mod_userid
User ID
 
x(8)
 
 
attrd_name
Attribute Name
 
x(32)
 
 
attrd_ref
Reference
 
x(125)
 
 
attrd_setid
Set ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
attrd_user1
User Field Character 1
 
x(24)
 
 
attrd_user2
User Field Character 2
 
x(24)
 
 
attrd_value
Value
 
x(50)
 
 
oid_attrd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrd_name
no
attrd_name
yes
no
attrd_setid
yes
attrd_setid
yes
no
 
 
 
attrd_name
yes
no
 
oid_attrd_det
yes
oid_attrd_det
yes
no
attrlot_mstr
Attribute Item Lot Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrlot__chr01
 
 
x(8)
 
 
attrlot__chr02
 
 
x(8)
 
 
attrlot__chr03
 
 
x(8)
 
 
attrlot__chr04
 
 
x(8)
 
 
attrlot__chr05
 
 
x(8)
 
 
attrlot__dec01
 
 
>>>,>>>,>>9.99
10
 
attrlot__dec02
 
 
>>>,>>>,>>9.99
10
 
attrlot__dte01
 
 
99/99/99
 
 
attrlot__dte02
 
 
99/99/99
 
 
attrlot__log01
 
 
yes/no
 
 
attrlot__qadc01
 
 
x(24)
 
 
attrlot__qadc02
 
 
x(24)
 
 
attrlot_domain
Domain
 
x(8)
 
 
attrlot_loc
Location
 
x(8)
 
 
attrlot_lot
Lot
 
x(18)
 
 
attrlot_mfg_date
Manufacture Date
 
99/99/99
 
 
attrlot_mod_date
Modified Date
 
99/99/99
 
 
attrlot_mod_userid
User ID
 
x(8)
 
 
attrlot_part
Item Number
 
x(18)
 
 
attrlot_site
Site
 
x(8)
 
 
attrlot_sublot
Sublot
 
x(18)
 
 
attrlot_user1
Ufld1
 
x(8)
 
 
attrlot_user2
Ufld2
 
x(8)
 
 
oid_attrlot_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrlot_lot_part
no
attrlot_domain
yes
no
 
 
 
attrlot_lot
yes
no
 
 
 
attrlot_sublot
yes
no
 
 
 
attrlot_part
yes
no
 
 
 
attrlot_site
yes
no
 
 
 
attrlot_loc
yes
no
 
attrlot_part_lot
no
attrlot_domain
yes
no
 
 
 
attrlot_part
yes
no
 
 
 
attrlot_lot
yes
no
 
 
 
attrlot_sublot
yes
no
 
 
 
attrlot_site
yes
no
 
 
 
attrlot_loc
yes
no
 
attrlot_partsite
no
attrlot_domain
yes
no
 
 
 
attrlot_part
yes
no
 
 
 
attrlot_site
yes
no
 
 
 
attrlot_loc
yes
no
 
 
 
attrlot_lot
yes
no
 
 
 
attrlot_sublot
yes
no
attrlot_site
yes
attrlot_domain
yes
no
 
 
 
attrlot_site
yes
no
 
 
 
attrlot_part
yes
no
 
 
 
attrlot_lot
yes
no
 
 
 
attrlot_sublot
yes
no
 
 
 
attrlot_loc
yes
no
 
oid_attrlot_mstr
yes
oid_attrlot_mstr
yes
no
attrpfd_det
Attribute Profile Detail Definition
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrpfd__qadc01
 
 
x(24)
 
 
attrpfd__qadc02
 
 
x(24)
 
 
attrpfd__qadc03
 
 
x(24)
 
 
attrpfd__qadc04
 
 
x(24)
 
 
attrpfd__qadl01
 
 
yes/no
 
 
attrpfd__qadl02
 
 
yes/no
 
 
attrpfd_attr_name
Attribute ID
 
x(32)
 
 
attrpfd_cert_category
Certification Category
 
x(18)
 
 
attrpfd_certification
Certification Record
 
yes/no
 
 
attrpfd_date_number_of_days
Days
 
>,>>9
 
 
attrpfd_date_plus_minus
Plus/Minus
 
x(8)
 
 
attrpfd_def_value_timestamp
Default Value
 
99/99/9999 HH:MM:SS.SSS
 
 
attrpfd_default_date_type
Default Value
 
x(8)
 
 
attrpfd_default_value_char
Default Value
 
x(50)
 
 
attrpfd_default_value_dec
Default Value
 
->>,>>9.99
10
 
attrpfd_default_value_int
Default Value
 
->,>>>,>>9
 
 
attrpfd_default_value_log
Default Value
 
yes/no
 
 
attrpfd_domain
Domain
 
x(8)
 
 
attrpfd_edit_spec
Print
 
yes/no
 
 
attrpfd_input_method
Input Method
 
x(8)
 
 
attrpfd_inv_update_level
Inventory Update
 
x(8)
 
 
attrpfd_list_value
Values
 
yes/no
 
 
attrpfd_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrpfd_mod_userid
User ID
 
x(8)
 
 
attrpfd_printable
Print
 
yes/no
 
 
attrpfd_req
Required
 
yes/no
 
 
attrpfd_seq
Sequence
 
>>>>>>>9
 
 
attrpfd_status
Status
 
x(8)
 
 
attrpfd_test_id
Test ID
 
x(24)
 
 
attrpfd_test_method
Test Method
 
x(12)
 
 
attrpfd_trans_hist
Transaction History
 
yes/no
 
 
attrpfd_um_desc
Measurement
 
x(12)
 
 
attrpfd_user1
User Field Character 1
 
x(24)
 
 
attrpfd_user2
User Field Character 2
 
x(24)
 
 
attrpfd_userc03
User Field Character 3
 
x(24)
 
 
attrpfd_userc04
User Field Character 4
 
x(24)
 
 
attrpfd_userl01
User Field Logical 1
 
yes/no
 
 
attrpfd_userl02
User Field Logical 2
 
yes/no
 
 
attrpfd_validate_to_spec
Validation
 
yes/no
 
 
oid_attrpf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_attrpfd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrpfd_det
no
oid_attrpf_mstr
yes
no
 
 
 
attrpfd_domain
yes
no
 
 
 
attrpfd_attr_name
yes
no
 
attrpfd_domain
no
attrpfd_domain
yes
no
 
 
 
attrpfd_attr_name
yes
no
 
attrpfd_input_mtd
no
attrpfd_input_method
yes
no
 
attrpfd_inv_upd
no
attrpfd_inv_update_level
yes
no
 
attrpfd_name
yes
oid_attrpf_mstr
yes
no
 
 
 
attrpfd_attr_name
yes
no
attrpfd_seq
no
oid_attrpf_mstr
yes
no
 
 
 
attrpfd_seq
yes
no
 
 
 
attrpfd_attr_name
yes
no
 
attrpfd_status
no
attrpfd_status
yes
no
 
attrpfd_tr_hist
no
attrpfd_trans_hist
yes
no
 
oid_attrpfd_det
yes
oid_attrpfd_det
yes
no
attrpf_mstr
Attribute Profile Definition
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrpf__qadc01
 
 
x(24)
 
 
attrpf__qadc02
 
 
x(24)
 
 
attrpf__qadc03
 
 
x(24)
 
 
attrpf__qadc04
 
 
x(24)
 
 
attrpf__qadl01
 
 
yes/no
 
 
attrpf__qadl02
 
 
yes/no
 
 
attrpf_desc
Description
 
x(24)
 
 
attrpf_domain
Domain
 
x(8)
 
 
attrpf_key1
Key 1
 
x(32)
 
 
attrpf_key10
Key 10
 
x(32)
 
 
attrpf_key2
Key 2
 
x(32)
 
 
attrpf_key3
Key 3
 
x(32)
 
 
attrpf_key4
Key 4
 
x(32)
 
 
attrpf_key5
Key 5
 
x(32)
 
 
attrpf_key6
Key 6
 
x(32)
 
 
attrpf_key7
Key 7
 
x(32)
 
 
attrpf_key8
Key 8
 
x(32)
 
 
attrpf_key9
Key 9
 
x(32)
 
 
attrpf_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrpf_mod_userid
User ID
 
x(8)
 
 
attrpf_parent_table
Parent Table
 
x(14)
 
 
attrpf_ref
Reference
 
x(32)
 
 
attrpf_type
Type
 
x(8)
 
 
attrpf_user1
User Field Character 1
 
x(24)
 
 
attrpf_user2
User Field Character 2
 
x(24)
 
 
attrpf_userc03
User Field Character 3
 
x(24)
 
 
attrpf_userc04
User Field Character 4
 
x(24)
 
 
attrpf_userl01
User Field Logical 1
 
yes/no
 
 
attrpf_userl02
User Field Logical 2
 
yes/no
 
 
oid_attrpf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_parent
Parent OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrpf_dom_par
no
attrpf_domain
yes
no
 
 
 
oid_parent
yes
no
 
 
 
attrpf_type
yes
no
 
attrpf_key
no
attrpf_domain
yes
no
 
 
 
attrpf_key1
yes
no
 
 
 
attrpf_key2
yes
no
 
 
 
attrpf_key3
yes
no
 
 
 
attrpf_key4
yes
no
 
 
 
attrpf_key5
yes
no
 
 
 
attrpf_key6
yes
no
 
 
 
attrpf_key7
yes
no
 
 
 
attrpf_key8
yes
no
 
 
 
attrpf_key9
yes
no
 
 
 
attrpf_key10
yes
no
 
 
 
attrpf_type
yes
no
 
attrpf_key_type
no
attrpf_domain
yes
no
 
 
 
attrpf_type
yes
no
 
 
 
attrpf_key1
yes
no
 
 
 
attrpf_key2
yes
no
 
 
 
attrpf_key3
yes
no
 
 
 
attrpf_key4
yes
no
 
 
 
attrpf_key5
yes
no
 
 
 
attrpf_key6
yes
no
 
 
 
attrpf_key7
yes
no
 
 
 
attrpf_key8
yes
no
 
 
 
attrpf_key9
yes
no
 
 
 
attrpf_key10
yes
no
 
attrpf_oid_parent
no
oid_parent
yes
no
 
 
 
attrpf_type
yes
no
oid_attrpf_mstr
yes
oid_attrpf_mstr
yes
no
attrp_det
Attribute parameter to control the attr value processing logic
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrp__qadc01
 
 
x(24)
 
 
attrp__qadc02
 
 
x(24)
 
 
attrp__qadc03
 
 
x(24)
 
 
attrp__qadc04
 
 
x(24)
 
 
attrp__qadc05
 
 
x(24)
 
 
attrp__qadl01
 
 
yes/no
 
 
attrp__qadl02
 
 
yes/no
 
 
attrp_append_text_value
Append Text Value
 
yes/no
 
 
attrp_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrp_mod_userid
User ID
 
x(8)
 
 
attrp_remarks
Remarks
 
x(40)
 
 
attrp_resolution_method
Resolution Method
 
x(8)
 
 
attrp_user1
User Field Character 1
 
x(24)
 
 
attrp_user2
User Field Character 2
 
x(24)
 
 
attrp_userc03
User Field Character 3
 
x(24)
 
 
attrp_userc04
User Field Character 4
 
x(24)
 
 
attrp_userl01
User Field Logical 1
 
yes/no
 
 
attrp_userl02
User Field Logical 2
 
yes/no
 
 
oid_attrd_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_attrp_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
oid_attrd_det
yes
oid_attrd_det
yes
no
 
oid_attrp_det
yes
oid_attrp_det
yes
no
attrsl_det
Attribute Set Link Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrsl__qadc01
 
 
x(24)
 
 
attrsl__qadc02
 
 
x(24)
 
 
attrsl_link_id
Link ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
attrsl_link_ref
Link Field
 
x(23)
 
 
attrsl_link_table
Link Table
 
x(23)
 
 
attrsl_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrsl_mod_userid
User ID
 
x(8)
 
 
attrsl_setid
Set ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
attrsl_user1
User Field Character 1
 
x(24)
 
 
attrsl_user2
User Field Character 2
 
x(24)
 
 
oid_attrsl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
attrsl_link
yes
attrsl_link_table
yes
no
 
 
 
attrsl_link_id
yes
no
 
 
 
attrsl_link_ref
yes
no
 
attrsl_setid
no
attrsl_setid
yes
no
 
oid_attrsl_det
yes
oid_attrsl_det
yes
no
attrsp_det
Attribute specification
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrsp__qadc01
 
 
x(24)
 
 
attrsp__qadc02
 
 
x(24)
 
 
attrsp__qadc03
 
 
x(24)
 
 
attrsp__qadc04
 
 
x(24)
 
 
attrsp__qadl01
 
 
yes/no
 
 
attrsp__qadl02
 
 
yes/no
 
 
attrsp_attr_name
Attribute ID
Attribute
x(32)
 
 
attrsp_desc
Specification
 
x(48)
 
 
attrsp_domain
Domain
 
x(8)
 
 
attrsp_exclude_list
Exclude List
 
x(50)
 
 
attrsp_field_name
Field
 
x(24)
 
 
attrsp_include_list
Include List
 
x(50)
 
 
attrsp_include_max_value
Maximum Value Included
 
yes/no
 
 
attrsp_include_min_value
Minimum Value Included
 
yes/no
 
 
attrsp_log_false_term
No Label Term
 
x(24)
 
 
attrsp_log_true_term
Yes Label Term
 
x(24)
 
 
attrsp_max_char
Maximum Value
 
x(8)
 
 
attrsp_max_date_num_days
Days
 
>,>>9
 
 
attrsp_max_date_plus_minus
Operation
 
x(8)
 
 
attrsp_max_dec
Maximum Value
 
->>,>>9.99
10
 
attrsp_max_int
Maximum Value
 
->,>>>,>>9
 
 
attrsp_max_timestamp
Maximum Value
 
99/99/9999 HH:MM:SS.SSS
 
 
attrsp_max_value_date
Maximum Date Value
 
x(8)
 
 
attrsp_min_char
Minimum Value
 
x(8)
 
 
attrsp_min_date_num_days
Days
 
>,>>9
 
 
attrsp_min_date_plus_minus
Operation
 
x(8)
 
 
attrsp_min_dec
Minimum Value
 
->>,>>9.99
10
 
attrsp_min_int
Minimum Value
 
->,>>>,>>9
 
 
attrsp_min_timestamp
Minimum Value
 
99/99/9999 HH:MM:SS.SSS
 
 
attrsp_min_value_date
Minimum Date Value
 
x(8)
 
 
attrsp_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrsp_mod_userid
User ID
 
x(8)
 
 
attrsp_parent_table
Parent Table
 
x(14)
 
 
attrsp_ref
Reference
 
x(24)
 
 
attrsp_spec_type
Specification Type
 
x(8)
 
 
attrsp_table_name
Parent Table
 
x(14)
 
 
attrsp_target_dec_value
Target Value
 
->>,>>9.99
10
 
attrsp_target_timestamp_value
Target Datetime
 
99/99/9999 HH:MM:SS.SSS
 
 
attrsp_tolerance_max
Tolerance Max
 
->>,>>>,>99.99<<<
10
 
attrsp_tolerance_min
Tolerance Min
 
->>,>>>,>99.99<<<
10
 
attrsp_user1
User Field Character 1
 
x(24)
 
 
attrsp_user2
User Field Character 2
 
x(24)
 
 
attrsp_userc03
User Field Character 3
 
x(24)
 
 
attrsp_userc04
User Field Character 4
 
x(24)
 
 
attrsp_userl01
User Field Logical 1
 
yes/no
 
 
attrsp_userl02
User Field Logical 2
 
yes/no
 
 
attrsp_validation_rule
Validation Rule
 
x(255)
 
 
oid_attrpfd_det
Parent ID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_attrsp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
attrsp_attr_name
yes
oid_attrpfd_det
yes
no
 
 
 
attrsp_attr_name
yes
no
 
attrsp_name_domain
no
attrsp_domain
yes
no
 
 
 
attrsp_attr_name
yes
no
 
oid_attrsp_det
yes
oid_attrsp_det
yes
no
attrs_det
Attribute Set Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
attrs__qadc01
 
 
x(24)
 
 
attrs__qadc02
 
 
x(24)
 
 
attrs_mod_date
Modified Date
Mod Date
99/99/99
 
 
attrs_mod_userid
User ID
 
x(8)
 
 
attrs_ref_domain
Originating Domain
 
x(8)
 
 
attrs_ref_id
Reference ID
Ref ID
x(24)
 
 
attrs_ref_type
Reference Type
Ref Type
x(8)
 
 
attrs_user1
User Field Character 1
 
x(24)
 
 
attrs_user2
User Field Character 2
 
x(24)
 
 
oid_attrs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
attrs_ref_id
no
attrs_ref_domain
yes
no
 
 
 
attrs_ref_type
yes
no
 
 
 
attrs_ref_id
yes
no
oid_attrs_det
yes
oid_attrs_det
yes
no