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

COMPANY..IV10003 Table Definition

(COMPANY..Inventory Transaction Bin Quantities Work)

This file is used to store bin information for line items on Inventory transactions. The line items must be for Inventory item. A single record in this file is used to store information for one bin number. The records in this file for a line item are linked back to the line item's record in the IV_TRX_WORK_LINE file by the values in the IV Document Type, IV Document Number, and Line SEQ Number fields.

In SBM, this table is not available. SBM does not use multiple bin functionality.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
IVDOCNBR char(17)
''
IV Documen...(more) Join Now
IVDOCTYP smallint
0
IV Documen...(more) Join Now
LNSEQNBR numeric(19,5)
0
Line SEQ N...(more) Join Now
SEQNUMBR int
0
Sequence N...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
BIN char(15)
''
Bin The de...(more) Join Now
TOBIN char(15)
''

QTYTYPE smallint
0
QTY Type F...(more) Join Now
QUANTITY numeric(19,5)
0.00
QTY This i...(more) Join Now
QTYSCRAPPED numeric(19,5)
0.00
Quantity S...(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