Returns Master (SVC05000)

azurecurve Products FieldService (949)ProjectReturns Master (SVC05000)

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

Display Name: Returns Master
Physical Name: SVC05000
Technical Name: SVC_RMA_MSTR

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RETDOCID	Return Document ID	String	STR15_LBAU	15
2	Return_Record_Type	Return Record Type	Integer	DDL_Return_Record_Type	0
3	RMA_Status	RMA Status	Integer	INT	0
4	Received	Received	Boolean	CB_Received	0
5	RETORIG	Return Origin	Integer	DDL_Return	0
6	RETREF	Return Reference	String	STR30_LBAU	30
7	RETSTAT	Return Status	String	STR3_LBAU	3
8	RETTYPE	SVC Return Type	String	STR10_LBAU	10
9	ENTDTE	Entry Date	Date	DT_Date	6
10	ENTTME	Entry Time	Time	TM6	6
11	ETADTE	ETA Date	Date	DT_Date	6
12	ETATME	ETA Time	Time	TM6	6
13	RETUDATE	Return Date	Date	DT	8
14	Return_Time	Return Time	Time	TM6	6
15	COMPDTE	Complete Date	Date	DT_Date	6
16	COMPTME	Complete Time	Time	TM6	6
17	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Returns Master'].USERID AS 'Returns Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC05000 AS ['Returns Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Returns Master'].USERID = ['Users Master'].USERID
18	OFFID	Office ID	String	STR10_LBAU	10
19	RTRNNAME	Return Address Name	String	STR44_LBU	44
20	RETADDR1	Return Address 1	String	STR60	60
21	RETADDR2	Return Address 2	String	STR60	60
22	RETADDR3	Return Address 3	String	STR60	60
23	RTRNCITY	Return Address City	String	STR20_LBU	20
24	SVC_Return_State	SVC Return State	String	STR30_State	29
25	RTRNZIP	Return Address Zip Code	String	STR10	10
26	Return_Country	Return Country	String	STR60	60
27	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Returns Master'].LOCNCODE AS 'Returns Master-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC05000 AS ['Returns Master'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Returns Master'].LOCNCODE = ['Site Setup'].LOCNCODE
28	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Returns Master'].CUSTNMBR AS 'Returns Master-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC05000 AS ['Returns Master'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Returns Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
29	ADRSCODE	Address Code	String	STR15_Address_Code	15
30	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
31	CONTACT	Contact	String	STR60	60
32	ADDRESS1	Address 1	String	STR60	60
33	ADDRESS2	Address 2	String	STR60	60
34	ADDRESS3	Address 3	String	STR60	60
35	CITY	City	String	STR35	35
36	STATE	State	String	STR30_State	29
37	ZIPCODE	Zip Code	String	STR10	10
38	COUNTRY	Country	String	STR60	60
39	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Returns Master'].NOTEINDX AS 'Returns Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC05000 AS ['Returns Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Returns Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
40	CALLNBR	Service Call Number	String	STR10_LBAU	10
41	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
42	EQPLINE	Equipment Line Item Sequence	Long Integer	LI_Sequence_Number	10
43	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
44	Bill_of_Lading	Bill of Lading	String	STR30	30
45	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Returns Master'].SHIPMTHD AS 'Returns Master-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC05000 AS ['Returns Master'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Returns Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
47	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
48	SOP_Line_Item_Sequence	SOP Line Item Sequence	Long Integer	LI_Sequence_Number	10
49	CMPNTSEQ	Component Sequence	Long Integer	LI_Sequence_Number	10
50	Bill_To_Customer	Bill To Customer	String	STR15_RM_Customer_Number	15
51	SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	STR15_Address_Code	15
52	Commit_Date	Commit Date	Date	DT_Date	6
53	Commit_Time	Commit Time	Time	TM6	6
54	USERDEF1	User Defined 1	String	STR20	20
55	USERDEF2	User Defined 2	String	STR20	20
56	USRDEF03	User Defined 3	String	STR20	20
57	USRDEF04	User Defined 4	String	STR20	20
58	USRDEF05	User Defined 5	String	STR20	20
59	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Returns Master'].CURNCYID AS 'Returns Master-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM SVC05000 AS ['Returns Master'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Returns Master'].CURNCYID = ['Currency Setup'].CURNCYID
60	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Returns Master'].CURRNIDX AS 'Returns Master-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SVC05000 AS ['Returns Master'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Returns Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
61	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Returns Master'].RATETPID AS 'Returns Master-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM SVC05000 AS ['Returns Master'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Returns Master'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
62	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Returns Master'].EXGTBLID AS 'Returns Master-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM SVC05000 AS ['Returns Master'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Returns Master'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
63	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
64	EXCHDATE	Exchange Date	Date	DT_Date	6
65	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
66	TIME1	Time	Time	TM6	6
67	RATECALC	Rate Calc Method	Integer	INT	0
68	VIEWMODE	View Mode	Integer	INT	0
69	ISMCTRX	IS MC Trx	Integer	INT	0
70	EXPNDATE	Expiration Date	Date	DT_Date	6
71	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
72	MCTRXSTT	MC Transaction State	Integer	INT1	1
73	CSTPONBR	Customer PO Number	String	STR20_Document_Number	20
74	SVC_RMA_Reason_Code	SVC_RMA_Reason_Code	String	STR3_LBAU	3
75	SVC_RMA_Reason_Code_Desc	SVC_RMA_Reason_Code_Desc	String	STR30	30
76	SVC_RMA_From_Service	SVC RMA From Service	Boolean	Boolean	0
77	SVC_FO_ID	SVC FO ID	String	STR50	50

azurecurve Products FieldService (949)ProjectReturns Master (SVC05000)

Leave a Reply Cancel reply