Module List > Module Manufacturing tables QA010132
You are currently viewing the COMPANY database.
Change

COMPANY..QA010132 Table Definition

(COMPANY..QA_HIST_Incoming_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
RECEIVINGNUMBER_I char(21)
''

RECTRANSNUMBER_I smallint
0

SERLTNUM char(21)
''
Serial/Lot...(more) Join Now POP10330.SERLTNUM
SLTSQNUM int
0
Serial/Lot...(more) Join Now POP10330.SLTSQNUM
SERLTQTY numeric(19,5)
0.00
Serial/Lot...(more) Join Now
Lot_QA_Completed tinyint
0

Lot_Passed_Inspection tinyint
0

LOTREDPOSTI tinyint
0

LOTSAVBATCHI tinyint
0

LOTPOSTEDTOINVI tinyint
0

LOTQTYPASS numeric(19,5)
0.00

LOTQTYFAIL numeric(19,5)
0.00

Lot_QTY_Destroyed_in_Tes numeric(19,5)
0.00

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
USERID char(15)
''
The user t...(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