TX00201 - Sales/Purchases Tax Master | Prospr

TX00201 - Sales/Purchases Tax Master

Query Builder

Select * from TX00201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TAXDTLID	Tax Detail ID	String	16	View
TXDTLDSC	Tax Detail Description	String	32	View
TXDTLTYP	Tax Detail Type	Integer	2	View
ACTINDX	Account Index	Long Integer	4	View
TXIDNMBR	Tax ID Number	String	12	View
TXDTLBSE	Tax Detail Base	Integer	2	View
TXDTLPCT	Tax Detail Percent	Currency	10	View
TXDTLAMT	Tax Detail Amount	Currency	10	View
TDTLRNDG	Tax Detail Rounding	Integer	2	View
TXDBODTL	Tax Detail Based On Detail ID	String	16	View
TDTABMIN	Tax Detail Taxable Minimum	Currency	10	View
TDTABMAX	Tax Detail Taxable Maximum	Currency	10	View
TDTAXMIN	Tax Detail Tax Minimum	Currency	10	View
TDTAXMAX	Tax Detail Tax Maximum	Currency	10	View
TDRNGTYP	Tax Detail Range Type	Integer	2	View
TXDTQUAL	Tax Detail Base Qualifiers	Integer	2	View
TDTAXTAX	Tax Detail Taxable Tax	Boolean	2	View
TXDTLPDC	Tax Detail Print on Documents	Boolean	2	View
TXDTLPCH	Tax Detail Print Character	String	2	View
TXDXDISC	Tax Detail Exclude Discounts	Boolean	2	View
CMNYTXID	Company Tax ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
NAME	Name	String	32	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
TXUSRDF1	Tax User Defined 1	String	22	View
TXUSRDF2	Tax User Defined 2	String	22	View
VATREGTX	VAT Register Tax	Boolean	2	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
TaxPostToAcct	Tax Post To Account	Integer	2	View
TaxBoxes	Tax Boxes	Long Integer	4	View
IGNRGRSSAMNT	Ignore Gross Amount	Boolean	2	View
TDTABPCT	Tax Detail Taxable Percent	Currency	10	View

TX00201 - Sales/Purchases Tax Master

Query Builder

Customer Service

Information

My Account

Contact Us