STCOM

Communication Path for ITS

Field Name

Caption

Mask

Description

Field Type

CO_ACCT

Account Number

50x

Account Number

String

CO_AG_ID

AutoGate RecordNumber

nnnnnnnn

Link to STAGATE.AG_ID

Long Integer

CO_AL_ID

Camera Location Record Number

nnnnnnnn

Link to STCAML.AL_ID

Long Integer

CO_BL_ID

Facility Building Rec #

nnnnnnnn

Link to EFBLDG.BL_ID

Long Integer

CO_CEXP_DT

Contract Expiration Date

mm/dd/yyyy hh:mm am

Contract Expiration Date

DateTime

CO_COMMENT1

Long Note

 

Long Note

Memo

CO_CONT_DT

Contract Date

mm/dd/yyyy hh:mm am

Contract Date

DateTime

CO_CRT_BY

Created By

25x

Created By

String

CO_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

CO_CTYP_CD

Comm Type

nnn

Comm Type

Integer

CO_CTYP_TY

Comm Type Text

50x

Comm Type Text

String

CO_DE_ID

Comm Device Rec #

nnnnnnnn

Link to STCOMD.DE_ID

Long Integer

CO_DM_ID

DMS Record Number

nnnnnnnn

Link to STDMS.DM_ID

Long Integer

CO_DOC_FLG

Document Available

 

Document Available

Boolean

CO_DP_ID

PDMS Record Number

nnnnnnnn

Link to STPDMS.DP_ID

Long Integer

CO_DURAT

Contract Duration

nnn

Contract Duration

Integer

CO_END_DT

End Date

mm/dd/yyyy hh:mm am

End Date

DateTime

CO_FL_ID

Fleet Rec #

nnnnnnnn

Link to EFFLEET.FL_ID

Long Integer

CO_ID

Communication Number

nnnnnnnn

Communication Number

Long Integer

CO_IP

IP Address

50x

IP Address

String

CO_KI_ID

Kiosk Record Number

nnnnnnnn

Link to STKIOSK.KI_ID

Long Integer

CO_MCOST

Monthly Cost

nnnnnnnn.nn

Monthly Cost

Double

CO_MOD_BY

Last Modified By

25x

Last Modified By

String

CO_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

CO_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

CO_NOTES

Notes or Short Comment

255x

Notes or Short Comment

String

CO_NUMBER

Phone Number

50x

Phone Number

String

CO_PHONE

Phone Number

15x

Phone Number

String

CO_PU_ID

Anti-Icing Pump House Record Number

nnnnnnnn

Link to STAICEPH.PU_ID

Long Integer

CO_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

CO_RW_ID

RWIS Record Number

nnnnnnnn

Link to STRWIS.RW_ID

Long Integer

CO_SIM

SIM

20x

SIM

String

CO_SO_ID

Sensor Record Number

nnnnnnnn

Link to STSENS.SO_ID

Long Integer

CO_ST_ID

Facility Site Rec #

nnnnnnnn

Link to EFSITE.ST_ID

Long Integer

CO_STAT_CD

Status

nnn

Status

Integer

CO_STAT_TY

Status Text

25x

Status Text

String

CO_STRT_DT

Start Date

mm/dd/yyyy hh:mm am

Start Date

DateTime

CO_USER10

User 10

mm/dd/yyyy hh:mm am

User 10

DateTime

CO_USER11

User 11

mm/dd/yyyy hh:mm am

User 11

DateTime

CO_USER12

User 12

mm/dd/yyyy hh:mm am

User 12

DateTime

CO_USER13

User 13

 

User 13

Boolean

CO_USER14

User 14

 

User 14

Boolean

CO_USER15

User 15

 

User 15

Boolean

CO_USER1CD

User 1

nnn

User 1

Integer

CO_USER1TY

User 1 Text

25x

User 1 Text

String

CO_USER2CD

User 2

nnn

User 2

Integer

CO_USER2TY

User 2 Text

25x

User 2 Text

String

CO_USER3CD

User 3

nnn

User 3

Integer

CO_USER3TY

User 3 Text

25x

User 3 Text

String

CO_USER4

User 4

50x

User 4

String

CO_USER5

User 5

50x

User 5

String

CO_USER6

User 6

50x

User 6

String

CO_USER7

User 7

nnnnnnnn.nn

User 7

Double

CO_USER8

User 8

nnnnnnnn.nn

User 8

Double

CO_USER9

User 9

nnnnnnnn.nn

User 9

Double

CO_VEND_CD

Vendor

nnn

Vendor

Integer

CO_VEND_TY

Vendor Text

50x

Vendor Text

String