Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1110
Product: Manufacturing (346)
Series: 3rd Party
Display Name: OSRC_Suggested_PO_Work DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: OSRC1110
Technical Name: OSRC_Suggested_PO_WorkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 MANUFACTUREORDER_I 
Manufacture Order STR30_UC String 32 30 2 RTSEQNUM_I rtseqnum STR10 String 12 10 3 RTSEQDES_I rtseqdes STR100 String 102 100 4 ITEMNMBR Item Number STR30_Item_Number String 32 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 STR100 String 102 100 6 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17 7 FGDITMNM Finished Good Item Number Item_Number String 32 30 8 WCID_I WC ID STR10_Location_Code String 12 10 9 VENDORID Vendor ID STR_15_Vendor_ID String 16 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 STR64_Vendor_Name String 66 64 11 QTYTORDR QTY To Order DLR17_QTY_RBS0_UTR Currency 10 17 12 UOFM U Of M U_Of_M String 10 8 13 Total_Suggested_QTY Total Suggested QTY DLR17_QTY_RBS0_UTR Currency 10 17 14 U_Of_M_2 U Of M 2 U_Of_M String 10 8 15 QTYORDER QTY Ordered DLR17_QTY_RBS0_UTR Currency 10 17 16 U_of_M_3 U of M 3 U_Of_M String 10 8 17 EXTDCOST Extended Cost DLR17_RBS0_UTR$ Currency 10 17 18 REQDATE Required Date DATE_L Date 4 0 19 COMMNTID Comment ID STR15_Comment_ID String 16 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 DLR14 Currency 10 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 DLR14 Currency 10 14 22 RELEASEBYDATE Release By Date DATE_L Date 4 0 23 CB_I CB CB Boolean 2 0 24 USERID User ID STR15_User_ID String 16 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 TX500 Text 2 500 26 DEX_ROW_ID int int 10 10