Adjustment Site Override Upload

This integration uploads site adjustment overrides.

Connector Overview

Component

Detail

Company Type

Buyer

MSP Partner

Supplier

Version Type

API-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Adjustment Site Override Upload.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

Sites

Invoice Adjustments

Related Connectors

Adjustment Only Credit Debit Memo 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.

Adjustment Site Override Upload

Transaction

No

Only applicable for the API-V1.0 version.

Transaction Type

Transaction Type. The valid type names are:

  • True: if any record errors, entire upload fails.

  • False: only records that are in error fail, remaining records are committed successfully.

If this field is not included in the header, the default value will be True.

Number Format

No

Determines the number format to be used in the file.

The valid 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" (Example: "1,234,567.99")

Date Format

No

Determines the date format to be used in the file.

The valid 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.

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

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

Modification Type

Char

1

Yes

Valid values are:

  • A

  • D

  • U

Action to be performed:

A = Add

U = Update

D = Delete

Adjustment Name

Text

100

Yes

Example:

State Tax

Adjustment name of an existing adjustment created for the company in which the upload is to be processed.

Adjustment Type

Text

32

Yes

Valid values are:

  • Invoice Adjustment

  • Credit/Debit Memo Adjustment

  • Miscellaneous Invoice Adjustment

  • SOW Credit/Debit Memo Adjustment

  • SOW Invoice Adjustment

Type of adjustment.

Site Code

Text

100

Yes

Valid SAP Fieldglass Site Code

Site code to which adjustment is applied.

Default Value

Decimal

No

Example:

6.500

Adjustment percentage to be applied to site.

If field left blank, will default to 0.0.

Unique Identifier

  • Combination of Adjustment Name, Adjustment Type, and Site Code fields

Configuration Considerations

#

Item

Notes

1

Site Visibility

A user's visibility will be affected, in part, by the sites to which they are associated. It is important to consider what sites a user should be able to have visibility into for this reason.

2

Site Naming

It is important to choose a meaningful and readable naming convention for your sites. Since users will need to select them from a list when creating different transactions in SAP Fieldglass, it is important that they can easily find them and know they are choosing the correct item. The same applies to Adjustment naming.