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

COMPANY..QA010433 Table Definition

(COMPANY..QA_HIST_NSR_Incoming)

4Penny.net

Field Definitions:

What is the 'source' column?

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

RECEIVINGNUMBER_I char(21)
''

RECTRANSNUMBER_I smallint
0

PORDNMBR char(21)
''
Purchase O...(more) Join Now
ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
Inspector_ID char(11)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
DATEENTERED_I datetime
'1/1/1900'

DATERECD datetime
'1/1/1900'
Date Recei...(more) Join Now POP10500.DATERECD
RECEIVEDTIME_I datetime
'1/1/1900'

ORIGINATOR char(15)
''

SCAR_Number char(21)
''

LOCNCODE char(11)
''
Location C...(more) Join Now POP10110.LOCNCODE
join ... more text available
TIMENSR_I datetime
'1/1/1900'

REVISIONLEVEL_I char(51)
''

ITEMDESC char(101)
''
Item Descr...(more) Join Now POP10110.ITEMDESC
QTYRECEIVED2_I numeric(19,5)
0.00

BASEUOFM char(9)
''

See I... more text available
VNDITNUM char(31)
''
Vendor Ite...(more) Join Now
Procedure_Number char(11)
''

QAPROCREVLEVI smallint
0

QAPROCNAMI char(21)
''

QTYPASSED_I numeric(19,5)
0.00

QTYFAILED_I numeric(19,5)
0.00

QTY_Destroyed_in_Testing numeric(19,5)
0.00

QCUNIT char(9)
''

CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
MFGNOTEINDEX_I numeric(19,5)
0.00

MFGNOTEINDEX2_I numeric(19,5)
0.00

MFGNOTEINDEX3_I numeric(19,5)
0.00

MFGNOTEINDEX4I numeric(19,5)
0.00

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