Work Flow Setup Materials
Field Name |
Caption |
Mask |
Description |
Field Type |
MT_AC_ID |
Account Rec # |
-nnnnnnnn |
Long Integer |
|
MT_ACCOUNT |
Account # |
45x |
Account # |
Text |
MT_ACT_FLG |
Active Material |
|
Active Material |
Boolean |
MT_CRT_BY |
Created By |
25x |
Created By |
Text |
MT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
MT_CSTTYP |
|
10x |
Eden Cost Type |
Text |
MT_DEPT_CD |
Department |
10x |
Department |
Text |
MT_DEPT_TY |
Department Description |
50x |
Department Text |
Text |
MT_DIV_CD |
Division Code |
10x |
Division Code |
String |
MT_DIV_TY |
Division Description |
40x |
Division Description |
String |
MT_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
MT_EA_ID |
Eden Acct Rec # |
nnnnnnnnn |
Long Integer |
|
MT_EP_ID |
Eden Proj Rec # |
nnnnnnnnn |
Long Integer |
|
MT_ID |
Material Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
MT_IMG_FLG |
|
|
Image Available |
Boolean |
MT_IT_ID |
|
|
Link to Common items |
Long Integer |
MT_ITEM_ID |
Eden Item ID |
nnnnnnnn |
Eden Item ID |
Long Integer |
MT_JE_FLG |
Journal Entry Import |
|
Journal Entry Flag |
Boolean |
MT_MAKE |
Make |
25x |
Make: |
Text |
MT_MAT_CD |
Material ID |
20x |
Material Code |
Text |
MT_MAT_TY |
Material Text |
75x |
Material Text |
Text |
MT_MOD_BY |
Modified By |
25x |
Modified By |
Text |
MT_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
MT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
MT_MODEL |
Model |
25x |
Model: |
Text |
MT_MOV_FLG |
|
|
Movie Available |
Boolean |
MT_OID |
|
|
Visual CE Linking Field |
Long Integer |
MT_PA_ID |
|
|
Not Used |
Long Integer |
MT_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
MT_REC_T |
Financial Record Type |
1x |
Eden Record Type |
Text |
MT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
MT_SPECID |
Special ID |
25x |
Special ID: |
Text |
MT_STAT_CD |
Material Status |
nnn |
Material Status |
Integer |
MT_STAT_TY |
Material Status Text |
25x |
Material Status Txt |
Text |
MT_UNIT_C |
Unit Cost |
nnnnn.nnn |
Unit Cost |
Double |
MT_UNIT_M |
Units of Material |
10x |
Unit of Measure |
Text |
MT_UOM_CD |
Unit of Measure |
5x |
Unit of Measure |
Text |
MT_UOM_TY |
Unit of Measure Text |
25x |
Unit of Measure Text |
Text |
MT_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
MT_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
MT_USER12 |
User 12 |
-nnnnnnnnn.nn |
User 12 |
Double |
MT_USER13 |
User 13 |
-nnnnnnnnn.nn |
User 13 |
Double |
MT_USER14 |
User 14 |
30x |
User 14 |
Text |
MT_USER15 |
User 15 |
30x |
User 15 |
Text |
MT_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
MT_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
MT_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
MT_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
MT_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
MT_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
MT_USER4 |
User 4 |
-nnnnnnnnn.nn |
User 4 |
Double |
MT_USER5 |
User 5 |
30x |
User 5 |
Text |
MT_USER6 |
User 6 |
|
User 6 |
Boolean |
MT_USER7 |
User 7 |
|
User 7 |
Boolean |
MT_USER8 |
User 8 |
|
User 8 |
Boolean |
MT_USER9 |
User 9 |
mm/dd/yyyy |
User 9 |
Date/Time |
MT_WDAYS |
Warranty Length (days) |
nnnnn |
Warranty Length (days) |
Integer |
MT_WDISTANCE |
Warranty Distance (miles) |
nnnnn |
Warranty Distance(miles) |
Integer |
MT_WHSE_ID |
Eden Warehouse |
nnnnnnnnn |
Eden Warehouse ID |
Long Integer |
MT_WHSE_TY |
Warehouse |
35x |
Eden Warehouse Desc |
Text |
MT_WVEND |
Warranty Vendor Code |
30x |
Warranty Vendor Code |
Text |