Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXPV1002
Product: Manufacturing (346)
Series:
Display Name: EXP_SuggestedOsrcPO
Physical Name: EXPV1002
Technical Name: EXP_SuggestedOsrcPOSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MANUFACTUREORDER_I Manufacture Order String STR30_UC 30 2 RTSEQNUM_I rtseqnum String STR10 10 3 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['EXP_SuggestedOsrcPO'].ITEMNMBR AS 'EXP_SuggestedOsrcPO-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
EXPV1002 AS ['EXP_SuggestedOsrcPO']
INNER JOIN
IV00101 AS ['Item Master']
ON
['EXP_SuggestedOsrcPO'].ITEMNMBR = ['Item Master'].ITEMNMBR
4 ITEMDESC Item Description String STR100 100 5 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['EXP_SuggestedOsrcPO'].VENDORID AS 'EXP_SuggestedOsrcPO-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
EXPV1002 AS ['EXP_SuggestedOsrcPO']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['EXP_SuggestedOsrcPO'].VENDORID = ['PM Vendor Master File'].VENDORID
6 RELEASEBYDATE Release By Date Date DATE_L 0 7 REQDATE Required Date Date DATE_L 0 8 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 9 Total_Suggested_QTY Total Suggested QTY Currency DLR17_QTY_RBS0_UTR 17 10 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 11 QTYTORDR QTY To Order Currency DLR17_QTY_RBS0_UTR 17 12 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 13 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 14 UOFM U Of M String U_Of_M 8 15 MANUFACTUREORDERST_I Manufacture Order Status Integer DDL_WO_Status 0