WKORDERLOC

Field Name

Caption

Mask

Description

Field Type

WL_ADR_APT

Apartment/Suite

25x

Apartment/Suite

Text

WL_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

WL_ADR_B22

Street 2 Post Bldg No

8x

Street Post Building No 2

Text

WL_ADR_BDG

Address

nnnnnn

Address : Building Number

Long Integer

WL_ADR_DIR

Street Direction

2x

Street Direction

Text

WL_ADR_PT

Street Prefix Type

5x

Street Prefix Type

Text

WL_ADR_SFX

Street Suffix

5x

Street Suffix

Text

WL_ADR_STR

Street Name

50x

Street Name

Text

WL_ADR_TY

Street Type

5x

Street Type

Text

WL_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

Text

WL_ADRBDG2

Address 2

nnnnnn

Address - Building Number

Long Integer

WL_ADRDIR2

Street Direction 2

2x

Street Direction 2

Text

WL_ADRSFX2

Street Suffix 2

5x

Street Suffix 2

Text

WL_ADRSTR2

Street Name 2

50x

Street Name 2

Text

WL_ADRTY2

Street Type 2

5x

Street Type 2

Text

WL_AS_ID

nnnnnnnn

Link to WKWOASSET.AS_ID

Long Integer

WL_BLDG_CD

Building Type

nnn

Building Type

Integer

WL_BLDG_TY

Building Type Text

100x

Building Type Text

Text

WL_CITY

Loc City

100x

City

Text

WL_CITY_CD

Facility

nnn

Facility

Integer

WL_CITY_TY

Facility Text

50x

Facility Text

Text

WL_COMP_DT

Completion Date

mm/dd/yyyy

Completion Date

Date/Time

WL_COUNTRY

Loc Country

15x

Req Country

Text

WL_CRT_BY

Created By

25x

Created By

Text

WL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

WL_DOC_FLG

Document Available

Doc Available

Boolean

WL_GENLOC

General Location

200x

General Location

Text

WL_HANDHELD

50x

Handheld Name

Text

WL_ID

Loc Rec #

-nnnnnnnn

Auto Number

Long Integer

WL_IMG_FLG

Image Available

Boolean

WL_INIDTTM

Initiated Date/Time

mm/dd/yyyy hh:mm am

Initiated Date/Time

Date/Time

WL_LOCNO

Location No

nnn

Location No

Integer

WL_MBL_ID

Copy of WO_ID for mobile device

Long Integer

WL_MOD_BY

Last Modified By

25x

Modified By

Text

WL_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified

Date/Time

WL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

WL_MOV_FLG

Movie Available

Boolean

WL_OID

Visual CE Linking Field

Long Integer

WL_PARCEL

Loc Parcel Number

40x

Parcel

Text

WL_POSTAL

Loc Zip Code

15x

Zip Code

Text

WL_ROWVER

Rowversion for optimistic locking

Date/Time

WL_SOURCE

Source

25x

Source

String

WL_STATE

Loc State

25x

State

Text

WL_STRT_DT

Start Date

mm/dd/yyyy

Start Date

Date/Time

WL_TIMESTAMP

Mobile Timestamp

mm/dd/yyyy

Timestamp for Visual CE

Date/Time

WL_WO_ID

Work Order Rec #

-nnnnnnnn

Link to WKORDER.WO_ID

Long Integer

WL_X_COORD

Loc X Coord.

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

WL_Y_COORD

Loc Y Coord.

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double