Request Notifications
Field Name |
Caption |
Mask |
Description |
Field Type |
RN_AGENCY |
Agency |
50x |
Agency |
Text |
RN_CONTACT |
Contact |
25x |
Contact |
Text |
RN_CRT_BY |
Created By |
25x |
Created By |
Text |
RN_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RN_ID |
Notifications Rec # |
nnnnnnnn |
Auto Number |
Long Integer |
RN_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
RN_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Date Modified |
Date/Time |
RN_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RN_PHONE |
Phone |
25x |
Phone |
Text |
RN_PURP_CD |
Purpose |
nnn |
Purpose |
Integer |
RN_PURP_TY |
Purpose Text |
25x |
Purpose Text |
Text |
RN_REC_BY |
Initiated By |
25x |
Initiated By |
Text |
RN_REC_DT |
Initiated Date |
mm/dd/yyyy |
Initiated Date |
Date/Time |
RN_REC_TM |
Initiated Time |
hh:mm am |
Initiated Time |
Date/Time |
RN_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RN_RQ_ID |
Request Rec # |
-nnnnnnnn |
Long Integer |