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