Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1300
Product: Manufacturing (346)
Series:
Display Name: OSRC_Recorded_Shipments_MSTR
Physical Name: OSRC1300
Technical Name: OSRC_Recorded_Shipments_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Shipment_ID 
Shipment ID Long Integer LI_Sequence_Number 10 2 MANUFACTUREORDER_I Manufacture Order String STR30_UC 30 3 RTSEQNUM_I rtseqnum String STR10 10 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['OSRC_Recorded_Shipments_MSTR'].ITEMNMBR AS 'OSRC_Recorded_Shipments_MSTR-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
OSRC1300 AS ['OSRC_Recorded_Shipments_MSTR']
INNER JOIN
IV00101 AS ['Item Master']
ON
['OSRC_Recorded_Shipments_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR5 ITEMDESC Item Description String STR100 100 6 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['OSRC_Recorded_Shipments_MSTR'].VENDORID AS 'OSRC_Recorded_Shipments_MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
OSRC1300 AS ['OSRC_Recorded_Shipments_MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['OSRC_Recorded_Shipments_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID7 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 8 Ship_Date Ship Date Date Date 6 9 RETUDATE Return Date Date DT 8 10 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['OSRC_Recorded_Shipments_MSTR'].SHIPMTHD AS 'OSRC_Recorded_Shipments_MSTR-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
OSRC1300 AS ['OSRC_Recorded_Shipments_MSTR']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['OSRC_Recorded_Shipments_MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD11 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['OSRC_Recorded_Shipments_MSTR'].USERID AS 'OSRC_Recorded_Shipments_MSTR-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
OSRC1300 AS ['OSRC_Recorded_Shipments_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['OSRC_Recorded_Shipments_MSTR'].USERID = ['Users Master'].USERID12 USERDEF1 User Defined 1 String STR20 20 13 UOFM U Of M String U_Of_M 8 14 VOIDED Voided Boolean CB 0 15 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['OSRC_Recorded_Shipments_MSTR'].NOTEINDX AS 'OSRC_Recorded_Shipments_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
OSRC1300 AS ['OSRC_Recorded_Shipments_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['OSRC_Recorded_Shipments_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX16 OSRC_Item_Type OSRC_Item_Type Integer OSRC_Item_Type 2 17 Ship_By_Date Ship By Date Date DT 8 18 SEQ_I Seq Long Integer LINT_10 10 19 VOIDEDBY Voided By String STR15 15 20 VOIDDATE Void Date Date DT 8