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.