SVC_RTV_Serial_Lot_Work (SVC05602)

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

Display Name: SVC_RTV_Serial_Lot_Work
Physical Name: SVC05602
Technical Name: SVC_RTV_Serial_Lot_Work

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RTV_Number	RTV Number	String	STR15_LBAU	15
2	RTV_Line	RTV Line	Currency	Sequence_Number	19
3	QTYTYPE	QTY Type	Integer	DDL_QTY_Type	0
4	SERLTQTY	Serial/Lot QTY	Currency	DLR17_QTY_RBS0_UTR	17
5	SLTSQNUM	Serial/Lot SEQ Number	Long Integer	LI_Sequence_Number	10
6	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_RTV_Serial_Lot_Work'].ITEMNMBR AS 'SVC_RTV_Serial_Lot_Work-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC05602 AS ['SVC_RTV_Serial_Lot_Work'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_RTV_Serial_Lot_Work'].ITEMNMBR = ['Item Master'].ITEMNMBR
7	SERLNMBR	Serial Number	String	STR20_LBAU	20
8	SVC_Serial_ID	SVC Serial ID	String	STR20_LBAU	20
9	EQUIPID	Equipment ID	Long Integer	Long Int	8
10	Return_Item_Number	Return Item Number	String	STR30_Item_Number	30
11	Return_Serial_Number	Return Serial Number	String	STR20_LBAU	20
12	SVC_Return_Serial_ID	SVC Return Serial ID	String	STR20_LBAU	20
13	Return_Equipment_ID	Return Equipment ID	Long Integer	Long Int	8
14	BIN	Bin	String	STR15_Bin	15
15	TOBIN	To Bin	String	STR15_Bin	15
16	RETCOST	Return Cost	Currency	DLR17_$S2	17
17	SVC_Original_Serial	SVC Original Serial	Boolean	Boolean	0
18	DATERECD	Date Received	Date	DATE	6
19	DTSEQNUM	Date SEQ Number	Currency	Sequence_Number	19
20	TRXSORCE	TRX Source	String	STR13	13
21	Shipped	Shipped	Boolean	CB_Shipped	0
22	MARKED	Marked	Boolean	Boolean	0
23	POSTED	Posted	Boolean	True/False	0
24	MFGDATE	Manufacture Date	Date	DT_Date	6
25	EXPNDATE	Expiration Date	Date	DT_Date	6