PM_PROJECT_TYPE_CUSTOM_FIELDS

This table stores PPM User data field to Microsoft Project custom text fields mappings.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

PM_PROJECT_TYPES

PROJECT_TYPE_ID

PROJECT_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PROJECT_TYPE_ID

NOT NULL

NUMBER

A foreign key reference to project_type_id of PM_PROJECT_TYPES table.

CUSTOM_FIELD

NULLABLE

NUMBER

text number of MSP custom fields.

TYPE

NOT NULL

NUMBER

User data number in PPM.

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201559

UNIQUE

1

PROJECT_TYPE_ID

SYS_C005201559

UNIQUE

2

TYPE

Sequences

This table uses no sequences.