Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1110
Product: Manufacturing (346)
Series:
Display Name: OSRC_Suggested_PO_Work
Physical Name: OSRC1110
Technical Name: OSRC_Suggested_PO_WorkSeq 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 RTSEQDES_I rtseqdes String STR100 100 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['OSRC_Suggested_PO_Work'].ITEMNMBR AS 'OSRC_Suggested_PO_Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
OSRC1110 AS ['OSRC_Suggested_PO_Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['OSRC_Suggested_PO_Work'].ITEMNMBR = ['Item Master'].ITEMNMBR5 ITEMDESC Item Description String STR100 100 6 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 7 FGDITMNM Finished Good Item Number String Item_Number 30 8 WCID_I WC ID String STR10_Location_Code 10 9 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_Work'].VENDORID AS 'OSRC_Suggested_PO_Work-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
OSRC1110 AS ['OSRC_Suggested_PO_Work']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['OSRC_Suggested_PO_Work'].VENDORID = ['PM Vendor Master File'].VENDORID10 VENDNAME Vendor Name String STR64_Vendor_Name 64 11 QTYTORDR QTY To Order Currency DLR17_QTY_RBS0_UTR 17 12 UOFM U Of M String U_Of_M 8 13 Total_Suggested_QTY Total Suggested QTY Currency DLR17_QTY_RBS0_UTR 17 14 U_Of_M_2 U Of M 2 String U_Of_M 8 15 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 16 U_of_M_3 U of M 3 String U_Of_M 8 17 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 18 REQDATE Required Date Date DATE_L 0 19 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['OSRC_Suggested_PO_Work'].COMMNTID AS 'OSRC_Suggested_PO_Work-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
OSRC1110 AS ['OSRC_Suggested_PO_Work']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['OSRC_Suggested_PO_Work'].COMMNTID = ['Comment Master'].COMMNTID20 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['OSRC_Suggested_PO_Work'].NOTEINDX AS 'OSRC_Suggested_PO_Work-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
OSRC1110 AS ['OSRC_Suggested_PO_Work']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['OSRC_Suggested_PO_Work'].NOTEINDX = ['Record Notes Master'].NOTEINDX21 NOTEINDX2 Note Index2 Currency DLR14 14 22 RELEASEBYDATE Release By Date Date DATE_L 0 23 CB_I CB Boolean CB 0 24 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['OSRC_Suggested_PO_Work'].USERID AS 'OSRC_Suggested_PO_Work-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
OSRC1110 AS ['OSRC_Suggested_PO_Work']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['OSRC_Suggested_PO_Work'].USERID = ['Users Master'].USERID25 CMMTTEXT Comment Text Text TX500 500