Sales/Purchases Tax Master (TX00201)

azurecurve Products Microsoft Dynamics GP (0)CompanySales/Purchases Tax Master (TX00201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00201

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Sales/Purchases Tax Master
Physical Name: TX00201
Technical Name: TX_Detail_MSTR

Group Display Name: Sales/Purchases Tax Master
Group Technical Name: Sales/Purchases Tax Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	TAXDTLID	Tax Detail ID	String	STR15_Tax_Detail_ID	15
2	TXDTLDSC	Tax Detail Description	String	STR30	30
3	TXDTLTYP	Tax Detail Type	Integer	DDL_Tax_Detail_Type	0
4	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Sales/Purchases Tax Master'].ACTINDX AS 'Sales/Purchases Tax Master-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM TX00201 AS ['Sales/Purchases Tax Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Sales/Purchases Tax Master'].ACTINDX = ['Account Index Master'].ACTINDX
5	TXIDNMBR	Tax ID Number	String	Tax_ID_Number	11
6	TXDTLBSE	Tax Detail Base	Integer	DDL_Tax_Detail_Base	0
7	TXDTLPCT	Tax Detail Percent	Currency	DLR7_%5S	7
8	TXDTLAMT	Tax Detail Amount	Currency	DLR11_$U5	11
9	TDTLRNDG	Tax Detail Rounding	Integer	DDL_Tax_Detail_Rounding	0
10	TXDBODTL	Tax Detail Based On Detail ID	String	STR15_LBAU	15
11	TDTABMIN	Tax Detail Taxable Minimum	Currency	DLR19_RBS0_UTR$	19
12	TDTABMAX	Tax Detail Taxable Maximum	Currency	DLR19_RBS0_UTR$	19
13	TDTAXMIN	Tax Detail Tax Minimum	Currency	DLR19_RBS0_UTR$	19
14	TDTAXMAX	Tax Detail Tax Maximum	Currency	DLR19_RBS0_UTR$	19
15	TDRNGTYP	Tax Detail Range Type	Integer	DDL_Tax_Detail_Range_Type	0
16	TXDTQUAL	Tax Detail Base Qualifiers	Integer	DDL	0
17	TDTAXTAX	Tax Detail Taxable Tax	Boolean	CB_Taxable_Tax	0
18	TXDTLPDC	Tax Detail Print on Documents	Boolean	CB_Print_on_Documents	0
19	TXDTLPCH	Tax Detail Print Character	String	STR1	1
20	TXDXDISC	Tax Detail Exclude Discounts	Boolean	CB_Exclude_Discounts	0
21	CMNYTXID	Company Tax ID	String	STR15	15
22	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Sales/Purchases Tax Master'].NOTEINDX AS 'Sales/Purchases Tax Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM TX00201 AS ['Sales/Purchases Tax Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Sales/Purchases Tax Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
23	NAME	Name	String	STR30	30
24	CNTCPRSN	Contact Person	String	STR60	60
25	ADDRESS1	Address 1	String	STR60	60
26	ADDRESS2	Address 2	String	STR60	60
27	ADDRESS3	Address 3	String	STR60	60
28	CITY	City	String	STR35	35
29	STATE	State	String	STR30_State	29
30	ZIPCODE	Zip Code	String	STR10	10
31	COUNTRY	Country	String	STR60	60
32	PHONE1	Phone 1	String	Phone_Number	14
33	PHONE2	Phone 2	String	Phone_Number	14
34	PHONE3	Phone 3	String	Phone_Number3	14
35	FAX	Fax	String	STR14_FAX	14
36	TXUSRDF1	Tax User Defined 1	String	Tax User Defined1	20
37	TXUSRDF2	Tax User Defined 2	String	Tax User Defined2	20
38	VATREGTX	VAT Register Tax	Boolean	CB_VAT_Register_Tax	0
39	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
40	TaxPostToAcct	Tax Post To Account	Integer	DDL_Tax_Post_To_Account	0
41	TaxBoxes	Tax Boxes	Long Integer	ML_Tax_Boxes	0
42	IGNRGRSSAMNT	Ignore Gross Amount	Boolean	CB_Ignore_Gross_Amount	0
43	TDTABPCT	Tax Detail Taxable Percent	Currency	DLR5_%2	8

azurecurve Products Microsoft Dynamics GP (0)CompanySales/Purchases Tax Master (TX00201)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply