SmartList Tax History (ASIEXP29)

azurecurveProductsSmartList (1493)PathnameSmartList Tax History (ASIEXP29)

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_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
2ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
3ASI_Document_Status SearchASI_Document_StatusIntegerINT0
4DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
5DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
6SERIES SearchSeriesIntegerDDL_Series0
7RCTRXSEQ SearchRecurring TRX SequenceCurrencyDLR19_$S219
8SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10
9TAXDTLID SearchTax Detail IDStringSTR15_Tax_Detail_ID15
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'].TAXDTLID
10TXDTLPCT SearchTax Detail PercentCurrencyDLR7_%5S7
11TXDTLAMT SearchTax Detail AmountCurrencyDLR11_$U511
12ACTINDX SearchAccount IndexLong IntegerLI_1414
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'].ACTINDX
13DOCDATE SearchDocument DateDateDT8
14Tax_Date SearchTax DateDateDT8
15PSTGDATE SearchPosting DateDateDT8
16TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
17ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
18Taxable_Amount SearchTaxable AmountCurrencyDLR19_RBS0_UTR$19
19Originating_Taxable_Amt SearchOriginating Taxable AmountCurrencyDLR19_RBS0_UTR$19
20DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
21ORDOCAMT SearchOriginating Document AmountCurrencyDLR17_RBS0_STR$17
22ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
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.
23VOIDSTTS SearchVoid StatusIntegerINT0
24CustomerVendor_ID SearchCustomer/Vendor IDStringSTR1515
25CURRNIDX SearchCurrency IndexIntegerINT33
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'].CURRNIDX
26Included_On_Return SearchIncluded On ReturnBooleanBoolean0
27Tax_Return_ID SearchTax Return IDStringSTR20_LBAU20
28TXORGN SearchTax OriginIntegerINT33
29TXDTLTYP SearchTax Detail TypeIntegerDDL_Tax_Detail_Type0
30TXDTLDSC SearchTax Detail DescriptionStringSTR3030
31TXDTLBSE SearchTax Detail BaseIntegerDDL_Tax_Detail_Base0
32TXDETPCTAMT SearchTax Detail Percent/AmountStringSTR1515
33CustomerVendor_Name SearchCustomer/Vendor NameStringSTR6464
34ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1StringAccount_Segment_Pool16
35ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2StringAccount_Segment_Pool26
36ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3StringAccount_Segment_Pool36
37ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4StringAccount_Segment_Pool46
38ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5StringAccount_Segment_Pool56
39ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6StringAccount_Segment_Pool66
40ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7StringAccount_Segment_Pool76
41ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8StringAccount_Segment_Pool86
42ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9StringAccount_Segment_Pool96
43ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10StringAccount_Segment_Pool106
azurecurveProductsSmartList (1493)PathnameSmartList Tax History (ASIEXP29)

Leave a Reply

Your email address will not be published. Required fields are marked *