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 TypeLength
1TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
2TXDTLDSC SearchTax Detail DescriptionSTR30String30
3TXDTLTYP SearchTax Detail TypeDDL_Tax_Detail_TypeInteger0
4ACTINDX SearchAccount IndexLI_14Long Integer14
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_NumberString11
6TXDTLBSE SearchTax Detail BaseDDL_Tax_Detail_BaseInteger0
7TXDTLPCT SearchTax Detail PercentDLR7_%5SCurrency7
8TXDTLAMT SearchTax Detail AmountDLR11_$U5Currency11
9TDTLRNDG SearchTax Detail RoundingDDL_Tax_Detail_RoundingInteger0
10TXDBODTL SearchTax Detail Based On Detail IDSTR15_LBAUString15
11TDTABMIN SearchTax Detail Taxable MinimumDLR19_RBS0_UTR$Currency19
12TDTABMAX SearchTax Detail Taxable MaximumDLR19_RBS0_UTR$Currency19
13TDTAXMIN SearchTax Detail Tax MinimumDLR19_RBS0_UTR$Currency19
14TDTAXMAX SearchTax Detail Tax MaximumDLR19_RBS0_UTR$Currency19
15TDRNGTYP SearchTax Detail Range TypeDDL_Tax_Detail_Range_TypeInteger0
16TXDTQUAL SearchTax Detail Base QualifiersDDLInteger0
17TDTAXTAX SearchTax Detail Taxable TaxCB_Taxable_TaxBoolean0
18TXDTLPDC SearchTax Detail Print on DocumentsCB_Print_on_DocumentsBoolean0
19TXDTLPCH SearchTax Detail Print CharacterSTR1String1
20TXDXDISC SearchTax Detail Exclude DiscountsCB_Exclude_DiscountsBoolean0
21CMNYTXID SearchCompany Tax IDSTR15String15
22NOTEINDX SearchNote IndexDLR14Currency14
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 SearchNameSTR30String30
24CNTCPRSN SearchContact PersonSTR60String60
25ADDRESS1 SearchAddress 1STR60String60
26ADDRESS2 SearchAddress 2STR60String60
27ADDRESS3 SearchAddress 3STR60String60
28CITY SearchCitySTR35String35
29STATE SearchStateSTR30_StateString29
30ZIPCODE SearchZip CodeSTR10String10
31COUNTRY SearchCountrySTR60String60
32PHONE1 SearchPhone 1Phone_NumberString14
33PHONE2 SearchPhone 2Phone_NumberString14
34PHONE3 SearchPhone 3Phone_Number3String14
35FAX SearchFaxSTR14_FAXString14
36TXUSRDF1 SearchTax User Defined 1Tax User Defined1String20
37TXUSRDF2 SearchTax User Defined 2Tax User Defined2String20
38VATREGTX SearchVAT Register TaxCB_VAT_Register_TaxBoolean0
39TaxInvReqd SearchTax Invoice RequiredCB_Tax_Invoice_RequiredBoolean0
40TaxPostToAcct SearchTax Post To AccountDDL_Tax_Post_To_AccountInteger0
41TaxBoxes SearchTax BoxesML_Tax_BoxesLong Integer0
42IGNRGRSSAMNT SearchIgnore Gross AmountCB_Ignore_Gross_AmountBoolean0
43TDTABPCT SearchTax Detail Taxable PercentDLR5_%2Currency8
44DEX_ROW_ID Searchintint10

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 *