SWFOGFC

FOG Facility Contacts

Field Name

Caption

Mask

Description

Field Type

FZ_CRT_BY

Created By

25x

Created By

Text

FZ_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

FZ_EMAIL

Email Address

150x

Email

Text

FZ_FA_ID

Facility Record No

nnnnnnnn

Link to SWFOGFA.FA_ID

Long Integer

FZ_FAX

Fax Phone

25x

Fax

Text

FZ_ID

Contact Rec #

nnnnnnnn

Unique ID

Long Integer

FZ_MOBILE

Mobile Phone

25x

Mobile Phone

Text

FZ_MOD_BY

Last Mod By

25x

Modified By

Text

FZ_MOD_DT

Last Mod Date

mm/dd/yyyy

Modified Date

Date/Time

FZ_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

FZ_NAME

Name

50x

Name

Text

FZ_PHONE

Phone

25x

Phone

Text

FZ_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

FZ_TITL_CD

Title

nnn

Title

Integer

FZ_TITL_TY

Title Text

30x

Title Text

Text