SVC35601 - SVC_RTV_Line_HIST | Prospr - Dynamics GP Table Reference

SVC35601 - SVC_RTV_Line_HIST

Query Builder

Select * from SVC35601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RTV_Number	RTV Number	String	16	View
RTV_Line	RTV Line	Currency	10	View
RTV_Type	RTV Type	String	12	View
RTV_Status	RTV Status	Integer	2	View
RTV_Return_Status	RTV Return Status	String	4	View
VRMA_Document_ID	VRMA Document ID	String	16	View
RETDOCID	Return Document ID	String	16	View
LNSEQNBR	Line SEQ Number	Currency	10	View
SVC_Process_SEQ_Number	SVC Process SEQ Number	Currency	10	View
DSCRIPTN	Description	String	32	View
REFRENCE	Reference	String	32	View
Reference2	Reference2	String	32	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
QUANTITY	QTY	Currency	10	View
QTYSHPPD	QTY Shipped	Currency	10	View
QTY_To_Receive	QTY To Receive	Currency	10	View
QTYRECVD	QTY Received	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
UOFM	U Of M	String	10	View
VENDORID	Vendor ID	String	16	View
VNDITNUM	Vendor Item Number	String	32	View
Return_Item_Number	Return Item Number	String	32	View
OFFID	Office ID	String	12	View
LOCCODEB	Location Code Bad	String	12	View
LOCNCODE	Location Code	String	12	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
PONMBRSTR	Purchase_Order_Number_STR	String	18	View
POLNSEQ	Purchase_Order_Line_Sequence_DOL	Currency	10	View
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
Transfer_Reference	Transfer Reference	String	32	View
TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	4	View
CALLNBR	Service Call Number	String	12	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
LINITMTYP	Line Item Type	String	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	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
Tracking_Number	Tracking Number	String	42	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
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
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
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
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View

SVC35601 - SVC_RTV_Line_HIST

Query Builder

Customer Service

Information

My Account

Contact Us