QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
sod_det
Sales Order Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sod__chr01
 
 
x(8)
 
 
sod__chr02
 
 
x(8)
 
 
sod__chr03
 
 
x(8)
 
 
sod__chr04
 
 
x(8)
 
 
sod__chr05
 
 
x(8)
 
 
sod__chr06
 
 
x(8)
 
 
sod__chr07
 
 
x(8)
 
 
sod__chr08
 
 
x(8)
 
 
sod__chr09
 
 
x(8)
 
 
sod__chr10
 
 
x(8)
 
 
sod__dec01
 
 
>>>,>>>,>>9.99
10
 
sod__dec02
 
 
>>>,>>>,>>9.99
10
 
sod__dte01
 
 
99/99/99
 
 
sod__dte02
 
 
99/99/99
 
 
sod__log01
 
 
yes/no
 
 
sod__qad01
 
 
->>>>,>>>,>>9
 
 
sod__qad02
 
 
yes/no
 
 
sod__qadc01
QAD Field
 
X(8)
0
 
sod__qadc02
QAD Field
 
X(8)
0
 
sod__qadc03
QAD Field
 
X(8)
0
 
sod__qadc04
QAD Field
 
X(8)
0
 
sod__qadd01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
sod__qadd02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
sod__qadd03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
sod__qadd04
 
 
->,>>>,>>9.9<<<<<<<<
10
 
sod__qadi01
QAD Field
 
->,>>>,>>9
 
 
sod__qadi02
QAD Field
 
->,>>>,>>9
 
 
sod__qadl01
QAD Field
 
yes/no
 
 
sod__qadl02
QAD Field
 
yes/no
 
 
sod__qadl03
QAD Field
 
yes/no
 
 
sod__qadt01
QAD Field
 
99/99/99
 
 
sod__qadt02
QAD Field
 
99/99/99
 
 
sod__qadt03
QAD Field
 
99/99/99
 
 
sod__qadt04
QAD Field
 
99/99/99
 
 
sod_abnormal
Abnormal Demand
Abnormal
yes/no
 
 
sod_acct
Sales Acct
Sales
x(8)
 
 
sod_act_price
Total List Price
 
->>>>,>>>,>>9.99<<<
10
 
sod_alt_pkg
Alternates
 
yes/no
 
 
sod_auto_ins
Installation Call
 
yes/no
 
 
sod_auto_replenish
Auto Replenish
Auto!Replenish
yes/no
 
 
sod_bo_chg
Qty Backord
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_bonus
Bonus Stock Line
 
yes/no
 
 
sod_btb_po
EMT PO Nbr
EMT PO
x(8)
 
 
sod_btb_pod_line
EMT PO Line
EMT PO Ln
>>9
 
 
sod_btb_type
EMT Type
 
xx
 
 
sod_btb_vend
EMT Supplier
EMT Supp
x(8)
 
 
sod_ca_line
Call Line
 
>>9
 
 
sod_ca_nbr
Call
 
x(8)
 
 
sod_calc_isb
Calculate Isb
 
yes/no
 
 
sod_car_load
Call Act. Rec. Load
 
yes/no
 
 
sod_cc
Cost Ctr
CC
x(4)
 
 
sod_cfg_type
Configuration
Config
x(1)
 
 
sod_charge_type
Charge Type
Charge!Type
x(8)
 
 
sod_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
sod_comm_pct[4]
Commission
Comm%
>>9.99%
10
 
sod_comment[5]
Comments
 
x(40)
 
 
sod_compl_date
Status Date
Stat Date
99/99/99
 
 
sod_compl_stat
Complete Status
Status
x(8)
 
 
sod_config_id
Configuration ID
 
x(8)
 
 
sod_confirm
Confirmed
 
yes/no
 
 
sod_conrep
Netting Logic
C/R
x(1)
 
 
sod_consign_loc
Consignment Location
Consignment!Location
x(8)
 
 
sod_consignment
Consignment
 
yes/no
 
 
sod_consume
Consume Forecast
Consume Fcst
yes/no
 
 
sod_contr_id
PO Number
 
x(30)
 
 
sod_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
sod_crt_int
Credit Terms Int
CRT Int
->>>9.99
10
 
sod_cum_date[4]
Cum Start
 
99/99/99
 
 
sod_cum_qty[4]
Cum Shipped
 
->>>>,>>>,>>9.9<<<<<<<<
10
 
sod_cum_time[4]
Time
 
>>,>>>,>>9
 
 
sod_curr_rlse_id[3]
Active Rlse ID
 
x(30)
 
 
sod_custpart
Customer Item
 
x(30)
 
 
sod_custref
Customer Ref
 
x(30)
 
 
sod_desc
Description
 
x(24)
 
 
sod_dir_all
Allocated Direct
Alloc Dir
yes/no
 
 
sod_disc_pct
Disc %
 
->>9.99%
10
 
sod_div
Division
 
x(8)
 
 
sod_dock
Dock
 
x(8)
 
 
sod_domain
Domain
 
x(8)
 
 
sod_drp_ref
DRP Ref
 
x(8)
 
 
sod_dsc_acct
Disc Acct
 
x(8)
 
 
sod_dsc_cc
Disc CC
CC
x(4)
 
 
sod_dsc_project
Disc Project
 
x(8)
 
 
sod_dsc_sub
Disc Sub-Acct
Sub-Acct
x(8)
 
 
sod_due_date
Due Date
Due
99/99/99
 
 
sod_end_eff[4]
End Effective
 
99/99/99
 
 
sod_enduser
End User
 
x(8)
 
 
sod_exp_del
Exp Delivery Date
Exp Date
99/99/99
 
 
sod_expire
Expires
 
99/99/99
 
 
sod_fa_nbr
FAS W/O
Final Assembly W/O
x(18)
 
 
sod_fab_days
Fab Auth Days
 
>,>>9
 
 
sod_fix_pr
Fixed Price
Fix
yes/no
 
 
sod_fixed_price
Fixed Price
 
>>>>,>>>,>>9.99<<<
10
 
sod_for
For
 
x(18)
 
 
sod_for_serial
Parent Item Serial
 
X(18)
 
 
sod_fr_chg
Unit Freight Charge
 
->>>,>>>,>>9.99
10
 
sod_fr_class
Freight Class
 
x(8)
 
 
sod_fr_list
Freight List
Frt List
x(8)
 
 
sod_fr_rate
Freight Rate
 
>>>,>>>,>>9.99<<
10
 
sod_fr_wt
Unit Ship Weight
 
->,>>>,>>9.<<<<<<
10
 
sod_fr_wt_um
UM
 
x(2)
 
 
sod_fsm_type
FSM Type
 
x(8)
 
 
sod_fsrev_acct
Revenue Acct
Revenue Acct
x(8)
 
 
sod_fsrev_cc
Revenue CC
CC
x(4)
 
 
sod_fsrev_sub
Revenue Sub-Acct
Sub-Acct
x(8)
 
 
sod_fst_list
FST on List
 
yes/no
 
 
sod_hold_stat
Hold Status
 
x(8)
 
 
sod_intrans_loc
In-Transit Location
In-Transit!Location
x(8)
 
 
sod_inv_cost
Invoice Cost
 
->>>,>>>,>>9.99<<<
10
 
sod_inv_nbr
Invoice
 
x(22)
 
 
sod_isb_loc
Installed Base Location
 
x(22)
 
 
sod_isb_ref
ISB Ref
 
>>>>>>>9
 
 
sod_line
Line
Ln
>>9
 
 
sod_list_pr
List Price
 
>>>>,>>>,>>9.99<<<
10
 
sod_ln_ref
Line Ref
 
x(8)
 
 
sod_loc
Location
 
x(8)
 
 
sod_lot
ID
 
x(8)
 
 
sod_manual_fr_list
Manual Fr List
 
yes/no
 
 
sod_max_aging_days
Maximum Aging Days
Maximum!Aging Days
>>9
 
 
sod_mod_date
Modified Date
Mod Date
99/99/99
 
 
sod_mod_userid
User ID
 
X(8)
 
 
sod_modelyr
Model Year
 
x(4)
 
 
sod_nbr
Sales Order
Order
x(8)
 
 
sod_ord_mult
Std Pack Qty
Mult
>>,>>>,>>9
0
 
sod_order_category
Category
 
x(8)
 
 
sod_out_po
Display PO Number
 
x(30)
 
 
sod_override_lmt
Override Limits
Lmt
yes/no
 
 
sod_owner
Ownership
 
x(8)
 
 
sod_part
Item Number
 
x(18)
 
 
sod_partial
Partial OK
Partial
yes/no
 
 
sod_pastdue
Past Due Logic
C/R
x(1)
 
 
sod_per_date
Perform
 
99/99/99
 
 
sod_pickdate
Pick Date
 
99/99/99
 
 
sod_pkg_code
Pkg Code
 
x(18)
 
 
sod_pl_priority
P/L Priority
 
>9
 
 
sod_pr_list
Price List
List
x(8)
 
 
sod_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
sod_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
sod_prig1
Pricing Group 1
 
x(8)
 
 
sod_prig2
Pricing Group 2
 
x(8)
 
 
sod_prodline
Product Line
Line
x(4)
 
 
sod_project
Project
 
x(8)
 
 
sod_promise_date
Promise Date
Promise
99/99/99
 
 
sod_pst
PST Taxable
 
yes/no
 
 
sod_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_chg
Qty To Ship
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_cons
Qty Consumed
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_exch
Qty Exchanged
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_inv
Qty to Invoice
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_item
Item Quantity
Item Qty
->>,>>9.9<<<<
10
 
sod_qty_ivcd
Quantity Invoiced
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_pend
Qty Pending
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_per
Duration
 
->>>9.9<<<
10
 
sod_qty_pick
Qty Picked
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_qote
Qty Quoted
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_ret
Qty Returned
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_qty_ship
Qty Shipped
 
->,>>>,>>9.9<<<<<<<<
10
 
sod_raw_days
Raw Auth Days
 
>,>>9
 
 
sod_rbkt_days
Req Schedule Days
 
>>9
 
 
sod_rbkt_mths
Req Schedule Months
 
>>9
 
 
sod_rbkt_weeks
Req Schedule Weeks
 
>>9
 
 
sod_ref
Ref
 
>>>>>>>9
 
 
sod_req_date
Required Date
Required
99/99/99
 
 
sod_req_time
Required Time
 
99:99
 
 
sod_rlse_nbr
Next Release ID
 
99999999
 
 
sod_rma_type
RMA Type
 
x(1)
 
 
sod_sa_nbr
Service Contract
 
x(8)
 
 
sod_sad_line
Contract Line
 
>>>>>>>9
 
 
sod_sch_data
Schedule Data
 
x(8)
 
 
sod_sch_mrp
Sched MRP Req
 
yes/no
 
 
sod_sched
Scheduled
 
yes/no
 
 
sod_sched_chgd
Schedule Changed
 
yes/no
 
 
sod_serial
Lot/Serial
 
x(18)
 
 
sod_ship
Ship-To
 
x(8)
 
 
sod_ship_part
End Customer Shipping Item
 
x(30)
 
 
sod_shipvia
Ship Via
 
x(20)
 
 
sod_site
Site
 
x(8)
 
 
sod_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
sod_sob_rev
Revised Date
Revised
99/99/99
 
 
sod_sob_std
Standard Bill
Std BOM
yes/no
 
 
sod_start_eff[4]
Start Effective
 
99/99/99
 
 
sod_status
Status
 
x(8)
 
 
sod_std_cost
Cost
 
->>>,>>>,>>9.99<<<
10
 
sod_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
sod_sv_code
Warranty Code
 
X(8)
 
 
sod_tax_env
Tax Environment
Tax Env
x(16)
 
 
sod_tax_in
Tax In
 
yes/no
 
 
sod_tax_max
Max Taxable Amount
Max Amount
->>>,>>>,>>9.99
10
 
sod_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
sod_taxable
Taxable
Tax
yes/no
 
 
sod_taxc
Tax Class
TxC
x(3)
 
 
sod_to_loc
Location
 
x(8)
 
 
sod_to_ref
Kit Ref
 
x(8)
 
 
sod_to_site
Site
 
x(8)
 
 
sod_trade_sale_po
Trade Sales PO
TS PO
x(8)
 
 
sod_trade_sale_po_line
Trade Sales PO Line Number
Line
>>9
 
 
sod_trade_sale_vend
Trade Sales Supplier
TS Supplier
x(8)
 
 
sod_translt_days
Transport Days
 
>>9.99
10
 
sod_translt_hrs
Transport Hours
 
>>9.99
10
 
sod_type
Ship Type
T
x(1)
 
 
sod_um
UM
 
x(2)
 
 
sod_um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
sod_unadjust_cum_qty
Shipped quantity
 
>,>>>,>>>,>>9.9<<<<<<<<
10
 
sod_upd_isb
Update Installed Base
 
yes/no
 
 
sod_user1
Ufld1
 
x(8)
 
 
sod_user2
Ufld2
 
x(8)
 
 
sod_warr_start
Warranty Start Date
 
99/99/99
 
 
sod_xcomm_pct[2]
Commission
Comm%
>>9.99%
10
 
sod_xslspsn[3]
Salesperson
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sod_det
yes
oid_sod_det
yes
no
 
sod_call
no
sod_domain
yes
no
 
 
 
sod_ca_nbr
yes
no
 
 
 
sod_ca_line
yes
no
 
 
 
sod_part
yes
no
 
 
 
sod_serial
yes
no
 
sod_fr_list
no
sod_domain
yes
no
 
 
 
sod_nbr
yes
no
 
 
 
sod_fr_list
yes
no
 
sod_fsm_type
no
sod_domain
yes
no
 
 
 
sod_fsm_type
yes
no
 
 
 
sod_nbr
yes
no
 
 
 
sod_line
yes
no
sod_nbrln
yes
sod_domain
yes
no
 
 
 
sod_nbr
yes
no
 
 
 
sod_line
yes
no
 
sod_part
yes
sod_domain
yes
no
 
 
 
sod_part
yes
no
 
 
 
sod_nbr
yes
no
 
 
 
sod_line
yes
no
sop_det
Cost Simulation Operation Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sop_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sop__qadc01
 
 
x(8)
 
 
sop_batch
Batch Qty
Batch!Qty
>,>>>,>>9.9<<<<<<<<
10
 
sop_cost
Cost
 
>>>>,>>>,>>9.99<<<
10
 
sop_domain
Domain
 
x(8)
 
 
sop_element
Cost Element
Element
x(8)
 
 
sop_elm_bdn
Burden Element
Bdn Elmt
x(8)
 
 
sop_elm_lbr
Labor Element
Lbr Elmt
x(8)
 
 
sop_elm_sub
Subcontract Element
Sub Elmt
x(8)
 
 
sop_end
End Date
End
99/99/99
 
 
sop_inv_value
Inventory Value
 
>>>>,>>>,>>9.99<<<
10
 
sop_mch_op
Machines per Op
Mach / Op
->,>>>,>>9
 
 
sop_men_mch
Run Crew
 
->>,>>9.99
10
 
sop_milestone
Milestone Operation
Milestone
yes/no
 
 
sop_op
Operation
 
>>>>9
 
 
sop_routing
Routing Code
 
x(18)
 
 
sop_run
Run Time
Run
>>>,>>>,>>9.9<<<<<<<<
10
 
sop_setup
Setup Time
Setup
>,>>9.9<<
10
 
sop_setup_men
Setup Crew
 
->>,>>9.99
10
 
sop_sim
Cost Set
 
x(18)
 
 
sop_start
Start Date
Start
99/99/99
 
 
sop_std_batch
Standard Batch Size
Batch
>>>,>>9.9
10
 
sop_sub_cost
Subcontract Cost
Subcontract
>>>>,>>>,>>9.99<<<
10
 
sop_user1
Ufld1
 
x(8)
 
 
sop_user2
Ufld2
 
x(8)
 
 
sop_wkctr
Work Center
Work Ctr
x(8)
 
 
sop_yield_pct
Yield%
 
>>9.99%
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sop_det
yes
oid_sop_det
yes
no
 
sop_sim_elem
yes
sop_domain
yes
no
 
 
 
sop_sim
yes
no
 
 
 
sop_element
yes
no
 
 
 
sop_routing
yes
no
 
 
 
sop_op
yes
no
sop_sim_part
yes
sop_domain
yes
no
 
 
 
sop_sim
yes
no
 
 
 
sop_routing
yes
no
 
 
 
sop_op
yes
no
 
 
 
sop_element
yes
no
sor_mstr
Sales Order Relationship Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sor_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sor__qadc01
 
 
x(8)
 
 
sor__qadc02
 
 
x(8)
 
 
sor__qadc03
 
 
x(8)
 
 
sor__qadd01
 
 
->>>>,>>>,>>9.9
10
 
sor__qadd02
 
 
->>>>,>>>,>>9.9
10
 
sor__qadi01
 
 
->,>>>,>>9
 
 
sor__qadi02
 
 
->,>>>,>>9
 
 
sor__qadl01
 
 
yes/no
 
 
sor__qadl02
 
 
yes/no
 
 
sor__qadt01
 
 
99/99/99
 
 
sor__qadt02
 
 
99/99/99
 
 
sor_div
Division
 
X(8)
 
 
sor_domain
Domain
 
x(8)
 
 
sor_group
Group
 
X(8)
 
 
sor_nbr
Sales Order
 
X(8)
 
 
sor_pricing
Pricing
 
>9
 
 
sor_seq
Sequence
 
>>9
 
 
sor_type
Type
 
>>>9
 
 
sor_user1
Ufld1
 
x(8)
 
 
sor_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sor_mstr
yes
oid_sor_mstr
yes
no
sor_nbr_seq
yes
sor_domain
yes
no
 
 
 
sor_nbr
yes
no
 
 
 
sor_seq
yes
no
 
sor_type
no
sor_domain
yes
no
 
 
 
sor_type
yes
no
sosrd_det
Sales Order Shipment Reason Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sosrd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sosrd__qadc01
 
 
X(24)
 
 
sosrd__qadc02
 
 
X(24)
 
 
sosrd_abs_id
Shipper
 
x(20)
 
 
sosrd_dataset
Dataset
 
x(12)
 
 
sosrd_domain
Domain
 
x(8)
 
 
sosrd_line
Line
 
>>9
 
 
sosrd_measurement_type
Type
 
>
 
 
sosrd_mod_date
Modified Date
Mod Date
99/99/99
 
 
sosrd_mod_userid
User ID
 
X(8)
 
 
sosrd_nbr
Order
 
x(8)
 
 
sosrd_rsn_code
Reason Code
 
x(8)
 
 
sosrd_shipfrom
Ship-from
 
x(8)
 
 
sosrd_user1
User Field Character 1
 
X(24)
 
 
sosrd_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sosrd_det
yes
oid_sosrd_det
yes
no
sosrd_nbr
yes
sosrd_domain
yes
no
 
 
 
sosrd_nbr
yes
no
 
 
 
sosrd_line
yes
no
 
 
 
sosrd_shipfrom
yes
no
 
 
 
sosrd_abs_id
yes
no
 
 
 
sosrd_measurement_type
yes
no
 
 
 
sosrd_dataset
yes
no
sosr_mstr
Sales Order Shipment Reason Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sosr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sosr__qadc01
 
 
X(24)
 
 
sosr__qadc02
 
 
X(24)
 
 
sosr_abs_id
Shipper
 
x(20)
 
 
sosr_cmtindx
Comment
 
>>>>>>>9
 
 
sosr_domain
Domain
 
x(8)
 
 
sosr_line
Line
 
>>9
 
 
sosr_mod_date
Modified Date
Mod Date
99/99/99
 
 
sosr_mod_userid
User ID
 
X(8)
 
 
sosr_nbr
Order
 
x(8)
 
 
sosr_shipfrom
Ship-From
 
x(8)
 
 
sosr_user1
User Field Character 1
 
X(24)
 
 
sosr_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sosr_mstr
yes
oid_sosr_mstr
yes
no
sosr_order
yes
sosr_domain
yes
no
 
 
 
sosr_nbr
yes
no
 
 
 
sosr_line
yes
no
 
 
 
sosr_shipfrom
yes
no
 
 
 
sosr_abs_id
yes
no
so_mstr
Sales Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_so_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
so__chr01
 
 
x(8)
 
 
so__chr02
 
 
x(8)
 
 
so__chr03
 
 
x(8)
 
 
so__chr04
 
 
x(8)
 
 
so__chr05
 
 
x(8)
 
 
so__chr06
 
 
x(8)
 
 
so__chr07
 
 
x(8)
 
 
so__chr08
 
 
x(8)
 
 
so__chr09
 
 
x(8)
 
 
so__chr10
 
 
x(8)
 
 
so__dec01
 
 
>>>,>>>,>>9.99
10
 
so__dec02
 
 
>>>,>>>,>>9.99
10
 
so__dte01
 
 
99/99/99
 
 
so__dte02
 
 
99/99/99
 
 
so__log01
 
 
yes/no
 
 
so__qad01
 
 
-z,zzz,zzz,zz9.99
10
 
so__qad02
 
 
-z,zzz,zzz,zz9.99
10
 
so__qad03
 
 
-z,zzz,zzz,zz9.99
10
 
so__qad04
 
 
>
 
 
so__qad05[2]
 
 
>>9.9<<
10
 
so__qadc01
QAD Field
 
X(8)
0
 
so__qadc02
QAD Field
 
X(8)
0
 
so__qadc03
QAD Field
 
X(8)
0
 
so__qadc04
QAD Field
 
X(8)
0
 
so__qadc05
QAD Field
 
X(8)
0
 
so__qadd01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
so__qadd02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
so__qadd03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
so__qadi01
QAD Field
 
->,>>>,>>9
 
 
so__qadi02
QAD Field
 
->,>>>,>>9
 
 
so__qadi03
QAD Field
 
->,>>>,>>9
 
 
so__qadl01
QAD Field
 
yes/no
 
 
so__qadl02
Exclude Planning Data
 
yes/no
 
 
so__qadl04
 
 
yes/no
 
 
so__qadt01
QAD Field
 
99/99/99
 
 
so__qadt02
QAD Field
 
99/99/99
 
 
so__qadt03
QAD Field
 
99/99/99
 
 
so_app_owner
Owner Application
 
x(12)
 
 
so_ar_acct
AR Account
AR
x(8)
 
 
so_ar_cc
Cost Ctr
CC
x(4)
 
 
so_ar_sub
AR Sub-Account
Sub-Acct
x(8)
 
 
so_asb_ar_accr_acct
Self-Billing Sales Accrual Acct
 
x(8)
 
 
so_asb_ar_accr_cc
Self-Billing Sales Accrual CC
 
x(4)
 
 
so_asb_ar_accr_project
Self-Billing Sales Accrual Project
 
x(8)
 
 
so_asb_ar_accr_sub
Self-Billing Sales Accrual Sub-Acct
 
x(8)
 
 
so_auth_days
AUTHNBR Unique Days
 
>>9
 
 
so_auto_replenish
Auto Replenish
Auto!Replenish
yes/no
 
 
so_bank
Bank
 
x(2)
 
 
so_bill
Bill-To
 
x(8)
 
 
so_bol
BOL
 
x(18)
 
 
so_bump_all
Unpeg
 
yes/no
 
 
so_ca_nbr
Call
 
x(8)
0
 
so_calc_fr
Calculate Freight
 
yes/no
 
 
so_cartons
Cartons
 
->,>>>,>>9
 
 
so_channel
Channel
 
x(8)
 
 
so_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
so_cncl_date
Cancel Date
Cancel
99/99/99
 
 
so_comm_pct[4]
Commission
Comm%
>>9.99%
10
 
so_compl_date
Status Date
Stat Date
99/99/99
 
 
so_compl_stat
Complete Status
Status
x(8)
 
 
so_conf_date
Confirmed Date
Confirmed
99/99/99
 
 
so_conrep
Netting Logic
C/R
x(1)
 
 
so_consign_loc
Consignment Location
Consignment!Location
x(8)
 
 
so_consignment
Consignment
 
yes/no
 
 
so_consume
Consume Forecast
Consume Fcst
yes/no
 
 
so_cr_card
Credit Card
Card
x(2)
 
 
so_cr_init
Cr Initials
Initials
x(3)
 
 
so_cr_terms
Credit Terms
Terms
x(8)
 
 
so_credit
Credit
Cr
yes/no
 
 
so_crprlist
Credit Price List
 
X(8)
 
 
so_cum_acct
Cumulative Accounting
 
Cum/Req
 
 
so_curr
Currency
Cur
x(3)
 
 
so_cust
Sold-To
 
x(8)
 
 
so_cust_po
End Customer PO
End Cust PO
x(22)
 
 
so_cust_self_bill
Self-Billing Sales Order
 
yes/no
 
 
so_custref_val
Customer Ref Is Customer Item
 
yes/no
 
 
so_daybookset
Daybook Set
Dybk Set
x(8)
 
 
so_disc_pct
Disc %
 
->>9.99%
10
 
so_div
Division
 
x(8)
 
 
so_domain
Domain
 
x(8)
 
 
so_due_date
Due Date
Due
99/99/99
 
 
so_eng_code
Engineer
 
x(8)
 
 
so_ent_ex
Exch Rate
 
>>,>>9.99999<<<<<
10
 
so_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
so_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
so_ex_ratetype
Rate Type
 
x(8)
 
 
so_exru_seq
Sequence
 
>>>>>>>>9
 
 
so_fcg_code
Charge Code
 
x(8)
0
 
so_firm_seq_days
Firm Days
 
>>9
 
 
so_fix_pr
Fixed Price
 
yes/no
 
 
so_fix_rate
Fixed Rate
Fixed
yes/no
 
 
so_fob
FOB Point
 
x(20)
 
 
so_fr_list
Freight List
Frt List
x(8)
 
 
so_fr_min_wt
Frt Min Wt
 
->>>,>>>,>>9
10
 
so_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
so_fsaccr_acct
Accrued Revenue
Accrued
x(8)
 
 
so_fsaccr_cc
Accrued Revenue CC
 
x(4)
 
 
so_fsaccr_sub
Accrued Revenue Sub-Acct
 
x(8)
 
 
so_fsdef_acct
Deferred Revenue
Deferred
x(8)
 
 
so_fsdef_cc
Deferred Revenue CC
 
x(4)
 
 
so_fsdef_sub
Deferred Revenue Sub-Acct
 
x(8)
 
 
so_fsm_type
FSM Type
 
x(8)
 
 
so_fst_id
FST ID
 
x(18)
 
 
so_gt_trans_type
GT Trans Type
 
x(25)
 
 
so_hold_stat
Hold Status
 
x(8)
 
 
so_inc_in_rss
Include Seq in Req Ship Sched
 
yes/no
 
 
so_incl_iss
Include Saturday/Sunday
 
yes/no
 
 
so_intrans_loc
In-Transit Location
In-Transit!Location
x(8)
 
 
so_inv_cr
Invoice To Credit
Cr Invoice
x(8)
 
 
so_inv_date
Invoice Date
Inv Date
99/99/99
 
 
so_inv_mthd
Invoices Via
 
x(1)
 
 
so_inv_nbr
Invoice Number
Invoice
x(22)
 
 
so_invoiced
Invoiced
 
yes/no
 
 
so_lang
Language
 
x(2)
 
 
so_manual_fr_terms
Manual Fr Terms
 
yes/no
 
 
so_max_aging_days
Maximum Aging Days
Maximum!Aging Days
>>9
 
 
so_merge_rss
Merge RSS
 
yes/no
 
 
so_nbr
Sales Order
Order
x(8)
 
 
so_nrm
Sequence ID
Seq ID
x(8)
 
 
so_ord_date
Order Date
Ord Date
99/99/99
 
 
so_partial
Partial OK
Partial
yes/no
 
 
so_per_date
Perform
 
99/99/99
 
 
so_po
Purchase Order
 
x(22)
 
 
so_pod
Proof of Delivery
POD
yes/no
 
 
so_pr_list
Manual
Disc Tbl
x(8)
 
 
so_pr_list2
Price Tbl
Pr Tbl
x(8)
 
 
so_prep_tax
Prepaid Tax
 
->>>>,>>>,>>9.99<<<
10
 
so_prepaid
Prepaid
 
-z,zzz,zzz,zz9.99
10
 
so_priced_dt
Last Price Dt
Last Pri
99/99/99
 
 
so_pricing_dt
Pricing Date
Price Dt
99/99/99
 
 
so_primary
Primary SO
Pr SO
yes/no
 
 
so_print_bl
Print Bill of Lading
Print BOL
yes/no
 
 
so_print_pl
Print Pack List
Print Pack
yes/no
 
 
so_print_so
Print Sales Order
Print SO
yes/no
 
 
so_project
Project
 
x(8)
 
 
so_promise_date
Promise Date
Promise
99/99/99
 
 
so_pst
PST
 
yes/no
 
 
so_pst_id
PST ID
 
x(18)
 
 
so_pst_pct
PST Pct
 
->9.99<%
10
 
so_quote
Quote
 
x(8)
 
 
so_reprice
Reprice/Edit
 
yes/no
 
 
so_req_date
Required Date
Required
99/99/99
 
 
so_req_time
Required Time
 
99:99
 
 
so_rev
Revision
Rev
>>9
 
 
so_revenue
Revenue Type
 
x(1)
 
 
so_reviewed
Reviewed
 
yes/no
 
 
so_rmks
Remarks
 
x(40)
 
 
so_rss_cal_option
RSS Calendar Option
 
>>9
 
 
so_sa_nbr
Contract
 
x(8)
 
 
so_sch_mthd
Schedules Via
 
x(1)
 
 
so_sched
Scheduled
 
yes/no
 
 
so_secondary
Secondary EMT Order
Sec EMT
yes/no
 
 
so_seq_order
Sequenced
Partial
yes/no
 
 
so_ship
Ship-To
 
x(8)
 
 
so_ship_cmplt
Ship Complete
 
>>9
 
 
so_ship_date
Ship Date
 
99/99/99
 
 
so_ship_eng
Ship-To Engineer
 
yes/no
 
 
so_ship_po
Ship To PO
 
x(22)
 
 
so_shipvia
Ship Via
 
x(20)
 
 
so_site
Site
 
x(8)
 
 
so_size
Size
 
->,>>>,>>9.9<<<<<<<<
10
 
so_size_um
Size UM
UM
x(2)
 
 
so_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
so_source
Order Source
Source
x(8)
 
 
so_stat
Action Status
St
x(2)
 
 
so_tax_date
Tax Date
 
99/99/99
 
 
so_tax_env
Tax Environment
Tax Env
x(16)
 
 
so_tax_in
Tax In
 
yes/no
 
 
so_tax_pct[3]
Tax
 
->9.99<%
10
 
so_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
so_taxable
Taxable
Tax
yes/no
 
 
so_taxc
Tax Class
TxC
x(3)
 
 
so_to_inv
Ready to Invoice
Invoice
yes/no
 
 
so_trade_sale
Trade Sales Contract
 
yes/no
 
 
so_trl1_amt
Trailer Amt 1
 
-zzzz,zzz,zz9.99
10
 
so_trl1_cd
Trailer 1
Trl1
x(2)
 
 
so_trl2_amt
Trailer Amt 2
 
-zzzz,zzz,zz9.99
10
 
so_trl2_cd
Trailer 2
Trl2
x(2)
 
 
so_trl3_amt
Trailer Amt 3
 
-zzzz,zzz,zz9.99
10
 
so_trl3_cd
Trailer 3
Trl3
x(2)
 
 
so_type
Type
 
x(8)
 
 
so_user1
Ufld1
 
x(8)
 
 
so_user2
Ufld2
 
x(8)
 
 
so_userid
User ID
 
x(8)
 
 
so_weight
Weight
 
->>>,>>>,>>9.9999
10
 
so_weight_um
Weight UM
UM
x(2)
 
 
so_xcomm_pct[2]
Commission
Comm%
>>9.99%
10
 
so_xslspsn[2]
Salesperson
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_so_mstr
yes
oid_so_mstr
yes
no
 
so_bill
no
so_domain
yes
no
 
 
 
so_bill
yes
no
 
 
 
so_compl_stat
yes
no
 
 
 
so_nbr
yes
no
 
 
 
so_ord_date
yes
no
 
so_ca_nbr
no
so_domain
yes
no
 
 
 
so_ca_nbr
yes
no
 
so_complete
yes
so_domain
yes
no
 
 
 
so_compl_stat
yes
no
 
 
 
so_nbr
yes
no
 
so_cust
no
so_domain
yes
no
 
 
 
so_cust
yes
no
 
 
 
so_compl_stat
yes
no
 
so_cust_po
no
so_domain
yes
no
 
 
 
so_cust_po
yes
no
 
 
 
so_cust
yes
no
 
 
 
so_nbr
yes
no
 
so_fsm_type
no
so_domain
yes
no
 
 
 
so_fsm_type
yes
no
 
 
 
so_nbr
yes
no
 
so_invoice
no
so_domain
yes
no
 
 
 
so_inv_nbr
yes
no
so_nbr
yes
so_domain
yes
no
 
 
 
so_nbr
yes
no
 
so_po_nbr
no
so_domain
yes
no
 
 
 
so_po
yes
no
 
 
 
so_cust
yes
no
 
 
 
so_nbr
yes
no
 
so_quote
no
so_domain
yes
no
 
 
 
so_quote
yes
no
 
 
 
so_nbr
yes
no
 
so_ship
no
so_domain
yes
no
 
 
 
so_ship
yes
no
 
 
 
so_compl_stat
yes
no
 
so_to_inv
yes
so_domain
yes
no
 
 
 
so_to_inv
yes
no
 
 
 
so_nbr
yes
no
spc_ctrl
Salesperson Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_spc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
spc__qad01
 
 
>>>>>>9
 
 
spc__qadi01
 
 
->>>>>>>9
 
 
spc_domain
Domain
 
x(8)
 
 
spc_nbr
Next Salesperson
 
99999999
 
 
spc_user1
Ufld1
 
x(8)
 
 
spc_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_spc_ctrl
yes
oid_spc_ctrl
yes
no
spc_index1
yes
spc_domain
yes
no
spd_det
Salesperson Commission Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_spd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
spd__chr01
 
 
x(8)
 
 
spd__chr02
 
 
x(8)
 
 
spd__chr03
 
 
x(8)
 
 
spd__chr04
 
 
x(8)
 
 
spd__chr05
 
 
x(8)
 
 
spd__dec01
 
 
>>>,>>>,>>9.99
10
 
spd__dec02
 
 
>>>,>>>,>>9.99
10
 
spd__dte01
 
 
99/99/99
 
 
spd__dte02
 
 
99/99/99
 
 
spd_addr
Salespsn
 
x(8)
 
 
spd_comm_pct
Commission
Comm%
>>9.99%
10
 
spd_cust
Customer
 
x(8)
 
 
spd_domain
Domain
 
x(8)
 
 
spd_mod_date
Modified Date
Mod Date
99/99/99
 
 
spd_part
Item Number
 
x(18)
 
 
spd_prod_ln
Prod Line
Line
x(4)
 
 
spd_user1
Ufld1
 
x(8)
 
 
spd_user2
Ufld2
 
x(8)
 
 
spd_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_spd_det
yes
oid_spd_det
yes
no
spd_addr
yes
spd_domain
yes
no
 
 
 
spd_addr
yes
no
 
 
 
spd_prod_ln
yes
no
 
 
 
spd_part
yes
no
 
 
 
spd_cust
yes
no
sph_hist
Salesperson Sales History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sph__chr01
 
 
x(8)
 
 
sph__chr02
 
 
x(8)
 
 
sph__chr03
 
 
x(8)
 
 
sph__chr04
 
 
x(8)
 
 
sph__chr05
 
 
x(8)
 
 
sph__dec01[12]
 
 
>>>>,>>>,>>9.99
10
 
sph__dec02[12]
 
 
>>>>,>>>,>>9.99
10
 
sph__dte01
 
 
99/99/99
 
 
sph__dte02
 
 
99/99/99
 
 
sph__log01
 
 
yes/no
 
 
sph_cost[12]
Cost
 
->>>,>>>,>>9
10
 
sph_domain
Domain
 
x(8)
 
 
sph_quota[12]
Quota
 
->>>,>>>,>>9
10
 
sph_sales[12]
Sales
 
->>>,>>>,>>9
10
 
sph_slspsn1
Salespsn1
 
x(8)
 
 
sph_smonth
Start Month
 
>9
 
 
sph_tot_cost
YTD Cost
 
->,>>>,>>>,>>9
10
 
sph_tot_sale
YTD Sales
 
->,>>>,>>>,>>9
10
 
sph_type
Ship Type
T
x(1)
 
 
sph_user1
Ufld1
 
x(8)
 
 
sph_user2
Ufld2
 
x(8)
 
 
sph_year
Year
 
9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sph_hist
yes
oid_sph_hist
yes
no
 
sph_slspsn1
yes
sph_domain
yes
no
 
 
 
sph_slspsn1
yes
no
 
 
 
sph_year
yes
no
sph_year
yes
sph_domain
yes
no
 
 
 
sph_year
yes
no
 
 
 
sph_slspsn1
yes
no
spod_mstr
Ship-To/POD Control Maintenace
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_spod_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
spod__qadc01
 
 
x(24)
 
 
spod__qadc02
 
 
x(24)
 
 
spod_domain
Domain
 
x(8)
 
 
spod_mod_date
Modified Date
Mod Date
99/99/99
 
 
spod_mod_userid
User ID
 
x(8)
 
 
spod_pod_orders
Proof of Delivery Orders
POD Orders
yes/no
 
 
spod_shipto
Ship-To
 
x(8)
 
 
spod_trans_loc
In-Transit Location
Transit Loc
x(8)
 
 
spod_user1
User Field Character 1
 
x(24)
 
 
spod_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_spod_mstr
yes
oid_spod_mstr
yes
no
spod_ship
yes
spod_domain
yes
no
 
 
 
spod_shipto
yes
no
 
spod_trans_loc
no
spod_domain
yes
no
 
 
 
spod_trans_loc
yes
no
spt_det
Cost Simulation Item Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_spt_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
spt__qadc01
 
 
x(8)
 
 
spt_ao
Add On
A/O
yes/no
 
 
spt_cst_ll
Cost LL
 
>>>>,>>>,>>9.99<<<
10
 
spt_cst_tl
Cost
 
>>>>,>>>,>>9.99<<<
10
 
spt_domain
Domain
 
x(8)
 
 
spt_element
Cost Element
Element
x(8)
 
 
spt_mod_date
Modified Date
Mod Date
99/99/99
 
 
spt_part
Item Number
 
x(18)
 
 
spt_pct_ll
Seq 1
 
>>9.99%
10
 
spt_pct_tl
Seq 2
 
>>9.99%
10
 
spt_sim
Cost Set
 
x(18)
 
 
spt_site
Site
 
x(8)
 
 
spt_user1
Ufld1
 
x(8)
 
 
spt_user2
Ufld2
 
x(8)
 
 
spt_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_spt_det
yes
oid_spt_det
yes
no
 
spt_sim_elem
yes
spt_domain
yes
no
 
 
 
spt_sim
yes
no
 
 
 
spt_element
yes
no
 
 
 
spt_part
yes
no
 
 
 
spt_site
yes
no
spt_sim_part
yes
spt_domain
yes
no
 
 
 
spt_site
yes
no
 
 
 
spt_sim
yes
no
 
 
 
spt_part
yes
no
 
 
 
spt_element
yes
no
sp_mstr
Salesperson Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sp__chr01
 
 
x(8)
 
 
sp__chr02
 
 
x(8)
 
 
sp__chr03
 
 
x(8)
 
 
sp__chr04
 
 
x(8)
 
 
sp__chr05
 
 
x(8)
 
 
sp__dec01
 
 
>>>,>>>,>>9.99
10
 
sp__dec02
 
 
>>>,>>>,>>9.99
10
 
sp__dte01
 
 
99/99/99
 
 
sp__dte02
 
 
99/99/99
 
 
sp__log01
 
 
yes/no
 
 
sp_addr
Salespsn
 
x(8)
 
 
sp_comm_pct
Commission
Comm%
>>9.99%
10
 
sp_domain
Domain
 
x(8)
 
 
sp_sort
Sort Name
 
x(28)
 
 
sp_territory
Territory
Trty
x(4)
 
 
sp_user1
Ufld1
 
x(8)
 
 
sp_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sp_mstr
yes
oid_sp_mstr
yes
no
sp_addr
yes
sp_domain
yes
no
 
 
 
sp_addr
yes
no
 
sp_sort
no
sp_domain
yes
no
 
 
 
sp_sort
yes
no
srand_det
Preloaded Serial ID for Serial Range ID
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sran_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_srand_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
srand__qadc01
 
 
x(24)
 
 
srand__qadc02
 
 
x(24)
 
 
srand_mod_date
Modified Date
Mod Date
99/99/99
 
 
srand_mod_userid
User ID
 
x(8)
 
 
srand_serial_id
Reserved ID
 
x(40)
 
 
srand_used
Used
 
yes/no
 
 
srand_user1
User Field Character 1
 
x(24)
 
 
srand_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_srand_det
yes
oid_srand_det
yes
no
srand_seq_serial
yes
oid_sran_mstr
yes
no
 
 
 
srand_serial_id
yes
no
 
srand_serial_id
yes
srand_serial_id
yes
no
 
srand_used
no
oid_sran_mstr
yes
no
 
 
 
srand_used
yes
no
 
 
 
srand_serial_id
yes
no
sran_mstr
Serial Range ID with preloaded Serial IDs
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sran_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sran__qadc01
 
 
x(24)
 
 
sran__qadc02
 
 
x(24)
 
 
sran_desc
Serial Range Description
 
x(40)
 
 
sran_domain
Domain
 
x(8)
 
 
sran_exec
Program Name
 
x(40)
 
 
sran_mod_date
Modified Date
Mod Date
99/99/99
 
 
sran_mod_userid
User ID
 
x(8)
 
 
sran_qty_unused
Serial ID Unused Qty
 
>,>>>,>>>,>>9
 
 
sran_seqid
Serial Range ID
 
x(8)
 
 
sran_ser_qty
Serial ID Qty
 
>,>>>,>>>,>>9
 
 
sran_user1
User Field Character 1
 
x(24)
 
 
sran_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sran_mstr
yes
oid_sran_mstr
yes
no
sran_seqid
yes
sran_domain
yes
no
 
 
 
sran_seqid
yes
no
src_ctrl
Service Request Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_src_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
src__qadc01
 
 
x(8)
 
 
src__qadi01
 
 
->>>>>>>9
 
 
src_domain
Domain
 
x(8)
 
 
src_nbr
SR Number
 
>>>>>>9
 
 
src_user1
Ufld1
 
x(8)
 
 
src_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_src_ctrl
yes
oid_src_ctrl
yes
no
src_index1
yes
src_domain
yes
no
srg_mstr
Serial ID Range by Item/Site/Address
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_srg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
srg__qadc01
 
 
x(24)
 
 
srg__qadc02
 
 
x(24)
 
 
srg_addr
Address
 
x(8)
 
 
srg_domain
Domain
 
x(8)
 
 
srg_label_format
Label Format
 
x(8)
 
 
srg_mod_date
Modified Date
Mod Date
99/99/99
 
 
srg_mod_userid
User ID
 
x(8)
 
 
srg_pack_code
Pack Code
 
x(18)
 
 
srg_part
Item
 
x(18)
 
 
srg_seqid
Sequence ID
 
x(8)
 
 
srg_site
Site
 
x(8)
 
 
srg_user1
User Field Character 1
 
x(24)
 
 
srg_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_srg_mstr
yes
oid_srg_mstr
yes
no
srg_site_addr_part
yes
srg_domain
yes
no
 
 
 
srg_site
yes
no
 
 
 
srg_addr
yes
no
 
 
 
srg_part
yes
no
 
 
 
srg_pack_code
yes
no
 
srg_site_part_addr
yes
srg_domain
yes
no
 
 
 
srg_site
yes
no
 
 
 
srg_part
yes
no
 
 
 
srg_addr
yes
no
 
 
 
srg_pack_code
yes
no
sroc_ctrl
Service/Repair Order Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sroc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sroc__qad01
 
 
>>>>>>9
 
 
sroc__qadi01
 
 
->>>>>>>9
 
 
sroc_domain
Domain
 
x(8)
 
 
sroc_sro
Next SR/O Number
Next SRO
>>>>>>>9
 
 
sroc_sro_pre
SRO Prefix
Pre
x(3)
 
 
sroc_user1
Ufld1
 
x(8)
 
 
sroc_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sroc_ctrl
yes
oid_sroc_ctrl
yes
no
sroc_index1
yes
sroc_domain
yes
no
sro_mstr
Service/Repair Order Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sro_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sro__chr01
 
 
x(8)
 
 
sro__chr02
 
 
x(8)
 
 
sro__chr03
 
 
x(8)
 
 
sro__chr04
 
 
x(8)
 
 
sro__chr05
 
 
x(8)
 
 
sro__dec01
 
 
>>>,>>>,>>9.99
10
 
sro__dec02
 
 
>>>,>>>,>>9.99
10
 
sro__dte01
 
 
99/99/99
 
 
sro__dte02
 
 
99/99/99
 
 
sro__log01
 
 
yes/no
 
 
sro__qadc05
 
 
x(8)
 
 
sro__qadc06
 
 
x(4)
 
 
sro_assign
Assigned To
Assigned
x(8)
 
 
sro_author
Authorized By
Author
x(8)
 
 
sro_closed
Closed
 
yes/no
 
 
sro_cls_date
Closed
 
99/99/99
 
 
sro_cmmt[16]
 
 
x(76)
 
 
sro_cmtindx
Comment
 
>>>>>>>9
 
 
sro_cr_terms
Credit Terms
Terms
x(8)
 
 
sro_cust
Customer
 
x(8)
 
 
sro_desc
Description
 
x(24)
 
 
sro_disc_pct
Disc %
 
->9.99%
10
 
sro_domain
Domain
 
x(8)
 
 
sro_dspstn
Disposition
Dspstn
x(8)
 
 
sro_due_date
Due Date
 
99/99/99
 
 
sro_ent_date
Entered
 
99/99/99
 
 
sro_failure1
Failure Code
Failure1
x(8)
 
 
sro_failure2
Failure Code 2
Failure2
x(8)
 
 
sro_failure3
Failure Code 3
Failure3
x(8)
 
 
sro_failure4
Failure Code 4
Failure4
x(8)
 
 
sro_failure5
Failure Code 5
Failure5
x(8)
 
 
sro_frt
Freight
 
-z,zzz,zzz,zz9.99
10
 
sro_inv_date
Invoice Date
Inv Date
99/99/99
 
 
sro_invoiced
Invoiced
 
yes/no
 
 
sro_nbr
S/RO
 
x(8)
 
 
sro_part
Item
 
x(18)
 
 
sro_po
PO
 
x(20)
 
 
sro_prepaid
Prepaid Amount
Prepaid
-z,zzz,zzz,zz9.99
10
 
sro_print_pl
Print Pack List
Print Pack
yes/no
 
 
sro_print_rg
Print RGA
 
yes/no
 
 
sro_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
sro_repair1
Repair Code
Repair1
x(8)
 
 
sro_repair2
Repair Code 2
Repair2
x(8)
 
 
sro_repair3
Repair Code 3
Repair3
x(8)
 
 
sro_repair4
Repair Code 4
Repair4
x(8)
 
 
sro_repair5
Repair Code 5
Repair5
x(8)
 
 
sro_rev
Rev
 
x(2)
 
 
sro_rga
RGA
 
x(8)
 
 
sro_serial
Lot/Serial
 
x(18)
 
 
sro_serv_chg
Service
 
-z,zzz,zzz,zz9.99
10
 
sro_ship
Ship-To
 
x(8)
 
 
sro_shipvia
Ship Via
 
x(20)
 
 
sro_shp_date
Ship Date
Shipped
99/99/99
 
 
sro_spec_chg
Special
 
-z,zzz,zzz,zz9.99
10
 
sro_status
Status
 
x(8)
 
 
sro_taken
Taken By
 
x(8)
 
 
sro_tax_pct[3]
Tax
 
->9.99<%
10
 
sro_to_inv
Ready to Invoice
Invoice
yes/no
 
 
sro_type
Type
 
x(8)
 
 
sro_user1
Ufld1
 
x(8)
 
 
sro_user2
Ufld2
 
x(8)
 
 
sro_wrrnty
Warranty
Wrrnty
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sro_mstr
yes
oid_sro_mstr
yes
no
 
sro_assign
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_assign
yes
no
 
 
 
sro_ent_date
yes
no
 
sro_cust
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_cust
yes
no
 
 
 
sro_ent_date
yes
no
 
sro_desc
yes
sro_domain
yes
no
 
 
 
sro_desc
yes
no
 
 
 
sro_nbr
yes
no
 
sro_dspstn
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_dspstn
yes
no
 
 
 
sro_ent_date
yes
no
 
sro_ent_date
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_ent_date
yes
no
 
 
 
sro_nbr
yes
no
 
sro_failure1
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_failure1
yes
no
 
 
 
sro_ent_date
yes
no
sro_nbr
yes
sro_domain
yes
no
 
 
 
sro_nbr
yes
no
 
sro_part
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_part
yes
no
 
 
 
sro_ent_date
yes
no
 
sro_ship
no
sro_domain
yes
no
 
 
 
sro_ship
yes
no
 
sro_status
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_status
yes
no
 
 
 
sro_ent_date
yes
no
 
sro_type
no
sro_domain
yes
no
 
 
 
sro_closed
yes
no
 
 
 
sro_type
yes
no
 
 
 
sro_ent_date
yes
no
srr_mstr
Service Request Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_srr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
srr__chr01
 
 
x(8)
 
 
srr__chr02
 
 
x(8)
 
 
srr__chr03
 
 
x(8)
 
 
srr__chr04
 
 
x(8)
 
 
srr__chr05
 
 
x(8)
 
 
srr__chr06
 
 
x(8)
 
 
srr__chr07
 
 
x(8)
 
 
srr__chr08
 
 
x(8)
 
 
srr__chr09
 
 
x(8)
 
 
srr__chr10
 
 
x(8)
 
 
srr__dec01
 
 
>>>,>>>,>>9.99
10
 
srr__dec02
 
 
>>>,>>>,>>9.99
10
 
srr__dte01
 
 
99/99/99
 
 
srr__dte02
 
 
99/99/99
 
 
srr__log01
 
 
yes/no
 
 
srr_act_hrs
Actual Hours
Act Hours
->>,>>9.99
10
 
srr_assign
Assigned
 
x(8)
 
 
srr_ca_nbr
Call
 
x(8)
 
 
srr_cls_date
Close Date
 
99/99/99
 
 
srr_date
Date Entered
 
99/99/99
 
 
srr_desc
Description
 
x(60)
 
 
srr_domain
Domain
 
x(8)
 
 
srr_eco
ECO
 
x(8)
 
 
srr_est_hrs
Estimated Hours
Est Hours
->>,>>9.99
10
 
srr_eu_nbr
End User
 
x(8)
 
 
srr_nbr
SR
 
x(8)
 
 
srr_note
Note#
 
x(20)
 
 
srr_part
Item
 
x(18)
 
 
srr_phone
Phone
 
x(20)
 
 
srr_pri
Priority
 
>>>9
 
 
srr_probidx
Problem Index
 
>>>>>>9
 
 
srr_problem
Problem
 
x(8)
 
 
srr_que
Queue
 
x(8)
 
 
srr_requestor
Requestor
 
x(24)
 
 
srr_residx
Resolve Index
 
>>>>>>9
 
 
srr_resolution
Resolution
 
x(8)
 
 
srr_severity
Severity
 
x(8)
 
 
srr_started
Started In
 
x(8)
 
 
srr_status
Status
 
x(8)
 
 
srr_tdate
Target Fix Date
Target
99/99/99
 
 
srr_tfix
Target Version Fix
Target
x(8)
 
 
srr_type
Type
 
x(8)
 
 
srr_update
Fixed In
 
x(8)
 
 
srr_user1
Ufld1
 
x(8)
 
 
srr_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_srr_mstr
yes
oid_srr_mstr
yes
no
 
srr_assign
no
srr_domain
yes
no
 
 
 
srr_assign
yes
no
 
srr_eco
no
srr_domain
yes
no
 
 
 
srr_eco
yes
no
 
srr_eu_nbr
no
srr_domain
yes
no
 
 
 
srr_eu_nbr
yes
no
srr_nbr
yes
srr_domain
yes
no
 
 
 
srr_nbr
yes
no
 
srr_part
yes
srr_domain
yes
no
 
 
 
srr_part
yes
no
 
 
 
srr_nbr
yes
no
 
srr_problem
no
srr_domain
yes
no
 
 
 
srr_problem
yes
no
sr_wkfl
Serial Number Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sr_wkfl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sr__qadc01
 
 
x(8)
 
 
sr_algo
Algorithm
Algo
x(8)
 
 
sr_alt_um
Alternate UM
Alt UM
x(2)
 
 
sr_assay
Assay %
 
>>9.99%
10
 
sr_domain
Domain
 
x(8)
 
 
sr_expire
Expire Date
Expire
99/99/99
 
 
sr_lineid
 
 
x(8)
 
 
sr_loc
Location
 
x(8)
 
 
sr_lotser
Lot/Serial
 
x(18)
 
 
sr_mode
Mode
Mode
x(8)
 
 
sr_qty
Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
sr_ref
Ref
Reference
x(8)
 
 
sr_rev
Rev
 
x(4)
 
 
sr_site
Site
 
x(8)
 
 
sr_status
Status
 
x(8)
 
 
sr_to_loc
Location
 
x(8)
 
 
sr_to_site
Site
 
x(8)
 
 
sr_user1
Ufld1
 
x(8)
 
 
sr_user2
Ufld2
 
x(8)
 
 
sr_userid
Session ID
 
x(60)
 
 
sr_vend_lot
Supplier Lot
 
x(18)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sr_wkfl
yes
oid_sr_wkfl
yes
no
sr_id
yes
sr_domain
yes
no
 
 
 
sr_userid
yes
no
 
 
 
sr_lineid
yes
no
 
 
 
sr_site
yes
no
 
 
 
sr_loc
yes
no
 
 
 
sr_lotser
yes
no
 
 
 
sr_ref
yes
no
ssd_det
Source of Supply Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ssd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ssd__qadc01
 
 
x(8)
 
 
ssd__qadd01
 
 
>>>,>>>,>>9.99
10
 
ssd_domain
Domain
 
x(8)
 
 
ssd_end
End
 
99/99/99
 
 
ssd_fr_list
Freight List
Frt List
X(8)
 
 
ssd_fr_min_wt
Frt Min Wt
 
>>>,>>>,>>9.9<<
10
 
ssd_fr_terms
Freight Terms
Fr Terms
x(8)
 
 
ssd_leadtime
Lead Time
LT
->,>>>
 
 
ssd_network
Network Code
 
x(18)
 
 
ssd_percent
Supply Percent
Percent
->>9.9<<%
10
 
ssd_rec_site
Receiving Site
Rec Site
x(8)
 
 
ssd_ref
Reference
 
x(12)
 
 
ssd_src_site
Supply Site
Source
x(8)
 
 
ssd_start
Start
 
99/99/99
 
 
ssd_trans
Transportation Code
Ship Via
x(8)
 
 
ssd_user1
Ufld1
 
x(8)
 
 
ssd_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ssd_det
yes
oid_ssd_det
yes
no
ssd_det
yes
ssd_domain
yes
no
 
 
 
ssd_network
yes
no
 
 
 
ssd_rec_site
yes
no
 
 
 
ssd_src_site
yes
no
 
 
 
ssd_ref
yes
no
 
ssd_rec_site
no
ssd_domain
yes
no
 
 
 
ssd_rec_site
yes
no
 
 
 
ssd_network
yes
no
 
 
 
ssd_src_site
yes
no
 
ssd_src_site
no
ssd_domain
yes
no
 
 
 
ssd_src_site
yes
no
 
 
 
ssd_network
yes
no
 
 
 
ssd_rec_site
yes
no
ssm_mstr
Source of Supply Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_ssm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
ssm__qadc01
 
 
x(8)
 
 
ssm_desc
Description
 
x(24)
 
 
ssm_domain
Domain
 
x(8)
 
 
ssm_network
Network Code
 
x(18)
 
 
ssm_planner
Planner
 
x(8)
 
 
ssm_user1
Ufld1
 
x(8)
 
 
ssm_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_ssm_mstr
yes
oid_ssm_mstr
yes
no
 
ssm_desc
no
ssm_domain
yes
no
 
 
 
ssm_desc
yes
no
 
 
 
ssm_network
yes
no
ssm_network
yes
ssm_domain
yes
no
 
 
 
ssm_network
yes
no
State
State
 
 
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
 
 
State_ID
Record ID
 
-99999999999
 
 
StateCode
State
 
x(4)
 
 
StateDescription
Description
 
x(40)
 
 
StateIsActive
Active
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Code
yes
StateCode
yes
no
 
IsActive
no
StateIsActive
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
State_ID
yes
no
 
ViewIndex
no
StateIsActive
yes
no
 
 
 
StateCode
yes
no