IVC40100 - Invoicing Setup | Prospr - Dynamics GP Table Reference

IVC40100 - Invoicing Setup

Query Builder

Select * from IVC40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SETUPKEY	Setup Key	Integer	2	View
DPYITMCS	Display Item Unit Cost	Boolean	2	View
ACDSTRBN	Account Distributions	Boolean	2	View
TRKVDTRX	Track Voided Trx In History	Boolean	2	View
TRXDTL	Transaction Detail	Boolean	2	View
LOCNCODE	Location Code	String	12	View
CHEKBKID	Checkbook ID	String	16	View
INVCFRMT	Invoice Format	Integer	2	View
RETNFRMT	Return Format	Integer	2	View
PKSLPFMT	Packing Slip Format	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
USEADVTX	Use Advanced Taxes	Integer	2	View
NONIVSCH	Non IV Item Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
NONIVTXB	Non IV Taxable	Integer	2	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
USEACFRM	Use Posting Accounts From	Integer	2	View
RTNUSIVC	Return Use Invoice	Boolean	2	View
PKSLPIVC	Packing Slip Use Invoice	Boolean	2	View
COMMNTID	Comment ID	String	16	View
IVCALLOW_1	IVC Allow[1]	Boolean	2	View
IVCALLOW_2	IVC Allow[2]	Boolean	2	View
IVCALLOW_3	IVC Allow[3]	Boolean	2	View
IVCALLOW_4	IVC Allow[4]	Boolean	2	View
IVCALLOW_5	IVC Allow[5]	Boolean	2	View
IVCALLOW_6	IVC Allow[6]	Boolean	2	View
IVCALLOW_7	IVC Allow[7]	Boolean	2	View
IVCALLOW_8	IVC Allow[8]	Boolean	2	View
IVCALLOW_9	IVC Allow[9]	Boolean	2	View
IVCALLOW_10	IVC Allow[10]	Boolean	2	View
IVCALLOW_11	IVC Allow[11]	Boolean	2	View
IVCPSSWD_1	IVC Password[1]	String	12	View
IVCPSSWD_2	IVC Password[2]	String	12	View
IVCPSSWD_3	IVC Password[3]	String	12	View
IVCPSSWD_4	IVC Password[4]	String	12	View
IVCPSSWD_5	IVC Password[5]	String	12	View
IVCPSSWD_6	IVC Password[6]	String	12	View
IVCPSSWD_7	IVC Password[7]	String	12	View
IVCPSSWD_8	IVC Password[8]	String	12	View
IVCPSSWD_9	IVC Password[9]	String	12	View
IVCPSSWD_10	IVC Password[10]	String	12	View
IVCPSSWD_11	IVC Password[11]	String	12	View
IVCSEQNC_1	IVC Sequence[1]	Integer	2	View
IVCSEQNC_2	IVC Sequence[2]	Integer	2	View
IVCSEQNC_3	IVC Sequence[3]	Integer	2	View
IVCSEQNC_4	IVC Sequence[4]	Integer	2	View
IVCSEQNC_5	IVC Sequence[5]	Integer	2	View
IVCSEQNC_6	IVC Sequence[6]	Integer	2	View
IVCSEQNC_7	IVC Sequence[7]	Integer	2	View
IVCSEQNC_8	IVC Sequence[8]	Integer	2	View
IVCSEQNC_9	IVC Sequence[9]	Integer	2	View
IVCSEQNC_10	IVC Sequence[10]	Integer	2	View
IVCSEQNC_11	IVC Sequence[11]	Integer	2	View
IVCDSTCK	IVC Dist Check	Long Integer	4	View
NUMOFTRX	Number Of TRX	Long Integer	4	View

IVC40100 - Invoicing Setup

Query Builder

Customer Service

Information

My Account

Contact Us