Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00202
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Sales/Purchases Tax Summary Master Group Display Name: Sales/Purchases Tax Master
Physical Name: TX00202
Technical Name: TX_Detail_MSTR_SUM
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 | |
Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hideSELECT
['Sales/Purchases Tax Summary Master'].TAXDTLID AS 'Sales/Purchases Tax Summary Master-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX00202 AS ['Sales/Purchases Tax Summary Master']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Sales/Purchases Tax Summary Master'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 2 | TDTSYTD | Tax Detail Total Sales YTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 3 | TDSLLYTD | Tax Detail Total Sales LYTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 4 | TXDTSYTD | Tax Detail Taxable Sales YTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 5 | TDTSLYTD | Tax Detail Taxable Sales LYTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 6 | TXDSTYTD | Tax Detail Sales Taxes YTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 7 | TDSTLYTD | Tax Detail Sales Taxes LYTD | Currency | DLR19_RBS0_UTR$ | 19 | |
| 8 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 | |
| 9 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 | |