Project number.

The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in.

The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in.

Project name.

Variable indicating the project's charge type. Valid options are R-Regular, H-Overhead, P-Promotional.

Flag indicating whether the project has phases and tasks.

Principal's employee number.

Project manager's employee number.

Project, phase or task supervisor's employee number.

Client number.

Client address code.

Project's total fee.

Project's reimbursable allowance.

Project's consultant fee.

Project's budgeted overhead rate.

Project's status. Valid options are A-Active, I-Inactive, D-Dormant.

Project's revenue method.

Multiplier or amount to use for the project when running Revenue Generation.

The project's organization.

Default unit table to use for the project.

Expected start date for the project.

Expected end date for the project.

Estimated overall percent complete for the project.

Estimated labor percent complete for the project.

Estimated expense percent complete for the project.

Variable indicating whether certain project expenses are billable to the client. Valid options are Y-Billable, N-Nonbillable, C-Category-specific.

Type of message to appear in Expense when the user charges certain expenses to the project. Valid options are E-Error, W-Warning, N-None.

Memo field for comments on the project.

Budgeted labor code check for timesheets. Valid options are N-None, W-Warning, E-Error.

The project's budgeted labor code levels; used when budgeted validation is in effect for timesheets.

Reference project for the Unbilled Detail Report.

The reference field for the project phase.

The reference field for the project task.

Setting to use for cross charges to the project. Valid options are G-Global (the default setting), N-None, P-Project.

Cross-charge method for the project.

Cross-charge multiplier for the project.

The project's description.

Reserved for future use.

Reserved for future use.

Reserved for future use.

Reserved for future use.

Reserved for future use.

The contact record number for the primary contact.

The client's billing address.

The project's long name.

The first line of the project's address.

The second line of the project's address.

The third line of the project's address.

The city of the project's address.

The state of the project's address.

The ZIP code of the project's address.

The county of the project's address.

The country of the project's address.

Variable indicating whether this is a federal project.

The project type.

The Organization's project responsibility.

Flag indicating whether the project can be used as a work reference in proposals.

The project's estimated completion date.

The project's actual completion date.

The project contract's award date.

The date when the Organization submitted its bid on the project.

User-entered comment regarding the completion date.

The Organization's total cost for completing the project.

User-entered comment regarding the Firm Cost.

The total project cost.

User-entered comment regarding the Project Cost.

The project's Opportunity record number.

Flag indicating whether the client's name will be used in proposals, or replaced with an alias.

The client alias to use in proposals if the client is confidential.

Variable indicating whether the record is available to CRM users. The default value is Yes.

Variable indicating whether the record is available to Accounting users.

Flag indicating whether the record is approved for use in transaction processing.

The client record number for the billing client.

The contact record number for the billing contact.

The project location telephone number.

The project location facsimile transmission telephone number.

The project location e-mail address.

The promotional project linked to the record.

The project's cost rate method. Valid options are 0 - None; 1 - from Labor Rate Table; 2 - from Category Rate Table; 3 - from Labor Code Rate Table; 4 - from Employee Cost Rate.

The cost rate table number.

The project's pay rate method. Valid options are 0 - None; 1 - from Labor Rate Table; 2 - from Category Rate Table; 3 - from Labor Code Rate Table; 4 - from Employee Pay Rate.

The pay rate table number.

The project's payroll tax locale.

Variable indicating the project's timesheet line item approval setting. Valid options are Yes, No, and System (the default setting.)

Variable indicating the project's expense report line item approval setting. Valid options are Yes, No, and System (the default setting.)

This field is active only when BudgetedFlag is set to Error or Warning. The budget to use for budget validation of timesheets. Valid options are Project Planning or Budget Worksheet.

This field is active only when the BudgetSource is Project Planning. Valid options are Employee Only, Labor Code Only, or Both.

The user-entered value in Prof. Services Compl. Dt. on the project's Background tab; used to auto-populate Part I, block 19 (2) Year Completed - Professional Services of an SF330 proposal.

The user-entered value in Cons. Compl. Dt. on the project's Background tab; used to auto-populate Part I, block 19 (2) Year Completed - Construction of an SF330 proposal.

The project's functional currency.

An optimal fixed exchange rate to be used for any currency exchanges from the functional currency of the project/phase/task to the project currency.

The project's billing currency.

An optimal fixed exchange rate to be used for any currency exchanges from the functional currency of the project/phase/task to the billing currency.

Flag indicating whether charges to the project are restricted to named companies.

The project's fee in the project's billing currency.

The project's reimbursable allowance in the project's billing currency.

The project's consultant fee in the project's billing currency.

Flag indicating whether revenue upset limits are enabled for the project.

Variable indicating whether revenue upset limits are enabled at the phase level.

Variable indicating whether revenue upset limits are enabled at the task level.

Flag indicating whether to include compensation in the project's revenue upset limit.

Flag indicating whether to include consultant expense in the project's revenue upset limit.

Flag indicating whether to include reimbursable expense in the project's revenue upset limit.

The reimbursable expense markup for the project's committed expenses from purchase orders.

The consultant expense markup for the project's committed expenses from purchase orders.

Internal identifier for the Plan record.

Flag indicating whether Deltek Time should check task start and end dates in Resource Planning.

The Intercompany Labor flag on the project's Intercompany Billing tab. The flag indicates whether to apply the rate method at the Global or Project level.

PRTemplate

The multiplier for Intercompany Labor, on the project's Intercompany Billing tab. This multiplier is used when the ICBillingLabMethod is Rate Method - Multiplier.

The Intercompany Expense flag, on the project's Intercompany Billing tab. The flag indicates whether to apply the rate method at the Global or Project level.

The rate method for Intercompany Expense, on the project's Intercompany Billing tab. The method is used when the Rate Method is applied at the project level. Valid options are Multiplier and Billing Terms.

The multiplier for Intercompany Expense, on the project's Intercompany Billing tab. The multiplier is used when the ICBillingExpMethod is Multiplier.

Flag indicating whether the Require Comments for Entered Hours option is selected on the project record's Time & Expense tab.

Flag indicating whether the Check Project Planning for Planned Hours option is selected on the project record's Time & Expense tab.

Variable indicating the selection in the Bill by Default/Consultants field. Valid options are Y - Yes, N - No, and E - Expense Code.

Variable indicating the selection in the Bill by Default/Other Expenses field. Valid options are Y - Yes, N - No, and E - Expense Code.

The override table number selected in the Bill by Default/Override Table field.

The number format to use for the Phone value.

The number format to use for the Fax value.

The revenue method to use for the second uninvoiced acccount when the revenue by category feature is enabled.

The revenue method to use for the third uninvoiced acccount when the revenue by category feature is enabled.

The revenue method to use for the fourth uninvoiced acccount when the revenue by category feature is enabled.

The revenue method to use for the fifth uninvoiced acccount when the revenue by category feature is enabled.

The unbillled revenue category in which to place any adjustment when the revenue upset limit is exceeded.

The total compensation in the project's functional currency.

The reimbursable allowance in the project's functional currency.

The consultant fee in the project's functional currency.

The project's revenue method.

The intercompany labor rate table ID for the rate table entered in Project Info Center » Intercompany Billing tab » Intercompany Labor section.

The intercompany expense rate table ID for the rate table entered in Project Info Center » Intercompany Billing tab » Intercompany Expense section.

Internal person who is responsible for sending out client invoices.

Award Type

Duration

Contract Type GovCon

Competition Type

Master Contract

Solicitation

NAICS

The pre-invoice number.

Fee Estimate Service Profile

Fee Estimate Surcharge Percentage

Fee Estimate Surcharge Amount

Fee Estimate Additional Expenses Percentage

Fee Estimate Additional Expenses Amount

Fee Estimate Other Percentage

Fee Estimate Other Amount

The project template code as defined in the Ajera Project Template code table in  Configuration.

Ajera Spent Labor

Ajera Spent Reimbursable

Ajera Spent Consultant

Ajera Cost Labor

Ajera Cost Reimbursable

Ajera Cost Consultant

Ajera WIP Labor

Ajera WIP Reimbursable

Ajera WIP Consultant

Ajera Billed Labor

Ajera Billed Reimbursable

Ajera Billed Consultant

Ajera Received Labor

Ajera Received Reimbursable

Ajera Received Consultant

The internal ID for TrafficLIVE.

Traffic Live Project ID

Traffic Live Project Name

The Chargeband internal id for TrafficLIVE.

The Chargeband (mapped to Level 1 Labor Code) for TrafficLIVE.

Username of the user logged in when this record was created.

Date and time when this record was created.

The username of the user logged in when the record was modified.

Date and time when this record was modified.