MOP_Receipt_Detail_Serial_Lot (MOP1120)

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

Display Name: MOP_Receipt_Detail_Serial_Lot
Physical Name: MOP1120
Technical Name: MOP_Receipt_Detail_Serial_Lot

Seq 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_Serial_Lot'].ITEMNMBR AS 'MOP_Receipt_Detail_Serial_Lot-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM MOP1120 AS ['MOP_Receipt_Detail_Serial_Lot'] INNER JOIN IV00101 AS ['Item Master'] ON ['MOP_Receipt_Detail_Serial_Lot'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	PICKLISTSEQ	Picklist Seq	Long Integer	LINT_10	10
4	ITMTRKOP	Item Tracking Option	Integer	DDL_Track	0
5	SERLTNUM	Serial/Lot Number	String	STR20	20
6	QTY_BACKFLUSHED_I	QTY Backflushed	Currency	DLR17_QTY_RBS0_UTR	17
7	QTYCONSUMED	QTY Consumed	Currency	DLR17_QTY_RBS0_UTR	17
8	NUMBERSCRAPPED_I	Number Scrapped	Currency	DLR_14_MRP	14
9	BIN	Bin	String	STR15_Bin	15
10	EXPNDATE	Expiration Date	Date	DT_Date	6
11	MFGDATE	Manufacture Date	Date	DT_Date	6
12	WIPSEQNMBR	WIP SEQ Number	Currency	Sequence_Number	19