BMP Site Contacts
Field Name |
Caption |
Mask |
Description |
Field Type |
BC_ADDR1 |
Address 1 |
50x |
Address 1 |
Text |
BC_ADDR2 |
Address 2 |
50x |
Address 2 |
Text |
BC_ADDR3 |
Address 3 |
50x |
Address 3 |
Text |
BC_BNAME |
Business Name |
50x |
Business Name |
Text |
BC_BS_ID |
Site Record No |
nnnnnnnn |
Long Integer |
|
BC_CRT_BY |
Created By |
25x |
Created By |
Text |
BC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
BC_CTYP_CD |
Contact Type |
nnn |
Contact Type |
Integer |
BC_CTYP_TY |
Contact Type Text |
30x |
Contact Type Text |
Text |
BC_EMAIL |
Email Address |
150x |
Text |
|
BC_FAX |
Fax Phone |
25x |
Fax |
Text |
BC_ID |
Contact Rec # |
nnnnnnnn |
BMP Site Contact Record Number |
Long Integer |
BC_MOBILE |
Mobile Phone |
25x |
Mobile Phone |
Text |
BC_MOD_BY |
Last Mod By |
25x |
Modified By |
Text |
BC_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
BC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
BC_NAME |
Name |
50x |
Name |
Text |
BC_NOTE |
Notes |
254x |
Notes |
Text |
BC_PHONE |
Phone |
25x |
Phone |
Text |
BC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
BC_TITL_CD |
Title |
nnn |
Title |
Integer |
BC_TITL_TY |
Title Text |
30x |
Title Text |
Text |