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
Physical Name: TX20500
Technical Name: taxRebateSeq 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 APFRDCNM Apply From Document Number String STR20_Document_Number 20 4 APFRDCTY Apply From Document Type Integer INT2 2 5 SERIES Series Integer DDL_Series 0 6 TaxRebateType TaxRebateType Integer INT2 2 7 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 8 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 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'].TAXDTLID9 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 10 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 11 Taxable_Amount Taxable Amount Currency DLR19_RBS0_UTR$ 19 12 Originating_Taxable_Amt Originating Taxable Amount Currency DLR19_RBS0_UTR$ 19 13 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 14 ORDOCAMT Originating Document Amount Currency DLR17_RBS0_STR$ 17 15 ACTINDX Account Index Long Integer LI_14 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'].ACTINDX16 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.17 TRXSORCE TRX Source String STR13 13 18 POSTED Posted Boolean True/False 0 19 CustomerVendor_ID Customer/Vendor ID String STR15 15 20 DOCDATE Document Date Date DT 8 21 Tax_Date Tax Date Date DT 8 22 PSTGDATE Posting Date Date DT 8 23 CURRNIDX Currency Index Integer INT3 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