PeopleSoft 9
Asset Management

Table Name FS_CF_TEMPLATE

Table Description
FS_CF_TEMPLATE
Columns
Name Datatype Is PK Is FK
ORIG_CF_NAME char(18) Yes No
FIELDNAME char(18) No No
CF_ORDER smallint No No
CF_TYPE char(1) No No
CF_LENGTH smallint No No
DISPLAY_LENGTH smallint No No
CF_ACTIVE_STATUS char(1) No No
DELETE_CF char(1) No No
AFFILIATE_TYPE char(1) No No
AFF_RELATED_CF char(18) No No
ADDED_CF char(1) No No
MODEL_CF char(18) No No
RECNAME char(15) No No
ORIG_REC_NAME char(15) No No
PREV_DISPLAY_LEN smallint No No
PREV_CF_ORDER smallint No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_FS_CF_TEMPLATE PK Yes
PSAFS_CF_TEMPLATE IE1 No
Member(s) of "PS_FS_CF_TEMPLATE" Index
ORIG_CF_NAME
Member(s) of "PSAFS_CF_TEMPLATE" Index
SYNCID

Published December 16, 2006