| ColumnName |
Domain |
Datatype |
NULL |
Definition |
WBS1 |
|
nvarchar(30) |
NO |
Project number. |
| WBS2 |
|
nvarchar(30) |
NO |
The reference field for the project phase. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| WBS3 |
|
nvarchar(30) |
NO |
The reference field for the project task. This column is populated by Deltek once the WBS1 column in this table is filled in. |
| Seq |
|
int |
NO |
Line sequence number for the phase. |
| Phase |
|
int |
NO |
Phase number as displayed on the invoice. |
| Name |
|
nvarchar(40) |
YES |
Name for the phase to print on the invoice. |
| PctComplete |
|
decimal(19, 4) |
NO |
Percent complete for the phase for billing purposes. |
| PctOfFee |
|
decimal(19, 4) |
NO |
Percent of total fee that the phase represents. |
| Fee |
|
decimal(19, 4) |
NO |
Fee for the phase, if Percent Complete by Phase is the Percent of Fee method. |
| BilledJTD |
|
decimal(19, 4) |
NO |
Job-to-date billed amount for the final invoice. |
| BilledLast |
|
decimal(19, 4) |
NO |
Amount billed for the phase on the last invoice for the project. |
| PostWBS1 |
|
nvarchar(30) |
YES |
The project used during the invoice posting. |
| PostWBS2 |
|
nvarchar(30) |
YES |
The reference field for the project phase. This column is populated by Deltek once the PostWBS1 column in this table is filled in. |
| PostWBS3 |
|
nvarchar(30) |
YES |
The reference field for the project task. This column is populated by Deltek once the PostWBS1 column in this table is filled in. |
| FeeToDate |
|
decimal(19, 4) |
NO |
The fee amount for the phase that will appear on the invoice. |
| PhaseGroup |
|
nvarchar(10) |
YES |
The group to which the billing phase belongs. |