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

COMPANY..IV30004 Table Definition

(COMPANY..)

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
Bin_XFer_Doc_Number char
''

Bin_XFer_Date datetime
'1/1/1900'

SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
ITEMNMBR char
''
span style...(more) Join Now JC00701.ITEMNMBR
join ... more text available
LOCNCODE char
''
Location C...(more) Join Now PA11801.LOCNCODE
join ... more text available
QTYTYPE smallint
0
QTY Type...(more) Join Now WOUF0132.QTYTYPE
FROMBIN char
''

TOBIN char
''

SERLTNUM char
''
Serial/Lot...(more) Join Now RVPS0132.SERLTNUM
SERLTQTY numeric
0.00
Serial/Lot...(more) Join Now QA010332.SERLTQTY
DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now MOP1027.DATERECD
DTSEQNUM numeric
0.00
Date SEQ N...(more) Join Now MOP1020.DTSEQNUM
OVRSERLT smallint
0
Override S...(more) Join Now
Reason_Code char
''

USERID char
''
The user t...(more) Join Now
join ... more text available
NOTEINDX numeric
0.00
Note Index...(more) Join Now
join ... more text available
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