Projects - Contract Credit Table Formats

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