Projects - Contract Credit Table Formats
Follow DPS specifications for preparing a file containing project-contract credit 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 | 20 | Project number associated with the Contract, Primary Key, required and must exist in PR. |
Employee | varchar | 20 | Employee’s employee number, primary key, required and must exist in EM. |
PercentCredit | decimal(19,4) | 19,4 | Employee’s percentage of Contract Amount. Not required. |