Service/Time Sheets Import
Overview
The Service/Time Sheets import process reads files from ./Incoming/WorkConfirmationHeader in the standard SFTP setup. These files are moved to the archive folder located at ./Incoming/Archive/WorkConfirmationHeader before being processed in alphanumeric order.
You can also find this integration object in your Coupa instance at:
https://{your_instance}/integration_documents/bulk_show/WorkConfirmation::Header
Service/Time Sheets Columns
The Service/Time Sheets CSV loader utilizes multiple headers rows, listed below.
Service Time/Sheet Header
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Service/Time Sheet Header | Specifies the type of row | FALSE | FALSE | string(255) | Service/Time Sheet Header |
| PO Number | PO number of the associated PO | FALSE | FALSE | string(20) | any |
| Supplier Name | The name of the supplier | FALSE | FALSE | string(100) | any |
| Supplier Number | Used to cross-reference the supplier number from your financial system | FALSE | FALSE | (string255) | any |
| External Reference | External Reference | FALSE | FALSE | string(255) | any |
Time Sheet Line
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Time Sheet Line | Specifies the type of row | FALSE | FALSE | string(255) | Time Sheet Line |
| PO Line Number | Line number of the associated PO line | FALSE | FALSE | string(20) | any |
| Week Start Date | Date when the work began. Can't be in the future. | FALSE | FALSE | date | Can't be future. Format must include dashes. Acceptable formats are:
|
| Day 1 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 2 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 3 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 4 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 5 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 6 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
| Day 7 | Hours worked. Sum of hours for all days must be greater than zero. | FALSE | FALSE | decimal(30,3) | any |
Day 1 is always the first day of the week. Currently, it's always Sunday, but in future releases, the actual day (Sunday, Monday, etc) of Day 1 could be determined by your locale.
Service Line
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| Service Line | Specifies the type of row | FALSE | FALSE | string(255) | Service Line |
| Price | For service quantity lines, must match the PO's line. For service amount lines, can be any valid amount. | FALSE | FALSE | decimal(30,6) | any |
| Currency | Must match the PO line's currency code | FALSE | FALSE | string(6) | any |
| Quantity | For amount-based lines, must be blank | FALSE | FALSE | decimal(30,6) | any |
| Actual Completion | Time and date of when the work was completed | FALSE | FALSE | datetime | any |
| UOM | For service quantity lines, Must match the PO line. For service amount lines, must be blank. | FALSE | FALSE | string(100) | any |