Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1100
Product: Manufacturing (346)
Series:
Display Name: OSRC_Suggested_PO_MSTR
Physical Name: OSRC1100
Technical Name: OSRC_Suggested_PO_MSTRSeq 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
['OSRC_Suggested_PO_MSTR'].ITEMNMBR AS 'OSRC_Suggested_PO_MSTR-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
OSRC1100 AS ['OSRC_Suggested_PO_MSTR']
INNER JOIN
IV00101 AS ['Item Master']
ON
['OSRC_Suggested_PO_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR4 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['OSRC_Suggested_PO_MSTR'].VENDORID AS 'OSRC_Suggested_PO_MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
OSRC1100 AS ['OSRC_Suggested_PO_MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['OSRC_Suggested_PO_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID5 RELEASEBYDATE Release By Date Date DATE_L 0 6 QTYTORDR QTY To Order Currency DLR17_QTY_RBS0_UTR 17 7 Total_Suggested_QTY Total Suggested QTY Currency DLR17_QTY_RBS0_UTR 17 8 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 9 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 10 REQDATE Required Date Date DATE_L 0 11 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['OSRC_Suggested_PO_MSTR'].COMMNTID AS 'OSRC_Suggested_PO_MSTR-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
OSRC1100 AS ['OSRC_Suggested_PO_MSTR']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['OSRC_Suggested_PO_MSTR'].COMMNTID = ['Comment Master'].COMMNTID12 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['OSRC_Suggested_PO_MSTR'].NOTEINDX AS 'OSRC_Suggested_PO_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
OSRC1100 AS ['OSRC_Suggested_PO_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['OSRC_Suggested_PO_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX13 NOTEINDX2 Note Index2 Currency DLR14 14 14 CMMTTEXT Comment Text Text TX500 500