SMBMPSO

BMP Site Conversations

Field Name

Caption

Mask

Description

Field Type

BO_AREP_CD

Agency Rep

nnn

Agency Representative

Integer

BO_AREP_TY

Agency Rep Text

30x

Agency Representative Text

Text

BO_BNAME

Business Name

50x

Business Name

Text

BO_BS_ID

Site Record No

nnnnnnnn

Link to SMBMPS.BS_ID

Long Integer

BO_CDIR_CD

Contact Direction

nnn

Contact Direction

Integer

BO_CDIR_TY

Contact Direction Text

30x

Contact Direction Text

Text

BO_CONTACT

Contact

50x

Contact

Text

BO_CONV_DT

Conversation Date

mm/dd/yyyy

Conversation Date

Date/Time

BO_CONV_TM

Conversation Time

hh:mm am

Conversation Time

Date/Time

BO_CRT_BY

Created By

25x

Created By

Text

BO_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BO_CTYP_CD

Conversation Type

nnn

Conversation Type

Integer

BO_CTYP_TY

Conversation Type Text

30x

Conversation Type Text

Text

BO_DESC

Short Description

254x

Short Description

Text

BO_DOC_FLG

Document Available

 

Document Available

Boolean

BO_ID

Conversation Record No

nnnnnnnn

BMP Site Conversation Record Number

Long Integer

BO_MOD_BY

Last Modified By

25x

Modified By

Text

BO_MOD_DT

Last Modified Date

mm/dd/yyyy

Modified Date

Date/Time

BO_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BO_PHONE

Phone

25x

Phone

Text

BO_REC_DT

Date Recorded

mm/dd/yyyy

Recorded Date

Date/Time

BO_REC_TM

Time Recorded

hh:mm am

Recorded Time

Date/Time

BO_ROWVER

 

 

Rowversion for optimistic locking

Date/Time