Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DET00100
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Date Effective Tax Rate Setup
Physical Name: DET00100
Technical Name: DET_Date_Effective_Tax_RateSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TAXDTLID 
Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['Date Effective Tax Rate Setup'].TAXDTLID AS 'Date Effective Tax Rate Setup-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
DET00100 AS ['Date Effective Tax Rate Setup']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Date Effective Tax Rate Setup'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID2 TXDTLDSC Tax Detail Description String STR30 30 3 TXDTLTYP Tax Detail Type Integer DDL_Tax_Detail_Type 0 4 TXDTLBSE Tax Detail Base Integer DDL_Tax_Detail_Base 0 5 STRTDATE Start Date Date DT 8 6 ENDDATE End Date Date DT 8 7 TXDTLPCT Tax Detail Percent Currency DLR7_%5S 7 8 TXDTLAMT Tax Detail Amount Currency DLR11_$U5 11 9 TaxBaseDescription Tax Base Description String STR50 50