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. |