STCONAD

Street Construction Assets

Field Name

Caption

Mask

Description

Field Type

ZD_AE_ID

 

nnnnnnnn

Link to STAUXILEQP.AE_ID

Long Integer

ZD_AG_ID

 

nnnnnnnn

Link to STAGATE.AG_ID

Long Integer

ZD_AL_ID

 

nnnnnnnn

Link to STCAML.AL_ID

Long Integer

ZD_AM_ID

 

nnnnnnnn

Link to STCAM.AM_ID

Long Integer

ZD_AST_CST

Asset Cost

nnnnnnnn.nn

Asset Cost

Double

ZD_BS_ID

 

nnnnnnnn

Link to STBSINV.BS_ID

Long Integer

ZD_BV_ID

 

nnnnnnnn

Link to STBRINV.BV_ID

Long Integer

ZD_CB_ID

 

nnnnnnnn

Link to STCABINET.CB_ID

Long Integer

ZD_CM_ID

 

nnnnnnnn

Link to STCNTRLINV.CM_ID

Long Integer

ZD_CR_ID

 

nnnnnnnn

Link to STCONDUCTR.CR_ID

Long Integer

ZD_CRT_BY

Created By

25x

Created By

Text

ZD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ZD_CT_ID

 

nnnnnnnn

Link to STCONDUIT.CT_ID

Long Integer

ZD_CU_ID

 

nnnnnnnn

Link to STCURBINV.CU_ID

Long Integer

ZD_DM_ID

 

nnnnnnnn

Link to STDMS.DM_ID

Long Integer

ZD_DP_ID

 

nnnnnnnn

Link to STPDMS.DP_ID

Long Integer

ZD_EP_ID

 

nnnnnnnn

Link to STSTEPSINV.EP_ID

Long Integer

ZD_FE_ID

 

nnnnnnnn

Link to STFENINV.FE_ID

Long Integer

ZD_FN_ID

 

 

Link to STFURN.FN_ID

Long Integer

ZD_FO_ID

 

nnnnnnnn

Link to STFIBROPTC.FO_ID

Long Integer

ZD_GA_ID

 

 

Link to STTRAIL.GA_ID

Long Integer

ZD_GR_ID

 

nnnnnnnn

Link to STGRINV.GR_ID

Long Integer

ZD_HA_ID

 

nnnnnnnn

Link to STRDROADA.HA_ID

Long Integer

ZD_IC_ID

 

nnnnnnnn

Link to STAICE.IC_ID

Long Integer

ZD_ID

Rec #

nnnnnnnn

AutoID

Long Integer

ZD_IN_ID

 

nnnnnnnn

Link to INTNET.IN_ID

Long Integer

ZD_JB_ID

 

nnnnnnnn

Link to STJBOXINV.JB_ID

Long Integer

ZD_KI_ID

 

nnnnnnnn

Link to STKIOSK.KI_ID

Long Integer

ZD_LC_ID

 

nnnnnnnn

Link to STLCCINV.LC_ID

Long Integer

ZD_LD_ID

 

 

Link to STLSA.LD_ID

Long Integer

ZD_LIFE

Asset Life (in Years)

nnnnnnnn.nn

Asset Life (in Years)

Double

ZD_LINK1

Link 1

150x

System ID 1

Text

ZD_LINK2

Link 2

150x

System ID 2

Text

ZD_LT_ID

 

nnnnnnnn

Link to STLITINV.LT_ID

Long Integer

ZD_MB_ID

 

nnnnnnnn

Link to STMETERBOX.MB_ID

Long Integer

ZD_ME_ID

 

nnnnnnnn

Link to STMEDINV.ME_ID

Long Integer

ZD_MK_ID

 

nnnnnnnn

Link to STPMINV.MK_ID

Long Integer

ZD_ML_ID

 

nnnnnnnn

Link to STMAINLINE.ML_ID

Long Integer

ZD_MOD_BY

Last Modified By

25x

Last Modified by

Text

ZD_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

ZD_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ZD_NOVALUE

No Remaining Value

 

No Remaining Value

Boolean

ZD_PK_ID

 

nnnnnnnn

Link to STPARK.PK_ID

Long Integer

ZD_PL_ID

 

nnnnnnnn

Link to STPOLINV.PL_ID

Long Integer

ZD_PR_ID

 

nnnnnnnn

Link to STPREEMPT.PR_ID

Long Integer

ZD_PU_ID

 

nnnnnnnn

Link to STAICEPH.PU_ID

Long Integer

ZD_PVALUE

Present Value

nnnnnnnn.nn

Present Value

Double

ZD_REPLACE

Replace Previous Worth

 

Replace Previous Worth

Boolean

ZD_RLIFE

Remaining Life

nnnn.nn

Remaining Life

Double

ZD_RM_ID

 

nnnnnnnn

Link to STRAMPINV.RM_ID

Long Integer

ZD_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

ZD_RP_ID

 

nnnnnnnn

Link to STRDRAMP.RP_ID

Long Integer

ZD_RS_ID

 

nnnnnnnn

Link to STRDSEG.RS_ID

Long Integer

ZD_RT_ID

 

nnnnnnnn

Link to STRDASST.RT_ID

Long Integer

ZD_RW_ID

 

nnnnnnnn

Link to STRWIS.RW_ID

Long Integer

ZD_RX_ID

 

nnnnnnnn

Link to STRRXINV.RX_ID

Long Integer

ZD_SC_ID

 

nnnnnnnn

Link to STSTRUCT.SC_ID

Long Integer

ZD_SH_ID

 

nnnnnnnn

Link to STSHEAD.SH_ID

Long Integer

ZD_SN_ID

 

nnnnnnnn

Link to STNET.SN_ID

Long Integer

ZD_SO_ID

 

nnnnnnnn

Link to STSENS.SO_ID

Long Integer

ZD_SS_ID

 

nnnnnnnn

Link to STSNOWSHOE.SS_ID

Long Integer

ZD_STRT_DT

Start Date

mm/dd/yyyy

Start Date

Date/Time

ZD_SV_ID

 

nnnnnnnn

Link to STSININV.SV_ID

Long Integer

ZD_SVALUE

Salvage Value

nnnnnnnn.nn

Salvage Value

Double

ZD_SW_ID

 

nnnnnnnn

Link to STSWINV.SW_ID

Long Integer

ZD_TD_ID

 

nnnnnnnn

Link to STTRAFDECT.TD_ID

Long Integer

ZD_TR_ID

 

 

Link to STTRAIL.TR_ID

Long Integer

ZD_TYPE

Object Type

50x

External Object Type

Text

ZD_WL_ID

 

nnnnnnnn

Link to STWALLINV.WL_ID

Long Integer

ZD_ZR_ID

 

nnnnnnnn

Link to STCONA.ZR_ID

Long Integer