Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX30000
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Tax History Group Display Name: Tax Transactions
Physical Name: TX30000
Technical Name: taxHistory
Group Technical Name: Tax Transactions
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | DOCNUMBR  | Document Number | String | STR20_Document_Number | 20 | |
| 2 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
| 3 | SERIES | Series | Integer | DDL_Series | 0 | |
| 4 | RCTRXSEQ | Recurring TRX Sequence | Currency | DLR19_$S2 | 19 | |
| 5 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
| 6 | TAXDTLID | Tax Detail ID | String | STR15_Tax_Detail_ID | 15 | |
Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hideSELECT
['Tax History'].TAXDTLID AS 'Tax History-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX30000 AS ['Tax History']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Tax History'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID | ||||||
| 7 | TXDTLPCT | Tax Detail Percent | Currency | DLR7_%5S | 7 | |
| 8 | TXDTLAMT | Tax Detail Amount | Currency | DLR11_$U5 | 11 | |
| 9 | ACTINDX | Account Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['Tax History'].ACTINDX AS 'Tax History-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
TX30000 AS ['Tax History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Tax History'].ACTINDX = ['Account Index Master'].ACTINDX | ||||||
| 10 | DOCDATE | Document Date | Date | DT | 8 | |
| 11 | Tax_Date | Tax Date | Date | DT | 8 | |
| 12 | PSTGDATE | Posting Date | Date | DT | 8 | |
| 13 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 14 | ORTAXAMT | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 15 | Taxable_Amount | Taxable Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 16 | Originating_Taxable_Amt | Originating Taxable Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 17 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 18 | ORDOCAMT | Originating Document Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 19 | ECTRX | EC Transaction | Boolean | CB_EC_Transaction | 0 | |
The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction. | ||||||
| 20 | VOIDSTTS | Void Status | Integer | INT | 0 | |
| 21 | CustomerVendor_ID | Customer/Vendor ID | String | STR15 | 15 | |
| 22 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['Tax History'].CURRNIDX AS 'Tax History-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
TX30000 AS ['Tax History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Tax History'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 23 | Included_On_Return | Included On Return | Boolean | Boolean | 0 | |
| 24 | Tax_Return_ID | Tax Return ID | String | STR20_LBAU | 20 | |
| 25 | TXORGN | Tax Origin | Integer | INT3 | 3 | |
| 26 | TXDTLTYP | Tax Detail Type | Integer | DDL_Tax_Detail_Type | 0 | |
| 27 | TRXSTATS | Trx Status | String | STR1 | 1 | |
| 28 | RETNUM | Return Number | String | STR16_LBAU | 16 | |
| 29 | YEAR1 | Year | Integer | Year | 4 | |
| 30 | INVATRET | Included On VAT Return | Boolean | Boolean | 0 | |
| 31 | VATCOLCD | Vat Column Code | String | STR3_LBAU | 3 | |
| 32 | VATRPTID | Vat Daybook Report ID | String | STR8_LBAU | 8 | |
| 33 | Revision_Number | Revision Number | Integer | INT4 | 4 | |
| 34 | PERIODID | Period ID | Integer | INT3 | 3 | |
| 35 | ISGLTRX | IsGLTax | Boolean | CB | 0 | |