Assets on Master Projects
Field Name |
Caption |
Mask |
Description |
Field Type |
MA_CAT_CD |
Category |
10x |
Category |
Text |
MA_CAT_INV |
Asset Type |
nnnnnnnn |
Link to WKCATINV.CI_ID - Lucity System Category |
Long Integer |
MA_CAT_TY |
Category Text |
60x |
Category Text |
Text |
MA_CRT_BY |
Created By |
25x |
Created By |
Text |
MA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
MA_DOC_FLG |
Document Available |
|
Doc Available |
Boolean |
MA_ID |
Work Asset Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
MA_INV_ID |
Asset Rec # |
nnnnnnnn |
Link to **_ID field on the selected Asset module. |
Long Integer |
MA_LINK1 |
System ID 1 |
150x |
Link 1 |
Text |
MA_LINK2 |
System ID 2 |
150x |
Link 2 |
Text |
MA_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
MA_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
MA_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
MA_MP_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
MA_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
MA_SEQNCE |
Sequence |
nnn |
This number is used for ordering the Sys ID items. |
Integer |
MA_TYPE |
Asset Type Text |
50x |
External Object Type |
Text |
MA_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
MA_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
MA_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
MA_USER13 |
User 13 |
|
User 13 |
Boolean |
MA_USER14 |
User 14 |
|
User 14 |
Boolean |
MA_USER15 |
User 15 |
|
User 15 |
Boolean |
MA_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
MA_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
MA_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
MA_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
MA_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
MA_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
MA_USER4 |
User 4 |
30x |
User 4 |
Text |
MA_USER5 |
User 5 |
30x |
User 5 |
Text |
MA_USER6 |
User 6 |
30x |
User 6 |
Text |
MA_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
MA_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
MA_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |