QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
qltx_ref
Item Test Link Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qltx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qltx__qadc01
 
 
x(8)
 
 
qltx__qadc02
 
 
x(8)
 
 
qltx__qadc03
 
 
x(8)
 
 
qltx__qadd01
QAD Field
 
>>>,>>>,>>9.99
10
 
qltx__qadd02
QAD Field
 
>>>,>>>,>>9.99
10
 
qltx__qadl01
 
 
yes/no
 
 
qltx__qadt01
QAD Date Field
 
99/99/99
 
 
qltx__qadt02
QAD Date Field
 
99/99/99
 
 
qltx_domain
Domain
 
x(8)
 
 
qltx_mod_date
Modified Date
 
99/99/99
 
 
qltx_mod_userid
User ID
 
x(8)
 
 
qltx_op
Operation
Op
>>>>9
 
 
qltx_part
Item Number
 
x(18)
 
 
qltx_required
Required Test
 
yes/no
 
 
qltx_routing
Routing Code
 
x(18)
 
 
qltx_seq
Sequence
 
>>>9
 
 
qltx_site
Site
 
x(8)
 
 
qltx_test_id
Test ID
 
x(24)
 
 
qltx_user1
Ufld1
 
x(8)
 
 
qltx_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qltx_ref
yes
oid_qltx_ref
yes
no
 
qltx_item_test
yes
qltx_domain
yes
no
 
 
 
qltx_part
yes
no
 
 
 
qltx_site
yes
no
 
 
 
qltx_routing
yes
no
 
 
 
qltx_op
yes
no
 
 
 
qltx_seq
yes
no
 
 
 
qltx_test_id
yes
no
qltx_test_item
yes
qltx_domain
yes
no
 
 
 
qltx_test_id
yes
no
 
 
 
qltx_part
yes
no
 
 
 
qltx_site
yes
no
 
 
 
qltx_routing
yes
no
 
 
 
qltx_op
yes
no
qlt_mstr
Quality Test Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qlt_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qlt__qadc01
 
 
x(8)
 
 
qlt__qadc02
 
 
x(8)
 
 
qlt__qadc03
 
 
x(8)
 
 
qlt__qadd01
QAD Field
 
>>>,>>>,>>9.99
10
 
qlt__qadd02
QAD Field
 
>>>,>>>,>>9.99
10
 
qlt__qadl01
 
 
yes/no
 
 
qlt__qadt01
QAD Date Field
 
99/99/99
 
 
qlt__qadt02
QAD Date Field
 
99/99/99
 
 
qlt_category
Test Category
 
x(18)
 
 
qlt_description
Description
 
x(24)
 
 
qlt_domain
Domain
 
x(8)
 
 
qlt_mod_date
Modified Date
 
99/99/99
 
 
qlt_mod_userid
User ID
 
x(8)
 
 
qlt_test_id
Test ID
 
x(24)
 
 
qlt_user1
Ufld1
 
x(8)
 
 
qlt_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qlt_mstr
yes
oid_qlt_mstr
yes
no
 
qlt_test_category
no
qlt_domain
yes
no
 
 
 
qlt_category
yes
no
 
 
 
qlt_test_id
yes
no
qlt_test_id
yes
qlt_domain
yes
no
 
 
 
qlt_test_id
yes
no
qlwr_route
Quality Work Order Routing
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qlwr_route
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qlwr__qadc01
 
 
x(24)
 
 
qlwr__qadc02
 
 
x(24)
 
 
qlwr_bom_code
BOM/Formula
 
x(18)
 
 
qlwr_cmtindx
Comment Index
 
>>>>>>>9
 
 
qlwr_domain
Domain
 
x(8)
 
 
qlwr_emp
Employee
 
x(8)
 
 
qlwr_line
Production Line
 
x(8)
 
 
qlwr_lot
ID
 
x(8)
 
 
qlwr_lotser
Lot/Serial
 
x(18)
 
 
qlwr_mch
Machine
 
x(8)
 
 
qlwr_milestone
Milestone Operation
Milestone
yes/no
 
 
qlwr_mod_date
Modified Date
Mod Date
99/99/99
 
 
qlwr_mod_userid
User ID
 
x(8)
 
 
qlwr_nbr
Work Order
 
x(18)
 
 
qlwr_op
Operation
 
>>>>>9
 
 
qlwr_op_desc
Description
 
x(24)
 
 
qlwr_part
Item Number
 
x(18)
 
 
qlwr_ref
Reference
Ref
x(8)
 
 
qlwr_routing
Routing Code
 
x(18)
 
 
qlwr_site
Site
 
x(8)
 
 
qlwr_user1
User Field Character 1
 
x(24)
 
 
qlwr_user2
User Field Character 2
 
x(24)
 
 
qlwr_wkctr
Work Center
 
x(8)
 
 
qlwr_wo_type
Type
T
x(1)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qlwr_route
yes
oid_qlwr_route
yes
no
 
qlwr_emp_wkctr
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_emp
yes
no
 
 
 
qlwr_wkctr
yes
no
 
 
 
qlwr_part
yes
no
 
 
 
qlwr_routing
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
qlwr_lot
yes
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_lot
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
 
qlwr_lotser
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
 
 
 
qlwr_lot
yes
no
 
 
 
qlwr_op
yes
no
 
qlwr_part_route
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_part
yes
no
 
 
 
qlwr_routing
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
 
qlwr_part_wkctr
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_part
yes
no
 
 
 
qlwr_wkctr
yes
no
 
 
 
qlwr_routing
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
 
qlwr_wkctr_part
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_wkctr
yes
no
 
 
 
qlwr_part
yes
no
 
 
 
qlwr_routing
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
 
qlwr_wkctr_route
no
qlwr_domain
yes
no
 
 
 
qlwr_wo_type
yes
no
 
 
 
qlwr_wkctr
yes
no
 
 
 
qlwr_mch
yes
no
 
 
 
qlwr_routing
yes
no
 
 
 
qlwr_op
yes
no
 
 
 
qlwr_lotser
yes
no
 
 
 
qlwr_ref
yes
no
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
qob_det
Sales Quotation Configuration Bill Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qob_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qob__qadc01
 
 
x(8)
 
 
qob_bo_chg
Qty B/O
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_cfg_type
Configuration
Config
x(1)
 
 
qob_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qob_domain
Domain
 
x(8)
 
 
qob_feature
Feature
 
x(12)
 
 
qob_iss_date
Issue Date
Iss Date
99/99/99
 
 
qob_line
Line
 
>>9
 
 
qob_loc
Location
 
x(8)
 
 
qob_nbr
Quote
 
x(8)
 
 
qob_parent
Parent Item
 
x(18)
 
 
qob_part
Item Number
 
x(18)
 
 
qob_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
qob_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_qty_chg
Qty to Issue
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_qty_iss
Qty Issued
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_qty_req
Qty Required
 
->,>>>,>>9.9<<<<<<<<
10
 
qob_serial
Lot/Serial
 
x(18)
 
 
qob_site
Site
 
x(8)
 
 
qob_tot_std
List Price
 
->>>,>>9.999
10
 
qob_user1
Ufld1
 
x(8)
 
 
qob_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qob_det
yes
oid_qob_det
yes
no
qob_det
yes
qob_domain
yes
no
 
 
 
qob_nbr
yes
no
 
 
 
qob_line
yes
no
 
 
 
qob_feature
yes
no
 
 
 
qob_part
yes
no
 
qob_part
yes
qob_domain
yes
no
 
 
 
qob_part
yes
no
 
 
 
qob_nbr
yes
no
 
 
 
qob_line
yes
no
 
 
 
qob_feature
yes
no
qoc_ctrl
Sales Quotation Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qoc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qoc__qad01
 
 
>>>>>>9
 
 
qoc__qadi01
 
 
->>>>>>>9
 
 
qoc_company
Company Address
 
x(8)
 
 
qoc_days
Days Until Expire
 
>>>>>9
 
 
qoc_domain
Domain
 
x(8)
 
 
qoc_ex_ratetype
Rate Type
 
x(8)
 
 
qoc_fob
F.O.B.
 
x(20)
 
 
qoc_fr_by_site
Calculate Freight by Site
 
yes/no
 
 
qoc_hcmmts
Quote Header Comments
 
yes/no
 
 
qoc_lcmmts
Quote Line Comments
 
yes/no
 
 
qoc_list_markup_net_req
List/Mark-Up/Net Price Tbl Req
 
yes/no
 
 
qoc_ln_fmt
Ln Format S/M
 
single/multi
 
 
qoc_pc_line
Price by QO Line Due Date
 
yes/no
 
 
qoc_pl_req
Price List Required
 
yes/no
 
 
qoc_print
Are Quotes Printed
 
yes/no
 
 
qoc_pt_req
Price Table Required
 
yes/no
 
 
qoc_qo
Next Quote
 
>>>>>>>9
 
 
qoc_qo_pre
Quote Prefix
Pre
x(3)
 
 
qoc_user1
Ufld1
 
x(8)
 
 
qoc_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qoc_ctrl
yes
oid_qoc_ctrl
yes
no
qoc_index1
yes
qoc_domain
yes
no
qodr_det
Sales Quotation Relationship Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qodr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qodr__qadc01
 
 
x(8)
 
 
qodr__qadc02
 
 
x(8)
 
 
qodr__qadc03
 
 
x(8)
 
 
qodr__qadd01
 
 
->>>>,>>>,>>9.9
10
 
qodr__qadd02
 
 
->>>>,>>>,>>9.9
10
 
qodr__qadi01
 
 
->,>>>,>>9
 
 
qodr__qadi02
 
 
->,>>>,>>9
 
 
qodr__qadl01
 
 
yes/no
 
 
qodr__qadl02
 
 
yes/no
 
 
qodr__qadt01
 
 
99/99/99
 
 
qodr__qadt02
 
 
99/99/99
 
 
qodr_div
Division
 
X(8)
 
 
qodr_domain
Domain
 
x(8)
 
 
qodr_group
Group
 
X(8)
 
 
qodr_line
Line
 
>>9
 
 
qodr_nbr
Quote
 
X(8)
 
 
qodr_pricing
Pricing
 
>9
 
 
qodr_seq
Sequence
 
>>9
 
 
qodr_type
Type
 
>>>9
 
 
qodr_user1
Ufld1
 
x(8)
 
 
qodr_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qodr_det
yes
oid_qodr_det
yes
no
qodr_nbrln_seq
yes
qodr_domain
yes
no
 
 
 
qodr_nbr
yes
no
 
 
 
qodr_line
yes
no
 
 
 
qodr_seq
yes
no
 
qodr_type
no
qodr_domain
yes
no
 
 
 
qodr_type
yes
no
qod_det
Sales Quotation Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qod__chr01
Price List
List
x(8)
 
 
qod__chr02
 
 
x(8)
 
 
qod__chr03
 
 
x(8)
 
 
qod__chr04
 
 
x(8)
 
 
qod__chr05
 
 
x(8)
 
 
qod__chr06
 
 
x(8)
 
 
qod__chr07
 
 
x(8)
 
 
qod__chr08
 
 
x(8)
 
 
qod__chr09
 
 
x(8)
 
 
qod__chr10
 
 
x(8)
 
 
qod__dec01
 
 
>>>,>>>,>>9.99
10
 
qod__dec02
 
 
>>>,>>>,>>9.99
10
 
qod__dte01
 
 
99/99/99
 
 
qod__dte02
 
 
99/99/99
 
 
qod__log01
 
 
yes/no
 
 
qod__qad01[5]
 
 
x(40)
 
 
qod__qad02
 
 
>
 
 
qod__qad03
 
 
yes/no
 
 
qod_abnormal
Abnormal Demand
Abnormal
yes/no
 
 
qod_acct
Sales Acct
Sales
x(8)
 
 
qod_bonus
Bonus Stock Line
 
yes/no
 
 
qod_cc
Cost Ctr
CC
x(4)
 
 
qod_cfg_type
Configuration
Config
x(1)
 
 
qod_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qod_comm_pct[2]
Commission
Comm%
>>9.99%
10
 
qod_config_id
Configuration ID
 
x(8)
 
 
qod_crt_int
Credit Terms Int
CRT Int
->>>9.99
10
 
qod_custpart
Customer Item
 
x(30)
 
 
qod_desc
Description
 
x(24)
 
 
qod_disc_pct
Disc %
 
->>9.99%
10
 
qod_div
Division
 
x(8)
 
 
qod_domain
Domain
 
x(8)
 
 
qod_dsc_acct
Disc Acct
 
x(8)
 
 
qod_dsc_cc
Disc CC
CC
x(4)
 
 
qod_dsc_project
Disc Project
 
x(8)
 
 
qod_dsc_sub
Disc Sub-Acct
Sub-Acct
x(8)
 
 
qod_due_date
Due Date
Due
99/99/99
 
 
qod_fa_nbr
Final Assy
FAS
x(8)
 
 
qod_fix_pr
Fixed Price
 
yes/no
 
 
qod_fr_chg
Unit Freight Charge
 
->>>,>>>,>>9.99
10
 
qod_fr_class
Freight Class
 
x(8)
 
 
qod_fr_list
Freight List
Frt List
x(8)
 
 
qod_fr_rate
Freight Rate
 
>>>,>>>,>>9.99<<
10
 
qod_fr_wt
Unit Ship Weight
 
->,>>>,>>9.<<<<<<
10
 
qod_fr_wt_um
UM
 
x(2)
 
 
qod_fst_list
FST on List
 
yes/no
 
 
qod_fst_rate
FST Rate
Rate
->>9%
10
 
qod_fst_tax
FST Tax
 
->>,>>>,>>9.99
10
 
qod_line
Line
Ln
>>9
 
 
qod_list_pr
List Price
 
>>>>,>>>,>>9.99<<<
10
 
qod_loc
Location
 
x(8)
 
 
qod_lot
ID
 
x(8)
 
 
qod_manual_fr_list
Manual Fr List
 
yes/no
 
 
qod_nbr
Quote
 
x(8)
 
 
qod_part
Item Number
 
x(18)
 
 
qod_per_date
Performance Date
Perform
99/99/99
 
 
qod_pl_priority
P/L Priority
 
>9
 
 
qod_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
qod_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
qod_prig1
Pricing Group 1
 
x(8)
 
 
qod_prig2
Pricing Group 2
 
x(8)
 
 
qod_prodline
Product Line
Line
x(4)
 
 
qod_project
Project
 
x(8)
 
 
qod_pst
PST
 
yes/no
 
 
qod_pst_tax
PST Tax
 
->>,>>>,>>9.99
10
 
qod_qob_rev
Revised Date
Revised
99/99/99
 
 
qod_qob_std
Standard Bill
Std BOM
yes/no
 
 
qod_qty_quot
Qty Quoted
 
->,>>>,>>9.9<<<<<<<<
10
 
qod_qty_rel
Qty Released
 
->,>>>,>>9.9<<<<<<<<
10
 
qod_rel_chg
Qty to Release
To Release
->,>>>,>>9.9<<<<<<<<
10
 
qod_req_date
Required Date
Required
99/99/99
 
 
qod_rsn_lost
Reason Lost
Rsn Lost
x(8)
 
 
qod_serial
Lot/Serial
 
x(18)
 
 
qod_site
Site
 
x(8)
 
 
qod_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
qod_status
Status
St
x(1)
 
 
qod_std_cost
Cost
 
->>>,>>>,>>9.99<<<
10
 
qod_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
qod_tax_env
Tax Environment
Tax Env
x(16)
 
 
qod_tax_in
Tax In
 
yes/no
 
 
qod_tax_max
Max Taxable Amount
Max Amount
->>>,>>>,>>9.99
10
 
qod_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
qod_taxable
Taxable
Tax
yes/no
 
 
qod_taxc
Tax Class
TxC
x(3)
 
 
qod_type
Ship Type
T
x(1)
 
 
qod_um
UM
 
x(2)
 
 
qod_um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
qod_user1
Ufld1
 
x(8)
 
 
qod_user2
Ufld2
 
x(8)
 
 
qod_xslspsn[3]
Salesperson
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qod_det
yes
oid_qod_det
yes
no
 
qod_fr_list
no
qod_domain
yes
no
 
 
 
qod_nbr
yes
no
 
 
 
qod_fr_list
yes
no
qod_nbrln
yes
qod_domain
yes
no
 
 
 
qod_nbr
yes
no
 
 
 
qod_line
yes
no
 
qod_part
yes
qod_domain
yes
no
 
 
 
qod_part
yes
no
 
 
 
qod_nbr
yes
no
 
 
 
qod_line
yes
no
qor_mstr
Sales Quotation Relationship Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qor_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qor__qadc01
 
 
x(8)
 
 
qor__qadc02
 
 
x(8)
 
 
qor__qadc03
 
 
x(8)
 
 
qor__qadd01
 
 
->>>>,>>>,>>9.9
10
 
qor__qadd02
 
 
->>>>,>>>,>>9.9
10
 
qor__qadi01
 
 
->,>>>,>>9
 
 
qor__qadi02
 
 
->,>>>,>>9
 
 
qor__qadl01
 
 
yes/no
 
 
qor__qadl02
 
 
yes/no
 
 
qor__qadt01
 
 
99/99/99
 
 
qor__qadt02
 
 
99/99/99
 
 
qor_div
Division
 
X(8)
 
 
qor_domain
Domain
 
x(8)
 
 
qor_group
Group
 
X(8)
 
 
qor_nbr
Quote
 
X(8)
 
 
qor_pricing
Pricing
 
>9
 
 
qor_seq
Sequence
 
>>9
 
 
qor_type
Type
 
>>>9
 
 
qor_user1
Ufld1
 
x(8)
 
 
qor_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qor_mstr
yes
oid_qor_mstr
yes
no
qor_nbr_seq
yes
qor_domain
yes
no
 
 
 
qor_nbr
yes
no
 
 
 
qor_seq
yes
no
 
qor_type
no
qor_domain
yes
no
 
 
 
qor_type
yes
no
qo_mstr
Sales Quotation Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qo_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qo__chr01
 
 
x(8)
 
 
qo__chr02
 
 
x(8)
 
 
qo__chr03
 
 
x(8)
 
 
qo__chr04
 
 
x(8)
 
 
qo__chr05
 
 
x(8)
 
 
qo__chr06
 
 
x(8)
 
 
qo__chr07
 
 
x(8)
 
 
qo__chr08
 
 
x(8)
 
 
qo__chr09
 
 
x(8)
 
 
qo__chr10
 
 
x(8)
 
 
qo__dec01
PST
 
>>>,>>>,>>9.99
10
 
qo__dec02
 
 
>>>,>>>,>>9.99
10
 
qo__dte01
 
 
99/99/99
 
 
qo__dte02
 
 
99/99/99
 
 
qo__log01
 
 
yes/no
 
 
qo__qad01
 
 
-z,zzz,zzz,zz9.99
10
 
qo__qad02
 
 
-z,zzz,zzz,zz9.99
10
 
qo__qad03
Fixed Price
 
-z,zzz,zzz,zz9.99
10
 
qo__qad04
 
 
>
 
 
qo__qad05[2]
 
 
>>9.9<<
10
 
qo_app_owner
Owner Application
 
x(12)
 
 
qo_ar_acct
AR Account
AR
x(8)
 
 
qo_ar_cc
Cost Ctr
CC
x(4)
 
 
qo_ar_sub
AR Sub-Acct
Sub-Acct
x(8)
 
 
qo_bank
Bank
 
x(2)
 
 
qo_bill
Bill-To
 
x(8)
 
 
qo_bol
BOL
 
x(18)
 
 
qo_cartons
Cartons
 
->,>>>,>>9
 
 
qo_channel
Channel
 
x(8)
 
 
qo_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qo_comm_pct[4]
Commission
Comm%
>>9.99%
10
 
qo_confirm
Confirm Date
Confirm
99/99/99
 
 
qo_cr_card
Credit Card
Card
x(2)
 
 
qo_cr_init
Cr Initials
Initials
x(3)
 
 
qo_cr_terms
Credit Terms
Terms
x(8)
 
 
qo_curr
Currency
Curr
x(3)
 
 
qo_cust
Sold-To
 
x(8)
 
 
qo_cycle
Cycle Code
Cy
x(2)
 
 
qo_daybookset
Daybook Set
Dybk Set
x(8)
 
 
qo_disc_pct
Disc %
 
->>9.99%
10
 
qo_div
Division
 
x(8)
 
 
qo_domain
Domain
 
x(8)
 
 
qo_due_date
Due Date
Due
99/99/99
 
 
qo_ent_ex
Exch Rate
 
>>,>>9.99999<<<<<
10
 
qo_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
qo_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
qo_ex_ratetype
Rate Type
 
x(8)
 
 
qo_exp_date
Expires
 
99/99/99
 
 
qo_exru_seq
Sequence
 
>>>>>>>>9
 
 
qo_fix_rate
Fixed Rate
Fixed
yes/no
 
 
qo_flw_date
Follow-up
 
99/99/99
 
 
qo_fob
FOB Point
 
x(20)
 
 
qo_fr_list
Freight List
Frt List
x(8)
 
 
qo_fr_min_wt
Frt Min Wt
 
->>>,>>>,>>9
10
 
qo_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
qo_fst_id
FST ID
 
x(18)
 
 
qo_inv_mthd
Invoicing Method
 
x(1)
 
 
qo_lang
Language
Lang
x(2)
 
 
qo_manual_fr_terms
Manual Fr Terms
 
yes/no
 
 
qo_nbr
Quote
 
x(8)
 
 
qo_ord_date
Quote Date
Quote
99/99/99
 
 
qo_partial
Partial OK
Partial
yes/no
 
 
qo_po
Purchase Order
 
x(20)
 
 
qo_pod
Proof of Delivery
POD
yes/no
 
 
qo_pr_list
Manual
Disc Tbl
x(8)
 
 
qo_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
qo_prepaid
Prepaid Amount
 
-z,zzz,zzz,zz9.99
10
 
qo_priced_dt
Last Price Dt
Last Pri
99/99/99
 
 
qo_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
qo_print_bl
Print Bill of Lading
Print BOL
yes/no
 
 
qo_print_pl
Print Pack List
Print Pack
yes/no
 
 
qo_print_qo
Print Quote
Print QT
yes/no
 
 
qo_project
Project
 
x(8)
 
 
qo_pst
PST
 
yes/no
 
 
qo_pst_id
PST ID
 
x(18)
 
 
qo_pst_pct
PST Pct
 
->9.99<%
10
 
qo_recur
Recurring
Rec
yes/no
 
 
qo_rel_cnt
Release Count
Cnt
>>9
 
 
qo_rel_date
Release Date
Release
99/99/99
 
 
qo_release
Release
Rel
yes/no
 
 
qo_req_date
Required Date
Required
99/99/99
 
 
qo_rev
Revision
Rev
>>9
 
 
qo_rmks
Remarks
 
x(40)
 
 
qo_ship
Ship-To
 
x(8)
 
 
qo_ship_date
Ship Date
 
99/99/99
 
 
qo_shipvia
Ship Via
 
x(20)
 
 
qo_site
Site
 
x(8)
 
 
qo_size
Size
 
->,>>>,>>9.9<<<<<<<<
10
 
qo_size_um
Size UM
UM
x(2)
 
 
qo_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
qo_so_nbr
Last Sales Order
Lst Ordr
x(8)
 
 
qo_source
Order Source
Source
x(8)
 
 
qo_stat
Action Status
St
x(2)
 
 
qo_tax_date
Tax Date
 
99/99/99
 
 
qo_tax_env
Tax Environment
Tax Env
x(16)
 
 
qo_tax_pct[3]
Tax
 
->9.99<%
10
 
qo_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
qo_taxable
Taxable
Tax
yes/no
 
 
qo_taxc
Tax Class
TxC
x(3)
 
 
qo_trl1_amt
Trailer Amt 1
 
-zzzz,zzz,zz9.99
10
 
qo_trl1_cd
Trailer 1
Trl 1
x(4)
 
 
qo_trl2_amt
Trailer 2
 
-zzzz,zzz,zz9.99
10
 
qo_trl2_cd
Trailer 2
Trl 2
x(4)
 
 
qo_trl3_amt
Trailer 3
 
-zzzz,zzz,zz9.99
10
 
qo_trl3_cd
Trailer 3
Trl 3
x(4)
 
 
qo_user1
Ufld1
 
x(8)
 
 
qo_user2
Ufld2
 
x(8)
 
 
qo_userid
User ID
 
x(8)
 
 
qo_weight
Weight
 
->>>,>>>,>>9.9999
10
 
qo_weight_um
Weight UM
UM
x(2)
 
 
qo_xcomm_pct[2]
Commission
Comm%
>>9.99%
10
 
qo_xslspsn[2]
Salesperson
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qo_mstr
yes
oid_qo_mstr
yes
no
 
qo_cust
no
qo_domain
yes
no
 
 
 
qo_cust
yes
no
qo_nbr
yes
qo_domain
yes
no
 
 
 
qo_nbr
yes
no
 
qo_print_qo
no
qo_domain
yes
no
 
 
 
qo_print_qo
yes
no
 
qo_release
no
qo_domain
yes
no
 
 
 
qo_release
yes
no
 
 
 
qo_nbr
yes
no
 
qo_ship
no
qo_domain
yes
no
 
 
 
qo_ship
yes
no
QPostingSaf
Posting SAF Daemon Queue
 
 
Field Name
Label
Col-Label
Format
Dec
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
QPostingLine_ID
Link to QPostingLine
 
-99999999999
 
 
QPostingSaf_ID
Record ID
 
-99999999999
 
 
QPostingSafInputSequence
SAF Input Sequence
 
->,>>>,>>9
 
 
QPostingSafParentType
SAF Parent Type
 
x(20)
 
 
Saf_ID
Link to Saf
 
-99999999999
 
 
SafStructure_ID
Link to SafStructure
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
QPostingSaf_ID
yes
no
 
QPostingLine
no
QPostingLine_ID
yes
no
qps_det
Quality Test Bill Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qps_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qps__chr01
 
 
x(8)
 
 
qps__chr03
 
 
x(8)
 
 
qps__chr04
 
 
x(8)
 
 
qps__chr05
 
 
x(8)
 
 
qps__dec01
 
 
>>>,>>>,>>9.99
10
 
qps__dec02
 
 
>>>,>>>,>>9.99
10
 
qps__dec03
 
 
>>>,>>>,>>9.99
10
 
qps__log01
 
 
yes/no
 
 
qps_domain
Domain
 
x(8)
 
 
qps_op
Operation
Op
>>>>>>
 
 
qps_part
Item Number
Item
x(18)
 
 
qps_qty
Usage Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
qps_routing
Procedure
 
x(18)
 
 
qps_user1
Ufld1
 
x(8)
 
 
qps_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qps_det
yes
oid_qps_det
yes
no
qps_det
yes
qps_domain
yes
no
 
 
 
qps_routing
yes
no
 
 
 
qps_op
yes
no
 
 
 
qps_part
yes
no
qro_det
Quality Inspection Routing Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qro_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qro__chr01
 
 
x(8)
 
 
qro__chr02
 
 
x(8)
 
 
qro__chr03
 
 
x(8)
 
 
qro__chr04
 
 
x(8)
 
 
qro__chr05
 
 
x(8)
 
 
qro__dec01
 
 
>>>,>>>,>>9.99
10
 
qro__dec02
 
 
>>>,>>>,>>9.99
10
 
qro__dte01
 
 
99/99/99
 
 
qro__dte02
 
 
99/99/99
 
 
qro__log01
 
 
yes/no
 
 
qro_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qro_desc
Description
 
x(24)
 
 
qro_domain
Domain
 
x(8)
 
 
qro_mch
Machine
 
x(8)
 
 
qro_mch_op
Machines per Op
Mach/Op
->,>>>,>>9
 
 
qro_op
Operation
Op
>>>>9
 
 
qro_queue
Operation Time
Op Time
>,>>9.9<<
10
 
qro_routing
Procedure
 
x(18)
 
 
qro_tool
Tool Code
Tool
x(8)
 
 
qro_user1
Ufld1
 
x(8)
 
 
qro_user2
Ufld2
 
x(8)
 
 
qro_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qro_det
yes
oid_qro_det
yes
no
qro_routing
yes
qro_domain
yes
no
 
 
 
qro_routing
yes
no
 
 
 
qro_op
yes
no
 
qro_wkctr
no
qro_domain
yes
no
 
 
 
qro_wkctr
yes
no
 
 
 
qro_mch
yes
no
qr_test
Quality Order Test Steps
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qr_test
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qr__chr01
 
 
x(8)
 
 
qr__chr02
 
 
x(8)
 
 
qr__chr03
 
 
x(8)
 
 
qr__chr04
 
 
x(8)
 
 
qr__chr05
 
 
x(8)
 
 
qr__dec01
 
 
>>>,>>>,>>9.99
10
 
qr__dec02
 
 
>>>,>>>,>>9.99
10
 
qr__dte01
 
 
99/99/99
 
 
qr__dte02
 
 
99/99/99
 
 
qr__log01
 
 
yes/no
 
 
qr_act_op
Actual Operation Time
Act Op
->,>>9.9<<
10
 
qr_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
qr_desc
Description
 
x(24)
 
 
qr_domain
Domain
 
x(8)
 
 
qr_due
Due Date
Due
99/99/99
 
 
qr_lot
Batch
 
x(8)
 
 
qr_mch
Machine
 
x(8)
 
 
qr_nbr
Quality Order
 
x(18)
 
 
qr_op
Operation
Op
>>>>>9
 
 
qr_op_time
Operation Time
Op Time
->,>>9.9<<
10
 
qr_part
Item Number
 
x(18)
 
 
qr_qty_accpt
Qty Accepted
 
->,>>>,>>9.9<<<<<<<<
10
 
qr_qty_ord
Qty Pending
 
->,>>>,>>9.9<<<<<<<<
10
 
qr_qty_rjct
Qty Rejected
 
->,>>>,>>9.9<<<<<<<<
10
 
qr_start
Start Date
Start
99/99/99
 
 
qr_status
Status
St
x(1)
 
 
qr_tool
Tool Code
Tool
x(8)
 
 
qr_user1
Ufld1
 
x(8)
 
 
qr_user2
Ufld2
 
x(8)
 
 
qr_wkctr
Work Center
Work Ctr
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qr_test
yes
oid_qr_test
yes
no
 
qr_lot
yes
qr_domain
yes
no
 
 
 
qr_lot
yes
no
 
 
 
qr_op
yes
no
qr_nbrop
yes
qr_domain
yes
no
 
 
 
qr_nbr
yes
no
 
 
 
qr_lot
yes
no
 
 
 
qr_op
yes
no
 
qr_part
no
qr_domain
yes
no
 
 
 
qr_part
yes
no
 
 
 
qr_op
yes
no
qtbl_ext
QAD Table Extension
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_qtbl_ext
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
qtbl_key1
Key Field 1
 
x(24)
 
 
qtbl_key2
Key Field 2
 
x(24)
 
 
qtbl_key3
Key Field 3
 
x(24)
 
 
qtbl_key4
Key Field 4
 
x(24)
 
 
qtbl_key5
Key Field 5
 
x(24)
 
 
qtbl_key6
Key Field 6
 
x(24)
 
 
qtbl_owner
Owner
 
x(8)
 
 
qtbl_qadc01
 
 
x(24)
 
 
qtbl_qadc02
 
 
x(24)
 
 
qtbl_qadc03
 
 
x(24)
 
 
qtbl_qadc04
 
 
x(24)
 
 
qtbl_qadc05
 
 
x(24)
 
 
qtbl_qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
qtbl_qadd02
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
qtbl_qadd03
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
qtbl_qadd04
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
qtbl_qadd05
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
qtbl_qadl01
 
 
yes/no
 
 
qtbl_qadl02
 
 
yes/no
 
 
qtbl_qadt01
 
 
99/99/99
 
 
qtbl_qadt02
 
 
99/99/99
 
 
qtbl_reference
Extension Reference
 
x(20)
 
 
qtbl_table
Table Name
 
x(14)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_qtbl_ext
yes
oid_qtbl_ext
yes
no
qtbl_primary
yes
qtbl_owner
yes
no
 
 
 
qtbl_table
yes
no
 
 
 
qtbl_reference
yes
no
 
 
 
qtbl_key1
yes
no
 
 
 
qtbl_key2
yes
no
 
 
 
qtbl_key3
yes
no
 
 
 
qtbl_key4
yes
no
 
 
 
qtbl_key5
yes
no
 
 
 
qtbl_key6
yes
no
QueryCache
Query Cache
 
 
Field Name
Label
Col-Label
Format
Dec
 
Instance_ID
link to Instance
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
QueryCache_ID
record ID
 
-99999999999
 
 
RecordCount
Record Count
 
>>>>>9
 
 
SearchKey
Search Key
 
x(40)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
prim
yes
QueryCache_ID
yes
no
 
skey
no
SearchKey
yes
no
rbc_ctrl
Retrobill Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rbc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rbc__qadc01
 
 
x(24)
 
 
rbc__qadc02
 
 
x(24)
 
 
rbc_auth_nr_id
Authorization Sequence ID
 
x(8)
 
 
rbc_domain
Domain
 
x(8)
 
 
rbc_memo_breakby
Memo Per
 
X(2)
 
 
rbc_mod_date
Modified Date
Mod Date
99/99/99
 
 
rbc_mod_userid
User ID
 
x(8)
 
 
rbc_pl_req
Price List Required
 
yes/no
 
 
rbc_print_inv_det
Print Retrobill Invoice Detail
 
yes/no
 
 
rbc_user1
User Field Character 1
 
x(24)
 
 
rbc_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rbc_ctrl
yes
oid_rbc_ctrl
yes
no
rbc_domain
yes
rbc_domain
yes
no
rbi_det
Retrobill Invoice Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rbi_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rbi__qadc01
 
 
x(24)
 
 
rbi__qadc02
 
 
x(24)
 
 
rbi_amd_inv_nbr
Retrobill Invoice Number
 
x(22)
 
 
rbi_amd_line
Retrobill Sales Order Line
Line
>>9
 
 
rbi_amd_nbr
Retrobill Sales Order
Order
x(8)
 
 
rbi_amd_seq
Amendment Sequence
 
99999999
 
 
rbi_auth
Authorization Number
 
x(16)
 
 
rbi_cust
Sold-To
 
x(8)
 
 
rbi_domain
Domain
 
x(8)
 
 
rbi_inv_nbr
Invoice
 
x(22)
 
 
rbi_line
Line
Ln
>>9
 
 
rbi_mod_date
Modified Date
Mod Date
99/99/99
 
 
rbi_mod_userid
User ID
 
x(8)
 
 
rbi_nbr
Sales Order
Order
x(8)
 
 
rbi_prev_auth
Previous Authorization Number
 
x(16)
 
 
rbi_prev_price
Previous Price
 
>>>>,>>>,>>9.99<<<
10
 
rbi_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
rbi_user1
User Field Character 1
 
x(24)
 
 
rbi_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rbi_det
yes
oid_rbi_det
yes
no
 
rbi_amd_inv
no
rbi_domain
yes
no
 
 
 
rbi_amd_nbr
yes
no
 
 
 
rbi_amd_inv_nbr
yes
no
 
rbi_amd_seq
no
rbi_domain
yes
no
 
 
 
rbi_inv_nbr
yes
no
 
 
 
rbi_nbr
yes
no
 
 
 
rbi_line
yes
no
 
 
 
rbi_amd_seq
yes
no
rbi_auth
yes
rbi_domain
yes
no
 
 
 
rbi_cust
yes
no
 
 
 
rbi_auth
yes
no
 
 
 
rbi_nbr
yes
no
 
 
 
rbi_line
yes
no
 
 
 
rbi_inv_nbr
yes
no
rbm_mstr
Retrobill Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rbm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rbm__qadc01
 
 
x(8)
 
 
rbm_ar_nbr
A/R Reference
 
x(18)
 
 
rbm_auth
Authorization Number
 
x(16)
 
 
rbm_auto
Auto Generated
Auto
yes/no
 
 
rbm_cmtindx
Comment Index
 
>>>9
 
 
rbm_cust
Sold-To
 
x(8)
 
 
rbm_domain
Domain
 
x(8)
 
 
rbm_eff
Effective
 
99/99/99
 
 
rbm_newprice
New Price
 
>>>>,>>>,>>9.99<<<
10
 
rbm_pr_list
Price List
 
X(8)
 
 
rbm_rsn
Reason Code
 
x(8)
 
 
rbm_status
Status
 
x(8)
 
 
rbm_user1
Ufld1
 
x(8)
 
 
rbm_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rbm_mstr
yes
oid_rbm_mstr
yes
no
rbm_cust
yes
rbm_domain
yes
no
 
 
 
rbm_cust
yes
no
 
 
 
rbm_auth
yes
no
 
rbm_status
no
rbm_domain
yes
no
 
 
 
rbm_auto
yes
no
 
 
 
rbm_status
yes
no
rcc_mstr
Customer Sequence Schedule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rcc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rcc__qadc01
 
 
x(8)
 
 
rcc__qadc02
 
 
x(8)
 
 
rcc__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcc__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcc__qadi01
 
 
->,>>>,>>9
 
 
rcc__qadi02
 
 
->,>>>,>>9
 
 
rcc__qadl01
 
 
yes/no
 
 
rcc__qadl02
 
 
yes/no
 
 
rcc__qadl03
 
 
yes/no
 
 
rcc__qadl04
 
 
yes/no
 
 
rcc__qadt01
 
 
99/99/99
 
 
rcc__qadt02
 
 
99/99/99
 
 
rcc_addr
Ship-To
 
x(8)
 
 
rcc_asn_edi
Send Sequence with ASN
ASN!Send
yes/no
 
 
rcc_check_seq_tol
Check Sequence Tolerance
Check!Tol
yes/no
 
 
rcc_domain
Domain
 
x(8)
 
 
rcc_firm_seq_days
Firm Days
Firm!Days
>>9
 
 
rcc_inc_in_rss
Include Seq in Req Ship Sched
RSS
yes/no
 
 
rcc_invoice_edi
Send Sequence with Invoice
Inv!Send
yes/no
 
 
rcc_invoice_print
Print Sequence on Invoice
Inv!Print
yes/no
 
 
rcc_max_tol
Maximum Tolerance
Max!Tol
>>>>9
 
 
rcc_merge_seq
Merge Schedules
Merge
yes/no
 
 
rcc_mod_date
Modified Date
Mod Date
99/99/99
 
 
rcc_mod_pgm
Last Program
 
x(8)
 
 
rcc_mod_userid
User ID
 
x(8)
 
 
rcc_packing_order
Packing Order
Pack!Order
forward/reverse
 
 
rcc_seq_per_container
Sequences Per Container
Seq Per!Cont
>>>>>>>9
 
 
rcc_shipper_print
Print Sequence on Shipper
Ship!Print
yes/no
 
 
rcc_user1
Ufld1
 
x(8)
 
 
rcc_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rcc_mstr
yes
oid_rcc_mstr
yes
no
rcc_index1
yes
rcc_domain
yes
no
 
 
 
rcc_addr
yes
no
rcf_ctrl
Customer Sequence Schedule Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rcf_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rcf__qadc01
 
 
x(8)
 
 
rcf__qadc02
 
 
x(8)
 
 
rcf__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcf__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcf__qadi01
 
 
->,>>>,>>9
 
 
rcf__qadi02
 
 
->,>>>,>>9
 
 
rcf__qadi03
 
 
->>>>>>>9
 
 
rcf__qadl01
 
 
yes/no
 
 
rcf__qadl02
 
 
yes/no
 
 
rcf__qadl03
 
 
yes/no
 
 
rcf__qadl04
 
 
yes/no
 
 
rcf__qadt01
 
 
99/99/99
 
 
rcf__qadt02
 
 
99/99/99
 
 
rcf_active
Enable Sequence Schedules
 
yes/no
 
 
rcf_asn_edi
Send Sequence with ASN
 
yes/no
 
 
rcf_check_seq_tol
Check Sequence Tolerance
 
yes/no
 
 
rcf_domain
Domain
 
x(8)
 
 
rcf_firm_seq_days
Firm Days
 
>>9
 
 
rcf_inc_in_rss
Include Seq in Req Ship Sched
 
yes/no
 
 
rcf_invoice_edi
Send Sequence with Invoice
 
yes/no
 
 
rcf_invoice_print
Print Sequence on Invoice
 
yes/no
 
 
rcf_max_tol
Maximum Tolerance
 
>>>>9
 
 
rcf_merge_seq
Merge Schedules
 
yes/no
 
 
rcf_mod_date
Modified Date
Mod Date
99/99/99
 
 
rcf_mod_pgm
Last Program
 
x(8)
 
 
rcf_mod_userid
User ID
 
x(8)
 
 
rcf_packing_order
Packing Order
 
forward/reverse
 
 
rcf_sch_default
Schedule Order Default
 
yes/no
 
 
rcf_seq_per_container
Sequences Per Container
 
>>>>>>>9
 
 
rcf_shipper_print
Print Sequence on Shipper
 
yes/no
 
 
rcf_user1
Ufld1
 
x(8)
 
 
rcf_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rcf_ctrl
yes
oid_rcf_ctrl
yes
no
rcf_index1
yes
rcf_domain
yes
no
rcsd_det
Customer Sequence Schedule Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rcsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rcsd__qadc01
 
 
x(8)
 
 
rcsd__qadc02
 
 
x(8)
 
 
rcsd__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcsd__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcsd__qadi01
 
 
->,>>>,>>9
 
 
rcsd__qadi02
 
 
->,>>>,>>9
 
 
rcsd__qadl01
 
 
yes/no
 
 
rcsd__qadl02
 
 
yes/no
 
 
rcsd__qadt01
 
 
99/99/99
 
 
rcsd__qadt02
 
 
99/99/99
 
 
rcsd_cum_qty
Cum Quantity
 
>>,>>>,>>9.9<<<<<<<<<
10
 
rcsd_cust_build_date
Customer Build Date
 
99/99/99
 
 
rcsd_cust_job
Customer Job
 
x(30)
 
 
rcsd_cust_part
Customer Item
 
x(30)
 
 
rcsd_cust_po
PO Number
 
x(22)
 
 
rcsd_cust_ref
Customer Reference
 
x(30)
 
 
rcsd_cust_seq
Customer Sequence
 
x(30)
 
 
rcsd_custref
Customer Ref
 
x(30)
 
 
rcsd_date
Date
 
99/99/99
 
 
rcsd_deleted
Deleted
 
yes/no
 
 
rcsd_derived_rlse_id
Derived Release ID
 
x(30)
 
 
rcsd_discr_qty
Quantity
 
>>,>>>,>>9.9<<<<<<<<<
10
 
rcsd_dock
Customer Dock
 
x(30)
 
 
rcsd_domain
Domain
 
x(8)
 
 
rcsd_line
Line
 
>>9
 
 
rcsd_line_feed
Line Feed
 
x(30)
 
 
rcsd_mod_date
Modified Date
Mod Date
99/99/99
 
 
rcsd_mod_pgm
Last Program
 
x(8)
 
 
rcsd_mod_userid
User ID
 
x(8)
 
 
rcsd_modelyr
Model Year
 
x(4)
 
 
rcsd_order
Order
 
x(8)
 
 
rcsd_part
Item Number
 
x(18)
 
 
rcsd_picked
Picked
 
yes/no
 
 
rcsd_rlse_id
Release ID
 
x(30)
 
 
rcsd_shipfrom
Ship-From
 
x(8)
 
 
rcsd_shipto
Ship-To
 
x(8)
 
 
rcsd_status
Status
 
x(8)
 
 
rcsd_time
Time
 
99:99
 
 
rcsd_user1
Ufld1
 
x(8)
 
 
rcsd_user2
Ufld2
 
x(8)
 
 
rcsd_x_referenced
Cross Referenced
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rcsd_det
yes
oid_rcsd_det
yes
no
rcsd_index1
yes
rcsd_domain
yes
no
 
 
 
rcsd_shipfrom
yes
no
 
 
 
rcsd_shipto
yes
no
 
 
 
rcsd_rlse_id
yes
no
 
 
 
rcsd_cust_job
yes
no
 
 
 
rcsd_cust_seq
yes
no
 
 
 
rcsd_part
yes
no
 
 
 
rcsd_date
yes
no
 
 
 
rcsd_time
yes
no
 
 
 
rcsd_cust_ref
yes
no
 
 
 
rcsd_dock
yes
no
 
 
 
rcsd_line_feed
yes
no
 
rcsd_index2
no
rcsd_domain
yes
no
 
 
 
rcsd_shipfrom
yes
no
 
 
 
rcsd_shipto
yes
no
 
 
 
rcsd_rlse_id
yes
no
 
 
 
rcsd_date
yes
no
 
 
 
rcsd_time
yes
no
 
 
 
rcsd_cust_job
yes
no
 
 
 
rcsd_cust_seq
yes
no
 
 
 
rcsd_part
yes
no
 
rcsd_index3
no
rcsd_domain
yes
no
 
 
 
rcsd_order
yes
no
 
 
 
rcsd_line
yes
no
 
 
 
rcsd_rlse_id
yes
no
 
 
 
rcsd_part
yes
no
 
 
 
rcsd_date
yes
no
 
 
 
rcsd_time
yes
no
 
rcsd_index4
no
rcsd_domain
yes
no
 
 
 
rcsd_shipfrom
yes
no
 
 
 
rcsd_shipto
yes
no
 
 
 
rcsd_rlse_id
yes
no
 
 
 
rcsd_picked
yes
no
 
 
 
rcsd_x_referenced
yes
no
 
 
 
rcsd_date
yes
no
 
 
 
rcsd_time
yes
no
 
 
 
rcsd_dock
yes
no
 
 
 
rcsd_line_feed
yes
no
 
 
 
rcsd_cust_job
yes
no
 
 
 
rcsd_cust_seq
yes
no
 
 
 
rcsd_part
yes
no
 
rcsd_index5
no
rcsd_domain
yes
no
 
 
 
rcsd_shipfrom
yes
no
 
 
 
rcsd_shipto
yes
no
 
 
 
rcsd_rlse_id
yes
no
 
 
 
rcsd_part
yes
no
 
 
 
rcsd_cust_ref
yes
no
 
 
 
rcsd_dock
yes
no
 
 
 
rcsd_line_feed
yes
no
rcsx_ref
Customer Sequence Schedule Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rcsx_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rcsx__qadc01
 
 
x(8)
 
 
rcsx__qadc02
 
 
x(8)
 
 
rcsx__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcsx__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcsx__qadi01
 
 
->,>>>,>>9
 
 
rcsx__qadi02
 
 
->,>>>,>>9
 
 
rcsx__qadl01
 
 
yes/no
 
 
rcsx__qadl02
 
 
yes/no
 
 
rcsx__qadt01
 
 
99/99/99
 
 
rcsx__qadt02
 
 
99/99/99
 
 
rcsx_cust_job
Customer Job
 
x(30)
 
 
rcsx_cust_ref
Customer Reference
 
x(30)
 
 
rcsx_cust_seq
Customer Sequence
 
x(30)
 
 
rcsx_date
Date
 
99/99/99
 
 
rcsx_dock
Customer Dock
 
x(30)
 
 
rcsx_domain
Domain
 
x(8)
 
 
rcsx_line_feed
Line Feed
 
x(30)
 
 
rcsx_mod_date
Modified Date
Mod Date
99/99/99
 
 
rcsx_mod_pgm
Last Program
 
x(8)
 
 
rcsx_mod_userid
User ID
 
x(8)
 
 
rcsx_part
Item Number
 
x(18)
 
 
rcsx_picked
Picked
 
yes/no
 
 
rcsx_rlse_id
Release ID
 
x(30)
 
 
rcsx_shipfrom
Ship-From
 
x(8)
 
 
rcsx_shipped
Shipped
 
yes/no
 
 
rcsx_shipped_cust_job
Shipped Job
 
x(30)
 
 
rcsx_shipped_cust_ref
Shipped Reference
 
x(30)
 
 
rcsx_shipped_cust_seq
Shipped Sequence
 
x(30)
 
 
rcsx_shipped_date
Scheduled Date
 
99/99/99
 
 
rcsx_shipped_dock
Shipped Dock
 
x(30)
 
 
rcsx_shipped_line_feed
Shipped Line Feed
 
x(30)
 
 
rcsx_shipped_part
Shipped Item Number
 
x(18)
 
 
rcsx_shipped_rlse_id
Shipped Release ID
 
x(30)
 
 
rcsx_shipped_time
Scheduled Time
 
99:99
 
 
rcsx_shipto
Ship-To
 
x(8)
 
 
rcsx_time
Time
 
99:99
 
 
rcsx_user1
Ufld1
 
x(8)
 
 
rcsx_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rcsx_ref
yes
oid_rcsx_ref
yes
no
rcsx_index1
yes
rcsx_domain
yes
no
 
 
 
rcsx_shipfrom
yes
no
 
 
 
rcsx_shipto
yes
no
 
 
 
rcsx_shipped_rlse_id
yes
no
 
 
 
rcsx_shipped_cust_job
yes
no
 
 
 
rcsx_shipped_cust_seq
yes
no
 
 
 
rcsx_shipped_part
yes
no
 
 
 
rcsx_shipped_date
yes
no
 
 
 
rcsx_shipped_time
yes
no
 
 
 
rcsx_shipped_cust_ref
yes
no
 
 
 
rcsx_shipped_dock
yes
no
 
 
 
rcsx_shipped_line_feed
yes
no
 
rcsx_index2
no
rcsx_domain
yes
no
 
 
 
rcsx_shipfrom
yes
no
 
 
 
rcsx_shipto
yes
no
 
 
 
rcsx_rlse_id
yes
no
 
 
 
rcsx_cust_job
yes
no
 
 
 
rcsx_cust_seq
yes
no
 
 
 
rcsx_part
yes
no
 
 
 
rcsx_date
yes
no
 
 
 
rcsx_time
yes
no
 
 
 
rcsx_cust_ref
yes
no
 
 
 
rcsx_dock
yes
no
 
 
 
rcsx_line_feed
yes
no
rcs_mstr
Customer Schedule Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_rcs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
rcs__qadc01
 
 
x(8)
 
 
rcs__qadc02
 
 
x(8)
 
 
rcs__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcs__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
rcs__qadi01
 
 
->,>>>,>>9
 
 
rcs__qadi02
 
 
->,>>>,>>9
 
 
rcs__qadl01
 
 
yes/no
 
 
rcs__qadl02
 
 
yes/no
 
 
rcs__qadt01
 
 
99/99/99
 
 
rcs__qadt02
 
 
99/99/99
 
 
rcs_active
Active
 
yes/no
 
 
rcs_active_date
Active Date
Active!Date
99/99/99
 
 
rcs_active_end
Active End
 
99/99/99
 
 
rcs_active_start
Active Start
 
99/99/99
 
 
rcs_check_seq_tol
Check Sequence Tolerance
Check!Tol
yes/no
 
 
rcs_cr_date
Create Date
Create!Date
99/99/99
 
 
rcs_cr_time
Create Time
Create!Time
x(5)
 
 
rcs_cumulative
Cumulative
 
yes/no
 
 
rcs_date_type
Schedule Date Type
Schedule!Date!Type
Ship/Delivery
 
 
rcs_domain
Domain
 
x(8)
 
 
rcs_max_tol
Maximum Tolerance
Max!Tol
>>>>9
 
 
rcs_mod_date
Modified Date
Mod Date
99/99/99
 
 
rcs_mod_pgm
Last Program
 
x(8)
 
 
rcs_mod_userid
User ID
 
x(8)
 
 
rcs_packing_order
Packing Order
Packing!Order
forward/reverse
 
 
rcs_rlse_id
Release ID
 
x(30)
 
 
rcs_seq_per_container
Sequences Per Container
 
>>>>>>>9
 
 
rcs_shipfrom
Ship-From
 
x(8)
 
 
rcs_shipto
Ship-To
 
x(8)
 
 
rcs_user1
Ufld1
 
x(8)
 
 
rcs_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_rcs_mstr
yes
oid_rcs_mstr
yes
no
rcs_index1
yes
rcs_domain
yes
no
 
 
 
rcs_shipfrom
yes
no
 
 
 
rcs_shipto
yes
no
 
 
 
rcs_rlse_id
yes
no
 
rcs_index2
no
rcs_domain
yes
no
 
 
 
rcs_shipfrom
yes
no
 
 
 
rcs_shipto
yes
no
 
 
 
rcs_active_date
yes
no
 
rcs_index3
no
rcs_domain
yes
no
 
 
 
rcs_shipfrom
yes
no
 
 
 
rcs_shipto
yes
no
 
 
 
rcs_active
yes
no