SWIPTFC

IPT Facility Contacts

Field Name

Caption

Mask

Description

Field Type

IC_CRT_BY

Created By

25x

Created By

Text

IC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

IC_EMAIL

Email Address

150x

Email

Text

IC_FAX

Fax Phone

25x

Fax

Text

IC_ID

Contact Rec #

nnnnnnnn

Unique ID

Long Integer

IC_IF_ID

Facility Record No

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

IC_MOBILE

Mobile Phone

25x

Mobile Phone

Text

IC_MOD_BY

Last Mod By

25x

Modified By

Text

IC_MOD_DT

Last Mod Date

mm/dd/yyyy

Modified Date

Date/Time

IC_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

IC_NAME

Name

50x

Name

Text

IC_PHONE

Phone

25x

Phone

Text

IC_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

IC_TITL_CD

Title

nnn

Title

Integer

IC_TITL_TY

Title Text

30x

Title Text

Text