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

COMPANY..BM10400 Table Definition

(COMPANY..Assembly Serial Lot)
Contains serial/lot number information associated with assembly transaction components.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRX_ID char(19)
''
TRX ID The...(more) Join Now
Component_ID int
0
Component ...(more) Join Now
SLTYPE smallint
0
Serial/Lot...(more) Join Now
SLTSQNUM int
0
Serial/Lot...(more) Join Now
SERLTNUM char(21)
''
Serial/Lot...(more) Join Now
SERLTQTY numeric(19,5)
0.00
Serial/Lot...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
QTYTYPE smallint
0
QTY Type T...(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
PARSLSEQN int
0
Parent Ser...(more) Join Now
Parent_Component_ID int
0
Parent Com...(more) Join Now
ITMTRKOP smallint
0
Item Track...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
UNITCOST numeric(19,5)
0.00
Unit Cost ...(more) Join Now
Status smallint
0
Status Ind...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
BIN char(15)
''
Bin Do not...(more) Join Now
MFGDATE datetime
'1/1/1900'
Manufactur...(more) Join Now
EXPNDATE datetime
'1/1/1900'
Expiration...(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