Module List > Module PA tables PA30902
You are currently viewing the COMPANY database.
Change

COMPANY..PA30902 Table Definition

(COMPANY..PA Item Serial and Lot Number History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRXSORCE char(13)
''
Transactio...(more) Join Now
PAIV_Transfer_Type smallint
0

PAIV_Document_No char(17)
''

LNITMSEQ int
0
Line Item ...(more) Join Now
ITEMNMBR char(31)
''
Item Number.
join ... more text available
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
FROMBIN char(15)
''
To Bin For...(more) Join Now
TOBIN char(15)
''
To Bin For...(more) Join Now
PABILLQTY numeric(19,5)
0.00

PAbilled tinyint
0

PAbilledagn tinyint
0

QTYSCRAPPED numeric(19,5)
0.00
Quantity S...(more) Join Now IV10002.QTYSCRAPPED
MFGDATE datetime
'1/1/1900'
Manufactur...(more) Join Now IV10002.MFGDATE
EXPNDATE datetime
'1/1/1900'
Expiration...(more) Join Now CM20200.EXPNDATE
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