Module List > Module POP tables POP30330
You are currently viewing the COMPANY database.
Change

COMPANY..POP30330 Table Definition

(COMPANY..Purchasing Serial Lot History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRCTNM char(17)
''
POP Receip...(more) Join Now
RCPTLNNM int
0
Receipt Li...(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
DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now
DTSEQNUM numeric(19,5)
0.00
Date SEQ N...(more) Join Now
UNITCOST numeric(19,5)
0.00
Unit Cost ...(more) Join Now
TRXSORCE char(13)
''
Transactio...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now
join ... more text available
QTYTYPE smallint
0
QTY Type 1...(more) Join Now
BIN char(15)
''
Bin The bi...(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