Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX20500
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: Tax Rebate DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: TX20500
Technical Name: taxRebateSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 DOCNUMBR Document Number STR20_Document_Number String 22 20 2 DOCTYPE Document Type DDL_Document_Type Integer 2 0 3 APFRDCNM Apply From Document Number STR20_Document_Number String 22 20 4 APFRDCTY Apply From Document Type INT2 Integer 2 2 5 SERIES Series DDL_Series Integer 2 0 6 TaxRebateType TaxRebateType INT2 Integer 2 2 7 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 4 10 8 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 16 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['Tax Rebate'].TAXDTLID AS 'Tax Rebate-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX20500 AS ['Tax Rebate']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Tax Rebate'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
9 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 10 17 10 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 10 17 11 Taxable_Amount Taxable Amount DLR19_RBS0_UTR$ Currency 10 19 12 Originating_Taxable_Amt Originating Taxable Amount DLR19_RBS0_UTR$ Currency 10 19 13 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 10 19 14 ORDOCAMT Originating Document Amount DLR17_RBS0_STR$ Currency 10 17 15 ACTINDX Account Index LI_14 Long Integer 4 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Tax Rebate'].ACTINDX AS 'Tax Rebate-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
TX20500 AS ['Tax Rebate']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Tax Rebate'].ACTINDX = ['Account Index Master'].ACTINDX
16 ECTRX EC Transaction CB_EC_Transaction Boolean 2 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.
17 TRXSORCE TRX Source STR13 String 14 13 18 POSTED Posted True/False Boolean 2 0 19 CustomerVendor_ID Customer/Vendor ID STR15 String 16 15 20 DOCDATE Document Date DT Date 4 8 21 Tax_Date Tax Date DT Date 4 8 22 PSTGDATE Posting Date DT Date 4 8 23 CURRNIDX Currency Index INT3 Integer 2 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Tax Rebate'].CURRNIDX AS 'Tax Rebate-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
TX20500 AS ['Tax Rebate']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Tax Rebate'].CURRNIDX = ['Currency Setup'].CURRNIDX
24 DEX_ROW_ID int int 10 10