SVC06101 - Depot Master Line | Prospr - Dynamics GP Table Reference

SVC06101 - Depot Master Line

Select * from SVC06101

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
LINITMTYP	Line Item Type	String	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
ITEMUSETYPE	Item Use Type	String	4	View
ITEMDESC	Item Description	String	102	View
STATIONID	Depot Station ID	String	12	View
LOCNCODE	Location Code	String	12	View
UOFM	U Of M	String	10	View
TECHID	Tech ID	String	12	View
QTYORDER	QTY Ordered	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYBACKO	QTY Backordered	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
XTNDPRCE	Extended Price	Currency	10	View
STRTDATE	Start Date	Date	4	View
STRTTIME	Start Time	Time	4	View
ENDDATE	End Date	Date	4	View
ENDTIME	End Time	Time	4	View
TRANSTME	Transaction Time	String	8	View
BILLABLTIM	Billable Time	String	8	View
NOTEINDX	Note Index	Currency	10	View
SEQUENCE1	Sequence	Currency	10	View
ORDDOCID	Order Document ID	String	16	View
TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	4	View
PONMBRSTR	Purchase_Order_Number_STR	String	18	View
POLNSEQ	Purchase_Order_Line_Sequence_DOL	Currency	10	View
FUFILDAT	Fulfillment Date	Date	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
CMPITQTY	Component Item QTY	Currency	10	View