Requesters
Field Name |
Caption |
Mask |
Description |
Field Type |
RC_ACCOUNT |
Util Acct # |
20x |
Account # |
Text |
RC_ADR_APT |
Apartment/Suite |
8x |
Req Apartment/Suite : |
Text |
RC_ADR_B2 |
Req Street Post Bldg No |
8x |
Street Post Building No |
Text |
RC_ADR_B22 |
Req Street 2 Post Bldg No |
8x |
Street Post Building No 2 |
Text |
RC_ADR_BDG |
Address |
nnnnnn |
Req Address : Building Number |
Long Integer |
RC_ADR_DIR |
Street Direction |
2x |
Req Street Direction : |
Text |
RC_ADR_PT |
Req Street Prefix Type |
5x |
Req Street Prefix Type |
Text |
RC_ADR_SFX |
Street Suffix |
5x |
Req Street Suffix : |
Text |
RC_ADR_STR |
Street Name |
50x |
Req Street Name : |
Text |
RC_ADR_TY |
Street Type |
5x |
Req Street Type : |
Text |
RC_ADR2_PT |
Req Street 2 Prefix Type |
5x |
Req Street 2 Prefix Type |
Text |
RC_ADRBDG2 |
Req Address 2 |
nnnnnn |
Req Addr 2 |
Long Integer |
RC_ADRDIR2 |
Street 2 |
2x |
Req Street Direction 2 |
Text |
RC_ADRSFX2 |
Req Street Suffix 2 |
5x |
Req Street Suffix 2 |
Text |
RC_ADRSTR2 |
Req Street Name 2 |
50x |
Req Street Name 2 |
Text |
RC_ADRTY2 |
Req Street Type 2 |
5x |
Req Street Type 2 |
Text |
RC_BLDG_CD |
Building Type |
nnn |
Building Type : |
Integer |
RC_BLDG_TY |
Building Type Text |
100x |
Building Type Text : |
Text |
RC_BUSNAME |
Business |
50x |
Business |
Text |
RC_CALLNO |
Caller No |
nnn |
Caller No |
Integer |
RC_CITY |
Req City |
100x |
City |
Text |
RC_CITY_CD |
|
|
Facility |
Integer |
RC_CITY_TY |
|
50x |
Facility Text |
Text |
RC_COMMENT1 |
Long Note |
|
Long Note |
Memo |
RC_COUNTRY |
Req Country |
15x |
Country |
Text |
RC_CRT_BY |
Created By |
25x |
Created By |
Text |
RC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
RC_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
RC_EMAIL |
150x |
Text |
||
RC_HM_PHN |
Home Phone # |
25x |
Home Phone |
Text |
RC_ID |
Requestor Rec # |
-nnnnnnnn |
Record # |
Long Integer |
RC_IMG_FLG |
|
|
Image Available |
Boolean |
RC_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
RC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Date Modified |
Date/Time |
RC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
RC_MOV_FLG |
|
|
Movie Available |
Boolean |
RC_NAM_MI |
Middle Initial |
1x |
Name, Middle Initial |
Text |
RC_NAM_SAL |
Salutation |
6x |
Name, Salutation |
Text |
RC_NAM_SFX |
Name Suffix |
5x |
Name, Suffix (Jr., III) |
Text |
RC_NAME1 |
Name |
40x |
Name |
Text |
RC_NAME2 |
Name2 |
40x |
Name2 |
Text |
RC_NAMTYP_CD |
Name Type |
nnnn |
Name Type Code |
Integer |
RC_NAMTYP_TY |
Name Type Text |
30x |
Name Type Text |
Text |
RC_PARCEL |
Req Parcel Number |
40x |
Parcel |
Text |
RC_PHONE |
Phone # |
25x |
Phone # |
Text |
RC_PHONE1 |
Phone 1 |
25x |
Phone 1 |
Text |
RC_PHONE2 |
Phone 2 |
25x |
Phone 2 |
Text |
RC_POSTAL |
Zip Code |
15x |
Zip Code |
Text |
RC_REC_BY |
Received By |
25x |
Recorded By |
Text |
RC_REC_DT |
Date Received |
mm/dd/yyyy |
Recorded Date |
Date/Time |
RC_REC_TM |
Time Received |
hh:mm am |
Recorded Time |
Date/Time |
RC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
RC_RQ_ID |
Request Rec # |
-nnnnnnnn |
Long Integer |
|
RC_STATE |
Req State |
25x |
State |
Text |
RC_WK_PHN |
Work Phone |
25x |
Work Phone |
Text |