ASIEXP29 - SmartList Tax History
Dynamics GP table ASIEXP29 (SmartList Tax History) contains 38 columns including ASI_Favorite_Sequence, ASI_Order_By, ASI_Document_Status....
SQL Query Builder
38 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | 4 | ||
| ASI_Order_By | ASI_Order_By | Long Integer | 4 | ||
| ASI_Document_Status | ASI_Document_Status | Integer | 2 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| SERIES | Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project | Integer | 2 | ||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
| RCTRXSEQ | Recurring TRX Sequence | Currency | 10 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| TAXDTLID | Tax Detail ID | String | 16 | ||
| TXDTLPCT | Tax Detail Percent | Currency | 10 | ||
| TXDTLAMT | Tax Detail Amount | Currency | 10 | ||
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | ||
| DOCDATE | Document Date | Date | 4 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| PSTGDATE | Posting Date | Date | 4 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| ORTAXAMT | Originating Tax Amount | Currency | 10 | ||
| Taxable_Amount | Taxable Amount | Currency | 10 | ||
| Originating_Taxable_Amt | Originating Taxable Amount | Currency | 10 | ||
| DOCAMNT | Document Amount | Currency | 10 | ||
| ORDOCAMT | Originating Document Amount | Currency | 10 | ||
| ECTRX | EC Transaction | Boolean | 2 | ||
| VOIDSTTS | Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. | Integer | 2 | ||
Void Status values (2) 0 = Normal1 = Voided | |||||
| CustomerVendor_ID | Customer/Vendor ID | String | 16 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| Included_On_Return | Included On Return | Boolean | 2 | ||
| Tax_Return_ID | Tax Return ID | String | 22 | ||
| TXORGN | Tax Origin | Integer | 2 | ||
| TXDTLTYP | Tax Detail Type | Integer | 2 | ||
| TXDTLDSC | Tax Detail Description | String | 32 | ||
| TXDTLBSE | Tax Detail Base | Integer | 2 | ||
| TXDETPCTAMT | Tax Detail Percent/Amount | String | 16 | ||
| CustomerVendor_Name | Customer/Vendor Name | String | 66 | ||
| ACTNUMBR_1 | Account Number:Account_Segment_Pool1 | String | 10 | ||
| ACTNUMBR_2 | Account Number:Account_Segment_Pool2 | String | 10 | ||
| ACTNUMBR_3 | Account Number:Account_Segment_Pool3 | String | 10 | ||
| ACTNUMBR_4 | Account Number:Account_Segment_Pool4 | String | 10 | ||
| ACTNUMBR_5 | Account Number:Account_Segment_Pool5 | String | 10 | ||
Related Tables
Tables that share columns with ASIEXP29. Click "Join" to add to your query.