SVC00203 - Service Call Line Detail | Prospr - Dynamics GP Table Reference

SVC00203 - Service Call Line Detail

Query Builder

Select * from SVC00203

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SRVRECTYPE	Service Record Type	Integer	2	View
CALLNBR	Service Call Number	String	12	View
EQPLINE	Equipment Line Item Sequence	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
LINITMTYP	Line Item Type	String	4	View
SRVSTAT	Service Call Status	String	4	View
TECHID	Tech ID	String	12	View
ITEMNMBR	Item Number	String	32	View
ITEMUSETYPE	Item Use Type	String	4	View
ITEMDESC	Item Description	String	102	View
LOCNCODE	Location Code	String	12	View
UOFM	U Of M	String	10	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
NOTEINDX	Note Index	Currency	10	View
STRTDATE	Start Date	Date	4	View
STRTTIME	Start Time	Time	4	View
ENDDATE	End Date	Date	4	View
ENDTME	SVC_End Time	Time	4	View
TRANSTME	Transaction Time	String	8	View
BILLABLTIM	Billable Time	String	8	View
TRNSFLOC	Transfer From Location	String	12	View
TRNSFQTY	Transfer From QTY	Currency	10	View
TRNFLAG	Transfer Flag	Boolean	2	View
ORDDOCID	Order Document ID	String	16	View
TRANSLINESEQ	Transfer Line Item Sequence	Long Integer	4	View
LABPCT	Labor Pct	Currency	10	View
PARTPCT	Part Pct	Currency	10	View
MISCPCT	Misc Pct	Currency	10	View
FUFILDAT	Fulfillment Date	Date	4	View
PONMBRSTR	Purchase_Order_Number_STR	String	18	View
POLNSEQ	Purchase_Order_Line_Sequence_DOL	Currency	10	View
On_Return	On Return	Boolean	2	View
RETDOCID	Return Document ID	String	16	View
LNSEQNBR	Line SEQ Number	Currency	10	View
Miles_Start	Miles Start	Long Integer	4	View
Miles_End	Miles End	Long Integer	4	View
Miles_Used	Miles Used	Long Integer	4	View
PRICELVL	Price Level	String	16	View
SVC_Address_Option	SVC_Address_Option	Integer	2	View
SVC_Misc_Address_Code	SVC_Misc_Address_Code	String	16	View
SVC_Disable_XFR_Grouping	SVC_Disable_XFR_Grouping	Boolean	2	View
Work_Type	Work Type	String	12	View
ORUNTCST	Originating Unit Cost	Currency	10	View
ORUNTPRC	Originating Unit Price	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
OXTNDPRC	Originating Extended Price	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
SVC_FO_ID	SVC FO ID	String	52	View
svcCreateVoucher	svcCreateVoucher	Boolean	2	View
VCHRNMBR	Voucher Number	String	22	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
CMPITQTY	Component Item QTY	Currency	10	View

SVC00203 - Service Call Line Detail

Query Builder

Customer Service

Information

My Account

Contact Us