SVC35600 - SVC_RTV_MSTR_HIST | Prospr - Dynamics GP Table Reference

SVC35600 - SVC_RTV_MSTR_HIST

Query Builder

Select * from SVC35600

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RTV_Number	RTV Number	String	16	View
RTV_Type	RTV Type	String	12	View
RTV_Return_Status	RTV Return Status	String	4	View
RTV_Status	RTV Status	Integer	2	View
VRMA_Document_ID	VRMA Document ID	String	16	View
RETDOCID	Return Document ID	String	16	View
LNSEQNBR	Line SEQ Number	Currency	10	View
DSCRIPTN	Description	String	32	View
VENDORID	Vendor ID	String	16	View
VENDNAME	Vendor Name	String	66	View
ADRSCODE	Address Code	String	16	View
Ship_Address_Name	Ship Address Name	String	66	View
Ship_Address_1	Ship Address 1	String	62	View
Ship_Address_2	Ship Address 2	String	62	View
Ship_Address_3	Ship Address 3	String	62	View
Ship_City	Ship City	String	36	View
Ship_State	Ship State	String	30	View
ZIPCODE	Zip Code	String	12	View
Ship_Country	Ship Country	String	62	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
PRMDATE	Promised Date	Date	4	View
Promised_Time	Promised Time	Time	4	View
Shipped_Date	Shipped Date	Date	4	View
Shipped_Time	Shipped Time	Time	4	View
receiptdate	Receipt Date	Date	4	View
Receipt_Time	Receipt Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
LOCCODEB	Location Code Bad	String	12	View
LOCNCODE	Location Code	String	12	View
Part_Price	Part Price	Currency	10	View
Part_Cost	Part Cost	Currency	10	View
Labor_Price	Labor Price	Currency	10	View
Labor_Cost	Labor Cost	Currency	10	View
Expense_Price	Expense Price	Currency	10	View
Expense_Cost	Expense Cost	Currency	10	View
Travel_Price	Travel Price	Currency	10	View
Travel_Cost	Travel Cost	Currency	10	View
Bill_of_Lading_Out	Bill of Lading Out	String	32	View
Shipping_Method_Out	Shipping Method Out	String	16	View
Bill_of_Lading	Bill of Lading	String	32	View
SHIPMTHD	Shipping Method	String	16	View
OFFID	Office ID	String	12	View
NOTEINDX	Note Index	Currency	10	View
VCHNUMWK	Voucher Number - WORK	String	18	View
Voucher_Number_Invoice	Voucher Number Invoice	String	18	View
Voucher_Number_Reimburse	Voucher Number Reimbursement	String	18	View
CUSTOWN	Customer Owned	Boolean	2	View
USERID	User ID	String	16	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USRDEF03	User Defined 3	String	22	View
USRDEF04	User Defined 4	String	22	View
USRDEF05	User Defined 5	String	22	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
DECPLACS	Decimal Places	Integer	2	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
VIEWMODE	View Mode	Integer	2	View
ISMCTRX	IS MC Trx	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
Originating_Part_Price	Originating Part Price	Currency	10	View
Originating_Part_Cost	Originating Part Cost	Currency	10	View
Originating_Labor_Price	Originating Labor Price	Currency	10	View
Originating_Labor_Cost	Originating Labor Cost	Currency	10	View
Originating_ExpensePrice	Originating Expense Price	Currency	10	View
Originating_Expense_Cost	Originating Expense Cost	Currency	10	View
Originating_Travel_Price	Originating Travel Price	Currency	10	View
Originating_Travel_Cost	Originating Travel Cost	Currency	10	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View

SVC35600 - SVC_RTV_MSTR_HIST

Query Builder

Customer Service

Information

My Account

Contact Us