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

COMPANY..EC040131 Table Definition

(COMPANY..ECM_Exclude_Items)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
ECNumber char(15)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
PPN_I char(31)
''
Parent Par...(more) Join Now
MANUFACTUREORDER_I char(31)
''

SALESORDERNUMBER_I char(17)
''

SOPNUMBE char(21)
''

PORDNMBR char(21)
''
Purchase O...(more) Join Now JC00701.PORDNMBR
ROUTINGNAME_I char(31)
''

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