|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|