WKRTLOC

Field Name

Caption

Mask

Description

Field Type

RL_ADR_APT

Apartment/Suite

8x

Apartment/Suite

Text

RL_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

RL_ADR_B22

Street 2 Post Bldg No

8x

Street Post Building No 2

Text

RL_ADR_BDG

Address

nnnnnn

Address : Building Number

Long Integer

RL_ADR_DIR

Street Direction

2x

Street Direction

Text

RL_ADR_PT

Street Prefix Type

5x

Street Prefix Type

Text

RL_ADR_SFX

Street Suffix

5x

Street Suffix

Text

RL_ADR_STR

Street Name

50x

Street Name

Text

RL_ADR_TY

Street Type

5x

Street Type

Text

RL_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

Text

RL_ADRBDG2

Address 2

nnnnnn

Address : Building Number

Long Integer

RL_ADRDIR2

Street Direction 2

2x

Street Direction 2

Text

RL_ADRSFX2

Street Suffix 2

5x

Street Suffix 2

Text

RL_ADRSTR2

Street Name 2

50x

Street Name 2

Text

RL_ADRTY2

Street Type 2

5x

Street Type 2

Text

RL_BLDG_CD

Building Type Code

nnn

Building Type

Integer

RL_BLDG_TY

Building Type Text

100x

Building Type Text

Text

RL_CITY

Loc City

100x

City:

Text

RL_CITY_CD

Facility

nnn

Facility

Integer

RL_CITY_TY

Facility Text

50x

Facility Text

Text

RL_COUNTRY

Loc Country

15x

Country

Text

RL_CRT_BY

Created By

25x

Created By

Text

RL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

RL_DOC_FLG

Document Available

Doc Available: Doc Flag

Boolean

RL_GENLOC

General Location

200x

End Point 1

Text

RL_ID

AutoNumber

-nnnnnnnn

Auto Number

Long Integer

RL_IMG_FLG

Image Available

Boolean

RL_LOCNO

Location No

nnn

Location No

Integer

RL_MOD_BY

Last Modified By

25x

Modified B

Text

RL_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified

Date/Time

RL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

RL_MOV_FLG

Movie Available

Boolean

RL_PARCEL

Loc Parcel Number

40x

Parcel

Text

RL_POSTAL

Loc Zip Code

15x

Zip Code

Text

RL_ROWVER

Rowversion for optimistic locking

Date/Time

RL_RS_ID

Link to WKRTSYSID

nnnnnnnn

Link to WKRTSYSID.RS_ID

Long Integer

RL_STATE

Loc State

25x

State:

Text

RL_TO_ID

Link To PM

nnnnnnnn

Link to WKROUTINE.TO_ID

Long Integer

RL_X_COORD

Loc X Coord.

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

RL_Y_COORD

Loc Y Coord.

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double