Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOPW500
Product: Manufacturing (346)
Series:
Display Name: MOP Receipt TEMP WORK
Physical Name: MOPW500
Technical Name: MOP_Receipt_TEMP_WORKSeq 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 TEMP WORK'].ITEMNMBR AS 'MOP Receipt TEMP WORK-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MOPW500 AS ['MOP Receipt TEMP WORK']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MOP Receipt TEMP WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
3 PICKLISTSEQ Picklist Seq Long Integer LINT_10 10 4 POSITION_NUMBER Position Number Integer INT4_RB_U0 4 5 POSITION_NUMBER2 Position Number2 Integer INT4_RB_U0 4 6 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MOP Receipt TEMP WORK'].USERID AS 'MOP Receipt TEMP WORK-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MOPW500 AS ['MOP Receipt TEMP WORK']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MOP Receipt TEMP WORK'].USERID = ['Users Master'].USERID
7 ITEMDESC Item Description String STR100 100 8 ITMTRKOP Item Tracking Option Integer DDL_Track 0 9 QTYPLANNEDTOCONSUME QTY Planned To Consume Currency DLR17_QTY_RBS0_STR 17 10 QTYPLANNEDTOBACKFLUSH QTY Planned To Backflush Currency DLR17_QTY_RBS0_UTR 17 11 QTYTOCONSUME QTY To Consume Currency DLR17_QTY_RBS0_UTR 17 12 QTYTOBACKFLUSH QTY To Backflush Currency DLR17_QTY_RBS0_STR 17 13 BACKFLUSHSITEID Backflush Site ID String STR10_Location_Code 10 14 BYPRODUCTSITEID Byproduct Site ID String STR10_Location_Code 10 15 QTYTOUSE QTY To Use Currency DLR17_RBS0_UTR$ 17 16 UOFM U Of M String U_Of_M 8 17 MOP_REQUIRED_QUANTITY_I MOP Required Quantity Currency DLR14_RS5 0 18 WIPQUANTITY WIP Quantity Currency DLR17_QTY_RBS0_STR 17 19 QTYAVAIL QTY Available Currency DLR17_QTY_RBS0_UTR 17 20 QTYCONSUMEDTODATE QTY Consumed To Date Currency DLR17_QTY_RBS0_STR 17 21 QTYBACKFLUSHEDTODATE QTY Backflushed To Date Currency DLR17_QTY_RBS0_STR 17 22 QTYSLCTD QTY Selected Currency DLR17_QTY_RBS0_UTR 17 23 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 24 NUMBERSCRAPPED_I Number Scrapped Currency DLR_14_MRP 14 25 BOMSINGLELOT_I BOM_Single_Lot Boolean CB 0 26 BACKFLUSHCB Backflush CB Boolean CB_Backflush 0 27 ATYALLOC QTY Allocated Currency DLR17_QTY_RBS0_UTR 17 28 PLNDFIXDQTYTOCONS Planned Fixed Quantity to Consume Currency DLR17_QTY_RBS0_UTR 17 29 PLNDFIXDQTYTOBF Planned Fixed Quantity to Backflush Currency DLR17_QTY_RBS0_UTR 17 30 FIXDQTYTOCONS Fixed Quantity to Consume Currency DLR17_QTY_RBS0_UTR 17 31 FIXDQTYTOBF Fixed Quantity to Backflush Currency DLR17_QTY_RBS0_UTR 17 32 QTYSELCTDBF QTY Selected Backflushed Currency DLR17_QTY_RBS0_UTR 17 33 FLOORSTOCK_I Floor Stock Boolean CB 0 34 NONINVENTORY Non Inventory Boolean CB 0 35 STR20DUMMY_I STR20 Dummy String STR20 20 36 ITEMTYPE Item Type Integer DDL_Item_Type 0 37 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['MOP Receipt TEMP WORK'].NOTEINDX AS 'MOP Receipt TEMP WORK-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
MOPW500 AS ['MOP Receipt TEMP WORK']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['MOP Receipt TEMP WORK'].NOTEINDX = ['Record Notes Master'].NOTEINDX
38 SUBASSEMBLYOF_I Subassembly Of String STR30 30