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 |