Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP29
Product: SmartList (1493)
Series:
Display Name: SmartList Tax History
Physical Name: ASIEXP29
Technical Name: ASI_taxHistory_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 2 ASI_Order_By ASI_Order_By Long Integer LI_14 14 3 ASI_Document_Status ASI_Document_Status Integer INT 0 4 DOCNUMBR Document Number String STR20_Document_Number 20 5 DOCTYPE Document Type Integer DDL_Document_Type 0 6 SERIES Series Integer DDL_Series 0 7 RCTRXSEQ Recurring TRX Sequence Currency DLR19_$S2 19 8 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 9 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['SmartList Tax History'].TAXDTLID AS 'SmartList Tax History-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
ASIEXP29 AS ['SmartList Tax History']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['SmartList Tax History'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID10 TXDTLPCT Tax Detail Percent Currency DLR7_%5S 7 11 TXDTLAMT Tax Detail Amount Currency DLR11_$U5 11 12 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Tax History'].ACTINDX AS 'SmartList Tax History-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP29 AS ['SmartList Tax History']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Tax History'].ACTINDX = ['Account Index Master'].ACTINDX13 DOCDATE Document Date Date DT 8 14 Tax_Date Tax Date Date DT 8 15 PSTGDATE Posting Date Date DT 8 16 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 17 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 18 Taxable_Amount Taxable Amount Currency DLR19_RBS0_UTR$ 19 19 Originating_Taxable_Amt Originating Taxable Amount Currency DLR19_RBS0_UTR$ 19 20 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 21 ORDOCAMT Originating Document Amount Currency DLR17_RBS0_STR$ 17 22 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.23 VOIDSTTS Void Status Integer INT 0 24 CustomerVendor_ID Customer/Vendor ID String STR15 15 25 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Tax History'].CURRNIDX AS 'SmartList Tax History-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP29 AS ['SmartList Tax History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Tax History'].CURRNIDX = ['Currency Setup'].CURRNIDX26 Included_On_Return Included On Return Boolean Boolean 0 27 Tax_Return_ID Tax Return ID String STR20_LBAU 20 28 TXORGN Tax Origin Integer INT3 3 29 TXDTLTYP Tax Detail Type Integer DDL_Tax_Detail_Type 0 30 TXDTLDSC Tax Detail Description String STR30 30 31 TXDTLBSE Tax Detail Base Integer DDL_Tax_Detail_Base 0 32 TXDETPCTAMT Tax Detail Percent/Amount String STR15 15 33 CustomerVendor_Name Customer/Vendor Name String STR64 64 34 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 35 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 36 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 37 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 38 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 39 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 40 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 41 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 42 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 43 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6