Module List >
Module Manufacturing tables
MM010032
You are currently viewing the COMPANY
database.
Change
|
COMPANY..MM010032 Table Definition
(COMPANY..Machine Master)
Field Definitions:
What is the 'source' column?
| MACHINEID_I |
char(11)
''
|
|
|
|
|
| MACHINEDESC_I |
char(31)
''
|
|
|
|
|
| SERLNMBR |
char(21)
''
|
|
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
POP10100.VENDORID
|
|
join ... more text available
|
| DATEMACHINEINSTALL_I |
datetime
'1/1/1900'
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year: The ...(more) Join Now
|
UPR00900.YEAR1
|
|
|
| WARRANTY_I |
tinyint
0
|
|
|
|
|
| WARRANTYTIME_I |
char(9)
''
|
|
|
|
|
| LENGTHOFWARRANTY_I |
smallint
0
|
|
|
|
|
| DEPRECIATIONCOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| DEPRECIATIONCOSTUN_I |
smallint
0
|
|
|
|
|
| LOCATNID |
char(15)
''
|
Location I...(more) Join Now
|
PA01101.LOCATNID
|
|
join ... more text available
|
| MAINTENANCEDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| Maintenance_Procedure_Na |
char(21)
''
|
|
|
|
|
| OPERATIONCOUNT_I |
int
0
|
|
|
|
|
| TOTALOPERATIONCOUN_I |
int
0
|
|
|
|
|
| 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
|
| MFGNOTEINDEX_I |
numeric(19,5)
0.00
|
|
|
|
|
| MFGNOTEINDEX2_I |
numeric(19,5)
0.00
|
|
|
|
|
| Mach_Mach_Applied_Acct |
int
0
|
|
|
|
|
| Mach_Fixed_Ohd_Acct |
int
0
|
|
|
|
|
| Mach_Variable_Ohd_Acct |
int
0
|
|
|
|
|
| COST_I |
numeric(19,5)
0.00
|
|
|
|
|
| EFFECTIVEDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| COSTPERPIECE_I |
numeric(19,5)
0.00
|
|
|
|
|
| EFFECTIVEDATE2_I |
datetime
'1/1/1900'
|
|
|
|
|
| FIXAMTORPCT_I |
smallint
0
|
|
|
|
|
| Fixed_Overhead_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| FIXOHDPCT_I |
int
0
|
|
|
|
|
| FIXHRPC_I |
smallint
0
|
|
|
|
|
| FIXOHDEFFDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| VARAMTORPCT_I |
smallint
0
|
|
|
|
|
| Variable_Overhead_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| VAROHDPCT_I |
int
0
|
|
|
|
|
| VARHRPC_I |
smallint
0
|
|
|
|
|
| VAROHDEFFDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| PENDINGCOST_I |
numeric(19,5)
0.00
|
|
|
|
|
| PENDEFFDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| PENDCOSTPERPIECE_I |
numeric(19,5)
0.00
|
|
|
|
|
| PENDEFFDATE2_I |
datetime
'1/1/1900'
|
|
|
|
|
| PENDFIXAMTORPCT_I |
smallint
0
|
|
|
|
|
| PENDFIXOHDAMT_I |
numeric(19,5)
0.00
|
|
|
|
|
| PENDFIXOHDPCT_I |
int
0
|
|
|
|
|
| PENDFIXHRPC_I |
smallint
0
|
|
|
|
|
| PENDFIXOHDEFFDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| PENDVARAMTORPCT_I |
smallint
0
|
|
|
|
|
| PENDVAROHDAMT_I |
numeric(19,5)
0.00
|
|
|
|
|
| PENDVAROHDPCT_I |
int
0
|
|
|
|
|
| PENDVARHRPC_I |
smallint
0
|
|
|
|
|
| PENDVAROHDEFFDATE_I |
datetime
'1/1/1900'
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|