What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Import Service/Time Sheets Import

Service/Time Sheets Import

The Service/Time Sheets loader uses three header rows: Service/Time Sheet Header, Time Sheet Line, and Service Line.

Overview

This loader is available for Serices Maestro customers.

The Service/Time Sheets import process reads files from ./Incoming/ServiceTimeSheets in the standard SFTP setup. These files are moved to the archive folder located at ./Incoming/Archive/ServiceTimeSheets 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/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
My Custom Field	Custom Field	FALSE	FALSE		any

Note

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