SVC_RMA_Receiving_WORK (SVC05015)

azurecurve Products FieldService (949)ProjectSVC_RMA_Receiving_WORK (SVC05015)

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

Display Name: SVC_RMA_Receiving_WORK
Physical Name: SVC05015
Technical Name: SVC_RMA_Receiving_WORK

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SVC_RMA_Receiving_WORK'].USERID AS 'SVC_RMA_Receiving_WORK-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC05015 AS ['SVC_RMA_Receiving_WORK'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SVC_RMA_Receiving_WORK'].USERID = ['Users Master'].USERID
2	RETDOCID	Return Document ID	String	STR15_LBAU	15
3	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
4	RMA_Status	RMA Status	Integer	INT	0
5	TECHID	Tech ID	String	STR10_LBAU	10
6	RETTYPE	SVC Return Type	String	STR10_LBAU	10
7	OFFID	Office ID	String	STR10_LBAU	10
8	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SVC_RMA_Receiving_WORK'].CUSTNMBR AS 'SVC_RMA_Receiving_WORK-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC05015 AS ['SVC_RMA_Receiving_WORK'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SVC_RMA_Receiving_WORK'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
9	ADRSCODE	Address Code	String	STR15_Address_Code	15
10	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
11	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
12	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_RMA_Receiving_WORK'].ITEMNMBR AS 'SVC_RMA_Receiving_WORK-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC05015 AS ['SVC_RMA_Receiving_WORK'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_RMA_Receiving_WORK'].ITEMNMBR = ['Item Master'].ITEMNMBR
13	Return_Item_Number	Return Item Number	String	STR30_Item_Number	30
14	Return_QTY	Return QTY	Currency	DLR17_QTY_RBS0_UTR	17
15	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SVC_RMA_Receiving_WORK'].LOCNCODE AS 'SVC_RMA_Receiving_WORK-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC05015 AS ['SVC_RMA_Receiving_WORK'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SVC_RMA_Receiving_WORK'].LOCNCODE = ['Site Setup'].LOCNCODE
16	BINNMBR	Bin Number	String	STR20	20
17	ORDDOCID	Order Document ID	String	STR15_LBAU	15
18	CALLNBR	Service Call Number	String	STR10_LBAU	10
19	RETREF	Return Reference	String	STR30_LBAU	30
20	CB_Packing_Slip	CB Packing Slip	Boolean	CB	0
21	CHDFLAG	Child Flag	Boolean	Boolean	0
22	MKDTOPST	Marked To Post	Boolean	CB	0
23	POSTED	Posted	Boolean	True/False	0
24	ERMSGNBR	Error Message Number	Integer	INT4	4
25	ERMSGTXT	Error Message Text	String	STR255	255
26	ERMSGTX2	Error Message Text 2	String	STR255	255
27	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
28	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
29	UOFM	U Of M	String	U_Of_M	8
30	Return_U_Of_M	Return U Of M	String	U_Of_M	8
31	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0

azurecurve Products FieldService (949)ProjectSVC_RMA_Receiving_WORK (SVC05015)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply