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

COMPANY..OC010400 Table Definition

(COMPANY..Option Promotion MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Option_Category char(31)
''

ITEMNMBR char(31)
''
Item Numbe...(more) Join Now IV10201.ITEMNMBR
join ... more text available
BOMCAT_I smallint
0

BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
PROMOTION_ID_I char(31)
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now PA02101.STRTDATE
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now PA02101.ENDDATE
MRKDNAMT numeric(19,5)
0.00
Markdown A...(more) Join Now
MRKDNPCT smallint
0

MRKDNTYP smallint
0

MFGNOTEINDEX_I 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