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:
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:
CRDB can’t be uploaded in draft mode. |
True |
|
Approval Required |
No |
Approval process for Credit Debit Memos |
Valid values are:
If not entered, will default to True. |
|
|
Messaging Required |
No |
Determines whether or normal messages will be sent. |
Optional header value.
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)
|
|
|
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:
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:
|
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:
|
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:
|
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:
|
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.