Projects - Contracts Table Format
Follow Vantagepoint specifications for preparing a file containing project-contract associations.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| ApprovedDate | datetime | User-entered approved date. | |
| ContractDescription | nvarchar | ||
| ContractNumber | varchar | 30 | Contract Number for the record, primary key, required and must exist in Contracts. |
| ContractStatus | nvarchar | 10 | Contract status for the record. |
| ContractType | nvarchar | 10 | Contract type for the record. |
| FeeIncludeInd | nvarchar | 1 | |
| Notes | ntext | ||
| Period | int | Period for the project's contract. | |
| RequestDate | datetime | User-entered request date. | |
| WBS1 | varchar | 30 | Project number associated with the Contract, Primary Key, required and must exist in PR. |
Parent Topic: Hub Tables