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_ExplorerSeq 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
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 String STR10_Location_Code 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 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
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 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