Returns Line Master (SVC05200)

azurecurve Products FieldService (949)ProjectReturns Line Master (SVC05200)

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

Display Name: Returns Line Master
Physical Name: SVC05200
Technical Name: SVC_RMA_Line

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	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
4	SVC_Next_Line_SEQ_Number	SVC Next Line SEQ Number	Currency	Sequence_Number	19
5	SVC_Prev_Line_SEQ_Number	SVC Prev Line SEQ Number	Currency	Sequence_Number	19
6	RETTYPE	SVC Return Type	String	STR10_LBAU	10
7	RMA_Status	RMA Status	Integer	INT	0
8	RETSTAT	Return Status	String	STR3_LBAU	3
9	Received	Received	Boolean	CB_Received	0
10	Traveler_Printed	Traveler Printed	Boolean	CB_Traveler_Printed	0
11	SVC_Ready_To_Close	SVC Ready To Close	Boolean	CB_Ready_To_Close	0
12	SVC_RMA_Reason_Code	SVC_RMA_Reason_Code	String	STR3_LBAU	3
13	SVC_RMA_Reason_Code_Desc	SVC_RMA_Reason_Code_Desc	String	STR30	30
14	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Returns Line Master'].NOTEINDX AS 'Returns Line Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Returns Line Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15	RETORIG	Return Origin	Integer	DDL_Return	0
16	RETREF	Return Reference	String	STR30_LBAU	30
17	SRVRECTYPE	Service Record Type	Integer	DDL_Service_Record_Type	0
18	CALLNBR	Service Call Number	String	STR10_LBAU	10
19	EQPLINE	Equipment Line Item Sequence	Long Integer	LI_Sequence_Number	10
20	LNITMSEQ	Line Item Sequence	Long Integer	LI_Sequence_Number	10
21	SVC_RMA_From_Service	SVC RMA From Service	Boolean	Boolean	0
22	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
23	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
24	CMPNTSEQ	Component Sequence	Long Integer	LI_Sequence_Number	10
25	SOP_Line_Item_Sequence	SOP Line Item Sequence	Long Integer	LI_Sequence_Number	10
26	ENTDTE	Entry Date	Date	DT_Date	6
27	ENTTME	Entry Time	Time	TM6	6
28	ETADTE	ETA Date	Date	DT_Date	6
29	ETATME	ETA Time	Time	TM6	6
30	Commit_Date	Commit Date	Date	DT_Date	6
31	Commit_Time	Commit Time	Time	TM6	6
32	RETUDATE	Return Date	Date	DT	8
33	Return_Time	Return Time	Time	TM6	6
34	COMPDTE	Complete Date	Date	DT_Date	6
35	COMPTME	Complete Time	Time	TM6	6
36	PRMDATE	Promised Date	Date	DATE_L	0
37	REFRENCE	Reference	String	STR30	30
38	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Returns Line Master'].USERID AS 'Returns Line Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Returns Line Master'].USERID = ['Users Master'].USERID
39	OFFID	Office ID	String	STR10_LBAU	10
40	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Returns Line Master'].LOCNCODE AS 'Returns Line Master-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Returns Line Master'].LOCNCODE = ['Site Setup'].LOCNCODE
41	RTRNNAME	Return Address Name	String	STR44_LBU	44
42	RETADDR1	Return Address 1	String	STR60	60
43	RETADDR2	Return Address 2	String	STR60	60
44	RETADDR3	Return Address 3	String	STR60	60
45	RTRNCITY	Return Address City	String	STR20_LBU	20
46	SVC_Return_State	SVC Return State	String	STR30_State	29
47	RTRNZIP	Return Address Zip Code	String	STR10	10
48	Return_Country	Return Country	String	STR60	60
49	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Returns Line Master'].CUSTNMBR AS 'Returns Line Master-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Returns Line Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
50	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
51	ADRSCODE	Address Code	String	STR15_Address_Code	15
52	CONTACT	Contact	String	STR60	60
53	ADDRESS1	Address 1	String	STR60	60
54	ADDRESS2	Address 2	String	STR60	60
55	ADDRESS3	Address 3	String	STR60	60
56	CITY	City	String	STR35	35
57	STATE	State	String	STR30_State	29
58	ZIPCODE	Zip Code	String	STR10	10
59	COUNTRY	Country	String	STR60	60
60	Bill_To_Customer	Bill To Customer	String	STR15_RM_Customer_Number	15
61	SVC_Bill_To_Address_Code	SVC Bill To Address Code	String	STR15_Address_Code	15
62	CSTPONBR	Customer PO Number	String	STR20_Document_Number	20
63	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
64	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
65	UOFM	U Of M	String	U_Of_M	8
66	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Returns Line Master'].ITEMNMBR AS 'Returns Line Master-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN IV00101 AS ['Item Master'] ON ['Returns Line Master'].ITEMNMBR = ['Item Master'].ITEMNMBR
67	ITEMDESC	Item Description	String	STR100	100
68	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
69	ORUNTCST	Originating Unit Cost	Currency	DLR17_RBS0_UTR$	17
70	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
71	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
72	UNITPRCE	Unit Price	Currency	DLR17_RBS0_STR$	17
73	ORUNTPRC	Originating Unit Price	Currency	DLR17_RBS0_STR$	17
74	XTNDPRCE	Extended Price	Currency	DLR17_RBS0_STR$	17
75	OXTNDPRC	Originating Extended Price	Currency	DLR17_RBS0_STR$	17
76	CUSTOWN	Customer Owned	Boolean	CB	0
77	FACTSEAL	Factory Sealed	Boolean	CB	0
78	ORDDOCID	Order Document ID	String	STR15_LBAU	15
79	TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	LI_Sequence_Number	10
80	STATUS	Transfer Status	Integer	INT	0
81	Flat_Rate_Repair_Price	Flat Rate Repair Price	Currency	DLR17_RBSO_STR$	17
82	Orig_Flat_RepairPrice	Originating Flat Rate Repair Price	Currency	DLR17_RBS0_STR$	17
83	Repair_Price	Repair Price	Currency	DLR17_RBSO_STR$	17
84	Originating_Repair_Price	Originating Repair Price	Currency	DLR17_RBS0_STR$	17
85	NTE_Price	NTE Price	Currency	DLR17_RBS0_UTR$	17
86	Originating_NTE_Price	Originating NTE Price	Currency	DLR17_RBS0_UTR$	17
87	Repair_Cost	Repair Cost	Currency	DLR17_RBS0_UTR$	17
88	Originating_Repair_Cost	Originating Repair Cost	Currency	DLR17_RBS0_UTR$	17
89	Bill_of_Lading	Bill of Lading	String	STR30	30
90	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Returns Line Master'].SHIPMTHD AS 'Returns Line Master-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Returns Line Master'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
91	Credit_SOP_Type	Credit SOP Type	Integer	DDL_SOP_Type	0
92	Credit_SOP_Number	Credit SOP Number	String	STR20_SOP_Number	17
93	Credit_SOP_Line_Item_Seq	Credit SOP Line Item Sequence	Long Integer	LI_Sequence_Number	10
94	Replace_SOP_Type	Replace SOP Type	Integer	DDL_SOP_Type	0
95	Replace_SOP_Number	Replace SOP Number	String	STR20_SOP_Number	17
96	Replace_SOP_Line_Item_Se	Replace SOP Line Item Sequence	Long Integer	LI_Sequence_Number	10
97	Location_Code_Replacemen	Location Code Replacement	String	STR10_Location_Code	10
98	Replace_Item_Number	Replace Item Number	String	STR30_Item_Number	30
99	Replace_U_Of_M	Replace U Of M	String	U_Of_M	8
100	Replace_Price_Level	Replace Price Level	String	STR10_LBAU	10
101	Replace_QTY	Replace QTY	Currency	DLR17_QTY_RBS0_UTR	17
102	Replace_Cost	Replace Cost	Currency	DLR17_RBS0_STR$	17
103	Originating_Replace_Cost	Originating Replace Cost	Currency	DLR17_RBS0_STR$	17
104	Replace_Price	Replace Price	Currency	DLR17_RBS0_STR$	17
105	Originating_Replace_Pric	Originating Replace Price	Currency	DLR17_RBS0_STR$	17
106	SOP_Number_Invoice	SOP Number Invoice	String	STR20_SOP_Number	17
107	Item_Number_Invoice	Item Number Invoice	String	STR30_Item_Number	30
108	USERDEF1	User Defined 1	String	STR20	20
109	USERDEF2	User Defined 2	String	STR20	20
110	USRDEF03	User Defined 3	String	STR20	20
111	USRDEF04	User Defined 4	String	STR20	20
112	USRDEF05	User Defined 5	String	STR20	20
113	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Returns Line Master'].CURRNIDX AS 'Returns Line Master-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SVC05200 AS ['Returns Line Master'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Returns Line Master'].CURRNIDX = ['Currency Setup'].CURRNIDX
114	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
115	ODECPLCU	Originating Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
116	Return_Item_Number	Return Item Number	String	STR30_Item_Number	30
117	Return_Item_Description	Return Item Description	String	STR100	100
118	Return_Location_Code	Return Location Code	String	STR10_Location_Code	10
119	Return_QTY	Return QTY	Currency	DLR17_QTY_RBS0_UTR	17
120	Return_U_Of_M	Return U Of M	String	U_Of_M	8
121	RETCOST	Return Cost	Currency	DLR17_$S2	17
122	Originating_Return_Cost	Originating Return Cost	Currency	DLR17_RBS0_STR$	17
123	SVC_Extended_Return_Cost	SVC Extended Return Cost	Currency	DLR17_$S2	17
124	SVC_Orig_Ext_Return_Cost	SVC Originating Extended Return Cost	Currency	DLR17_$S2	17
125	SVC_Return_Price_Level	SVC Return Price Level	String	STR10_LBAU	10
126	SVC_Return_Price	SVC Return Price	Currency	DLR17_RBS0_STR$	17
127	Originating_Return_Price	Originating Return Price	Currency	DLR17_RBS0_STR$	17
128	SVC_Extended_Return_Pric	SVC Extended Return Price	Currency	DLR17_$S2	17
129	SVC_Orig_Ext_Return_Pric	SVC Originating Extended Return Price	Currency	DLR17_$S2	17
130	SVC_FO_ID	SVC FO ID	String	STR50	50
131	SVC_SCM_Complete	SVC SCM Complete	Integer	INT	0
132	svcRMAKitComponentFrom	svcRMAKitComponentFrom	Integer	RMAKitFromDDL	0
133	svcRMAComponentSeq	svcRMAComponentSeq	Long Integer	LI_Sequence_Number	10
134	CMPITQTY	Component Item QTY	Currency	DLR17_QTY_RBS0_UTR	17
135	QTYONHND	QTY On Hand	Currency	DLR17_QTY_RBS0_STR	17
136	QTYRTRND	QTY Returned	Currency	DLR17_QTY_RBS0_UTR	17
137	QTYINUSE	QTY In Use	Currency	DLR17_QTY_RBS0_UTR	17
138	QTYINSVC	QTY In Service	Currency	DLR17_QTY_RBS0_UTR	17
139	QTYDMGED	QTY Damaged	Currency	DLR17_QTY_RBS0_UTR	17
140	svcReverseFlag	svcReverseFlag	Boolean	CB	0
141	svcRMAallocated	svcRMAallocated	Boolean	CB	0

azurecurve Products FieldService (949)ProjectReturns Line Master (SVC05200)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply