Module List > Module IV tables IV40100
You are currently viewing the COMPANY database.
Change

COMPANY..IV40100 Table Definition

(COMPANY..Inventory Control Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SETUPKEY smallint
0
Setup Key...(more) Join Now
USCATDSC_1 char(15)
''
User Categ...(more) Join Now
USCATDSC_2 char(15)
''
User Categ...(more) Join Now
USCATDSC_3 char(15)
''
User Categ...(more) Join Now
USCATDSC_4 char(15)
''
User Categ...(more) Join Now
USCATDSC_5 char(15)
''
User Categ...(more) Join Now
USCATDSC_6 char(15)
''
User Categ...(more) Join Now
DCDCRADJ tinyint
0
Display Co...(more) Join Now
ACSGFLOC smallint
0
Account Se...(more) Join Now
MAINLOCN char(11)
''
Main Locat...(more) Join Now
DECPLCUR smallint
0
Number of ...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
NXADJDOC char(21)
''
Next Adjus...(more) Join Now
TXTRDNUM char(21)
''
Next Trans...(more) Join Now
NXTVDNUM char(21)
''
Next Varia...(more) Join Now
NXPRDNUM char(21)
''
Next Produ...(more) Join Now
ALADJOVR tinyint
0
Allow Adju...(more) Join Now
AVAROVRD tinyint
0
Allow Vari...(more) Join Now
ATRSOVRD tinyint
0
Allow Tran...(more) Join Now
ATPSTVRNC tinyint
0
Auto Post ...(more) Join Now
ENABLEMULTIBIN tinyint
0
Enable Mul...(more) Join Now
ENPICKSHORTTSK tinyint
0
Enable Pic...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
DISABLEAVGPERPADJ tinyint
0
Disable Av...(more) Join Now
DISABLEPERPADJ tinyint
0
Disable Pe...(more) Join Now
ALLEXPLOTSIV tinyint
0
Allow Expi...(more) Join Now
ALLEXPLOTSIVPASS char(11)
''
Allow Expi...(more) Join Now
ALLEXPLOTSOTHER tinyint
0
Allow Expi...(more) Join Now
ALLEXPLOTOTHERPASS char(11)
''
Allow Expi...(more) Join Now
USEEXISTINGSNLOTS tinyint
0
Use Only E...(more) Join Now
ASSIGNLOTNUMBY smallint
0
Assign Lot...(more) Join Now
NXTSPNUM char(15)
''
Next Two S...(more) Join Now
VIALOCN char(11)
''
Via Locati...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Next_Bin_XFer_Doc_Number char
''

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