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