Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1200
Product: Manufacturing (346)
Series:
Display Name: OSRC_Suggested_Shipments_MSTR
Physical Name: OSRC1200
Technical Name: OSRC_Suggested_Shipments_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_Shipments_MSTR'].ITEMNMBR AS 'OSRC_Suggested_Shipments_MSTR-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
OSRC1200 AS ['OSRC_Suggested_Shipments_MSTR']
INNER JOIN
IV00101 AS ['Item Master']
ON
['OSRC_Suggested_Shipments_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR
4 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['OSRC_Suggested_Shipments_MSTR'].VENDORID AS 'OSRC_Suggested_Shipments_MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
OSRC1200 AS ['OSRC_Suggested_Shipments_MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['OSRC_Suggested_Shipments_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
5 Total_Suggested_QTY Total Suggested QTY Currency DLR17_QTY_RBS0_UTR 17 6 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 7 Ship_By_Date Ship By Date Date DT 8 8 OSRC_Item_Type OSRC_Item_Type Integer OSRC_Item_Type 2 9 SEQ_I Seq Long Integer LINT_10 10 10 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['OSRC_Suggested_Shipments_MSTR'].NOTEINDX AS 'OSRC_Suggested_Shipments_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
OSRC1200 AS ['OSRC_Suggested_Shipments_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['OSRC_Suggested_Shipments_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
11 NOTEINDX2 Note Index2 Currency DLR14 14