Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP36
Product: SmartList (1493)
Series:
Display Name: ASI_IV_Purchase_Receipts_Explorer
Physical Name: ASIEXP36
Technical Name: ASI_IV_Purchase_Receipts_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 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hide | ||||||
| 4 | TRXLOCTN | TRX Location | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hide | ||||||
| 5 | DATERECD | Date Received | Date | DATE | 6 | |
| 6 | RCTSEQNM | Receipt SEQ Number | Long Integer | long | 8 | |
| 7 | RCPTSOLD | Receipt Sold | Boolean | YN | 0 | |
| 8 | QTYRECVD | QTY Received | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 9 | QTYSOLD | QTY Sold | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 10 | QTYCOMTD | QTY Committed | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 11 | QTYRESERVED | QTY Reserved | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 12 | FLRPLNDT | Floor Plan Date | Date | DATE | 6 | |
| 13 | PCHSRCTY | Purchase Receipt Type | Integer | DDL_Purchase_Receipt_Type | 0 | |
| 14 | RCPTNMBR | Receipt Number | String | STR20_Document_Number | 20 | |
| 15 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hide | ||||||
| 16 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
| 17 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 18 | QTYTYPE | QTY Type | Integer | DDL_QTY_Type | 0 | |
| 19 | Landed_Cost | Landed Cost | Boolean | CB | 0 | |
| 20 | NEGQTYSOPINV | IsNegQtySOPInvoice | Boolean | Boolean | 0 | |
| 21 | VCTNMTHD | Valuation Method | Integer | DDL_Valuation_Method | 0 | |
| 22 | ADJUNITCOST | Adjusted Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 23 | QTYONHND | QTY On Hand | Currency | DLR17_QTY_RBS0_STR | 17 | |