ASIEXP14 - ASI_MDA_SmartList
Dynamics GP table ASIEXP14 (ASI_MDA_SmartList) contains 23 columns including ASI_Order_By, ACTINDX, CODEAMT....
SQL Query Builder
23 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ASI_Order_By | ASI_Order_By | Long Integer | 4 | ||
| 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 | ||
| CODEAMT | DTA_Amount | Currency | 10 | ||
| CODEID | DTA_Code_ID | String | 16 | ||
| GROUPID | DTA_Group_ID | String | 16 | ||
| POSTDESC | DTA_Posting_Descr | String | 52 | ||
| DTAQNTY | DTA_Quantity | Currency | 10 | ||
| DTAREF | DTA_Reference | String | 26 | ||
| DTASERIES | DTA_Series | Integer | 2 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
| TRXDATE | TRX Date | Date | 4 | ||
| DTA_GL_Reference | DTA_GL_Reference | String | 26 | ||
| GROUPAMT | DTA_Group_Amount | Currency | 10 | ||
| JRNENTRY | Journal Entry | Long Integer | 4 | ||
| PSTGSTUS | Posting Status1 = Work2 = Open3 = History4 = Originating | Integer | 2 | ||
Posting Status values (11) 0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch | |||||
| 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 | ||
| ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | 4 | ||
Related Tables
Tables that share columns with ASIEXP14. Click "Join" to add to your query.