Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL10300
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: General Ledger Tax Work
Physical Name: GL10300
Technical Name: glTaxWorkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 JRNENTRY 
Journal Entry Long Integer LI8_U0 8 2 RCTRXSEQ Recurring TRX Sequence Currency DLR19_$S2 19 3 SQNCLINE Sequence Line Currency DLR19_$S2 19 4 SQNCLINE2 Sequence Line - 2 Currency DLR19_$S2 19 5 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['General Ledger Tax Work'].TAXDTLID AS 'General Ledger Tax Work-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
GL10300 AS ['General Ledger Tax Work']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['General Ledger Tax Work'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID6 DOCDATE Document Date Date DT 8 7 Tax_Date Tax Date Date DT 8 8 PSTGDATE Posting Date Date DT 8 9 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 TXDTLPCT Tax Detail Percent Currency DLR7_%5S 7 16 TXDTLAMT Tax Detail Amount Currency DLR11_$U5 11 17 TXDTLTYP Tax Detail Type Integer DDL_Tax_Detail_Type 0 18 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['General Ledger Tax Work'].ACTINDX AS 'General Ledger Tax Work-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GL10300 AS ['General Ledger Tax Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['General Ledger Tax Work'].ACTINDX = ['Account Index Master'].ACTINDX19 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['General Ledger Tax Work'].CURRNIDX AS 'General Ledger Tax Work-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
GL10300 AS ['General Ledger Tax Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['General Ledger Tax Work'].CURRNIDX = ['Currency Setup'].CURRNIDX