Module List > Module Manufacturing tables IVIC0101
You are currently viewing the COMPANY database.
Change

COMPANY..IVIC0101 Table Definition

(COMPANY..Manufacturing Series Inventory Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
IVDOCTYP smallint
0

IVDOCNBR char(17)
''

LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
RTSEQNUM_I char(11)
''

PICKLISTSEQ int
0

PICKNUMBER char(17)
''

PICKDOCLINENUM int
0

BACKFLUSHITEM_I tinyint
0

MOPRCTNM char(21)
''

DTRCVDINVNTRY datetime
'1/1/1900'

NUMBERSCRAPPED_I numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_1 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_2 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_3 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_4 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_5 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_6 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_7 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_8 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_9 numeric(19,5)
0.00

ITEM_COSTS_ARRAY_I_10 numeric(19,5)
0.00

CLOSEBOOL_I tinyint
0

CALLEDBY smallint
0

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