ASIEXP26 - SmartList Invoicing Transaction Amounts Work
Dynamics GP table ASIEXP26 (SmartList Invoicing Transaction Amounts Work) contains 62 columns including ASI_Favorite_Sequence, ASI_Order_By, ASI_Document_Status....
SQL Query Builder
62 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 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| INVCNMBR | Invoice Number | String | 22 | ||
| LNITMSEQ | Line Item Sequence | Long Integer | 4 | ||
| CMPNTSEQ | Component Sequence | Long Integer | 4 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| DECPLCUR | Decimal Places Currency | Integer | 2 | ||
| DECPLQTY | Decimal Places QTYS | Integer | 2 | ||
| INVINDX | Inventory Index | Long Integer | 4 | ||
| CSLSINDX | Cost Of Sales Index | Long Integer | 4 | ||
| SLSINDX | Sales Index | Long Integer | 4 | ||
| MKDNINDX | Markdown Index | Long Integer | 4 | ||
| RTNSINDX | Returns Index | Long Integer | 4 | ||
| INUSINDX | In Use Index | Long Integer | 4 | ||
| INSRINDX | In Service Index | Long Integer | 4 | ||
| DMGDINDX | Damaged Index | Long Integer | 4 | ||
| ITMTSHID | Item Tax Schedule ID | String | 16 | ||
| IVITMTXB | IV Item Taxable | Integer | 2 | ||
| NONINVEN | Non IV | Integer | 2 | ||
| QUANTITY | QTY | Currency | 10 | ||
| QTYINSVC | QTY In Service | Currency | 10 | ||
| QTYINUSE | QTY In Use | Currency | 10 | ||
| QTYDMGED | QTY Damaged | Currency | 10 | ||
| QTYRTRND | QTY Returned | Currency | 10 | ||
| QTYONHND | QTY On Hand | Currency | 10 | ||
| EXTQTYSEL | Existing Qty Selected | Currency | 10 | ||
| UOFM | U Of M | String | 10 | ||
| QTYBSUOM | QTY In Base U Of M | Currency | 10 | ||
| UNITCOST | Unit Cost | Currency | 10 | ||
| EXTDCOST | Extended Cost | Currency | 10 | ||
| DISCSALE | Discount Available Sales | Currency | 10 | ||
| TRDISAMT | Trade Discount Amount | Currency | 10 | ||
| ATYALLOC | QTY Allocated | Currency | 10 | ||
| LOCNCODE | Location Code | String | 12 | ||
| MRKDNTYP | Markdown Type | Integer | 2 | ||
| MRKDNAMT | Markdown Amount | Currency | 10 | ||
| MRKDNPCT | Markdown Percent | Integer | 2 | ||
| PRCLEVEL | PriceLevel | String | 12 | ||
| XTNDPRCE | Extended Price | Currency | 10 | ||
| UNITPRCE | Unit Price | Currency | 10 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| BKTSLSAM | Backout Sales Amount | Currency | 10 | ||
| TXBTXAMT | Taxable Tax Amount | Currency | 10 | ||
| BSIVCTTL | Based On Invoice Total | Boolean | 2 | ||
| SLPRSNID | Salesperson ID | String | 16 | ||
| SALSTERR | Sales Territory | String | 16 | ||
| DSCRIPTN | Description | String | 32 | ||
| ITEMDESC | Item Description | String | 102 | ||
| EXPTSHIP | Expected Ship Date | Date | 4 | ||
| ACTLSHIP | Actual Ship Date | Date | 4 | ||
| ReqShipDate | Requested Ship Date | Date | 4 | ||
| COMDLRAM | Commission Dollar Amount | Currency | 10 | ||
| CMPSERNM | Component Serial Numbered | Boolean | 2 | ||
| COMMNTID | Comment ID | String | 16 | ||
| BRKFLD1 | Break Field 1 | Integer | 2 | ||
| BRKFLD2 | Break Field 2 | Integer | 2 | ||
| BRKFLD3 | Break Field 3 | Integer | 2 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| IVCLINEERR | IVC LINE Errors | Long Integer | 4 | ||
| ASI_Customer_Number | ASI_Customer_Number | String | 16 | ||
Related Tables
Tables that share columns with ASIEXP26. Click "Join" to add to your query.