STCONLOC

Field Name

Caption

Mask

Description

Field Type

ZL_ADR_APT

Apartment/Suite

25x

Apartment/Suite

Text

ZL_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

ZL_ADR_B22

Street Post Bldg No 2

8x

Street Post Building No 2

Text

ZL_ADR_BDG

Address

nnnnnn

Address - Building Number

Long Integer

ZL_ADR_DIR

Street Direction

2x

Street Direction

Text

ZL_ADR_PT

Street Prefix Type

5x

Street Prefix Type

Text

ZL_ADR_SFX

Street Suffix

5x

Street Suffix

Text

ZL_ADR_STR

Street Name

50x

Street Name

Text

ZL_ADR_TY

Street Type

5x

Street Type

Text

ZL_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

Text

ZL_ADRBDG2

Address 2

nnnnnn

Address 2 Building Number

Long Integer

ZL_ADRDIR2

Address2 Direction

2x

Street Direction 2

Text

ZL_ADRSFX2

Address2 Suffix

5x

Street Suffix 2

Text

ZL_ADRSTR2

Address2 Name

50x

Street Name 2

Text

ZL_ADRTY2

Address2 Type

5x

Street Type 2

Text

ZL_CITY

City

30x

City

Text

ZL_COUNTRY

Country

30x

Country

Text

ZL_CRT_BY

Created By

25x

Created By

Text

ZL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ZL_DOC_FLG

Document Available

Doc Available

Boolean

ZL_GENLOC

General Location

100x

General Location

Text

ZL_ID

Constr Loc Rec #

nnnnnnnn

Construction Location Record ID

Long Integer

ZL_LOCNO

Location No

nnn

Location No

Integer

ZL_MOD_BY

Last Modified By

25x

Modified By

Text

ZL_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified

Date/Time

ZL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ZL_PARCEL

Parcel Number

40x

Parcel

Text

ZL_POSTAL

Zip Code

15x

Zip Code

Text

ZL_ROWVER

Rowversion for optimistic locking

TimeStamp

ZL_STATE

State

30x

State

Text

ZL_X_COORD

X Coord.

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

ZL_Y_COORD

Y Coord.

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double

ZL_ZS_ID

Constr Rec #

nnnnnnnn

Link to STCON.ZS_ID

Long Integer