PKCONLOC

Field Name

Caption

Mask

Description

Field Type

CL_ADR_APT

Apartment/Suite

25x

Apartment/Suite

Text

CL_ADR_B2

Street Post Bldg No

8x

Street Post Building No

Text

CL_ADR_B22

Street 2 Post Bldg No

8x

Street Post Building No 2

Text

CL_ADR_BDG

Address

nnnnnn

Address - Building Number

Long Integer

CL_ADR_DIR

Street Direction

2x

Street Direction

Text

CL_ADR_PT

Street Prefix Type

5x

Street Prefix Type

Text

CL_ADR_SFX

Street Suffix

5x

Street Suffix

Text

CL_ADR_STR

Street Name

50x

Street Name

Text

CL_ADR_TY

Street Type

5x

Street Type

Text

CL_ADR2_PT

Street 2 Prefix Type

5x

Street 2 Prefix Type

Text

CL_ADRBDG2

Address 2

nnnnnn

Address 2 Building Number

Long Integer

CL_ADRDIR2

Street Direction 2

2x

Street Direction 2

Text

CL_ADRSFX2

Street Suffix 2

5x

Street Suffix 2

Text

CL_ADRSTR2

Street Name 2

50x

Street Name 2

Text

CL_ADRTY2

Street Type 2

5x

Street Type 2

Text

CL_CITY

City

30x

City

Text

CL_COUNTRY

Country

30x

Country

Text

CL_CRT_BY

Created By

25x

Created By

Text

CL_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CL_CS_ID

Constr Rec #

nnnnnnnn

Link to PKCON.CS_ID

Long Integer

CL_DOC_FLG

Document Available

Doc Available

Boolean

CL_GENLOC

General Location

100x

General Location

Text

CL_ID

Constr Loc Rec #

nnnnnnnn

Construction Location Record ID

Long Integer

CL_LOCNO

Location No

nnn

Location No

Integer

CL_MOD_BY

Last Modified By

25x

Modified By

Text

CL_MOD_DT

Last Modified Date

mm/dd/yyyy

Date Modified

Date/Time

CL_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CL_PARCEL

Parcel Number

40x

Parcel

Text

CL_POSTAL

Zip Code

15x

Zip Code

Text

CL_ROWVER

Rowversion for optimistic locking

TimeStamp

CL_STATE

State

30x

State

Text

CL_X_COORD

X Coord.

-nnnnnnnnn.nnnnnnnn

X Coordinate

Double

CL_Y_COORD

Y Coord.

-nnnnnnnnn.nnnnnnnn

Y Coordinate

Double