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

COMPANY..IV10004 Table Definition

(COMPANY..Inventory Bin Quantity Transfer)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DOCTYPE smallint
0
Document T...(more) Join Now PM30300.DOCTYPE
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
SEQNUMBR int
0
Sequence N...(more) Join Now
Bin_XFer_Doc_Number char
''

Bin_XFer_Date datetime
'1/1/1900'

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
QTYTYPE smallint
0
QTY Type...(more) Join Now
FROMBIN char(15)
''

TOBIN char(15)
''

SERLTNUM char(21)
''
Serial/Lot...(more) Join Now
SERLTQTY numeric(19,5)
0.00
Serial/Lot...(more) Join Now
DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now
DTSEQNUM numeric(19,5)
0.00
Date SEQ N...(more) Join Now
OVRSERLT smallint
0
Override S...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Reason_Code char
''

NOTEINDX numeric
0.00
Note Index...(more) Join Now
join ... more text available
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