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

COMPANY..IV10301 Table Definition

(COMPANY..Stock Count Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
STCKCNTID char(15)
''
This simil...(more) Join Now
ITEMNMBR char(31)
''
The Invent...(more) Join Now
join ... more text available
LOCNCODE char(11)
''
This is th...(more) Join Now
join ... more text available
BINNMBR char(21)
''
If Multi-B...(more) Join Now
CAPTUREDQTY numeric(19,5)
0.00
This is th...(more) Join Now
COUNTEDQTY numeric(19,5)
0.00
This is th...(more) Join Now
COUNTDATE datetime
'1/1/1900'
The date t...(more) Join Now
COUNTTIME datetime
'1/1/1900'
The time t...(more) Join Now
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
ITMTRKOP smallint
0
Value take...(more) Join Now
IVIVINDX int
0
The long i...(more) Join Now
Stock_Serial_Lot_Count numeric(19,5)
0.00
If the ite...(more) Join Now
STCKSRLLTVRNC numeric(19,5)
0.00
This is th...(more) Join Now
IVVARIDX int
0
The long i...(more) Join Now
VARIANCEQTY numeric(19,5)
0.00
This is th...(more) Join Now
VERIFIED tinyint
0
Boolean va...(more) Join Now
Temp_Allocated_Quantity numeric(19,5)
0.00
This field...(more) Join Now
ACTIVE tinyint
0
This is a ...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Reason_Code 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