Project Import
The Object Translation integration loader uses only a single set of header columns.
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
Project | Describes the type of header row | No | No | project | |
Name* | The Tag's name | Yes | Yes | string(255) | |
Project ID | System generated Project ID for existing project | No | No | integer | |
Status | Status of the project | No | No | string(25) | |
Content Groups | Content Group list for the project | No | No | ||
Description | The Tagging's description | No | No | text | |
Allow anyone to join | If this project open to everyone to join or not | No | No | boolean | |
Who can view members | Who can view members of the project. Owners or anyone with access to the project | No | No | integer | anyone_with_access_to_this_project, project_owners_only |
Project Owners | Owner/s of the project | No | No | User | Must be active Coupa users |
Project Members | Member/s of the project | No | No | User | Must be active Coupa users |
Start Date | Start Date of the task | No | No | datetime | |
End Date | End Date of the project | No | No | datetime | |
External Ref Number | External Ref Number of the project | No | No | string(255) | |
Commodity | Commodity of the project | No | No | string(255) | Must already exist in Coupa |
Category | Category of the project | No | No | string(255) | Must already exist in Coupa |
Department | Department of the project | No | No | ||
Show Sourcing Tab | Enable Sourcing tab or not | No | No | boolean | |
Show Contracts Tab | Enable Contracts tab or not | No | No | boolean | |
Show Suppliers Tab | Enable Suppliers tab or not | No | No | boolean | |
Show Sourcing Calculated Fields | Enable Sourcing calculated fields or not | No | No | boolean | |
Show Contracts Calculated Fields | Enable Contracts calculated fields or not | No | No | boolean | |
Show Suppliers Calculated Fields | Enable Suppliers calculated fields or not | No | No | boolean | |
Additional Planned Savings | Additional Planned Savings of the project | No | No | decimal(32,4) | |
Additional Negotiated Savings | Additional Negotiated Savings of the project | No | No | decimal(32,4) | |
Additional Realized Savings | Additional Realized Savings of the project | No | No | decimal(32,4) |
Task
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
Task | Describes the type of header row | No | No | task | |
Title* | Title of the task | Yes | No | ||
Task ID | System generated Task ID for the task | No | No | ||
Assign To | Owner's login of the task for the project | No | No | ||
Due Date | Due Date of the task | No | No | ||
Original Estimate | Original Estimate of the task in days | No | No | ||
Task completion % | Percentage of the task completion | No | No |
Linked Object
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
Linked Object | Describes the type of header row | No | No | linked_object | |
Object Type* | Type of the linked object | Yes | No | ||
Object ID | ID of the linked object | No | No | ||
Object Name | Name of the linked object | No | No |
Tag
Column Name | Description | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|
Tag | Describes the type of header row | No | No | tag | |
System Tag | System Tag, defaults to false if not specified | No | No | Must be an existing tag |