Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOP1110
Product: Manufacturing (346)
Series:
Display Name: MOP_Receipt_Detail
Physical Name: MOP1110
Technical Name: MOP_Receipt_DetailSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MOPRCTNM 
MOP Receipt Number String STR20_Document_Number_Receipt 20 2 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['MOP_Receipt_Detail'].ITEMNMBR AS 'MOP_Receipt_Detail-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOP1110 AS ['MOP_Receipt_Detail']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP_Receipt_Detail'].ITEMNMBR = ['Item Master'].ITEMNMBR3 PICKLISTSEQ Picklist Seq Long Integer LINT_10 10 4 POSITION_NUMBER Position Number Integer INT4_RB_U0 4 5 ITEM_COSTS_ARRAY_I Item Costs Array DLR17_RBS0_UTR$ Currency 17 6 ITEM_COSTS_ARRAY_I_1 Item Costs Array[1] Currency DLR17_RBS0_UTR$ 17 7 ITEM_COSTS_ARRAY_I_2 Item Costs Array[2] Currency DLR17_RBS0_UTR$ 17 8 ITEM_COSTS_ARRAY_I_3 Item Costs Array[3] Currency DLR17_RBS0_UTR$ 17 9 ITEM_COSTS_ARRAY_I_4 Item Costs Array[4] Currency DLR17_RBS0_UTR$ 17 10 ITEM_COSTS_ARRAY_I_5 Item Costs Array[5] Currency DLR17_RBS0_UTR$ 17 11 ITEM_COSTS_ARRAY_I_6 Item Costs Array[6] Currency DLR17_RBS0_UTR$ 17 12 ITEM_COSTS_ARRAY_I_7 Item Costs Array[7] Currency DLR17_RBS0_UTR$ 17 13 ITEM_COSTS_ARRAY_I_8 Item Costs Array[8] Currency DLR17_RBS0_UTR$ 17 14 ITEM_COSTS_ARRAY_I_9 Item Costs Array[9] Currency DLR17_RBS0_UTR$ 17 15 ITEM_COSTS_ARRAY_I_10 Item Costs Array[10] Currency DLR17_RBS0_UTR$ 17 16 BACKFLUSHCB Backflush CB Boolean CB_Backflush 0 17 ITMTRKOP Item Tracking Option Integer DDL_Track 0 18 QTYPLANNEDTOCONSUME QTY Planned To Consume Currency DLR17_QTY_RBS0_STR 17 19 QTYPLANNEDTOBACKFLUSH QTY Planned To Backflush Currency DLR17_QTY_RBS0_UTR 17 20 QTYTOCONSUME QTY To Consume Currency DLR17_QTY_RBS0_UTR 17 21 QTYTOBACKFLUSH QTY To Backflush Currency DLR17_QTY_RBS0_STR 17 22 BACKFLUSHSITEID Backflush Site ID String STR10_Location_Code 10 23 BYPRODUCTSITEID Byproduct Site ID String STR10_Location_Code 10 24 QTYTOUSE QTY To Use Currency DLR17_RBS0_UTR$ 17 25 NUMBERSCRAPPED_I Number Scrapped Currency DLR_14_MRP 14 26 FIXDQTYTOCONS Fixed Quantity to Consume Currency DLR17_QTY_RBS0_UTR 17 27 FIXDQTYTOBF Fixed Quantity to Backflush Currency DLR17_QTY_RBS0_UTR 17 28 FLOORSTOCK_I Floor Stock Boolean CB 0 29 NONINVENTORY Non Inventory Boolean CB 0 30 ITEMTYPE Item Type Integer DDL_Item_Type 0 31 POSITION_NUMBER2 Position Number2 Integer INT4_RB_U0 4 32 SUBASSEMBLYOF_I Subassembly Of String STR30 30