Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00102
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Sales/Purchases Tax Schedule Master Group Display Name: Sales/Purchases Tax Master
Physical Name: TX00102
Technical Name: TX_Schedule_MSTR
Group Technical Name: Sales/Purchases Tax Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | TAXSCHID  | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['Sales/Purchases Tax Schedule Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Master-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
TX00102 AS ['Sales/Purchases Tax Schedule Master']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Sales/Purchases Tax Schedule Master'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 2 | 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 Schedule Master'].TAXDTLID AS 'Sales/Purchases Tax Schedule Master-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX00102 AS ['Sales/Purchases Tax Schedule Master']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Sales/Purchases Tax Schedule Master'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 3 | TXDTLBSE | Tax Detail Base | Integer | DDL_Tax_Detail_Base | 0 | |
| 4 | TDTAXTAX | Tax Detail Taxable Tax | Boolean | CB_Taxable_Tax | 0 | |
| 5 | Auto_Calculate | Auto Calculate | Boolean | CB | 0 | |