Sales/Purchases Tax Master (TX00201)

azurecurveProductsMicrosoft 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
2TXDTLDSC SearchTax Detail DescriptionSTR30String3230
3TXDTLTYP SearchTax Detail TypeDDL_Tax_Detail_TypeInteger20
4ACTINDX SearchAccount IndexLI_14Long Integer414
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
5TXIDNMBR SearchTax ID NumberTax_ID_NumberString1211
6TXDTLBSE SearchTax Detail BaseDDL_Tax_Detail_BaseInteger20
7TXDTLPCT SearchTax Detail PercentDLR7_%5SCurrency107
8TXDTLAMT SearchTax Detail AmountDLR11_$U5Currency1011
9TDTLRNDG SearchTax Detail RoundingDDL_Tax_Detail_RoundingInteger20
10TXDBODTL SearchTax Detail Based On Detail IDSTR15_LBAUString1615
11TDTABMIN SearchTax Detail Taxable MinimumDLR19_RBS0_UTR$Currency1019
12TDTABMAX SearchTax Detail Taxable MaximumDLR19_RBS0_UTR$Currency1019
13TDTAXMIN SearchTax Detail Tax MinimumDLR19_RBS0_UTR$Currency1019
14TDTAXMAX SearchTax Detail Tax MaximumDLR19_RBS0_UTR$Currency1019
15TDRNGTYP SearchTax Detail Range TypeDDL_Tax_Detail_Range_TypeInteger20
16TXDTQUAL SearchTax Detail Base QualifiersDDLInteger20
17TDTAXTAX SearchTax Detail Taxable TaxCB_Taxable_TaxBoolean20
18TXDTLPDC SearchTax Detail Print on DocumentsCB_Print_on_DocumentsBoolean20
19TXDTLPCH SearchTax Detail Print CharacterSTR1String21
20TXDXDISC SearchTax Detail Exclude DiscountsCB_Exclude_DiscountsBoolean20
21CMNYTXID SearchCompany Tax IDSTR15String1615
22NOTEINDX SearchNote IndexDLR14Currency1014
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
23NAME SearchNameSTR30String3230
24CNTCPRSN SearchContact PersonSTR60String6260
25ADDRESS1 SearchAddress 1STR60String6260
26ADDRESS2 SearchAddress 2STR60String6260
27ADDRESS3 SearchAddress 3STR60String6260
28CITY SearchCitySTR35String3635
29STATE SearchStateSTR30_StateString3029
30ZIPCODE SearchZip CodeSTR10String1210
31COUNTRY SearchCountrySTR60String6260
32PHONE1 SearchPhone 1Phone_NumberString2214
33PHONE2 SearchPhone 2Phone_NumberString2214
34PHONE3 SearchPhone 3Phone_Number3String2214
35FAX SearchFaxSTR14_FAXString2214
36TXUSRDF1 SearchTax User Defined 1Tax User Defined1String2220
37TXUSRDF2 SearchTax User Defined 2Tax User Defined2String2220
38VATREGTX SearchVAT Register TaxCB_VAT_Register_TaxBoolean20
39TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean20
40TaxPostToAcct SearchTax Post To AccountDDL_Tax_Post_To_AccountInteger20
41TaxBoxes SearchTax BoxesML_Tax_BoxesLong Integer40
42IGNRGRSSAMNT SearchIgnore Gross AmountCB_Ignore_Gross_AmountBoolean20
43TDTABPCT SearchTax Detail Taxable PercentDLR5_%2Currency108
44DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)CompanySales/Purchases Tax Master (TX00201)

Leave a Reply

Your email address will not be published. Required fields are marked *