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

COMPANY..MF010430 Table Definition

(COMPANY..MPS Transaction Log)

4Penny.net

Field Definitions:

What is the 'source' column?

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

MFLINEITEM_I smallint
0

DATE1 datetime
'1/1/1900'

POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
SUCCESSFULTRX_I tinyint
0

TRANSACTIONRESULT_I smallint
0

STARTQTY_I numeric(19,5)
0.00

MANUFACTUREORDER_I char(31)
''

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

SCHEDULINGPREFEREN_I char(21)
''

DRAWFROMSITE_I char(11)
''

POSTTOSITE_I char(11)
''

BOMCAT_I smallint
0

BOMNAME_I char(15)
''
Bill of Ma...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
COMMENTS1000_I text


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