Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/OSRC1500
Product: Manufacturing (346)
Series:
Display Name: OSRC_Selected_Lot_Numbers_MSTR
Physical Name: OSRC1500
Technical Name: OSRC_Selected_Lots_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 LOTNUMBR Lot Number String STR20_LBAU 20 4 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 5 LineNumber LineNumber Integer INT 0 6 SLTSQNUM Serial/Lot SEQ Number Long Integer LI_Sequence_Number 10 7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['OSRC_Selected_Lot_Numbers_MSTR'].ITEMNMBR AS 'OSRC_Selected_Lot_Numbers_MSTR-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
OSRC1500 AS ['OSRC_Selected_Lot_Numbers_MSTR']
INNER JOIN
IV00101 AS ['Item Master']
ON
['OSRC_Selected_Lot_Numbers_MSTR'].ITEMNMBR = ['Item Master'].ITEMNMBR8 RTSEQNUM_I rtseqnum String STR10 10 9 OSRC_Lot_Qty OSRC_Lot_Qty Currency DLR17_QTY_RBS0_UTR 17