Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00203
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Sales/Purchases Tax Period Summary Group Display Name: Sales/Purchases Tax Master
Physical Name: TX00203
Technical Name: TX_Detail_Period_SUM
Group Technical Name: Sales/Purchases Tax Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | HISTTYPE  | History Type | Integer | GB | 0 | |
| 2 | YEAR1 | Year | Integer | Year | 4 | |
| 3 | PERIODID | Period ID | Integer | INT3 | 3 | |
| 4 | 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 Period Summary'].TAXDTLID AS 'Sales/Purchases Tax Period Summary-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX00203 AS ['Sales/Purchases Tax Period Summary']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Sales/Purchases Tax Period Summary'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 5 | TDTSLPCH | Tax Detail Total Sales/Purchases | Currency | DLR19_RBS0_UTR$ | 19 | |
| 6 | TXDTTXSP | Tax Detail Total Taxable Sales/Purchases | Currency | DLR19_RBS0_UTR$ | 19 | |
| 7 | TXDTSPTX | Tax Detail Total Sales/Purchase Tax | Currency | DLR19_RBS0_UTR$ | 19 | |