Manufacture Order Lot Issue HIST (MOP1090)

azurecurveProductsManufacturing (346)3rd PartyManufacture Order Lot Issue HIST (MOP1090)

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

Product: Manufacturing (346)
Series:

Display Name: Manufacture Order Lot Issue HIST
Physical Name: MOP1090
Technical Name: MOP_Pending_Serial_Lot_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
2ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['Manufacture Order Lot Issue HIST'].ITEMNMBR AS 'Manufacture Order Lot Issue HIST-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       MOP1090 AS ['Manufacture Order Lot Issue HIST']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Manufacture Order Lot Issue HIST'].ITEMNMBR = ['Item Master'].ITEMNMBR
3SERLTNUM SearchSerial/Lot NumberStringSTR2020
4DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
5PICKLISTSEQ SearchPicklist SeqLong IntegerLINT_1010
6CALLEDBY SearchCalled ByIntegerINT0
7PICKDOCLINENUM SearchPick Doc Line NumberLong IntegerLI_Sequence_Number10
8SEQ_I SearchSeqLong IntegerLINT_1010
9WIPSEQNMBR SearchWIP SEQ NumberCurrencySequence_Number19
10SERLTQTY SearchSerial/Lot QTYCurrencyDLR17_QTY_RBS0_UTR17
11FROM_SITE_I SearchFrom SiteStringSTR10_Location_Code10
12TO_SITE_I SearchTo SiteStringSTR10_Location_Code10
13DATERECD SearchDate ReceivedDateDATE6
14DTSEQNUM SearchDate SEQ NumberCurrencySequence_Number19
15LineNumber SearchLineNumberIntegerINT0
16NUMBERSCRAPPED_I SearchNumber ScrappedCurrencyDLR_14_MRP14
17TRX_TYPE SearchTRX TypeIntegerDDL_TRX_Type_I0
18ORDOCNUM SearchOriginating Document NumberStringSTR2020
19ITMTRKOP SearchItem Tracking OptionIntegerDDL_Track0
20BYPRODUCTITEM SearchByProduct ItemBooleanBoolean0
21BIN SearchBinStringSTR15_Bin15
22EXPNDATE SearchExpiration DateDateDT_Date6
23MFGDATE SearchManufacture DateDateDT_Date6
azurecurveProductsManufacturing (346)3rd PartyManufacture Order Lot Issue HIST (MOP1090)

Leave a Reply

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