Module List > Module IVC tables IVC40100
You are currently viewing the COMPANY database.
Change

COMPANY..IVC40100 Table Definition

(COMPANY..Invoicing Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SETUPKEY smallint
0
Setup Key:...(more) Join Now
DPYITMCS tinyint
0
Display It...(more) Join Now
ACDSTRBN tinyint
0
Account Di...(more) Join Now
TRKVDTRX tinyint
0
Track Void...(more) Join Now
TRXDTL tinyint
0
Transactio...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
CHEKBKID char(15)
''
Checkbook ...(more) Join Now
join ... more text available
INVCFRMT smallint
0
Invoice Fo...(more) Join Now
RETNFRMT smallint
0
Return For...(more) Join Now
PKSLPFMT smallint
0
Packing Sl...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
USEADVTX smallint
0
Use Advanc...(more) Join Now
NONIVSCH char(15)
''
Non IV Ite...(more) Join Now
FRTSCHID char(15)
''
Freight Sc...(more) Join Now
join ... more text available
MSCSCHID char(15)
''
Misc Sched...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
NONIVTXB smallint
0
Non IV Tax...(more) Join Now
FRGTTXBL smallint
0
Freight Ta...(more) Join Now
MISCTXBL smallint
0
Misc Taxab...(more) Join Now
USRDFPR1 char(15)
''
User Defin...(more) Join Now
USRDRPR2 char(15)
''
User Defin...(more) Join Now
USEACFRM smallint
0
Use Postin...(more) Join Now
RTNUSIVC tinyint
0
Return Use...(more) Join Now
PKSLPIVC tinyint
0
Packing Sl...(more) Join Now
COMMNTID char(15)
''
Comment ID...(more) Join Now
join ... more text available
IVCALLOW_1 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_2 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_3 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_4 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_5 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_6 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_7 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_8 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_9 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_10 tinyint
0
IVC Allow:...(more) Join Now
IVCALLOW_11 tinyint
0
IVC Allow:...(more) Join Now
IVCPSSWD_1 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_2 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_3 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_4 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_5 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_6 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_7 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_8 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_9 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_10 char(11)
''
IVC Passwo...(more) Join Now
IVCPSSWD_11 char(11)
''
IVC Passwo...(more) Join Now
IVCSEQNC_1 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_2 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_3 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_4 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_5 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_6 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_7 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_8 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_9 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_10 smallint
0
IVC Sequen...(more) Join Now
IVCSEQNC_11 smallint
0
IVC Sequen...(more) Join Now
IVCDSTCK binary(4)
0
IVC Dist C...(more) Join Now
NUMOFTRX int
0
Number Of ...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3