Assets on Work Permits
Field Name |
Caption |
Mask |
Description |
Field Type |
OA_CAT_CD |
Category |
10x |
Category |
Text |
OA_CAT_INV |
Link to WKCATINV:Lucity System Category |
nnnnnnnn |
Link to WKCATINV:Lucity System Category |
Long Integer |
OA_CAT_TY |
Category Text |
60x |
Category Text |
Text |
OA_COMMENT1 |
Long Note |
|
Long Note |
Memo |
OA_CRT_BY |
Created By |
25x |
Created By |
Text |
OA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
OA_DOC_FLG |
Doc Available |
|
Doc Available |
Boolean |
OA_ID |
Permit Asset Rec # |
nnnnnnnn |
Permit Asset Rec # AutoID |
Long Integer |
OA_INV_ID |
Asset Auto ID: to get the inventory table information |
nnnnnnnn |
Asset Auto ID: to get the inventory table information |
Long Integer |
OA_LINK1 |
System ID |
150x |
System ID |
Text |
OA_MOD_BY |
Modified By |
25x |
Modified By |
Text |
OA_MOD_DT |
Modified Date |
mm/dd/yyyy hh:mm am |
Modified Date |
DateTime |
OA_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
OA_PP_ID |
Permit Rec #: Link to WKPERMIT |
nnnnnnnn |
Permit Rec #: Link to WKPERMIT.PP_ID |
Long Integer |
OA_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
OA_SEQNCE |
This number is used for ordering the Sys ID items. |
nnn |
This number is used for ordering the Sys ID items. |
Integer |
OA_TYPE |
External Object Type |
50x |
External Object Type |
Text |
OA_USER10_DT |
User 10 |
mm/dd/yyyy hh:mm am |
User 10 |
DateTime |
OA_USER11_DT |
User 11 |
mm/dd/yyyy hh:mm am |
User 11 |
DateTime |
OA_USER12_DT |
User 12 |
mm/dd/yyyy hh:mm am |
User 12 |
DateTime |
OA_USER13 |
User 13 |
|
User 13 |
Boolean |
OA_USER14 |
User 14 |
|
User 14 |
Boolean |
OA_USER15 |
User 15 |
|
User 15 |
Boolean |
OA_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
OA_USER1TY |
User 1 Text |
100x |
User 1 Text |
Text |
OA_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
OA_USER2TY |
User 2 Text |
100x |
User 2 Text |
Text |
OA_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
OA_USER3TY |
User 3 Text |
100x |
User 3 Text |
Text |
OA_USER4 |
User 4 |
250x |
User 4 |
Text |
OA_USER5 |
User 5 |
250x |
User 5 |
Text |
OA_USER6 |
User 6 |
250x |
User 6 |
Text |
OA_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
OA_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
OA_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |