ASIEXP28 - SmartList Purchasing Receipt Lines
Dynamics GP table ASIEXP28 (SmartList Purchasing Receipt Lines) contains 77 columns including ASI_Favorite_Sequence, ASI_Order_By, ASI_Document_Status....
SQL Query Builder
77 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 | ||
| POPRCTNM | POP Receipt Number | String | 18 | ||
| RCPTLNNM | Receipt Line Number | Long Integer | 4 | ||
| PONUMBER | PO Number | String | 18 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| ITEMDESC | Item Description | String | 102 | ||
| VNDITNUM | Vendor Item Number | String | 32 | ||
| VNDITDSC | Vendor Item Description | String | 102 | ||
| UMQTYINB | U Of M QTY In Base | Currency | 10 | ||
| ACTLSHIP | Actual Ship Date | Date | 4 | ||
| COMMNTID | Comment ID | String | 16 | ||
| INVINDX | Inventory Index | Long Integer | 4 | ||
| UOFM | U Of M | String | 10 | ||
| UNITCOST | Unit Cost | Currency | 10 | ||
| EXTDCOST | Extended Cost | Currency | 10 | ||
| LOCNCODE | Location Code | String | 12 | ||
| NONINVEN | Non IV | Integer | 2 | ||
| DECPLCUR | Decimal Places Currency | Integer | 2 | ||
| DECPLQTY | Decimal Places QTYS | Integer | 2 | ||
| ITMTRKOP | Item Tracking Option1. None2. Serial Numbers3. Lot Numbers | Integer | 2 | ||
Item Tracking Option values (3) 1 = None2 = Serial Numbers3 = Lot Numbers | |||||
| TRXSORCE | TRX Source | String | 14 | ||
| JOBNUMBR | Job Number | String | 18 | ||
| COSTCODE | Cost Code | String | 28 | ||
| COSTTYPE | Cost Code Type | Integer | 2 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| RATECALC | Rate Calc Method | Integer | 2 | ||
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | ||
| ORUNTCST | Originating Unit Cost | Currency | 10 | ||
| OREXTCST | Originating Extended Cost | Currency | 10 | ||
| ODECPLCU | Originating Decimal Places Currency | Integer | 2 | ||
| BOLPRONUMBER | BOL_PRO Number | String | 32 | ||
| Capital_Item | Capital Item | Boolean | 2 | ||
| Product_Indicator | Product Indicator | Integer | 2 | ||
| Purchase_IV_Item_Taxable | Purchase IV Item Taxable1 – Taxable2 – Nontaxable3 – Base on Vendor | Integer | 2 | ||
| Purchase_Item_Tax_Schedu | Purchase Item Tax Schedule ID | String | 16 | ||
| Purchase_Site_Tax_Schedu | Purchase Site Tax Schedule ID | String | 16 | ||
| BSIVCTTL | Based On Invoice Total | Boolean | 2 | ||
| TAXAMNT | Tax Amount | Currency | 10 | ||
| ORTAXAMT | Originating Tax Amount | Currency | 10 | ||
| BKTPURAM | Backout Purchases Amount | Currency | 10 | ||
| OBKPURAMT | Originating Backout Purchases Amount | Currency | 10 | ||
| Revalue_Inventory | Revalue Inventory | Boolean | 2 | ||
| PURPVIDX | Purchase Price Variance Index | 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 | |||||
| POPTYPE | POP Type | Integer | 2 | ||
| VENDORID | Vendor ID | String | 16 | ||
| VENDNAME | Vendor Name | String | 66 | ||
| VNDDOCNM | Vendor Document Number | String | 22 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| receiptdate | Receipt Date | Date | 4 | ||
| BCHSOURC | Batch Source | String | 16 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| USER2ENT | User To Enter | String | 16 | ||
| CREATDDT | Created Date | Date | 4 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| Tax_Date | Tax Date | Date | 4 | ||
| QTYSHPPD | QTY Shipped | Currency | 10 | ||
| QTYINVCD | QTY Invoiced | Currency | 10 | ||
| QTYREJ | QTY Rejected | Currency | 10 | ||
| Landed_Cost_Group_ID | Landed Cost Group ID | String | 16 | ||
| Landed_Cost | Landed Cost | Boolean | 2 | ||
| RCPTRETNUM | Receipt Return Number | String | 18 | ||
| INVRETNUM | Invoice Return Number | String | 18 | ||
| BIN | Bin | String | 16 | ||
| Total_Landed_Cost_Amount | Total Landed Cost Amount | Currency | 10 | ||
| QTYRESERVED | QTY Reserved | Currency | 10 | ||
| QTYINVRESERVE | QTY Invoice Reserve | Currency | 10 | ||
| UMSCHDSC | U Of M Schedule Description | String | 32 | ||
| QTYMATCH | QTY Matched | Currency | 10 | ||
| ProjNum | Project Number | String | 16 | ||
| CostCatID | Cost Category ID | String | 16 | ||
Related Tables
Tables that share columns with ASIEXP28. Click "Join" to add to your query.