STCONA

Street Construction Asset Types

Field Name

Caption

Mask

Description

Field Type

ZR_ASST_CD

Type

nnn

Asset Type

Integer

ZR_ASST_TY

Type Text

50x

Asset Type Text

Text

ZR_CRT_BY

Created By

25x

Created By

Text

ZR_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ZR_CST_PCT

Asset Cost %

nnn.nn

Asset Cost Percentage

Double

ZR_DESC

Description

50x

Description

Text

ZR_DOC_FLG

Document Available

 

Document Available

Boolean

ZR_ID

Rec #

nnnnnnnn

Const Asset Record AutoID

Long Integer

ZR_LIFE

Asset Life (in Years)

nnnnnnnn.nn

Asset Life (in Years)

Double

ZR_MOD_BY

Last Modified By

25x

Last Modified By

Text

ZR_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

ZR_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ZR_REPLACE

Replace Previous Worth

 

Replace Previous Worth

Boolean

ZR_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

ZR_STRT_DT

Start Date

mm/dd/yyyy

Start Date

Date/Time

ZR_SVALUE

Salvage Value %

nnn.nn

Salvage Value

Double

ZR_TOT_CST

Total Asset Cost

nnnnnnnn.nn

Total Asset Cost

Double

ZR_UNITS

Units

nnnnnnnn.nn

Units

Double

ZR_UNT_CST

Unit Cost

nnnnnnnn.nn

Unit Cost

Double

ZR_UOM_CD

UOM

nnn

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

Integer

ZR_UOM_TY

UOM Text

25x

Unit of Measure Type

Text

ZR_UOMF

UOM Field

30x

Unit of Measure Field (if CI_UOMT is not Count)

Text

ZR_ZS_ID

STCON Rec #

nnnnnnnn

Link to STCON.ZS_ID

Long Integer