Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1027Rebuild
Product: Manufacturing (346)
Series:
Display Name: Manufacture Order Lot Issue
Physical Name: MOP1027Rebuild
Technical Name: MOP1027RebuildSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MANUFACTUREORDER_I 
Manufacture Order String STR30_UC 30 2 PICKLISTSEQ Picklist Seq Long Integer LINT_10 10 3 FROM_SITE_I From Site String STR10_Location_Code 10 4 BIN Bin String STR15_Bin 15 5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Manufacture Order Lot Issue'].ITEMNMBR AS 'Manufacture Order Lot Issue-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1027Rebuild AS ['Manufacture Order Lot Issue']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacture Order Lot Issue'].ITEMNMBR = ['Item Master'].ITEMNMBR7 TO_SITE_I To Site String STR10_Location_Code 10 8 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 9 DATERECD Date Received Date DATE 6 10 WIPSEQNMBR WIP SEQ Number Currency Sequence_Number 19 11 IVDOCNBR IV Document Number String STR17_IV_Document_Number 17 12 IVDOCTYP IV Document Type Integer DDL_IV_Document_Type 0 13 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 14 QTYCONSUMED QTY Consumed Currency DLR17_QTY_RBS0_UTR 17 15 QTYPENDING QTY Pending Currency DLR17_QTY_RBS0_UTR 17 16 NUMBERSCRAPPED_I Number Scrapped Currency DLR_14_MRP 14 17 ATYALLOC QTY Allocated Currency DLR17_QTY_RBS0_UTR 17 18 PICKNUMBER Pick Number String STR17_LBAU_Pick_Number 17 19 PICKDOCLINENUM Pick Doc Line Number Long Integer LI_Sequence_Number 10 20 QTY_BACKFLUSHED_I QTY Backflushed Currency DLR17_QTY_RBS0_UTR 17 21 SCRAPBACKFLUSHED Scrap Backflushed Currency DLR17_QTY_RBS0_UTR 17 22 SCRAPCONSUMED Scrap Consumed Currency DLR17_QTY_RBS0_UTR 17 23 ROWID ROW_ID Long Integer long 8 24 MOPRCTNM MOP Receipt Number String STR20_Document_Number_Receipt 20