IVC30101 - Invoicing Transaction History | Prospr

IVC30101 - Invoicing Transaction History

Query Builder

Select * from IVC30101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
INVCNMBR	Invoice Number	String	22	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
PCKSLPNO	Packing Slip Number	String	22	View
CUSTNMBR	Customer Number	String	16	View
CUSTNAME	Customer Name	String	66	View
CSTPONBR	Customer PO Number	String	22	View
POSTDATE	Post Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
DOCDATE	Document Date	Date	4	View
QUOTEDAT	Quote Date	Date	4	View
ORDRDATE	Order Date	Date	4	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
HOLDNT	Hold NT	Boolean	2	View
SHIPMTHD	Shipping Method	String	16	View
TAXEXMT1	Tax Exempt 1	String	26	View
TAXEXMT2	Tax Exempt 2	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
MSCSCHID	Misc Schedule ID	String	16	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
MRKDNAMT	Markdown Amount	Currency	10	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
TXRGNNUM	Tax Registration Number	String	26	View
PYMTRMID	Payment Terms ID	String	22	View
PRCLEVEL	PriceLevel	String	12	View
LOCNCODE	Location Code	String	12	View
CURNCYID	Currency ID	String	16	View
COMMNTID	Comment ID	String	16	View
DOCAMNT	Document Amount	Currency	10	View
SUBTOTAL	Subtotal	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TXBTXAMT	Taxable Tax Amount	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ACCTAMNT	Account Amount	Currency	10	View
PYMTRCVD	Payment Received	Currency	10	View
CODAMNT	COD Amount	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
DISCRTND	Discount Returned	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
PRBTADCD	Primary Billto Address Code	String	16	View
PRSTADCD	Primary Shipto Address Code	String	16	View
CNTCPRSN	Contact Person	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
CCode	Country Code	String	8	View
COUNTRY	Country	String	62	View
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
PHONE3	Phone 3	String	22	View
FAXNUMBR	Fax Number	String	22	View
COMAPPTO	Commission Applied To	Integer	2	View
COMDLRAM	Commission Dollar Amount	Currency	10	View
NCOMAMNT	Non-Commissioned Amount	Currency	10	View
UPSZONE	UPS Zone	String	4	View
LSTUSRED	Last User to Edit	String	16	View
LSTEDTDT	Last Edit Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
USER2ENT	User To Enter	String	16	View
NOTEINDX	Note Index	Currency	10	View
TIMESPRT	Times Printed	Integer	2	View
NOCARTNS	Number Of Cartons	Integer	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
TRXSORCE	TRX Source	String	14	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
COMMENT_1	Comment[1]	String	52	View
COMMENT_2	Comment[2]	String	52	View
COMMENT_3	Comment[3]	String	52	View
COMMENT_4	Comment[4]	String	52	View
ECTRX	EC Transaction	Boolean	2	View
ShipToName	ShipToName	String	66	View
Tax_Date	Tax Date	Date	4	View
APLYWITH	Apply Withholding	Boolean	2	View
WITHHAMT	Withholding Amount	Currency	10	View
CMMTTEXT	Comment Text	Text	2	View

IVC30101 - Invoicing Transaction History

Query Builder

Customer Service

Information

My Account

Contact Us