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 IDStringSTR15_Tax_Detail_ID15
2TXDTLDSC SearchTax Detail DescriptionStringSTR3030
3TXDTLTYP SearchTax Detail TypeIntegerDDL_Tax_Detail_Type0
4ACTINDX SearchAccount IndexLong IntegerLI_1414
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 NumberStringTax_ID_Number11
6TXDTLBSE SearchTax Detail BaseIntegerDDL_Tax_Detail_Base0
7TXDTLPCT SearchTax Detail PercentCurrencyDLR7_%5S7
8TXDTLAMT SearchTax Detail AmountCurrencyDLR11_$U511
9TDTLRNDG SearchTax Detail RoundingIntegerDDL_Tax_Detail_Rounding0
10TXDBODTL SearchTax Detail Based On Detail IDStringSTR15_LBAU15
11TDTABMIN SearchTax Detail Taxable MinimumCurrencyDLR19_RBS0_UTR$19
12TDTABMAX SearchTax Detail Taxable MaximumCurrencyDLR19_RBS0_UTR$19
13TDTAXMIN SearchTax Detail Tax MinimumCurrencyDLR19_RBS0_UTR$19
14TDTAXMAX SearchTax Detail Tax MaximumCurrencyDLR19_RBS0_UTR$19
15TDRNGTYP SearchTax Detail Range TypeIntegerDDL_Tax_Detail_Range_Type0
16TXDTQUAL SearchTax Detail Base QualifiersIntegerDDL0
17TDTAXTAX SearchTax Detail Taxable TaxBooleanCB_Taxable_Tax0
18TXDTLPDC SearchTax Detail Print on DocumentsBooleanCB_Print_on_Documents0
19TXDTLPCH SearchTax Detail Print CharacterStringSTR11
20TXDXDISC SearchTax Detail Exclude DiscountsBooleanCB_Exclude_Discounts0
21CMNYTXID SearchCompany Tax IDStringSTR1515
22NOTEINDX SearchNote IndexCurrencyDLR1414
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 SearchNameStringSTR3030
24CNTCPRSN SearchContact PersonStringSTR6060
25ADDRESS1 SearchAddress 1StringSTR6060
26ADDRESS2 SearchAddress 2StringSTR6060
27ADDRESS3 SearchAddress 3StringSTR6060
28CITY SearchCityStringSTR3535
29STATE SearchStateStringSTR30_State29
30ZIPCODE SearchZip CodeStringSTR1010
31COUNTRY SearchCountryStringSTR6060
32PHONE1 SearchPhone 1StringPhone_Number14
33PHONE2 SearchPhone 2StringPhone_Number14
34PHONE3 SearchPhone 3StringPhone_Number314
35FAX SearchFaxStringSTR14_FAX14
36TXUSRDF1 SearchTax User Defined 1StringTax User Defined120
37TXUSRDF2 SearchTax User Defined 2StringTax User Defined220
38VATREGTX SearchVAT Register TaxBooleanCB_VAT_Register_Tax0
39TaxInvReqd SearchTax Invoice RequiredBooleanCB_Tax_Invoice_Required0
40TaxPostToAcct SearchTax Post To AccountIntegerDDL_Tax_Post_To_Account0
41TaxBoxes SearchTax BoxesLong IntegerML_Tax_Boxes0
42IGNRGRSSAMNT SearchIgnore Gross AmountBooleanCB_Ignore_Gross_Amount0
43TDTABPCT SearchTax Detail Taxable PercentCurrencyDLR5_%28
azurecurveProductsMicrosoft Dynamics GP (0)CompanySales/Purchases Tax Master (TX00201)

Leave a Reply

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