PKCONA

Park Construction Asset Types

Field Name

Caption

Mask

Description

Field Type

CR_ASST_CD

Type

nnn

Asset Type

Integer

CR_ASST_TY

Type Text

25x

Asset Type Text

Text

CR_CRT_BY

Created By

25x

Created By

Text

CR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CR_CS_ID

SWCONST Rec #

nnnnnnnn

Link to PKCON.CS_ID

Long Integer

CR_CST_PCT

Asset Cost %

nnn.nn

Asset Cost Percentage

Double

CR_DESC

Description

50x

Description

Text

CR_DOC_FLG

Document Available

 

Document Available

Boolean

CR_ID

Rec #

nnnnnnnn

Const Asset Record AutoID

Long Integer

CR_LIFE

Asset Life (in Years)

nnnnnnnn.nn

Asset Life (in Years)

Double

CR_MOD_BY

Last Modified By

25x

Last Modified By

Text

CR_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

CR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CR_REPLACE

Replace Previous Worth

 

Replace Previous Worth

Boolean

CR_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

CR_STRT_DT

Start Date

mm/dd/yyyy

Start Date

Date/Time

CR_SVALUE

Salvage Value %

nnn.nn

Salvage Value

Double

CR_TOT_CST

Total Asset Cost

nnnnnnnn.nn

Total Asset Cost

Double

CR_UNITS

Units

nnnnnnnn.nn

Units

Double

CR_UNT_CST

Unit Cost

nnnnnnnn.nn

Unit Cost

Double

CR_UOM_CD

UOM

nnn

Unit of Measure (1 - Count, 2 - Sum)

Integer

CR_UOM_TY

UOM Text

25x

Unit of Measure Type

Text

CR_UOMF

UOM Field

30x

Unit of Measure Field (if CI_UOMT is not Count)

Text