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 |