GP Tables

IVC40100 - Invoicing Setup

SQL Query Builder

62 Columns

Column Description Type Length
SETUPKEY smallint 0
DPYITMCS tinyint 0
ACDSTRBN tinyint 0
TRKVDTRX tinyint 0
TRXDTL tinyint 0
LOCNCODE char(11) ''
CHEKBKID char(15) ''
INVCFRMT smallint 0
RETNFRMT smallint 0
PKSLPFMT smallint 0
DECPLQTY smallint 0
DECPLCUR smallint 0
USEADVTX smallint 0
NONIVSCH char(15) ''
FRTSCHID char(15) ''
MSCSCHID char(15) ''
TAXSCHID char(15) ''
NONIVTXB smallint 0
FRGTTXBL smallint 0
MISCTXBL smallint 0
USRDFPR1 char(15) ''
USRDRPR2 char(15) ''
USEACFRM smallint 0
RTNUSIVC tinyint 0
PKSLPIVC tinyint 0
COMMNTID char(15) ''
IVCALLOW_1 tinyint 0
IVCALLOW_2 tinyint 0
IVCALLOW_3 tinyint 0
IVCALLOW_4 tinyint 0
IVCALLOW_5 tinyint 0
IVCALLOW_6 tinyint 0
IVCALLOW_7 tinyint 0
IVCALLOW_8 tinyint 0
IVCALLOW_9 tinyint 0
IVCALLOW_10 tinyint 0
IVCALLOW_11 tinyint 0
IVCPSSWD_1 char(11) ''
IVCPSSWD_2 char(11) ''
IVCPSSWD_3 char(11) ''
IVCPSSWD_4 char(11) ''
IVCPSSWD_5 char(11) ''
IVCPSSWD_6 char(11) ''
IVCPSSWD_7 char(11) ''
IVCPSSWD_8 char(11) ''
IVCPSSWD_9 char(11) ''
IVCPSSWD_10 char(11) ''
IVCPSSWD_11 char(11) ''
IVCSEQNC_1 smallint 0
IVCSEQNC_2 smallint 0
IVCSEQNC_3 smallint 0
IVCSEQNC_4 smallint 0
IVCSEQNC_5 smallint 0
IVCSEQNC_6 smallint 0
IVCSEQNC_7 smallint 0
IVCSEQNC_8 smallint 0
IVCSEQNC_9 smallint 0
IVCSEQNC_10 smallint 0
IVCSEQNC_11 smallint 0
IVCDSTCK binary(4) 0
NUMOFTRX int 0
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with IVC40100. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100