Skip to main content

 

 

Coupa Success Portal

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:
  • dd-mm-yyyy 
  • mm-dd-yyyy
  • yyyy-mm-dd
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
  • Was this article helpful?