Routine Work System ID table
Field Name |
Caption |
Mask |
Description |
Field Type |
RS_CAT_CD |
Category |
10x |
Category Code |
Text |
RS_CAT_TY |
Category Text |
60x |
Category Description |
Text |
RS_CRT_BY |
Created By |
25x |
Created By |
Text |
RS_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RS_DESC |
Description |
50x |
Description |
Text |
RS_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
RS_GI_ID |
PM Group ID |
nnnnnnnn |
PM Group ID |
Long Integer |
RS_GP_DSC |
Group Description |
50x |
Group Description |
String |
RS_ID |
AutoNumber |
-nnnnnnnn |
Unique ID |
Long Integer |
RS_IMG_FLG |
|
|
Image Available |
Boolean |
RS_INFR_ID |
Asset Rec # |
nnnnnnnn |
Link to an Inventory Table - table depends on INV_ID |
Long Integer |
RS_INV_ID |
Asset Type |
nnnnnnnn |
Link to WKCATINV.CI_ID - Lucity System Category |
Long Integer |
RS_LINK1 |
System ID 1 |
150x |
Common's Man ID # 1 |
Text |
RS_LINK2 |
System ID 2 |
150x |
Common's Man ID # 2 |
Text |
RS_MOD_BY |
LastModifiedBy |
25x |
Modified By |
Text |
RS_MOD_DT |
LastModifiedDate |
mm/dd/yyyy |
Modified Date |
Date/Time |
RS_MOD_TM |
LastModifiedTime |
hh:mm am |
Modified Time |
Date/Time |
RS_MOV_FLG |
|
|
Movie Available |
Boolean |
RS_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RS_SEQNCE |
Sequence No |
nnn |
Order Records are Displayed on Screen |
Integer |
RS_TEXT1 |
Description for Link1 |
255x |
Description for Link1 |
String |
RS_TEXT2 |
Description for Link 2 |
255x |
Description for Link 2 |
String |
RS_TO_ID |
PM Rec # |
nnnnnnnn |
Long Integer |
|
RS_TYPE |
Asset Type Text |
50x |
Object Type |
Text |