WKPROJCMC

Contractors on Maintenance Bonds for Contracts

Field Name

Caption

Mask

Description

Field Type

YA_COMMENT1

Long Note

 

Long Note

Memo

YA_CONT_CD

Contractor

10x

Contractor

String

YA_CONT_TY

Contractor Text

60x

Contractor Text

String

YA_CRT_BY

Created By

25x

Created By

String

YA_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

YA_DOC_FLG

Document Available

 

Document Available

Boolean

YA_ID

Maintenance Bond Contractors Rec #

nnnnnnnn

Maint Bond Contractors AutoID

Long Integer

YA_MOD_BY

Last Modified By

25x

Last Modified By

String

YA_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

YA_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

YA_PDAY

Permit Day

nnn

Permit Day

integer

YA_PDAYS

Total Permitted Days

nnn

Total Permitted Days

integer

YA_POTHER

Other Permit

 

Other Permit

Boolean

YA_PSEWER

Sewer Permit

 

Sewer Permit

Boolean

YA_PSTORM

Stormwater Permit

 

Stormwater Permit

Boolean

YA_PTRANS

Transportation Permit

 

Transportation Permit

Boolean

YA_PWATER

Water Permit

 

Water Permit

Boolean

YA_ROWVER

Rowversion for optimistic locking

 

Rowversion for optimistic locking

TimeStamp

YA_SUP_CELL

Super Cell Phone

25x

Super Cell Phone

String

YA_SUPER

Superintendant Name

50x

Superintendant Name

String

YA_WK_PHN

Contractor Work Phone

25x

Contractor Work Phone

String

YA_XM_ID

Maintenance Bond Rec # - Link to WKPROJCM table

nnnnnnnn

Link to WKPROJCM.XM_ID

Long Integer