|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qaddb_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qaddb__qadc01
|
|
|
x(24)
|
|
|
|
qaddb__qadc02
|
|
|
x(24)
|
|
|
|
qaddb_index1
|
Index
|
|
>>>>>9
|
|
|
|
qaddb_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qaddb_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qaddb_oid_code
|
OID Generator Code
|
|
>>>>>>>>>9
|
|
|
|
qaddb_oid_regid
|
OID Registration ID
|
|
>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qaddb_server_timezone
|
Server Time Zone
|
|
x(8)
|
|
|
|
qaddb_use_users_timezone
|
Use User's Time Zone
|
|
yes/no
|
|
|
|
qaddb_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qaddb_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qaddb_ctrl
|
yes
|
oid_qaddb_ctrl
|
yes
|
no
|
|
∗
|
qaddb_index1
|
yes
|
qaddb_index1
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qaddb_ver
|
OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qaddb_ver_001_0020
|
Schema Version
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_qaddb_ver
|
yes
|
oid_qaddb_ver
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADFinReserved_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QADFinReservedFieldName
|
Field Name
|
|
x(40)
|
|
|
|
QADFinReservedQADC01
|
Char 1
|
|
x(40)
|
|
|
|
QADFinReservedQADC02
|
Char 2
|
|
x(255)
|
|
|
|
QADFinReservedQADD01
|
Dec 1
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
QADFinReservedQADT01
|
Date 1
|
|
99/99/9999
|
|
|
|
QADFinReservedRecordID
|
Record ID
|
|
-99999999999
|
|
|
|
QADFinReservedTableName
|
Table Name
|
|
x(40)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
KeyIdx
|
yes
|
QADFinReservedTableName
|
yes
|
no
|
|
|
|
|
QADFinReservedRecordID
|
yes
|
no
|
|
|
|
|
QADFinReservedFieldName
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
QADFinReserved_ID
|
yes
|
no
|
|
|
TabFldIdx
|
no
|
QADFinReservedTableName
|
yes
|
no
|
|
|
|
|
QADFinReservedFieldName
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qad_wkfl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qad__qadc01
|
|
|
x(8)
|
|
|
|
qad_charfld[15]
|
|
|
x(8)
|
|
|
|
qad_charfld1[15]
|
|
|
x(8)
|
|
|
|
qad_datefld[4]
|
|
|
99/99/99
|
|
|
|
qad_decfld[15]
|
|
|
->>,>>9.99
|
10
|
|
|
qad_domain
|
Domain
|
|
x(8)
|
|
|
|
qad_intfld[15]
|
|
|
->,>>>,>>9
|
|
|
|
qad_key1
|
|
|
x(8)
|
|
|
|
qad_key2
|
|
|
x(8)
|
|
|
|
qad_key3
|
|
|
x(8)
|
|
|
|
qad_key4
|
|
|
x(8)
|
|
|
|
qad_key5
|
|
|
x(8)
|
|
|
|
qad_key6
|
|
|
x(8)
|
|
|
|
qad_logfld[15]
|
|
|
yes/no
|
|
|
|
qad_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qad_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qad_wkfl
|
yes
|
oid_qad_wkfl
|
yes
|
no
|
|
∗
|
qad_index1
|
yes
|
qad_domain
|
yes
|
no
|
|
|
|
|
qad_key1
|
yes
|
no
|
|
|
|
|
qad_key2
|
yes
|
no
|
|
|
qad_index2
|
no
|
qad_domain
|
yes
|
no
|
|
|
|
|
qad_key3
|
yes
|
no
|
|
|
|
|
qad_key4
|
yes
|
no
|
|
|
qad_index3
|
no
|
qad_domain
|
yes
|
no
|
|
|
|
|
qad_key5
|
yes
|
no
|
|
|
|
|
qad_key6
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QBatchDaemon_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QBatchDaemonPriority
|
Priority
|
|
99
|
|
|
|
QBatchDaemonReqStartDate
|
Requested Start Date
|
Req Start Date
|
99/99/9999
|
|
|
|
QBatchDaemonReqStartTime
|
Requested Start Time
|
Req Start Time
|
99999
|
|
|
|
QBatchDaemonRequestData
|
|
|
x(2000)
|
|
|
|
QBatchDaemonRequestType
|
Request Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
QBatchDaemon_ID
|
yes
|
no
|
|
|
TypeIdx
|
no
|
QBatchDaemonRequestType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qcc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qcc__qadc01
|
|
|
x(8)
|
|
|
|
qcc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
qcc_auto_nbr
|
Auto Order Numbers
|
|
yes/no
|
|
|
|
qcc_domain
|
Domain
|
|
x(8)
|
|
|
|
qcc_inspect
|
Inspection Location
|
|
x(8)
|
|
|
|
qcc_lot
|
Next Batch
|
|
>>>>>>>9
|
|
|
|
qcc_nbr
|
Next Order Number
|
|
>>>>>>>9
|
|
|
|
qcc_rcmmts
|
Procedure Comments
|
|
yes/no
|
|
|
|
qcc_site
|
Inspection Site
|
|
x(8)
|
|
|
|
qcc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qcc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
qcc_wcmmts
|
Quality Order Comments
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qcc_ctrl
|
yes
|
oid_qcc_ctrl
|
yes
|
no
|
|
∗
|
qcc_index1
|
yes
|
qcc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qcd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qcd__chr01
|
|
|
x(8)
|
|
|
|
qcd__chr02
|
|
|
x(8)
|
|
|
|
qcd__chr03
|
|
|
x(8)
|
|
|
|
qcd__chr04
|
|
|
x(8)
|
|
|
|
qcd__chr05
|
|
|
x(8)
|
|
|
|
qcd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qcd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qcd__dte01
|
|
|
99/99/99
|
|
|
|
qcd__dte02
|
|
|
99/99/99
|
|
|
|
qcd__log01
|
|
|
yes/no
|
|
|
|
qcd_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
qcd_domain
|
Domain
|
|
x(8)
|
|
|
|
qcd_iss_date
|
Issue Date
|
Iss Date
|
99/99/99
|
|
|
|
qcd_lot
|
Batch
|
|
x(8)
|
|
|
|
qcd_nbr
|
Quality Order
|
|
x(18)
|
|
|
|
qcd_op
|
Operation
|
Op
|
>>>>>>
|
|
|
|
qcd_part
|
Item Number
|
|
x(18)
|
|
|
|
qcd_qty_iss
|
Qty Issued
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qcd_qty_req
|
Qty Required
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qcd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qcd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qcd_det
|
yes
|
oid_qcd_det
|
yes
|
no
|
|
∗
|
qcd_det
|
yes
|
qcd_domain
|
yes
|
no
|
|
|
|
|
qcd_lot
|
yes
|
no
|
|
|
|
|
qcd_part
|
yes
|
no
|
|
|
|
|
qcd_op
|
yes
|
no
|
|
|
qcd_nbrpart
|
no
|
qcd_domain
|
yes
|
no
|
|
|
|
|
qcd_nbr
|
yes
|
no
|
|
|
|
|
qcd_lot
|
yes
|
no
|
|
|
|
|
qcd_part
|
yes
|
no
|
|
|
qcd_part
|
no
|
qcd_domain
|
yes
|
no
|
|
|
|
|
qcd_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qcs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qcs__chr01
|
|
|
x(8)
|
|
|
|
qcs__chr02
|
|
|
x(8)
|
|
|
|
qcs__chr03
|
|
|
x(8)
|
|
|
|
qcs__chr04
|
|
|
x(8)
|
|
|
|
qcs__chr05
|
|
|
x(8)
|
|
|
|
qcs_days
|
Days to Expire
|
Expire
|
>>>9
|
|
|
|
qcs_domain
|
Domain
|
|
x(8)
|
|
|
|
qcs_lot_int
|
Lot Interval
|
Interval
|
>>>>>>9
|
|
|
|
qcs_part
|
Item Number
|
Item
|
x(18)
|
|
|
|
qcs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qcs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qcs_mstr
|
yes
|
oid_qcs_mstr
|
yes
|
no
|
|
∗
|
qcs_part
|
yes
|
qcs_domain
|
yes
|
no
|
|
|
|
|
qcs_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qc__chr01
|
|
|
x(8)
|
|
|
|
qc__chr02
|
|
|
x(8)
|
|
|
|
qc__chr03
|
|
|
x(8)
|
|
|
|
qc__chr04
|
|
|
x(8)
|
|
|
|
qc__chr05
|
|
|
x(8)
|
|
|
|
qc__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qc__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qc__dte01
|
|
|
99/99/99
|
|
|
|
qc__dte02
|
|
|
99/99/99
|
|
|
|
qc__log01
|
|
|
yes/no
|
|
|
|
qc_autoissue
|
Auto Issue
|
|
yes/no
|
|
|
|
qc_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
qc_domain
|
Domain
|
|
x(8)
|
|
|
|
qc_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
qc_insp_loc
|
Inspection Location
|
Insp Loc
|
x(8)
|
|
|
|
qc_inv_stat
|
Inventory Status
|
Inv Stat
|
x(8)
|
|
|
|
qc_job
|
PO/Job
|
|
x(8)
|
|
|
|
qc_lead_time
|
Lead Time
|
|
->,>>>,>>9
|
10
|
|
|
qc_loc
|
Location
|
|
x(8)
|
|
|
|
qc_lot
|
Batch
|
|
x(8)
|
|
|
|
qc_nbr
|
Quality Order
|
|
x(18)
|
|
|
|
qc_ord_date
|
Start Date
|
Start
|
99/99/99
|
|
|
|
qc_part
|
Item Number
|
|
x(18)
|
|
|
|
qc_project
|
Project
|
|
x(8)
|
|
|
|
qc_qty_comp
|
Qty Accepted
|
Accepted
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qc_qty_ord
|
Qty Pending
|
Pending
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qc_qty_rjct
|
Qty Rejected
|
Rejected
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qc_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
qc_rel_date
|
Release Date
|
Release
|
99/99/99
|
|
|
|
qc_rmks
|
Remarks
|
|
x(40)
|
|
|
|
qc_serial
|
Lot/Serial
|
L/S
|
x(18)
|
|
|
|
qc_site
|
Site
|
|
x(8)
|
|
|
|
qc_status
|
Status
|
St
|
x(1)
|
|
|
|
qc_teststep
|
Procedure
|
|
x(18)
|
|
|
|
qc_type
|
Type
|
T
|
x(1)
|
|
|
|
qc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qc_mstr
|
yes
|
oid_qc_mstr
|
yes
|
no
|
|
|
qc_due_part
|
no
|
qc_domain
|
yes
|
no
|
|
|
|
|
qc_due_date
|
yes
|
no
|
|
|
|
|
qc_part
|
yes
|
no
|
|
|
|
|
qc_site
|
yes
|
no
|
|
|
qc_lot
|
yes
|
qc_domain
|
yes
|
no
|
|
|
|
|
qc_lot
|
yes
|
no
|
|
∗
|
qc_nbr
|
yes
|
qc_domain
|
yes
|
no
|
|
|
|
|
qc_nbr
|
yes
|
no
|
|
|
|
|
qc_lot
|
yes
|
no
|
|
|
qc_part
|
no
|
qc_domain
|
yes
|
no
|
|
|
|
|
qc_part
|
yes
|
no
|
|
|
|
|
qc_site
|
yes
|
no
|
|
|
|
|
qc_due_date
|
yes
|
no
|
|
|
qc_type_nbr
|
yes
|
qc_domain
|
yes
|
no
|
|
|
|
|
qc_type
|
yes
|
no
|
|
|
|
|
qc_nbr
|
yes
|
no
|
|
|
|
|
qc_lot
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Link to CostCentre
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-99999999999
|
|
|
|
Division_ID
|
Link to Division
|
|
-99999999999
|
|
|
|
FRWCube_ID
|
Link to FRWCube
|
|
-99999999999
|
|
|
|
GL_ID
|
Link to GL
|
|
-99999999999
|
|
|
|
IntercoBusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
Journal_ID
|
Link to Journal
|
|
-99999999999
|
|
|
|
JournalTypeCode
|
Daybook Type
|
|
x(30)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Layer_ID
|
Link to Layer
|
|
-99999999999
|
|
|
|
Period_ID
|
Link to Period
|
|
-99999999999
|
|
|
|
PeriodYearPeriod
|
Year / GL Period
|
|
999999
|
|
|
|
PostingHist_ID
|
Link to PostingHist
|
|
-99999999999
|
|
|
|
Project_ID
|
Link to Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QFRWCube_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QFRWCubeCreditCC
|
SC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeCreditLC
|
BC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeCreditTC
|
TC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitCC
|
SC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitLC
|
BC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeDebitTC
|
TC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
QFRWCubeETime
|
Time (s)
|
|
->>>,>>>,>>>,>>9.9999
|
4
|
|
|
QFRWCubeInfo
|
Info
|
|
x(40)
|
|
|
|
QFRWCubePHLastModifiedDate
|
Last Modified Date PH
|
Mod Date PH
|
99/99/9999
|
|
|
|
QFRWCubePHLastModifiedTime
|
Last Modified Time PH
|
Mod Time PH
|
99999
|
|
|
|
QFRWCubePostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
QFRWCubeQTY
|
Quantity
|
Qty
|
->>>,>>>,>>9.99999
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
FRWCubeIdx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
ICBusRel
|
no
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
|
PeriodYrPd
|
no
|
PeriodYearPeriod
|
yes
|
no
|
|
|
PostingHist
|
no
|
PostingHist_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
QFRWCube_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QFRWCube_ID
|
Link to QFRWCube
|
|
-99999999999
|
|
|
|
QFRWCubeSaf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
QFRWCubeSafInputSequence
|
SAF Input Sequence
|
|
->,>>>,>>9
|
|
|
|
QFRWCubeSafParentType
|
SAF Parent Type
|
|
x(20)
|
|
|
|
Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeIdx
|
no
|
QFRWCube_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
QFRWCubeSaf_ID
|
yes
|
no
|
|
|
SafIdx
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafStrIdx
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
FRWCube_ID
|
Link to FRWCube
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QFRWCube_ID
|
Link to QFRWCube
|
|
-99999999999
|
|
|
|
QFRWCubeSkip_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CubeIdx
|
no
|
FRWCube_ID
|
yes
|
no
|
|
|
|
|
QFRWCube_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
QFRWCubeSkip_ID
|
yes
|
no
|
|
|
QCubeIdx
|
no
|
QFRWCube_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qlcoac_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlcoac__qadc01
|
|
|
x(24)
|
|
|
|
qlcoac__qadc02
|
|
|
x(24)
|
|
|
|
qlcoac_certificate_seq_id
|
Certificate Sequence ID
|
|
x(8)
|
|
|
|
qlcoac_domain
|
Domain
|
|
x(8)
|
|
|
|
qlcoac_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qlcoac_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlcoac_print_assay
|
Print Assay%
|
|
yes/no
|
|
|
|
qlcoac_print_expire
|
Print Expire
|
|
yes/no
|
|
|
|
qlcoac_print_grade
|
Print Grade
|
|
yes/no
|
|
|
|
qlcoac_print_mfg_date
|
Print Manufacture
|
|
yes/no
|
|
|
|
qlcoac_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qlcoac_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qlcoac_ctrl
|
yes
|
oid_qlcoac_ctrl
|
yes
|
no
|
|
∗
|
qlcoac_domain
|
yes
|
qlcoac_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qlcoa_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_qlcoad_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlcoad__qadc01
|
|
|
x(24)
|
|
|
|
qlcoad__qadc02
|
|
|
x(24)
|
|
|
|
qlcoad_attr_name
|
Attribute ID
|
|
x(32)
|
|
|
|
qlcoad_cert_category
|
Certification Category
|
|
x(18)
|
|
|
|
qlcoad_existing_value_char
|
Existing Value
|
|
x(50)
|
|
|
|
qlcoad_format
|
Format
|
|
x(50)
|
|
|
|
qlcoad_inv_update_level
|
Inventory Update
|
|
x(8)
|
|
|
|
qlcoad_label_term
|
Label Term
|
|
x(35)
|
|
|
|
qlcoad_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qlcoad_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlcoad_ref
|
Reference
|
|
x(40)
|
|
|
|
qlcoad_result
|
Result
|
|
x(8)
|
|
|
|
qlcoad_seq
|
Sequence
|
|
>>>>>>>9
|
|
|
|
qlcoad_spec_desc
|
Specification
|
|
x(48)
|
|
|
|
qlcoad_test_date
|
Test Date
|
|
99/99/99
|
|
|
|
qlcoad_test_id
|
Test ID
|
|
x(24)
|
|
|
|
qlcoad_test_method
|
Test Method
|
|
x(12)
|
|
|
|
qlcoad_um_desc
|
Measurement
|
|
x(12)
|
|
|
|
qlcoad_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qlcoad_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qlcoad_det
|
yes
|
oid_qlcoad_det
|
yes
|
no
|
|
|
qlcoad_attr_name
|
no
|
oid_qlcoa_mstr
|
yes
|
no
|
|
|
|
|
qlcoad_attr_name
|
yes
|
no
|
|
|
|
|
qlcoad_seq
|
yes
|
no
|
|
∗
|
qlcoad_parent_name
|
yes
|
oid_qlcoa_mstr
|
yes
|
no
|
|
|
|
|
qlcoad_cert_category
|
yes
|
no
|
|
|
|
|
qlcoad_attr_name
|
yes
|
no
|
|
|
|
|
qlcoad_seq
|
yes
|
no
|
|
|
qlcoad_parent_seq
|
no
|
oid_qlcoa_mstr
|
yes
|
no
|
|
|
|
|
qlcoad_cert_category
|
yes
|
no
|
|
|
|
|
qlcoad_seq
|
yes
|
no
|
|
|
|
|
qlcoad_attr_name
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qlcoa_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlcoa__qadc01
|
|
|
x(24)
|
|
|
|
qlcoa__qadc02
|
|
|
x(24)
|
|
|
|
qlcoa_approve_date
|
Approve Date
|
|
99/99/99
|
|
|
|
qlcoa_approver_name
|
Approver Name
|
|
x(36)
|
|
|
|
qlcoa_approver_userid
|
Approved By
|
|
x(8)
|
|
|
|
qlcoa_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
qlcoa_certificate_date
|
Certificate Date
|
|
99/99/99
|
|
|
|
qlcoa_complete_date
|
Completed Date
|
|
99/99/99
|
|
|
|
qlcoa_completed_userid
|
Completed By
|
|
x(8)
|
|
|
|
qlcoa_cust
|
Sold-To
|
|
x(8)
|
|
|
|
qlcoa_cust_name
|
Cust Name
|
|
x(36)
|
|
|
|
qlcoa_doc_type
|
Doc Type
|
|
x(8)
|
|
|
|
qlcoa_domain
|
Domain
|
|
x(8)
|
|
|
|
qlcoa_expire
|
Expire Date
|
Expire
|
99/99/99
|
|
|
|
qlcoa_grade
|
Grade
|
|
x(2)
|
|
|
|
qlcoa_id
|
Certificate
|
|
x(24)
|
|
|
|
qlcoa_item_desc1
|
Description
|
|
x(24)
|
|
|
|
qlcoa_lot
|
Lot
|
|
x(18)
|
|
|
|
qlcoa_mfg_date
|
Mfg Date
|
|
99/99/99
|
|
|
|
qlcoa_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qlcoa_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlcoa_mtl_disposition
|
Material Disposition
|
|
x(8)
|
|
|
|
qlcoa_mtl_disposition_date
|
Disposition Date
|
|
99/99/99
|
|
|
|
qlcoa_part
|
Item Number
|
|
x(18)
|
|
|
|
qlcoa_print_assay
|
Print Assay%
|
|
yes/no
|
|
|
|
qlcoa_print_expire
|
Print Expire
|
|
yes/no
|
|
|
|
qlcoa_print_grade
|
Print Grade
|
|
yes/no
|
|
|
|
qlcoa_print_mfg_date
|
Print Manufacture
|
|
yes/no
|
|
|
|
qlcoa_ql_id
|
Document Order
|
|
x(24)
|
|
|
|
qlcoa_ship
|
Ship-To
|
|
x(8)
|
|
|
|
qlcoa_ship_name
|
Ship-To Name
|
|
x(36)
|
|
|
|
qlcoa_site
|
Site
|
|
x(8)
|
|
|
|
qlcoa_so_nbr
|
Sales Order
|
|
x(8)
|
|
|
|
qlcoa_sod_line
|
Line
|
Ln
|
>>9
|
|
|
|
qlcoa_sublot
|
Sublot
|
|
x(18)
|
|
|
|
qlcoa_test_result_status
|
COA Result
|
|
x(8)
|
|
|
|
qlcoa_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qlcoa_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qlcoa_mstr
|
yes
|
oid_qlcoa_mstr
|
yes
|
no
|
|
∗
|
qlcoa_id
|
yes
|
qlcoa_domain
|
yes
|
no
|
|
|
|
|
qlcoa_id
|
yes
|
no
|
|
|
qlcoa_lot_part
|
no
|
qlcoa_domain
|
yes
|
no
|
|
|
|
|
qlcoa_doc_type
|
yes
|
no
|
|
|
|
|
qlcoa_lot
|
yes
|
no
|
|
|
|
|
qlcoa_sublot
|
yes
|
no
|
|
|
|
|
qlcoa_part
|
yes
|
no
|
|
|
|
|
qlcoa_site
|
yes
|
no
|
|
|
|
|
qlcoa_certificate_date
|
yes
|
no
|
|
|
qlcoa_part_so
|
no
|
qlcoa_domain
|
yes
|
no
|
|
|
|
|
qlcoa_doc_type
|
yes
|
no
|
|
|
|
|
qlcoa_site
|
yes
|
no
|
|
|
|
|
qlcoa_part
|
yes
|
no
|
|
|
|
|
qlcoa_lot
|
yes
|
no
|
|
|
|
|
qlcoa_sublot
|
yes
|
no
|
|
|
|
|
qlcoa_so_nbr
|
yes
|
no
|
|
|
|
|
qlcoa_sod_line
|
yes
|
no
|
|
|
|
|
qlcoa_certificate_date
|
yes
|
no
|
|
|
qlcoa_qlid_so
|
no
|
qlcoa_domain
|
yes
|
no
|
|
|
|
|
qlcoa_doc_type
|
yes
|
no
|
|
|
|
|
qlcoa_ql_id
|
yes
|
no
|
|
|
|
|
qlcoa_so_nbr
|
yes
|
no
|
|
|
|
|
qlcoa_sod_line
|
yes
|
no
|
|
|
|
|
qlcoa_certificate_date
|
yes
|
no
|
|
|
qlcoa_sod_line
|
no
|
qlcoa_domain
|
yes
|
no
|
|
|
|
|
qlcoa_doc_type
|
yes
|
no
|
|
|
|
|
qlcoa_so_nbr
|
yes
|
no
|
|
|
|
|
qlcoa_sod_line
|
yes
|
no
|
|
|
|
|
qlcoa_lot
|
yes
|
no
|
|
|
|
|
qlcoa_sublot
|
yes
|
no
|
|
|
|
|
qlcoa_certificate_date
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qlc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlc__qadc01
|
|
|
x(8)
|
|
|
|
qlc__qadc02
|
|
|
x(8)
|
|
|
|
qlc__qadc03
|
|
|
x(8)
|
|
|
|
qlc__qadd01
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qlc__qadd02
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qlc__qadl01
|
|
|
yes/no
|
|
|
|
qlc__qadt01
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qlc__qadt02
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qlc_certification_seq_id
|
Certification Sequence ID
|
|
x(8)
|
|
|
|
qlc_display_specs
|
Display Specifications
|
|
yes/no
|
|
|
|
qlc_domain
|
Domain
|
|
x(8)
|
|
|
|
qlc_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
qlc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlc_qms_integration
|
QMS Integration
|
|
x(8)
|
|
|
|
qlc_quality_order_seq_id
|
Quality Order Sequence ID
|
|
x(8)
|
|
|
|
qlc_test_result_seq_id
|
Test Result Sequence ID
|
|
x(8)
|
|
|
|
qlc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qlc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qlc_ctrl
|
yes
|
oid_qlc_ctrl
|
yes
|
no
|
|
∗
|
qlc_domain
|
yes
|
qlc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_attrpf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_attrpfd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_original
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_parent
|
Parent OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_qlpfdv_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlpfdv__qadc01
|
|
|
x(24)
|
|
|
|
qlpfdv__qadc02
|
|
|
x(24)
|
|
|
|
qlpfdv__qadc03
|
|
|
x(24)
|
|
|
|
qlpfdv_append_text_value
|
Append Text Value
|
|
yes/no
|
|
|
|
qlpfdv_attr_name
|
Attribute ID
|
|
x(32)
|
|
|
|
qlpfdv_cert_category
|
Certification Category
|
|
x(18)
|
|
|
|
qlpfdv_certification
|
Certification Record
|
|
yes/no
|
|
|
|
qlpfdv_default_value_char
|
Default Value
|
|
x(50)
|
|
|
|
qlpfdv_default_value_dec
|
Default Value
|
|
->>,>>9.99
|
10
|
|
|
qlpfdv_default_value_dt
|
Default Value
|
|
99/99/9999 HH:MM:SS.SSS
|
|
|
|
qlpfdv_default_value_int
|
Default Value
|
|
->,>>>,>>9
|
|
|
|
qlpfdv_default_value_log
|
Default Value
|
|
yes/no
|
|
|
|
qlpfdv_edit_spec
|
Print
|
|
yes/no
|
|
|
|
qlpfdv_entered
|
Entered
|
|
yes/no
|
|
|
|
qlpfdv_input_method
|
Input Method
|
|
x(8)
|
|
|
|
qlpfdv_inv_update_level
|
Inventory Update
|
|
x(8)
|
|
|
|
qlpfdv_inv_update_level_act
|
Inventory Level Code
|
|
x(8)
|
|
|
|
qlpfdv_list_value
|
Values
|
|
yes/no
|
|
|
|
qlpfdv_loc
|
Location
|
|
x(8)
|
|
|
|
qlpfdv_lot
|
Lot
|
|
x(18)
|
|
|
|
qlpfdv_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qlpfdv_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlpfdv_nc_status_code
|
Non-conforming Status
|
|
x(8)
|
|
|
|
qlpfdv_op_attrpfd_det
|
Operation Type
|
|
x(8)
|
|
|
|
qlpfdv_parent_table
|
Parent Table
|
|
x(14)
|
|
|
|
qlpfdv_printable
|
Print
|
|
yes/no
|
|
|
|
qlpfdv_ref
|
Reference
|
|
x(40)
|
|
|
|
qlpfdv_remarks
|
Remarks
|
|
x(40)
|
|
|
|
qlpfdv_req
|
Required
|
|
yes/no
|
|
|
|
qlpfdv_resolution
|
Resolution
|
|
x(8)
|
|
|
|
qlpfdv_result
|
Result
|
|
x(8)
|
|
|
|
qlpfdv_seq
|
Sequence
|
|
>>>>>>>9
|
|
|
|
qlpfdv_site
|
Site
|
|
x(8)
|
|
|
|
qlpfdv_skip_save
|
Skip Save
|
|
yes/no
|
|
|
|
qlpfdv_src
|
Source
|
|
x(8)
|
|
|
|
qlpfdv_status
|
Status
|
|
x(8)
|
|
|
|
qlpfdv_sublot
|
Sublot
|
|
x(18)
|
|
|
|
qlpfdv_test_id
|
Test ID
|
|
x(24)
|
|
|
|
qlpfdv_test_method
|
Test Method
|
|
x(12)
|
|
|
|
qlpfdv_trans_hist
|
Transaction History
|
|
yes/no
|
|
|
|
qlpfdv_ui_display
|
UI Display
|
|
yes/no
|
|
|
|
qlpfdv_um_desc
|
Measurement
|
|
x(12)
|
|
|
|
qlpfdv_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qlpfdv_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
qlpfdv_validate_to_spec
|
Validation
|
|
yes/no
|
|
|
|
qlpfdv_value_src
|
Source Value
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_qlpfdv_det
|
yes
|
oid_qlpfdv_det
|
yes
|
no
|
|
|
qlpfdv_parent_attr
|
no
|
oid_parent
|
yes
|
no
|
|
|
|
|
qlpfdv_attr_name
|
yes
|
no
|
|
|
|
|
qlpfdv_seq
|
yes
|
no
|
|
∗
|
qlpfdv_parent_seq
|
yes
|
oid_parent
|
yes
|
no
|
|
|
|
|
qlpfdv_seq
|
yes
|
no
|
|
|
|
|
qlpfdv_attr_name
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qlt_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_qltd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qltd__qadc01
|
|
|
x(8)
|
|
|
|
qltd__qadc02
|
|
|
x(8)
|
|
|
|
qltd__qadc03
|
|
|
x(8)
|
|
|
|
qltd__qadd01
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qltd__qadd02
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qltd__qadl01
|
|
|
yes/no
|
|
|
|
qltd__qadt01
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qltd__qadt02
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qltd_domain
|
Domain
|
|
x(8)
|
|
|
|
qltd_effective_date
|
Effective Date
|
|
99/99/99
|
|
|
|
qltd_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
qltd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qltd_obsoleted_date
|
Obsolete Date
|
|
99/99/99
|
|
|
|
qltd_obsoleted_userid
|
Obsoleted By
|
|
x(8)
|
|
|
|
qltd_reference
|
Reference
|
|
x(24)
|
|
|
|
qltd_released_date
|
Released Date
|
|
99/99/99
|
|
|
|
qltd_released_userid
|
Released By
|
|
x(8)
|
|
|
|
qltd_status
|
Status
|
|
x(8)
|
|
|
|
qltd_test_cmtindx
|
Comments
|
|
>>>>>>>9
|
|
|
|
qltd_test_revision
|
Revision
|
|
x(8)
|
|
|
|
qltd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qltd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_qlt_mstr
|
yes
|
oid_qlt_mstr
|
yes
|
no
|
|
|
|
|
qltd_test_revision
|
yes
|
no
|
|
|
oid_qltd_det
|
yes
|
oid_qltd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_parent
|
Parent OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_qltr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qltr__qadc01
|
|
|
x(24)
|
|
|
|
qltr__qadc02
|
|
|
x(24)
|
|
|
|
qltr__qadc03
|
|
|
x(24)
|
|
|
|
qltr__qadc04
|
|
|
x(24)
|
|
|
|
qltr__qadl01
|
|
|
yes/no
|
|
|
|
qltr__qadl02
|
|
|
yes/no
|
|
|
|
qltr_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
qltr_domain
|
Domain
|
|
x(8)
|
|
|
|
qltr_emp
|
Employee
|
|
x(8)
|
|
|
|
qltr_id
|
Test Order
|
|
x(24)
|
|
|
|
qltr_manually_added
|
Manual
|
|
yes/no
|
|
|
|
qltr_mch
|
Machine
|
|
x(8)
|
|
|
|
qltr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
qltr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qltr_mtl_disposition
|
Material Disposition
|
|
x(8)
|
|
|
|
qltr_mtl_disposition_date
|
Disposition Date
|
|
99/99/99
|
|
|
|
qltr_order_date
|
Order Date
|
|
99/99/99
|
|
|
|
qltr_parent_table
|
Parent Table
|
|
x(14)
|
|
|
|
qltr_qty_accept
|
Qty Accepted
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qltr_qty_reject
|
Qty Rejected
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qltr_qty_retain
|
Qty Retained
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qltr_qty_scrap
|
Qty Scrapped
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qltr_qty_test
|
Test Quantity
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qltr_reference
|
Reference
|
|
x(24)
|
|
|
|
qltr_remarks
|
Remarks
|
|
x(60)
|
|
|
|
qltr_sample_um_desc
|
Measurement
|
|
x(12)
|
|
|
|
qltr_status
|
Test Status
|
|
x(8)
|
|
|
|
qltr_test_date
|
Test Date
|
|
99/99/99
|
|
|
|
qltr_test_id
|
Test ID
|
|
x(24)
|
|
|
|
qltr_test_result_status
|
Test Result
|
|
x(8)
|
|
|
|
qltr_test_revision
|
Revision
|
|
x(8)
|
|
|
|
qltr_tester_userid
|
Tested By
|
|
x(8)
|
|
|
|
qltr_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
qltr_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
qltr_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
qltr_userl02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
qltr_verifier_userid
|
Verified By
|
|
x(8)
|
|
|
|
qltr_verify_date
|
Verify Date
|
|
99/99/99
|
|
|
|
qltr_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_parent_test_rev
|
no
|
oid_parent
|
yes
|
no
|
|
|
|
|
qltr_test_id
|
yes
|
no
|
|
|
|
|
qltr_test_revision
|
yes
|
no
|
|
|
|
|
qltr_order_date
|
yes
|
no
|
|
|
|
|
qltr_reference
|
yes
|
no
|
|
|
oid_qltr_det
|
yes
|
oid_qltr_det
|
yes
|
no
|
|
|
qltr_domain_parent
|
no
|
qltr_domain
|
yes
|
no
|
|
|
|
|
oid_parent
|
yes
|
no
|
|
|
|
|
qltr_test_id
|
yes
|
no
|
|
|
|
|
qltr_test_revision
|
yes
|
no
|
|
|
|
|
qltr_order_date
|
yes
|
no
|
|
|
|
|
qltr_reference
|
yes
|
no
|
|
∗
|
qltr_id
|
yes
|
qltr_domain
|
yes
|
no
|
|
|
|
|
qltr_id
|
yes
|
no
|
|
|
qltr_test_id
|
no
|
qltr_domain
|
yes
|
no
|
|
|
|
|
qltr_test_id
|
yes
|
no
|
|
|
|
|
qltr_test_revision
|
yes
|
no
|
|
|
|
|
qltr_order_date
|
yes
|
no
|
|
|
|
|
qltr_reference
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_qltd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_qlts_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
qlts__qadc01
|
|
|
x(8)
|
|
|
|
qlts__qadc02
|
|
|
x(8)
|
|
|
|
qlts__qadc03
|
|
|
x(8)
|
|
|
|
qlts__qadd01
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qlts__qadd02
|
QAD Field
|
|
>>>,>>>,>>9.99
|
10
|
|
|
qlts__qadl01
|
|
|
yes/no
|
|
|
|
qlts__qadt01
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qlts__qadt02
|
QAD Date Field
|
|
99/99/99
|
|
|
|
qlts_domain
|
Domain
|
|
x(8)
|
|
|
|
qlts_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
qlts_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
qlts_nbr_of_samples
|
Number of Samples
|
|
>>,>>>,>>9
|
|
|
|
qlts_qty_sample
|
Sample Quantity
|
|
>>>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
qlts_record_attributes
|
Record Attributes
|
|
yes/no
|
|
|
|
qlts_record_results
|
Record Results
|
|
yes/no
|
|
|
|
qlts_sample_cmtindx
|
Comments
|
|
>>>>>>>9
|
|
|
|
qlts_sample_pattern
|
Sampling Pattern
|
|
x(24)
|
|
|
|
qlts_sample_percent
|
Sample Percent
|
|
>>9.99%
|
10
|
|
|
qlts_sample_reference
|
Reference
|
|
x(24)
|
|
|
|
qlts_sample_um_desc
|
Measurement
|
|
x(12)
|
|
|
|
qlts_user1
|
Ufld1
|
|
x(8)
|
|
|
|
qlts_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_qltd_det
|
yes
|
oid_qltd_det
|
yes
|
no
|
|
|
oid_qlts_det
|
yes
|
oid_qlts_det
|
yes
|
no
|