Event Hierarchy Completion Download
This integration downloads event hierarchy line-item information that needs to be completed.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Supplier |
|
Version Type |
1.0 |
|
Format |
CSV |
|
Prerequisites |
Company Details setting must be turned on for Integration – Event Hierarchy Completion Download. User role permission must be turned on for upload data and download data. |
|
Predecessors |
N/A |
|
Related Connectors |
N/A |
Triggering Events
All event hierarchy completion information is eligible to be downloaded.
Parameters
-
Parameter 1: Buyer Code (Required) - Single
-
Parameter 2: SOW ID - Multiple (separated semicolon)
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. |
Event Hierarchy Completion Upload |
| Transaction | Yes |
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. Optional field containing any specific reference value required by the supplier. False: Only records in error fail. Remaining records are committed successfully. |
|
|
Language |
No |
Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers always default to the upload user's preferred language. |
The valid language values are: Arabic (Standard Arabic)
|
|
|
Number Format |
No |
Determines the number format to be used in the file. |
This is an optional header value. Determines the number format used in the company. The valid number format 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". |
|
|
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. |
|
|
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 |
Field Length |
Required? |
Value(s)/Format |
Description/Use/Field Rules |
|---|---|---|---|---|---|
|
SOW ID |
Text |
16 |
Yes |
ABCDTQ00001234 |
SAP Fieldglass Statement of Work ID |
|
SOW Line Item ID |
Text |
16 |
Yes |
ABCDPE00001234 |
SOW Line Item ID for Event , Schedule, Management Event, or Milestone |
|
Parent Line Item ID |
Text |
16 |
No |
ABCDPE00001234 |
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 |
No |
External SOW Line item ID for Event, Schedule, Management Event, or Milestone |
|
|
Name |
Text |
100 |
Conditional |
Name of event item. Required for a hierarchical event whose Item Category is Limit and has a lookup. |
|
|
Completion Date |
Date |
Yes, for SOW Events and Management Events |
MM/DD/YYYY DD/MM/YYYY YYYY-MM-DD |
Date the SOW line item was completed. |
|
|
Custom Lookup Name |
Text |
Yes |
The lookup associated with the Event ID (Event Hierarchy Lookup Names). |
||
|
User Defined Segment Name |
Text |
100 |
Conditional. If Data Set company configuration is enabled, this column appears in this upload. In the connector configuration's optional column list view> ‘Show segment selection’ configuation is set to 'true' by default if 'Data Set' and 'Enable Buyer Defined Sequence' company configurations are enabled. |
Corresponding User selected segment values defined in the Lookup associated with that SOW ID. For Standard Lines - The connector pre populates the entire set UDS values. For Limit Lines - The connector pre populates the set of UDS values that were already pre defined. UDS columns are left blank if they were not pre defined and the supplier is expected to complete the entire set. If any one of the segment values are incorrect or left blank the upload fails. |
|
|
Item Category |
Text |
100 |
|||
|
Product Type |
Text |
100 |
|||
|
Valid To |
Date |
Yes for Standard Lines; not required for Limit Lines. |
'Valid To' value from the lookup associated with SOW ID. |
||
|
Valid From |
Date |
Yes for Standard Lines; not required for Limit Lines. |
'Valid From' value from the lookup associated with SOW ID. |
||
|
Comments |
Text |
100 |
No |
Comments regarding completion action. |
|
|
Auto Invoicing |
Text |
3 |
No |
Yes/No |
Indicates whether the item is auto invoiced after approval. |
|
Site |
Text |
100 |
No |
SAP Fieldglass Site Code. |
|
|
Approver Name |
Text |
100 |
Yes, when 'Allow Supplier to select Approver for Events, Fee responses, and Schedules' is enabled |
SAP Fieldglass buyer username |
Buyer user with permission to approve. |
|
Final Terms |
Decimal |
No |
Use if the supplier reduces the value of an event at completion. |
||
|
Rate |
Decimal |
No |
Standard Lines: Rates can't be changed if template rule 'Creation Type is 'Integrtion Only'. Limit Lines: With lookup, rates can't be changed. Without lookup, rates are editable. |
||
|
UOM |
Text |
100 |
Conditional |
Unit code in the buyer company. Only used with Item Category, Limit without lookup. Otherwise it is ignored. |
|
|
Amount |
Decimal |
Conditional |
|||
|
Number of Units |
Number |
No |
|||
|
Tax Service Type |
Text |
100 |
No |
SAP Fieldglass Tax Service Type |
SAP Fieldglass Tax Service Type, if applicable. |
|
Remit-to-Address Code |
Text |
100 |
No |
Supplier RTA code |
|
|
Invoice Adjustment |
Decimal |
No |
|||
|
Custom Field |
Dependent on custom field |
No |
|||
|
Attachment |
Text |
No |
Blank. One or more valid attachment names. |
Used to attach one or more attachment files from the attachment library (comma-separated) when itemizing an event. For example: document1.pdf, report2.docx, image3.jpg. Once added, attachments are displayed on the Event details page. An error displays for invalid attachment names. For duplicate attachment names, one of the files is ignored. |
|
|
Event Account Category |
Text |
500 |
A valid SAP Fieldglass account category. |
The Account category of the SOW event. |
|
|
Product Group |
Text |
100 |
No |
A valid SAP Fieldglass Product Code. |
Available when Product Group is enabled for event hierarchy lines. |
|
SOW Account Category |
Text |
500 |
A valid SAP Fieldglass account category. |
The Account category of the SOW. |