Custom Fields and Custom Outline Codes

Custom fields can be used to create your own cost, date, duration, finish, flag, number, outline code, start, and text fields in Microsoft Project. The number of customizable fields of a given type can range from 10 to 30. When using Microsoft Project or the OLE DB Provider, you will see the fields listed with the type and the number of the custom field. When you're viewing the custom fields using Microsoft Access or Microsoft Excel, each custom field is stored in a unique table that contains all the data required to identify the custom field or custom outline code and where it is being used within a project. The table name is listed in the Microsoft Project Database column. Table B-11 shows custom fields.

For more information about working with custom fields, see

"Customizing Fields" on page 788 and

"Working with Outline Codes" on page 806.

Table B-11. Custom Fields

Microsoft

Available

OLE DB

Project

Field

Categories

Provider

Database

Description

Cost1-10

Assignment

AssignmentCost1-10

The currency values

Resource

ResourceCost1-10

for the custom Cost1

Task

TaskCost1-10

through Cost10 fields.

Date1-10

Assignment

AssignmentDate1-10

The date values for

Resource

ResourceDate1-10

the custom Date1

Task

TaskDate1-10

through Date10 fields.

Duration1-10

Assignment

AssignmentDuration1-10

The duration values for

Resource

ResourceDuration1-10

the custom Duration1

Task

TaskDuration1-10

through Duration10 fields.

Finish1-10

Assignment

AssignmentFinish1-10

The date values for the

Resource

ResourceFinish1-10

custom Finish1 through

Task

TaskFinish1-10

Finish10 fields.

Flag1-20

Assignment

AssignmentFlag1-20

The Yes/No values for

Resource

ResourceFlag1-20

the custom Flag1

Task

TaskFlag1-20

through Flag20 fields.

Field

Available Categories

OLE DB

Provider

Microsoft

Project

Database

Description

Number1-20 Assignment Resource Task

AssignmentNumber1-20

ResourceNumber1-20

TaskNumber1-20

The numeric values for the custom Number1 through Number20 fields.

OutlineCode1-10 Resource Task

Resource√ľutlineCode1-10 TaskQutlineCode1-10

The values for the custom OutlineCode1 through OutlineCode10 fields.

Start1-10

Assignment

Resource

Task

AssignmentStart1-10

ResourceStart1-10

TaskStart1-10

The date values for the custom Start1 through Start10 fields.

Text1-30

Assignment

Resource

Task

AssignmentText1-30

ResourceText1-30

TaskText1-30

The text values for the custom Text1 through Text30 fields.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment