SVC_RMA_Serial_Lot_Work (SVC05255)

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

Display Name: SVC_RMA_Serial_Lot_Work
Physical Name: SVC05255
Technical Name: SVC_RMA_Serial_Lot_Work

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	Return_Item_Number	Return Item Number	STR30_Item_Number	String	32	30
7	Return_Serial_Number	Return Serial Number	STR20_LBAU	String	22	20
8	Return_Equipment_ID	Return Equipment ID	Long Int	Long Integer	4	8
9	SLTSQNUM	Serial/Lot SEQ Number	LI_Sequence_Number	Long Integer	4	10
10	BIN	Bin	STR15_Bin	String	16	15
11	RETCOST	Return Cost	DLR17_$S2	Currency	10	17
12	SVC_Original_Serial	SVC Original Serial	Boolean	Boolean	2	0
13	DATERECD	Date Received	DATE	Date	4	6
14	DTSEQNUM	Date SEQ Number	Sequence_Number	Currency	10	19
15	TRXSORCE	TRX Source	STR13	String	14	13
16	MARKED	Marked	Boolean	Boolean	2	0
17	POSTED	Posted	True/False	Boolean	2	0
18	MFGDATE	Manufacture Date	DT_Date	Date	4	6
19	EXPNDATE	Expiration Date	DT_Date	Date	4	6
20	CMPNTSEQ	Component Sequence	LI_Sequence_Number	Long Integer	4	10
21	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.