Cost Center Currency Upload

This integration associates currencies with a cost center.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Cost Center Currency Upload.

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

Predecessors

Cost Center

Currency

Related Connectors

Cost Center Upload

User Cost Center Upload

Task Code Cost Centers Association Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type No 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. Cost Center Currency Upload
Transaction No

Only applicable for the API-V1.0 version.

Transaction type

Transaction type. The valid type names are:

  • True

  • False

  • True: If any record errors, the 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.

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

Column Header Name

Data Type

Field Length

Required?

Value(s)/Format

Description/Use/Field Rules

Cost Center Code Text

200

Yes Valid SAP Fieldglass Cost Center Code

Cost center to which currencies are to be associated.

Cost center must be Open or Inactive.

Currency Text

100

Yes

Valid values are:

USD

All

[All]

Example:

GBP~USD~EUR

Valid three-character code(s) for the currency(ies) associated with the Cost Center listed in the Cost Center Code field.

Currency must be associated with the buyer prior to using in this upload.

Note: Valid three-character currency code(s). Multiple values should be separated by “~”.

If ‘All’ is specified in the Currency field, all the currencies enabled for the company will be associated with the cost center.

Unique Identifier

  • Cost Center Code field

Assumptions/Tips

  • Currency is associated with the buyer prior to use in the Cost Center Currency Upload.

  • Cost Center is Open.

  • This is an “Add Only” connector. Currencies may be added, but there is no option to delete or update Cost Center Currency associations. If multiple currencies appear in a record in the connector and some are already associated to the currency, only the new associations will be processed.