Time Sheet Credit Debit Memo Upload

This integration uploads adjustments to time sheets. It also allows administrators to upload only the hour adjustment value for each time sheet instead of the final corrected amount.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Partner

Version Type

API-V1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Time Sheet Credit Debit Memo Upload.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

Workers

Time Sheets

Related Connectors

Standard Time Sheet Upload

Full Time Sheet Credit Debit Memo Upload

Standard Adjust Credit/Debit Memo Upload

Standard TITO Time Sheet Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload File Type

If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.

Upload Time Sheet Credit/Debit Memo

Transaction

No

Only applicable for the API-V1.0 version.

Transaction Type

Transaction Type. The valid type names are:

  • True: If any record errors, the entire upload fails.

  • False: Only records in error fail. Remaining records are committed successfully.

If this field is not included in the header, the default value will be True.

Submit

Yes

Submit the credit debit memo

Valid values are:

  • True: The Credit Debit Memos are submitted.

CRDB can’t be uploaded in draft mode.

True

Approval Required

No

Approval process for Credit Debit Memos

Valid values are:

  1. True: The Credit Debit Memo will go through the approval process as set up in SAP Fieldglass.

  2. False: The Credit Debit Memo will bypass the approval process set-up in SAP Fieldglass.

If not entered, will default to True.

Messaging Required

No

Determines whether or normal messages will be sent.

Optional header value.

  • True: Messaging that is part of the Credit Debit Memo submission process in SAP Fieldglass will be used as part of the upload.

  • False: Messaging that is part of the Credit Debit Memo submission process in SAP Fieldglass will be turned off as part of the upload.

If this header field is not in the header, messaging will go out as part of the Credit Debit Memo submission process.

Language

No

Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Number Format

No

Optional header value.

Value defined in company configuration. Determines the number format used in the file.

If this header field is not in the header, it defaults to “99,999.99”.

Date Format

No

Optional header value.

Value defined in company configuration.

Determines the date format used in the file.

If this field is not in the header, it defaults to MM/DD/YYYY.

Associate Unassigned Cost Centers to Workers

or

Associate Unassigned Cost Centres to Workers

No

Determines if cost centers in upload file that are not currently associated to worker should be associated to worker.  (Also requires company config. ‘Allow worker access to all Cost Centers and Task Codes, and submit Time Sheets through the UI (can be updated on worker only)’ to be enabled.

 

Valid values are:

  • True

  • False

If not included in header, the value will default to False.

Different spelling of header based on upload user’s language

Comments

No

Upload comments

This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Field Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

Worker ID

Or

Work Order ID

Or

Job Seeker ID

Or

Buyer Ref

 

Text

16

Yes

Valid SAP Fieldglass ID format

Example:

XXXXWK00000001

XXXXWO00000001

XXXXJS00000001

Unique Identifier for the Worker. Can be any of the four listed to the left but must be consistent throughout the file.

Last_Name

Text

200

No

Worker’s last name

First_Name

Text

200

No

Worker’s first name

Date

Date

Yes

Time sheet week starting date

Week_Start_Date

Date

Conditional

Valid values are:

  • Time Sheet Start Date

  • Time Sheet Start Date + 7 Days

This field is only required when using bi-weekly, semi-monthly or monthly time sheets.

For instance:

If using a bi-weekly start date, this is the start date of the single week for which time is being entered on the current record.

For bi-weekly timesheets, a minimum of two lines will be required for each timesheet (if time is being recorded for both weeks). For the initial week, the Date and the Week_Start Date fields will have the same value. And for the subsequent week, the Week_Start_Date will be seven days later than the Date field.

Cost_Center_Code

Text

200

Yes

Valid SAP Fieldglass Cost Center Code

Cost Center Code for which time is to be adjusted.

Cost_Center_Name

Text

200

No

Cost Center Name for which time is to be adjusted.

Task_Code

Text

100

Yes

Valid SAP Fieldglass Task Code

Task Code for which time is to be adjusted.

Task_Name

Text

100

No

Task Name for which time is to be adjusted.

Rate_Category_Code

Text

100

Yes

Valid SAP Fieldglass Rate Category code

Examples:

ST

OT

DT

[Correction]

Rate Category Code for which time is to be adjusted. Rate Category Code listed will determine which of the worker’s rates to apply to the hours entered.

If you wish to correct an amount for a given day, use Correction.

Rate_Category_Name

Text

100

No

Examples:

  • Straight Time

  • Over Time

  • Double Time

Rate Category Name for which the time is to be adjusted.

UOM

Text

10

Yes, if Rate_Category_Code isn't [Correction].

Valid values are:

  • Hr

  • Day

  • Month

  • Blank

Unit of measure for the given Rate Category

or

Blank for [Correction]

Sun_Hrs

Decimal

No

Example:

##.##

Range:  -24.00 – 24.00*

Difference, in hours, from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Mon_Hrs

Decimal

No

Example:

##.##

Range:  -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Tue_Hrs

Decimal

No

Example:

##.##

Range:  -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Wed_Hrs

Decimal

No

Example:

##.##

Range:  -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Thu_Hrs

Decimal

No

Example:

##.##

Range:  -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Fri_Hrs

Decimal

No

Example:

##.##

Range: -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Sat_Hrs

Decimal

No

Example:

##.##

Range: -24.00 – 24.00*

Difference in hours from original time sheet.

The maximum negative value allowed will be equal to the original time sheet hours for that period.

Enter 0 or null if no change.

When loading correction, a valid amount will need to be given.

Apply Adjustments

Text

3

Conditional

Valid values are:

  • Yes

  • No

If company configuration Adjustment groups is turned ON for a buyer, this field can be utilized to apply adjustments to the uploaded timesheets/CRDB memos.

[c] Credit Debit Memo Custom Field 1

Dependent on Custom Field Type

Conditional

Dependent on custom field type.

Any custom field associated with a Credit Debit Memo. The custom field name should be prefixed with '[c]'. For example, custom field name: ‘Project' will be '[c] Project'.

Valid values of the custom field are configured during the setup of the SAP Fieldglass application.

Do not include this field if not in use.

[c] Task Code Custom Field 1

Dependent on Custom Field Type

Conditional

Dependent on custom field.

Any custom field associated with a Task Code. The custom field name should be prefixed with '[c]'. For example, custom field name: ‘Project' will be '[c] Project'.

Valid values of the custom field are configured during the setup of the SAP Fieldglass application.

Do not include this field if not in use.

[a] Adjustment 1

Decimal

Conditional

Depends on Adjustment Type either Flat Fee or Percentage.

Example:

[a] State Tax 1

10.00

Numeric value of adjustment to apply to the Credit Debit Memo.

The value is updated only if ‘Adjustment groups’ is turned ON for a buyer and ‘Apply Adjustments' column is set to 'Yes'

Note: When the Buyer has the “enter 100th hour on TS” flag on, the hours can be entered in 100th hr increments, i.e., 8.01, 8.02…..8.99. However, if the flag is not turned on, then hours must be entered in quarter or 10th hour increments, i.e., 8.10, 8.20, 8.25, and so on.

Unique Identifier

  • Job Seeker ID/Worker ID/Work Order ID/Buyer Ref field

  • Date field

  • Cost_Center_Code field

  • Task_Code field

  • Rate_Category_Code field

Configuration Considerations

#

Item

Notes

1

Associate Unassigned Cost Centers to Workers

or

Associate Unassigned Cost Centres to Workers

Prior to adding this header, company configuration ‘Allow worker access to all Cost Centers and Task Codes, and submit Time Sheets through the UI (can be updated on Worker only)’ must be enabled.

The first item is for upload users with language preference of English (United States). The second item is for those with preference of English (United Kingdom).

For Contingent Workers, the entered cost centers will be associated to the worker.

For SOW Workers, we will validate if the underlying SOW has the new SOW rule ‘Give Workers Access to all Cost Centers belonging to the Legal Entity of the SOW’ enabled.  

If enabled, the entered Cost Centers will be associated to the SOW Worker, else the upload will fail for that worker.

Assumptions/Tips

  • If the new Job Posting Template/SOW Template flag ‘Allow Additional Invoice Adjustment Currency' is enabled, the system will look back to the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision for the additional adjustments.

  • When a Time Sheet is submitted successfully via this upload, the system will update tenure information.​​​​​

  • Enabling the rule 'Allow Supplier to Edit Value' allows the supplier to modify the value of the affected adjustments in an adjustment group.