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)
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

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:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

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:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

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.