SVC_RTV_MSTR (SVC05600)

azurecurve Products FieldService (949)ProjectSVC_RTV_MSTR (SVC05600)

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

Display Name: SVC_RTV_MSTR
Physical Name: SVC05600
Technical Name: SVC_RTV_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	RTV_Number	RTV Number	String	STR15_LBAU	15
2	RTV_Type	RTV Type	String	STR10_LBAU	10
3	RTV_Return_Status	RTV Return Status	String	STR3_LBAU	3
4	RTV_Status	RTV Status	Integer	DDL_RTV_Type	0
5	VRMA_Document_ID	VRMA Document ID	String	STR15_LBAU	15
6	RETDOCID	Return Document ID	String	STR15_LBAU	15
7	LNSEQNBR	Line SEQ Number	Currency	Sequence_Number	19
8	DSCRIPTN	Description	String	STR30	30
9	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['SVC_RTV_MSTR'].VENDORID AS 'SVC_RTV_MSTR-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['SVC_RTV_MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID
10	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
11	ADRSCODE	Address Code	String	STR15_Address_Code	15
12	Ship_Address_Name	Ship Address Name	String	STR64_Vendor_Name	64
13	Ship_Address_1	Ship Address 1	String	STR60	60
14	Ship_Address_2	Ship Address 2	String	STR60	60
15	Ship_Address_3	Ship Address 3	String	STR60	60
16	Ship_City	Ship City	String	STR35	35
17	Ship_State	Ship State	String	STR30_State	29
18	ZIPCODE	Zip Code	String	STR10	10
19	Ship_Country	Ship Country	String	STR60	60
20	ENTDTE	Entry Date	Date	DT_Date	6
21	ENTTME	Entry Time	Time	TM6	6
22	PRMDATE	Promised Date	Date	DATE_L	0
23	Promised_Time	Promised Time	Time	TM6	6
24	Shipped_Date	Shipped Date	Date	DT_Date	6
25	Shipped_Time	Shipped Time	Time	TM6	6
26	receiptdate	Receipt Date	Date	DT	8
27	Receipt_Time	Receipt Time	Time	TM6	6
28	COMPDTE	Complete Date	Date	DT_Date	6
29	COMPTME	Complete Time	Time	TM6	6
30	LOCCODEB	Location Code Bad	String	STR10_Location_Code	10
31	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['SVC_RTV_MSTR'].LOCNCODE AS 'SVC_RTV_MSTR-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN IV40700 AS ['Site Setup'] ON ['SVC_RTV_MSTR'].LOCNCODE = ['Site Setup'].LOCNCODE
32	Part_Price	Part Price	Currency	DLR17_RBS0_STR$	17
33	Part_Cost	Part Cost	Currency	DLR17_RBS0_STR$	17
34	Labor_Price	Labor Price	Currency	DLR17_RBS0_STR$	17
35	Labor_Cost	Labor Cost	Currency	DLR17_RBS0_STR$	17
36	Expense_Price	Expense Price	Currency	DLR17_RBS0_STR$	17
37	Expense_Cost	Expense Cost	Currency	DLR17_RBS0_STR$	17
38	Travel_Price	Travel Price	Currency	DLR17_RBS0_STR$	17
39	Travel_Cost	Travel Cost	Currency	DLR17_RBS0_STR$	17
40	Bill_of_Lading_Out	Bill of Lading Out	String	STR30	30
41	Shipping_Method_Out	Shipping Method Out	String	STR15_Shipping_Method	15
42	Bill_of_Lading	Bill of Lading	String	STR30	30
43	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SVC_RTV_MSTR'].SHIPMTHD AS 'SVC_RTV_MSTR-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SVC_RTV_MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
44	OFFID	Office ID	String	STR10_LBAU	10
45	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SVC_RTV_MSTR'].NOTEINDX AS 'SVC_RTV_MSTR-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SVC_RTV_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
46	VCHNUMWK	Voucher Number - WORK	String	STR17_LBAU	17
47	Voucher_Number_Invoice	Voucher Number Invoice	String	STR17_LBAU	17
48	Voucher_Number_Reimburse	Voucher Number Reimbursement	String	STR17_LBAU	17
49	CUSTOWN	Customer Owned	Boolean	CB	0
50	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SVC_RTV_MSTR'].USERID AS 'SVC_RTV_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SVC_RTV_MSTR'].USERID = ['Users Master'].USERID
51	USERDEF1	User Defined 1	String	STR20	20
52	USERDEF2	User Defined 2	String	STR20	20
53	USRDEF03	User Defined 3	String	STR20	20
54	USRDEF04	User Defined 4	String	STR20	20
55	USRDEF05	User Defined 5	String	STR20	20
56	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SVC_RTV_MSTR'].CURNCYID AS 'SVC_RTV_MSTR-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SVC_RTV_MSTR'].CURNCYID = ['Currency Setup'].CURNCYID
57	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['SVC_RTV_MSTR'].CURRNIDX AS 'SVC_RTV_MSTR-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['SVC_RTV_MSTR'].CURRNIDX = ['Currency Setup'].CURRNIDX
58	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['SVC_RTV_MSTR'].RATETPID AS 'SVC_RTV_MSTR-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['SVC_RTV_MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
59	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['SVC_RTV_MSTR'].EXGTBLID AS 'SVC_RTV_MSTR-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM SVC05600 AS ['SVC_RTV_MSTR'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['SVC_RTV_MSTR'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
60	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
61	EXCHDATE	Exchange Date	Date	DT_Date	6
62	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
63	TIME1	Time	Time	TM6	6
64	RATECALC	Rate Calc Method	Integer	INT	0
65	VIEWMODE	View Mode	Integer	INT	0
66	ISMCTRX	IS MC Trx	Integer	INT	0
67	EXPNDATE	Expiration Date	Date	DT_Date	6
68	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
69	MCTRXSTT	MC Transaction State	Integer	INT1	1
70	Originating_Part_Price	Originating Part Price	Currency	DLR17_RBS0_STR$	17
71	Originating_Part_Cost	Originating Part Cost	Currency	DLR17_RBS0_STR$	17
72	Originating_Labor_Price	Originating Labor Price	Currency	DLR17_RBS0_STR$	17
73	Originating_Labor_Cost	Originating Labor Cost	Currency	DLR17_RBS0_STR$	17
74	Originating_ExpensePrice	Originating Expense Price	Currency	DLR17_RBS0_STR$	17
75	Originating_Expense_Cost	Originating Expense Cost	Currency	DLR17_RBS0_STR$	17
76	Originating_Travel_Price	Originating Travel Price	Currency	DLR17_RBS0_STR$	17
77	Originating_Travel_Cost	Originating Travel Cost	Currency	DLR17_RBS0_STR$	17
78	VOIDSTTS	Void Status	Integer	INT	0

azurecurve Products FieldService (949)ProjectSVC_RTV_MSTR (SVC05600)

Leave a Reply Cancel reply