QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
qaddb_ctrl
Database Control for QADDB
 
 
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
qaddb_ver
Table name identifies the database type.
 
 
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
QADFinReserved
QADFinancials
 
 
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
qad_wkfl
QAD Work Table
 
 
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
QBatchDaemon
Batch Daemon Queue
 
 
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
qcc_ctrl
Quality Order Control
 
 
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
qcd_det
Quality Control Order Detail
 
 
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
qcs_mstr
Quality Sampling Pattern Master
 
 
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
qc_mstr
Quality Control Order Master
 
 
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
QFRWCube
Financial Report Writer
 
 
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
QFRWCubeSaf
Financial Report Writer
 
 
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
QFRWCubeSkip
Financial Report Writer
 
 
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
qlcoac_ctrl
Certificate Of Analysis Control File
 
 
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
qlcoad_det
Quality Certificate of Analysis Detail
 
 
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
qlcoa_mstr
Quality Certificate of Analysis Master
 
 
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
qlc_ctrl
Quality Control File
 
 
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
qlpfdv_det
Quality Profile Detail Value
 
 
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
qltd_det
Test Revision Detail
 
 
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
qltr_det
Lot Attribute Test Record Detail
 
 
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
qlts_det
Test Sample Detail
 
 
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