FOCNTCTTEMP_UPG

(SQL Table)
Index Back

ContactTemplate

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 FO_TEMPLATE_TYPE Character(4) VARCHAR2(4) NOT NULL Form Type

Default Value: CONT

Prompt Table: %EDITTABLE

5 TEMPLATE_CODE Character(6) VARCHAR2(6) NOT NULL Form Code

Prompt Table: FO_TEMPLATE_HDR

6 FO_DATE Date(10) DATE Date