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.