Module List >
Module Manufacturing tables
IVIC0101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..IVIC0101 Table Definition
(COMPANY..Manufacturing Series Inventory Line)
Field Definitions:
What is the 'source' column?
| 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
|
|
|
|
|