ad_mstr


Field Name	Label	Col-Label	Format	Dec
ad__chr01			x(8)
ad__chr02			x(8)
ad__chr03			x(8)
ad__chr04			x(8)
ad__chr05			x(8)
ad__qad01			x(8)
ad__qad02			x(8)
ad__qad03			x(8)
ad__qad04			x(8)
ad__qad05			x(8)
ad_addr	Address		x(8)
ad_address_id	Business Relation Address		9999999999
ad_alt_um	Alternate UM	UM	x(2)
ad_asn_data	ASN Default Data		x(8)
ad_attn	Attention		x(24)
ad_attn2	Attention		x(24)
ad_barlbl_prt	Barcode Label Print Program		x(10)
ad_barlbl_val	Barcode Validation Program		x(10)
ad_bk_acct1	Bank Acct 1		x(24)
ad_bk_acct2	Bank Acct 2		x(24)
ad_bus_relation	Business Relation		x(20)
ad_calendar	Calendar		x(8)
ad_city	City		x(20)
ad_city_code	City Code		x(20)
ad_coc_reg	CoC Number	CoC	x(8)
ad_conrep	Netting Logic	C/R	x(1)
ad_country	Country		x(28)
ad_county	County		x(20)
ad_ctry	Country Code	Ctry	x(3)
ad_date	Added		99/99/99
ad_domain	Domain		x(8)
ad_edi_ctrl[5]	EDI Control		x(50)
ad_edi_id	Trading Prtnr EDI ID		x(24)
ad_edi_level	EDI Standard Level		x(8)
ad_edi_std	EDI Standard		x(8)
ad_edi_tpid	Trading Prtnr Interface ID		x(24)
ad_email	Email		x(48)
ad_email2	Email		x(48)
ad_ext	Ext		x(4)
ad_ext2	Ext		x(4)
ad_fax	Fax/Telex		x(20)
ad_fax2	Fax/Telex		x(20)
ad_format	Format		>9
ad_gst_id	Tax ID - Federal		x(18)
ad_intr_division	IntraStat Division		x(3)
ad_inv_mthd	Invoices Via		x(1)
ad_lang	Language		x(2)
ad_last_file	Last Filing		yes/no
ad_line1	Address		x(36)
ad_line2	Address		x(36)
ad_line3	Address		x(36)
ad_loadseq	Load Sequence	Load!Sequence	X(8)
ad_misc1_id	Tax ID - Misc 1		x(18)
ad_misc2_id	Tax ID - Misc 2		x(18)
ad_misc3_id	Tax ID - Misc 3		x(18)
ad_mod_date	Modified Date	Mod Date	99/99/99
ad_name	Name		x(36)
ad_name_control	Name Control		x(4)
ad_ns_pr_list	Non-Sales Price List	NSO Price List	x(8)
ad_phone	Telephone		x(20)
ad_phone2	Telephone		x(20)
ad_pick_by_date	Pick By Date	Pick!By Date	yes/no
ad_po_mthd	Purchase Orders Via		x(1)
ad_priority	Priority		X(8)
ad_profile	Profile	Prof	x(8)
ad_pst_id	Tax ID - State		x(18)
ad_ref	Reference		x(8)
ad_route	Route		X(8)
ad_sch_mthd	Schedules Via		x(2)
ad_sort	Sort Name		x(28)
ad_state	State	St	x(4)
ad_tax_in	Tax In		yes/no
ad_tax_in_city	In City		yes/no
ad_tax_report	Tax Report		yes/no
ad_tax_type	Tax Type		x(3)
ad_tax_usage	Tax Usage	TaxUsage	x(8)
ad_tax_zone	Tax Zone		x(16)
ad_taxable	Taxable		yes/no
ad_taxc	Tax Class	TxC	x(3)
ad_temp	Temporary	Temp	yes/no
ad_timezone	Time Zone		x(8)
ad_tp_loc_code	Trd Partner Location Code		x(24)
ad_type	List Type	List	x(8)
ad_user1	Ufld1		x(8)
ad_user2	Ufld2		x(8)
ad_userid	User ID		x(8)
ad_vat_reg	VAT Registration		x(18)
ad_wk_offset	Week Offset		9
ad_zip	Post		x(10)
oid_ad_mstr			>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<	10


	Index-Name	Uni	Field-Name	Asc	Abbr
∗	ad_addr	yes	ad_domain	yes	no
			ad_addr	yes	no
	ad_address_id	no	ad_address_id	yes	no
	ad_edi_tpid	no	ad_domain	yes	no
			ad_edi_tpid	yes	no
	ad_gst	yes	ad_domain	yes	no
			ad_gst_id	yes	no
			ad_addr	yes	no
			ad_sort	yes	no
	ad_ref	no	ad_domain	yes	no
			ad_ref	yes	no
			ad_addr	yes	no
	ad_sort	yes	ad_domain	yes	no
			ad_sort	yes	no
			ad_addr	yes	no
	ad_type	yes	ad_domain	yes	no
			ad_type	yes	no
			ad_addr	yes	no
	ad_zip	no	ad_domain	yes	no
			ad_zip	yes	no
			ad_addr	yes	no
	oid_ad_mstr	yes	oid_ad_mstr	yes	no