SVC_RMA_Replace_Serial_Lot (SVC05256)

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

Display Name: SVC_RMA_Replace_Serial_Lot
Physical Name: SVC05256
Technical Name: SVC_RMA_Replace_Serial_Lot

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	Return_Record_Type	Return Record Type	DDL_Return_Record_Type	Integer	2	0
2	RETDOCID	Return Document ID	STR15_LBAU	String	16	15
3	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	10	19
4	QTYTYPE	QTY Type	DDL_QTY_Type	Integer	2	0
5	SERLTQTY	Serial/Lot QTY	DLR17_QTY_RBS0_UTR	Currency	10	17
6	SLTSQNUM	Serial/Lot SEQ Number	LI_Sequence_Number	Long Integer	4	10
7	Replace_Item_Number	Replace Item Number	STR30_Item_Number	String	32	30
8	Replace_Serial_Number	Replace Serial Number	STR20_LBAU	String	22	20
9	Replace_Equipment_ID	Replace Equipment ID	Long Int	Long Integer	4	8
10	BIN	Bin	STR15_Bin	String	16	15
11	Replace_Cost	Replace Cost	DLR17_RBS0_STR$	Currency	10	17
12	MFGDATE	Manufacture Date	DT_Date	Date	4	6
13	EXPNDATE	Expiration Date	DT_Date	Date	4	6
14	DATERECD	Date Received	DATE	Date	4	6
15	DTSEQNUM	Date SEQ Number	Sequence_Number	Currency	10	19
16	CMPNTSEQ	Component Sequence	LI_Sequence_Number	Long Integer	4	10
17	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.