Characteristic Completion with Revision Upload
This integration allows buyers to mark an SOW Characteristics as Completed and revise an SOW Characteristic that has been invoiced. This upload also allows suppliers to edit SOW Characteristics.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer Supplier MSP Partner |
|
Version Type |
API-A-V1.0 |
|
Format |
CSV |
|
Prerequisites |
User role permission must be turned on for Upload Data and Download Data. Company plug-ins must be turned on for Integration – Characteristic Completion with Revision Upload. |
|
Predecessors |
Statement of Work Events Milestones Schedules |
|
Related Connectors |
SOW Shell Upload Characteristic Completion Upload SOW Submit 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. |
Characteristic Completion with Revision Upload |
|
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: Chinese (Simplified)
|
|
|
Date Format |
No |
Determines the date format to be used in the file. |
The valid date format values are:
If this field is not included in the header, the default value will be MM/DD/YYYY. |
|
|
Number Format |
No |
Determines the number format to be used in the file. |
The valid number format values are:
The quotes are required even if the value does not have a comma in it. If this header field is not in the header, it defaults to "#,##9.99". |
|
|
Buyer |
Yes if supplier upload |
Indicates which buyer information is being uploaded |
Valid SAP Fieldglass buyer 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 |
|---|---|---|---|---|---|
|
SOW ID |
Text |
16 |
Yes |
Example: ABCDTQ00001234
|
Valid SAP Fieldglass Statement of Work ID. |
|
SOW Line Item ID |
Text |
16 |
Yes, if External SOW Line Item ID not entered. |
Example: ABCDPE00001234 |
Valid SOW Line Item ID for Event, Schedule. |
|
Parent Line Item ID |
Text |
16 |
No |
Example: ABCDPE00001234 |
This field will accepts a valid SOW Line Item ID of an event to be itemized. This column only takes the line item ID of an event that has not been marked complete yet or a parent event which has itemized events under it. |
|
External SOW Line Item ID |
Text |
100 |
Yes, if SOW Line Item ID not entered. |
An External SOW Line Item ID for Event, Schedule. |
|
|
Name |
Text |
250 |
Conditional |
Name of event item. This field is required for a Hierarchical Event whose Item Category = Limit and has lookup. Except for 'Limit' type event, this column inherits the name of the event which is getting itemized if it is left blank. |
|
|
Completion Date |
Date |
Yes, if Event. |
Example:
|
Completion date of SOW characteristic. This field must be blank if the SOW Line Item ID and/or External SOW line item ID is for a holdback item. |
|
|
Auto Invoicing |
Text |
3 |
No |
Valid values are:
|
Indicates if characteristic is to be auto invoiced. The value is applied to the line item if the SOW template flag Auto invoice characteristics, timesheets and expense sheets is set to Yes and the Auto Invoicing for Services flag for Supplier Admin is not locked. Also applied if the current value of Auto invoice characteristics, timesheets and expense sheets flag on SOW is No, but the current value of Auto invoice characteristics, timesheets and expense sheets flag on the underlying SOW Template is Yes. Otherwise, the value in the column is ignored. If left blank, this field uses the existing Auto Invoicing for Services behavior as defined by the SOW Template and Buyer/Supplier contract. |
|
Site |
Text |
100 |
Yes, when SOW has Allow Supplier to specify Site on Line Item enabled. |
Valid Site Code in SAP Fieldglass. This can be entered only if the SOW template rule allows the supplier to set SITE on marking item as complete. If the Enhanced Legal Entity Validation is enabled for the company and the template rule Allow Supplier to specify Site on Line Item is enabled, apart from current validations performed, the system also checks if the site code entered is associated with the SOW legal entity. If it is not, the system displays an error message. |
|
|
Product Group |
Text |
100 |
Conditional |
A valid Product Group Code defined in the Product Group admin object. |
For a new itemization, required for standard and limit lines when the SOW Template rule Use Product Group on Hierarchical Events is set to Required and the SOW does not use an Event Hierarchy lookup. Column is ignored when the itemization is being revised. |
|
Approver Name |
Text |
100 |
Yes, when SOW has enabled rule Allow Supplier to select Approver for Events, Fee Responses, and Schedules. |
Valid SAP Fieldglass buyer username |
Valid Username of any buyer user with permission to Approve SOW Line Item AND visibility to the Business Unit, Cost Centers, and Site of Event or Schedule. If the Enhanced Legal Entity Validation configuration is enabled for the company and the Template rule Allow Supplier to select Approver for Events, Fee Responses, and Schedules is enabled, the system verifies that the selected approver has visibility access to the SOW legal entity/business unit/site/cost center combination. If the approver does not have visibility, the system displays an error message. |
|
Final Entry |
Text |
3 |
No |
Valid values:
|
Indicates if this line item is the final entry. Only applicable to Event Hierarchy for a Standard or Limit itemization. Otherwise, this field is blank. |
|
Number of Units |
Number |
No |
Example: 35 |
Used by supplier to reduce the final amount of the Schedule being marked as complete. When Schedule is of type Single Fee or Recurring Fee and the number of units is left blank in the upload file, then it takes the value as the max value. This field can also be used to itemize Hierarchical Events. If there is a value in Parent Line Item ID field and is of a Hierarchical Event, then the value in this field is considered as itemization of the Hierarchical Event. Number of units does not apply for non hierarchical events, since they are itemized by amounts. This field is ignored if the Parent Line Item ID field has a non hierarchical event. |
|
|
Tax Service Type |
Text |
100 |
Yes when the Site of the Line Item has Tax Guidance enabled |
Valid SAP Fieldglass Tax Service Type pick list value. |
Valid SAP Fieldglass Tax Service Type, if applicable. |
|
Remit-to Address Code |
Text |
100 |
No |
Valid Remit-to Address code for the supplier |
Valid SAP Fieldglass Tax Service Type, if applicable. If the SOW line item belongs to a buyer who has setup the supplier to create CTI, when this field is populated, the code is applied to the line item. If the legal entity of the SOW line item has setup Remit-To-Address as Mandatory, then this field is mandatory. If this field is left blank, the upload fails and the system displays an error. If RTA is optional per the legal entity, then this field can be left blank |
|
Final Terms |
Decimal |
No |
Example: 12345.00 |
Use if the supplier wishes to reduce the value of an event upon completion. This field must be blank if the SOW Line Item ID and/or External SOW line item ID is for a holdback item. Cannot be entered for Schedules. |
|
|
Rate |
Decimal |
No |
Example: 1.25 |
Rate value if the event is a hierarchical event. The rate can be changed depending upon the rule 'Can Reduce/Decrease'. |
|
|
UOM |
Text |
100 |
Conditional |
Unit of measure. The unit code configured in the buyer company in the Unit Type admin object. This UOM field is applicable only for a hierarchical event of item category = Limit without lookup. This column is ignored for all other types of events. |
|
|
Amount |
Decimal |
Conditional |
The itemized amount value for a regular event (non hierarchical). For Hierarchical Events (regular HE, Standard Events, Limit Events), this field does not apply. |
||
|
Account Category |
Text |
500 |
Yes |
A valid SAP Fieldglass account category. |
The account category of the SOW. |
|
Comments |
Text |
100 |
No |
Comments regarding completion action. |
|
|
Reason Code |
Text |
100 |
Yes if Revision |
Valid SAP Fieldglass Reason Code |
Reason code of revision |
| [c] Custom Field |
Dependent on custom field configuration |
Dependent on custom field configuration |
Custom field associated to SOW Characteristic. 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] Invoice Adjustment |
Decimal |
No |
Example: 10.00 |
If an invoice adjustment is available for selection, the supplier can upload on the template for that given Event/Schedule. This can NOT remove locked adjustments associated with invoice adjustment groups in place on the Event/Schedule. |
Unique Identifier
-
Sow ID field
-
SOW Line Item ID field
-
External SOW Line Item ID field
Assumptions/Tips
-
This connector is currently only available for suppliers to use.
-
Event Hierarchy Standard and Limit types can only be itemized.
-
Fees are not allowed in this connector. See Fee Response Update Upload.
-
When a field is not required, for example, the rule is disabled for the SOW, the system will ignore the contents of the field.
-
Both buyer and supplier entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
A revision is determined if the External SOW Line Item ID or SOW Line Item ID is in Invoiced status.
-
Enabling the rule 'Allow Supplier to Edit Value' allows the supplier to modify the value of the affected adjustments in an adjustment group.
-
When company configuration SOW owner name updates on existing line items is enabled for the SOW and the SOW Owner has been updated, and when the External SOW Line Item ID / SOW Line Item ID is in Invoiced status and a Revision is created, the new SOW Owner is reflected on the revised Event or Schedule.
-
When account category is unknown, the cost center name cannot be Unknown during the buyer submit or approve action on the document. The account category and related cost center must be chargeable.
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
External SOW ID |
In case the clients are using external ref or testing with external ref instead of SOW ID, then go to SA admin page, edit the bulk upload batch job for company, select the specific batch job ID, and change the column key from SOW ref to external ref. Example: For “SOW Characteristic Upload”, it is ‘dbo.get_split_key(data, 1,''' + ''','''')’ by default. Change 1 to 2 (column 2 is external ref column). |
|
2 |
SOW Line Item ID |
If Creation Type = Integration, the connector cannot upload if hiearchial event has Product Type = Material. If Creation Type = Integration, the connector cannot upload if hiearchial event has Product Type = Service and Item Category = Limit. |