Projects - Contract Credit Table Formats

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