Contracts Codes Table Formats (PRProjectCodes)
Follow GovWin Capture Management specifications for preparing a file containing contract codes.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| WBS1 | varchar | 30 | Contract record number; primary key; must exist in PR |
| WBS2 | varchar | 7 | Phase record number; primary key; must exist in PR |
| WBS3 | varchar | 7 | Task record number; primary key; must exist in PR |
| ContractCode | varchar | Contract code; primary key; must exist in CFGProjectCode (ProjectCode/Description) | |
| Fees | decimal | 9 | Total fees for work associated with the Contract Code |
| Seq | smallint | 2 | Sort sequence for data in the ContractCodes grid, used with Description to sort data when retrieved or displayed |