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: Pathname

Display Name: SmartList Tax History
Physical Name: ASIEXP29
Technical Name: ASI_taxHistory_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3ASI_Document_Status SearchASI_Document_StatusINTInteger20
4DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
5DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
6SERIES SearchSeriesDDL_SeriesInteger20
7RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency1019
8SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
9TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
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 PercentDLR7_%5SCurrency107
11TXDTLAMT SearchTax Detail AmountDLR11_$U5Currency1011
12ACTINDX SearchAccount IndexLI_14Long Integer414
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 DateDTDate48
14Tax_Date SearchTax DateDTDate48
15PSTGDATE SearchPosting DateDTDate48
16TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
17ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency1017
18Taxable_Amount SearchTaxable AmountDLR19_RBS0_UTR$Currency1019
19Originating_Taxable_Amt SearchOriginating Taxable AmountDLR19_RBS0_UTR$Currency1019
20DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
21ORDOCAMT SearchOriginating Document AmountDLR17_RBS0_STR$Currency1017
22ECTRX SearchEC TransactionCB_EC_TransactionBoolean20
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 StatusINTInteger20
24CustomerVendor_ID SearchCustomer/Vendor IDSTR15String1615
25CURRNIDX SearchCurrency IndexINT3Integer23
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 ReturnBooleanBoolean20
27Tax_Return_ID SearchTax Return IDSTR20_LBAUString2220
28TXORGN SearchTax OriginINT3Integer23
29TXDTLTYP SearchTax Detail TypeDDL_Tax_Detail_TypeInteger20
30TXDTLDSC SearchTax Detail DescriptionSTR30String3230
31TXDTLBSE SearchTax Detail BaseDDL_Tax_Detail_BaseInteger20
32TXDETPCTAMT SearchTax Detail Percent/AmountSTR15String1615
33CustomerVendor_Name SearchCustomer/Vendor NameSTR64String6664
34ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
35ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
36ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
37ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
38ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
39ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
40ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
41ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
42ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
43ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
azurecurveProductsSmartList (1493)PathnameSmartList Tax History (ASIEXP29)

Leave a Reply

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