MOP Receipt Detail Work (MOPW400)

azurecurveProductsManufacturing (346)3rd PartyMOP Receipt Detail Work (MOPW400)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOPW400

Product: Manufacturing (346)
Series:

Display Name: MOP Receipt Detail Work
Physical Name: MOPW400
Technical Name: MOP_Receipt_Detail_Work

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MOPRCTNM SearchMOP Receipt NumberStringSTR20_Document_Number_Receipt20
2PICKLISTSEQ SearchPicklist SeqLong IntegerLINT_1010
3ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['MOP Receipt Detail Work'].ITEMNMBR AS 'MOP Receipt Detail Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       MOPW400 AS ['MOP Receipt Detail Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['MOP Receipt Detail Work'].ITEMNMBR = ['Item Master'].ITEMNMBR
4QTYTOBACKFLUSH SearchQTY To BackflushCurrencyDLR17_QTY_RBS0_STR17
5ATYALLOC SearchQTY AllocatedCurrencyDLR17_QTY_RBS0_UTR17
6NUMBERSCRAPPED_I SearchNumber ScrappedCurrencyDLR_14_MRP14
7QTYSLCTD SearchQTY SelectedCurrencyDLR17_QTY_RBS0_UTR17
8QTYSELCTDBF SearchQTY Selected BackflushedCurrencyDLR17_QTY_RBS0_UTR17
9BACKFLUSHSITEID SearchBackflush Site IDStringSTR10_Location_Code10
10BYPRODUCTSITEID SearchByproduct Site IDStringSTR10_Location_Code10
azurecurveProductsManufacturing (346)3rd PartyMOP Receipt Detail Work (MOPW400)

Leave a Reply

Your email address will not be published. Required fields are marked *