sa_mstr


Field Name	Label	Col-Label	Format	Dec
oid_sa_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10
sa__chr01			x(8)
sa__chr02			x(8)
sa__chr03			x(8)
sa__chr04			x(8)
sa__chr05			x(8)
sa__chr06			x(8)
sa__chr07			x(8)
sa__chr08			x(8)
sa__chr09			x(8)
sa__chr10			x(8)
sa__dec01			>>>,>>>,>>9.99	10
sa__dec02			>>>,>>>,>>9.99	10
sa__dec03	User Decimal Field		->>,>>9.99	10
sa__dte01			99/99/99
sa__dte02			99/99/99
sa__dte03	User Date Field		99/99/99
sa__log01			yes/no
sa__log02	User Logical field		yes/no
sa__log03	User Logical Field		yes/no
sa__qadc01	Qad Field #1		x(8)
sa__qadc02	Qad Field #2		x(8)
sa__qadc03	Qad Field #3		x(8)
sa__qadc04	Qad Field #4		x(8)
sa__qadc05[2]			x(8)	0
sa__qadd01	Qad Decimal #1		->>>,>>>,>>9.99<<<<	10
sa__qadd02	Qad Decimal #2		->>>,>>>,>>9.99<<<<	10
sa__qadd03	Qad Decimal #3		->>>,>>>,>>9.99<<<<	10
sa__qadl01	Qad Logical #1		yes/no
sa__qadl02	Qad Logical #2		yes/no
sa__qadl03	Qad Logical #3		yes/no
sa__qadl04	QAD Logical Field		yes/no
sa__qadt01	Qad Date #1		99/99/99
sa__qadt02	Qad Date #2		99/99/99
sa__qadt03	Qad Date #3		99/99/99
sa_ar_acct	AR Account	AR	x(8)
sa_ar_cc	Cost Ctr	CC	x(4)
sa_ar_sub	AR Sub-Acct	Sub-Acct	x(8)
sa_area	Area		x(8)
sa_arrears	Bill Arrears	Arrear	yes/no
sa_autornew	Auto Renew	A Renew	yes/no
sa_base_pct	Contract Base		>>>9.99<<<	10
sa_bill_cnt	Bill Count	Bill Cnt	->,>>>,>>9
sa_bill_enduser	Bill End Users		yes/no
sa_bill_summary	Bill Summary		yes/no
sa_bill_to	Bill To		x(8)
sa_bill_type	Billing Type		x(8)
sa_blanket	Blanket Contract		yes/no
sa_bol	BOL		x(18)
sa_call_price	Call Price List	Price	x(8)
sa_calls_allow	Calls Allowed		>>>,>>9
sa_calls_total	Total Calls		>>>,>>9
sa_can_tax	PST Pct		->>9.99<<%	10
sa_cancel	Cancel Date		99/99/99
sa_channel	Channel		x(8)
sa_cmtindx	Comment Index	Comment	>>>>>>>9
sa_comm_pct[4]	Commission	Comm%	>>9.99%	10
sa_complete	Complete	Cplt	yes/no
sa_conf_date	Confirmed Date	Confirmed	99/99/99
sa_cr_card	Credit Card	Card	x(2)
sa_cr_init	Cr Initials	Initials	x(3)
sa_cr_terms	Credit Terms	Terms	x(8)
sa_curr	Currency	Cur	x(3)
sa_cust	Customer		x(8)
sa_cycle	Billing Cycle	Cyc	x(2)
sa_date_printed	Date Printed		99/99/99
sa_daybookset	Daybook Set	Dybk Set	x(8)
sa_disc_pct	Disc %		->9.99%	10
sa_domain	Domain		x(8)
sa_end_date	End Date		99/99/99
sa_enduser	End User		x(8)
sa_ent_ex	Exch Rate		>>,>>9.99999<<<<<	10
sa_ex_rate	Exch Rate		>>>>,>>>,>>9.9<<<<<<<<<	10
sa_ex_rate2	Exch Rate 2		>>>>,>>>,>>9.9<<<<<<<<<	10
sa_ex_ratetype	Rate Type		x(8)
sa_exp_date	Expire Date	Exp Date	99/99/99
sa_exru_seq	Sequence		>>>>>>>>9
sa_ext_date	Extend Date	Ext Date	99/99/9999
sa_fix_pr	Fixed Price		yes/no
sa_fix_rate	Fixed Rate	Fixed	yes/no
sa_fob	FOB Point		x(20)
sa_free_frm	Free Coverage From		99/99/99
sa_free_to	Free Coverage To		99/99/99
sa_fsaccr_acct	Accrued Revenue	Accrued	x(8)
sa_fsaccr_cc	Accrued Revenue CC		x(4)
sa_fsaccr_sub	Accrued Revenue Sub-Acct		x(8)
sa_fsdef_acct	Deferred Revenue	Deferred	x(8)
sa_fsdef_cc	Deferred Revenue CC		x(4)
sa_fsdef_sub	Deferred Revenue Sub-Acct		x(8)
sa_fst_id	FST ID		x(18)
sa_gen_0itm	Generate 0$ Items		yes/no
sa_hold	Hold Contract	Hld	yes/no
sa_inv_date	Invoice Date	Inv Date	99/99/99
sa_invoiced	Invoiced		yes/no
sa_item_enduser	Item End Users		yes/no
sa_lang	Language		x(2)
sa_last_bill	Last Billed	Last Bill	99/99/99
sa_limit_copy	Renew Limits From		X(1)
sa_lst_bill	Last Bill		99/99/99
sa_lst_cover	Last Bill	Lst Bill	99/99/99
sa_mod_date	Modified Date	Mod Date	99/99/99
sa_mod_userid	User ID		X(8)
sa_mref	Master Contract	Master	x(8)
sa_mrp	Link to MRP		yes/no
sa_nbr	Number		x(8)	0
sa_next_dur	Next Duration		>>9.99	10
sa_nxt_bill	Next Bill		99/99/99
sa_off_hours_pt	Off Hours Item		x(18)
sa_ord_date	Order Date	Ord Date	99/99/99
sa_orig_date	Original Start		99/99/99
sa_per_bill	Period Based Billing	PBB	yes/no
sa_periodic	Periodic Billing		yes/no
sa_po	Purchase Order		x(20)
sa_pr_list	Price List	List	x(8)
sa_pr_list2	List Price List	List	x(8)
sa_prefix	Pf		x(1)
sa_prepaid	Prepaid		-z,zzz,zzz,zz9.99	10
sa_print	Print Sales Order	Print SO	yes/no
sa_print_pl	Print Pack List	Print Pack	yes/no
sa_prodline	Product Line	Line	x(4)
sa_project	Project		x(8)
sa_prorate	Prorate Partial Periods	Pro	yes/no
sa_prt_0itm	Print 0$ Items		yes/no
sa_pst	PST		yes/no
sa_pst_id	PST ID		x(18)
sa_qty_per	Duration		->>>9.9<<<	10
sa_qty_plst	Last Qty Billed	Last Qty	->>>9.9<<<	10
sa_quote	Quote		x(8)
sa_quote_mod	Quote Modified		yes/no
sa_rel_date	Release Date	Rel Date	99/99/99
sa_release	Release To Contract	Rel	yes/no
sa_renew_count	Renewal Count		>>9
sa_renew_periods	Renewal Periods		>>9
sa_renewal_date	Renewal Date		99/99/99
sa_renewed_from	Renewed From		X(8)
sa_renewed_to	Renewed To		X(8)
sa_reval_index	Index Month		>>9
sa_reval_period	Revaluation Period		>>9
sa_revalue_date	Revaluation Date		99/99/99
sa_revenue	Revenue Type		x(1)
sa_reviewed	Reviewed		yes/no
sa_rmks	Remarks		x(40)
sa_rsn_lost	Reason Lost		x(8)
sa_sa_type	Type		x(8)
sa_sched_start	PM Start Date	Start	yes/no
sa_schedule	Billing Schedule File		yes/no
sa_serial_det	Serial Detail		yes/no
sa_ship_date	Ship Date		99/99/99
sa_shipvia	Ship Via		x(20)
sa_site	Site		x(8)
sa_slspsn[4]	Salesperson	Salespsn	X(8)	0
sa_so_nbr	Sales Order	Order	x(8)
sa_source	Order Source	Source	x(8)
sa_st_cover	Coverage		99/99/99
sa_st_date	Start Date		99/99/99
sa_stat	Action Status	St	x(2)
sa_summarize	Summarize		yes/no
sa_sv_code	Service Type	Svc Type	x(8)
sa_tax_date	Tax Date		99/99/99
sa_tax_env	Tax Environment	Tax Env	x(16)
sa_tax_pct[3]	Tax		->9.99%	10
sa_tax_usage	Tax Usage	TaxUsage	x(8)
sa_taxable	Taxable	Tax	yes/no
sa_taxc	Tax Class	TxC	x(3)
sa_total_billed	Total Billed		>>>>,>>>,>>9.99<<<	10
sa_total_cost	Total Cost		>>>>,>>>,>>9.99<<<	10
sa_trl1_amt	Trailer Amt 1		-zzzz,zzz,zz9.99	10
sa_trl1_cd	Trailer 1	Trl1	x(2)
sa_trl2_amt	Trailer Amt 2		-zzzz,zzz,zz9.99	10
sa_trl2_cd	Trailer 2	Trl2	x(2)
sa_trl3_amt	Trailer Amt 3		-zzzz,zzz,zz9.99	10
sa_trl3_cd	Trailer 3	Trl3	x(2)
sa_type	Type		x(8)
sa_um	UM		x(2)
sa_user1	Ufld1		x(8)
sa_user2	Ufld2		x(8)
sa_visits	Visits		>>9	10
sa_xcomm_pct[2]	Commission	Comm%	>>9.99%	10

	Index-Name	Uni	Field-Name	Asc	Abbr
	oid_sa_mstr	yes	oid_sa_mstr	yes	no
	sa_cust	yes	sa_domain	yes	no
			sa_cust	yes	no
			sa_prefix	yes	no
			sa_nbr	yes	no
	sa_end_date	no	sa_domain	yes	no
			sa_end_date	yes	no
	sa_enduser	no	sa_domain	yes	no
			sa_enduser	yes	no
			sa_prefix	yes	no
			sa_nbr	yes	no
∗	sa_nbr	yes	sa_domain	yes	no
			sa_nbr	yes	no
			sa_prefix	yes	no
	sa_po_nbr	no	sa_domain	yes	no
			sa_po	yes	no
			sa_cust	yes	no
			sa_nbr	yes	no
			sa_prefix	yes	no