IVC30102 - Invoicing Transaction Amounts History | Prospr

IVC30102 - Invoicing Transaction Amounts History

Query Builder

Select * from IVC30102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
INVCNMBR	Invoice Number	String	22	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
CMPNTSEQ	Component Sequence	Long Integer	4	View
NONINVEN	Non IV	Integer	2	View
ITEMNMBR	Item Number	String	32	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
ITMTSHID	Item Tax Schedule ID	String	16	View
IVITMTXB	IV Item Taxable	Integer	2	View
QUANTITY	QTY	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
EXTQTYSEL	Existing Qty Selected	Currency	10	View
UOFM	U Of M	String	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
LOCNCODE	Location Code	String	12	View
MRKDNTYP	Markdown Type	Integer	2	View
MRKDNAMT	Markdown Amount	Currency	10	View
MRKDNPCT	Markdown Percent	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
XTNDPRCE	Extended Price	Currency	10	View
UNITPRCE	Unit Price	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
BKTSLSAM	Backout Sales Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
DSCRIPTN	Description	String	32	View
ITEMDESC	Item Description	String	102	View
EXPTSHIP	Expected Ship Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
ReqShipDate	Requested Ship Date	Date	4	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
CMPSERNM	Component Serial Numbered	Boolean	2	View
COMMNTID	Comment ID	String	16	View
BRKFLD1	Break Field 1	Integer	2	View
BRKFLD2	Break Field 2	Integer	2	View
BRKFLD3	Break Field 3	Integer	2	View
TRXSORCE	TRX Source	String	14	View
PRSTADCD	Primary Shipto Address Code	String	16	View
SHIPMTHD	Shipping Method	String	16	View
ISLINEINTRA	IsLineIntrastat	Boolean	2	View

IVC30102 - Invoicing Transaction Amounts History

Query Builder

Customer Service

Information

My Account

Contact Us