WKREQSTR

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

Email

150x

Email

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

Link to WKREQ.RQ_ID

Long Integer

RC_STATE

Req State

25x

State

Text

RC_WK_PHN

Work Phone

25x

Work Phone

Text