About This Guide > ql_mstr
  
ql_mstr
Lot Attribute Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_parent
Parent OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_ql_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ql__qadc01
 
 
x(24)
 
 
ql__qadc02
 
 
x(24)
 
 
ql__qadc03
 
 
x(24)
 
 
ql__qadc04
 
 
x(24)
 
 
ql__qadl01
 
 
yes/no
 
 
ql__qadl02
 
 
yes/no
 
 
ql_approve_date
Approve Date
 
99/99/99
 
 
ql_approver_userid
Approved By
 
x(8)
 
 
ql_assay
Assay %
 
>>9.99%
10
 
ql_cmtindx
Comment Index
 
>>>>>>>9
 
 
ql_complete_date
Completed Date
 
99/99/99
 
 
ql_completed_userid
Completed By
 
x(8)
 
 
ql_doc_type
Doc Type
 
x(8)
 
 
ql_domain
Domain
 
x(8)
 
 
ql_eff_date
Effective Date
 
99/99/99
 
 
ql_expire
Expire Date
Expire
99/99/99
 
 
ql_grade
Grade
 
x(2)
 
 
ql_id
Document Order
 
x(24)
 
 
ql_inspect_loc
Inspect Location
 
x(8)
 
 
ql_loc
Location
 
x(8)
 
 
ql_lot
Lot
 
x(18)
 
 
ql_mfg_date
Mfg Date
 
99/99/99
 
 
ql_mod_date
Modified Date
Mod Date
99/99/99
 
 
ql_mod_userid
User ID
 
x(8)
 
 
ql_mtl_disposition
Material Disposition
 
x(8)
 
 
ql_mtl_disposition_date
Disposition Date
 
99/99/99
 
 
ql_non_conformance_number
Non-Conformance Number
 
x(50)
 
 
ql_order_date
Order Date
 
99/99/99
 
 
ql_parent_table
Parent Table
 
x(14)
 
 
ql_part
Item Number
 
x(18)
 
 
ql_qty_ord
Order Quantity
 
>,>>>,>>9.9<<<<<<<<
10
 
ql_qty_retain
Qty Retained
 
>,>>>,>>9.9<<<<<<<<
10
 
ql_qty_scrap
Qty Scrapped
 
>,>>>,>>9.9<<<<<<<<
10
 
ql_remarks
Remarks
 
x(60)
 
 
ql_site
Site
 
x(8)
 
 
ql_status
Order Status
 
x(8)
 
 
ql_sublot
Sublot
 
x(18)
 
 
ql_test_result_status
Quality Result
 
x(8)
 
 
ql_user1
User Field Character 1
 
x(24)
 
 
ql_user2
User Field Character 2
 
x(24)
 
 
ql_userl01
User Field Logical 1
 
yes/no
 
 
ql_userl02
User Field Logical 2
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_parent
no
oid_parent
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
 
 
ql_site
yes
no
 
 
 
ql_loc
yes
no
 
oid_ql_mstr
yes
oid_ql_mstr
yes
no
∗
ql_doc_type_id
yes
ql_domain
yes
no
 
 
 
ql_doc_type
yes
no
 
 
 
ql_id
yes
no
 
ql_doc_type_lot
no
ql_domain
yes
no
 
 
 
ql_doc_type
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_site
yes
no
 
 
 
ql_loc
yes
no
 
ql_doc_type_open_date
no
ql_domain
yes
no
 
 
 
ql_doc_type
yes
no
 
 
 
ql_order_date
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
 
 
ql_site
yes
no
 
 
 
ql_loc
yes
no
 
ql_doc_type_part
no
ql_domain
yes
no
 
 
 
ql_doc_type
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
 
 
ql_site
yes
no
 
 
 
ql_loc
yes
no
 
ql_domain_parent
no
ql_domain
yes
no
 
 
 
oid_parent
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
 
 
ql_site
yes
no
 
 
 
ql_loc
yes
no
 
ql_id
no
ql_domain
yes
no
 
 
 
ql_id
yes
no
 
ql_part_lot
no
ql_domain
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no
 
ql_type_parent
no
ql_domain
yes
no
 
 
 
ql_doc_type
yes
no
 
 
 
ql_parent_table
yes
no
 
 
 
ql_part
yes
no
 
 
 
ql_lot
yes
no
 
 
 
ql_sublot
yes
no