Projects - Contracts Table Format

Follow Vision specifications for preparing a file containing project-contract associations.

Field Name Data Type Length Notes

ContractNumber

Varchar

30 Contract Number for the record, primary key, required and must exist in Contracts.

WBS1

varchar

30 Project number associated with the Contract, Primary Key, required and must exist in PR.

ApprovedDate

datetime

User-entered approved date.

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.