so_mstr


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