Work Order Accept Upload
This integration accepts multiple work orders.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer Supplier MSP Partner |
|
Version Type |
API-V1.0 |
|
Format |
CSV |
|
Prerequisites |
Company plug-ins must be turned on for Integration – Work Order Accept Upload. User role permission must be turned on for Upload Data and Download Data. |
|
Predecessors |
Work Orders |
|
Related Connectors |
Work Order Revision Accept 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. |
Work Order Accept Upload |
|
Transaction |
No |
Only applicable for the API-V1.0 version. Transaction Type |
Transaction Type. Valid values are:
If this field is not included in the header, the default value will be True. |
|
|
Send Notification? |
No |
Determines if messaging workflow will be utilized |
Valid values are:
This field defaults to True if left blank. |
|
|
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. |
The valid language values are: Arabic (Standard Arabic)
|
|
|
Number Format |
No |
Number format used in the file. |
The valid values are:
The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be “#,##9.99" (Example: "1,234,567.99”) |
|
|
Date Format |
No |
Date format used in the file. |
The valid values are:
If this field is not included in the header, the default value will be MM/DD/YYYY. |
|
|
Buyer |
Yes if supplier upload |
Buyer Company Code |
||
|
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 |
|---|---|---|---|---|---|
|
Supplier Reference |
Text |
100 |
No |
Optional external reference information provided by the Supplier |
|
|
Modification Type |
Char |
1 |
Yes |
Valid values are:
|
A = Accept D = Decline |
|
Job Seeker ID |
Text |
16 |
Yes, If no Work Order ID |
Valid SAP Fieldglass Job Seeker ID Example: XXXXJS00000001 |
Job Seeker ID for which acceptance is being uploaded. |
|
Work Order ID |
Text |
16 or 100 |
Yes, if no Job Seeker ID. |
Valid SAP Fieldglass Work Order ID or Work Order external reference ID Examples: XXXXWO00000001 jsmith09092019Boston |
Work Order ID for which acceptance is being uploaded. This identifier must match the SAP Fieldglass Work Order ID or the external Work Order reference for the corresponding data record listed in the Work Order can be used. |
|
Worker Email |
Text |
100 |
Yes |
Valid SAP Fieldglass Worker Email |
Worker email to which the registration invitation will be sent. |
|
Remit to Address Code |
Text |
100 |
Yes if required by Buyer Config. |
Supplier’s Remit to Address |
|
|
Auto Invoicing |
Text |
13 |
No |
Valid values are:
|
Determines which transactions are to be auto invoiced for the work order. Blank defaults to None. |
|
Comments |
Text |
2000 |
No |
Comments the supplier would like to add when declining (when the Modification Type is D). You cannot add comments if the Modification Type is A. |
|
|
Additional Invoice Adjustment Currency |
Text |
3 |
No |
Valid Fieldglass buyer currency codes Examples:
|
Indicates if buyer is able to add additional invoice adjustment currency. |
|
Register on Behalf of Worker |
Text |
3 |
No |
Valid values are:
|
Indicates if supplier should register for worker. If field is not entered, it will default to No. |
|
Your Supplier Email |
Text |
100 |
Yes, if field Register on Behalf of Worker = Yes. |
Indicates supplier email address. If the field Register on Behalf of Worker = No, then this field cannot have a value. |
|
|
[pr] Rate Category / Rate UOM |
Text |
100 |
Yes, if rate is a Markup. |
For Worker’s Pay Rate. Only downloaded for buyer side. Supplier rates must be entered manually.
For Rates 2.0:
|
|
|
[c] Custom Field 1 |
Dependent on Custom Field configuration |
Dependent on custom field defined. |
Dependent on the custom field defined |
Any custom field associated with the work order defined. When Custom Field Type = Segmented Pick List and the Autopopulate Segment rule on the Pick List = Yes, if a segment value is left blank on the upload, the value is auto populated on the document if there is only one possible value based on the previous segment values. If there is more than one possible value, an error message displays. |
|
| [a] Adjustment 1 |
Text |
100 |
No |
Dependent on adjustment |
Any adjustment defined by the buyer. Buyer can add MSP adjustments on work order. Only available to supplier if Available to Supplier adjustment flag is enabled. |
Unique Identifier
-
Job Seeker ID field and/or Work Order ID field
Assumptions/Tips
-
User can accept or decline the work order through upload.
-
User needs to manually add pay rate columns to the file for any rates defined by the buyer.
For example, When rates defined by buyer are ST/Hr and DT/day, user needs to add [pr] ST/Hr and [pr] DT/Day columns to the file.
-
User needs to manually add custom field columns to the file. The mandatory custom fields (CF) defined by the buyer should be added to the file.
For example, if the buyer has defined CF1 and CF2 to be entered by the supplier on a work order, then while accepting the work order against that buyer, the supplier needs to add [c] CF1 and [c] CF2 columns to the upload file.
-
When company configuration ‘Capture effective dates for cost center on contingent workers’ is enabled, cost center start/end dates will be set to worker’s start/end dates.
-
Both buyer and supplier entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
Enabling the rule Allow Supplier to Edit Value allows the supplier to modify the value of the affected adjustments in an adjustment group.
-
When the Work Order is accepted, it is associated to Consolidated Worker.
-
Suppliers can add any additional adjustments to the work order accept step, but it will not impact the approved committed spend, even if the Include in Estimated and Committed Spend flag is enabled.