sod_det


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