SMBMPSMH

Field Name

Caption

Mask

Description

Field Type

AF_AE_ID

BMP Site Milestone Rec #

nnnnnnnn

Link to SMBMPSM.AE_ID

Long Integer

AF_CHNG_BY

Change Made By

25x

Change Made By

String

AF_CHNG_DT

Change Made on this date

mm/dd/yyyy

Change Made on this date

DateTime

AF_CRT_BY

Created By

25x

Created By

String

AF_CRT_DTTM

Creation Date Time

hh:mm am

Creation Date Time

DateTime

AF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

AF_ID

Site Milestone Hist Rec #

nnnnnnnn

Site Milestone Hist Rec #

Long Integer

AF_MOD_BY

Last Modified By

25x

Last Modified By

String

AF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

DateTime

AF_MOD_TM

Modified Time

hh:mm am

Modified Time

DateTime

AF_NEND_DT

New End Activity Date

mm/dd/yyyy

New End Activity Date

DateTime

AF_NSTR_DT

New Start Activity Date

mm/dd/yyyy

New Start Activity Date

DateTime

AF_PEND_DT

Previous End Activity Date

mm/dd/yyyy

Previous End Activity Date

DateTime

AF_PSTR_DT

Previous Start Activity Date

mm/dd/yyyy

Previous Start Activity Date

DateTime

AF_REAS_CD

Change Reason

nnn

Change Reason

Integer

AF_REAS_TY

Change Reason Text

25x

Change Reason Text

String

AF_REASON

Reason for Date Modification

254x

Reason for Date Modification

String

AF_ROWVER

Rowversion for optimistic locking

Rowversion for optimistic locking

TimeStamp