Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1095
Product: Manufacturing (346)
Series:
Display Name: Manufacture Order Pending Bin HIST
Physical Name: MOP1095
Technical Name: MOP_Pending_Nontracked_Bin_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 2 SEQ_I Seq Long Integer LINT_10 10 3 MANUFACTUREORDER_I Manufacture Order String STR30_UC 30 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Manufacture Order Pending Bin HIST'].ITEMNMBR AS 'Manufacture Order Pending Bin HIST-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1095 AS ['Manufacture Order Pending Bin HIST']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacture Order Pending Bin HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
5 MOPDOCNUM MOP Document Number String STR30_UC 30 6 PICKLISTSEQ Picklist Seq Long Integer LINT_10 10 7 CALLEDBY Called By Integer INT 0 8 PICKDOCLINENUM Pick Doc Line Number Long Integer LI_Sequence_Number 10 9 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 10 FROM_SITE_I From Site String STR10_Location_Code 10 11 TO_SITE_I To Site String STR10_Location_Code 10 12 TRX_TYPE TRX Type Integer DDL_TRX_Type_I 0 13 BIN Bin String STR15_Bin 15 14 BYPRODUCTITEM ByProduct Item Boolean Boolean 0 15 ORDOCNUM Originating Document Number String STR20 20 16 ORIG_PICK_DOC_LINE_NUM Originating Pick Doc Line Number Long Integer LI_Sequence_Number 10 17 Previous_Allocation Previous Allocation Boolean boolean 0 18 NUMBERSCRAPPED_I Number Scrapped Currency DLR_14_MRP 14