Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP36
Product: SmartList (1493)
Series: Pathname
Display Name: ASI_IV_Purchase_Receipts_Explorer
Physical Name: ASIEXP36
Technical Name: ASI_IV_Purchase_Receipts_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence ASI_LI_10_RU Long Integer 4 10 2 ASI_Order_By ASI_Order_By LI_14 Long Integer 4 14 3 ITEMNMBR Item Number STR30_Item_Number String 32 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ASI_IV_Purchase_Receipts_Explorer'].ITEMNMBR AS 'ASI_IV_Purchase_Receipts_Explorer-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP36 AS ['ASI_IV_Purchase_Receipts_Explorer']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ASI_IV_Purchase_Receipts_Explorer'].ITEMNMBR = ['Item Master'].ITEMNMBR4 TRXLOCTN TRX Location STR10_Location_Code String 12 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['ASI_IV_Purchase_Receipts_Explorer'].TRXLOCTN AS 'ASI_IV_Purchase_Receipts_Explorer-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP36 AS ['ASI_IV_Purchase_Receipts_Explorer']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['ASI_IV_Purchase_Receipts_Explorer'].TRXLOCTN = ['Site Setup'].LOCNCODE5 DATERECD Date Received DATE Date 4 6 6 RCTSEQNM Receipt SEQ Number long Long Integer 4 8 7 RCPTSOLD Receipt Sold YN Boolean 2 0 8 QTYRECVD QTY Received DLR17_QTY_RBS0_UTR Currency 10 17 9 QTYSOLD QTY Sold DLR17_QTY_RBS0_UTR Currency 10 17 10 QTYCOMTD QTY Committed DLR17_QTY_RBS0_UTR Currency 10 17 11 QTYRESERVED QTY Reserved DLR17_QTY_RBS0_UTR Currency 10 17 12 FLRPLNDT Floor Plan Date DATE Date 4 6 13 PCHSRCTY Purchase Receipt Type DDL_Purchase_Receipt_Type Integer 2 0 14 RCPTNMBR Receipt Number STR20_Document_Number String 22 20 15 VENDORID Vendor ID STR_15_Vendor_ID String 16 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ASI_IV_Purchase_Receipts_Explorer'].VENDORID AS 'ASI_IV_Purchase_Receipts_Explorer-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP36 AS ['ASI_IV_Purchase_Receipts_Explorer']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ASI_IV_Purchase_Receipts_Explorer'].VENDORID = ['PM Vendor Master File'].VENDORID16 PORDNMBR Purchase Order Number Purchase Order Number String 22 20 17 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17 18 QTYTYPE QTY Type DDL_QTY_Type Integer 2 0 19 Landed_Cost Landed Cost CB Boolean 2 0 20 NEGQTYSOPINV IsNegQtySOPInvoice Boolean Boolean 2 0 21 VCTNMTHD Valuation Method DDL_Valuation_Method Integer 2 0 22 ADJUNITCOST Adjusted Unit Cost DLR17_RBS0_UTR$ Currency 10 17 23 QTYONHND QTY On Hand DLR17_QTY_RBS0_STR Currency 10 17