SVC06100 - Depot Master | Prospr - Dynamics GP Table Reference

SVC06100 - Depot Master

Query Builder

Select * from SVC06100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
WORECTYPE	Work Order Record Type	Integer	2	View
WORKORDNUM	Work Order Number	String	12	View
WOSTAT	Work Order Status	String	4	View
WOTYPE	Work Order Type	String	12	View
SVC_Depot_Priority	SVC_Depot_Priority	Currency	10	View
PARWORECTYPE	Parent Work Order Record Type	Integer	2	View
PARWONUM	Parent Work Order Number	String	16	View
ORIGIN	Origin	Integer	2	View
REFRENCE	Reference	String	32	View
TIMEZONE	TimeZone	String	4	View
ENTDTE	Entry Date	Date	4	View
ENTTME	Entry Time	Time	4	View
ETADTE	ETA Date	Date	4	View
ETATME	ETA Time	Time	4	View
ECOMPDT	EComp Date	Date	4	View
EComp_Time	EComp Time	Time	4	View
RETUDATE	Return Date	Date	4	View
Return_Time	Return Time	Time	4	View
COMPDTE	Complete Date	Date	4	View
COMPTME	Complete Time	Time	4	View
BIN	Bin	String	16	View
USERID	User ID	String	16	View
OFFID	Office ID	String	12	View
CUSTNMBR	Customer Number	String	16	View
ADRSCODE	Address Code	String	16	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
RETDOCID	Return Document ID	String	16	View
LNSEQNBR	Line SEQ Number	Currency	10	View
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
SERVLITEMSEQ	Service Line Item Sequence	Long Integer	4	View
IBITEMNUM	Inbound Item Number	String	32	View
IBSERIAL	Inbound Serial Number	String	22	View
IBEQUIPID	Inbound Equipment ID	Long Integer	4	View
OBITEMNUM	Outbound Item Number	String	32	View
OBSERIAL	Outbound Serial Number	String	22	View
OBEQUIPID	Outbound Equipment ID	Long Integer	4	View
QUANTITY	QTY	Currency	10	View
STATIONID	Depot Station ID	String	12	View
ROUTEID	Route ID	String	12	View
SEQUENCE1	Sequence	Currency	10	View
LOCNCODE	Location Code	String	12	View
IBANALCODE	Inbound Analysis Code	String	12	View
OBANALCODE	Outbound Analysis Code	String	12	View
CUSTOWN	Customer Owned	Boolean	2	View
ORDDOCID	Order Document ID	String	16	View
TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
FACTSEAL	Factory Sealed	Boolean	2	View
LABSTOTCST	Labor Sub Total Cost	Currency	10	View
PARSTOTCST	Part Sub Total Cost	Currency	10	View
TOTLABHRS	Total Labor Hours	Currency	10	View
PRICELVL	Price Level	String	16	View
NUMRESCHED	Number of Reschedules	Integer	2	View
Commit_Date	Commit Date	Date	4	View
Commit_Time	Commit Time	Time	4	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
ADDRESS3	Address 3	String	62	View
COUNTRY	Country	String	62	View
SVC_RMA_Reason_Code	SVC_RMA_Reason_Code	String	4	View
SVC_RMA_Reason_Code_Desc	SVC_RMA_Reason_Code_Desc	String	32	View
SVC_Process_SEQ_Number	SVC Process SEQ Number	Currency	10	View
svcRMAComponentSeq	svcRMAComponentSeq	Long Integer	4	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View

SVC06100 - Depot Master

Query Builder

Customer Service

Information

My Account

Contact Us