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 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 | ||||||
| 10 | 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 | ||||||
| 13 | 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 | ||||||
| 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 | ||||||
| 26 | 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 | |