Parent Company Cost Center Upload

This integration uploads cost centers from a parent company. It also uploads cost center updates into any child companies based on the Parent Company Mapping Rule.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

BULK-DELTA-V1.0

BULK-FULL-V1.0

Format

CSV

Prerequisites

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

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

Predecessors

Legal Entities (if enabled for buyer)

Business Units

Cost Centers

Related Connectors

Cost Center Upload

User Cost Center Association 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. Parent Company Cost Center Upload
Transaction No Transaction Type

Transaction Type. The valid type names are:

  • 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.

 
Send Notification? No Determines whether normal messaging workflow should be followed.

This flag is used to control sending notifications to users. If the value set to True, email will be sent. If the value is set to False, email will not be sent.

The valid values are:

  • True

  • False

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)

 
If Cost Center is not specified in the file, set status to No Determines whether the cost center is closed or inactive.

If the header is included and the entry is Closed or Inactive, the system uses that status. Otherwise, the system defaults the status to Closed.

You can use this header only for the BULK-FULL-V1.0 version of the upload.

The valid values are:

Closed: When the cost centers not included in the file must be closed.

Inactive: When the cost centers not included in the file must be inactivated.

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

Modification Type Char

1

Yes, for Deletes only.

Valid values are:

  • A

  • U

  • D

  • I

  • Blank (no value)

A – Add

U – Update

D – Delete

I – Inactivate. This value is accepted when the cost center is in:
  • Open status; if user wishes to make the cost center inactive.

  • Inactive status, if user wishes to edit details of an existing inactive cost center and keep it inactive.

Blank – When an existing Cost Center Code is entered, SAP Fieldglass identifies it as an Update; however, when a new Cost Center Code is entered, SAP Fieldglass identifies it as an Add.

Never required for Bulk Full Uploads.

Cost Center Code

Text

200

Yes Valid Cost Center Code

Value that uniquely describes the child company cost center.

Changes only apply when company configuration Allows Unknown Cost Center Validation company configuration is enabled.

Cost Center Name

Text

200

Yes, for Adds only.   Value that uniquely describes the child company cost center in more recognizable terms than the Cost Center Code.
Cost Center Description Text

100

No   Optional long text description of the child company cost center.

Is this a Rebillable Cost Object?

Text

3

No

Valid values are:

  • Yes

  • No

Indicates whether cost objects are to be suppressed for suppliers.

If this field blank or missing, the value will default to No.

Include Start Date and End Date for Cost Center

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if the Cost Center will use start date and end date.

If blank, this field defaults to No.

Buyer must have the Segmented object detail based allocation is required company configuration disabled.

Cost Center Start Date Date Conditional  

Indicates the Cost Center Start Date.

Required if Include Start Date and End Date for Cost Center is Yes.

Cost Center End Date Date Conditional  

Indicates cost center end date and must be at least 1 day after the cost center start date.

Required if Include Start Date and End Date for Cost Center is Yes.

Open to Associate Text

3

Conditional

Valid values are:

  • Yes

Indicates if the worker can associate cost centers with start date and end date of legal entity.

Required if Include Start Date and End Date for Cost Center is Yes.

If any value other than Yesis entered, this field defaults to No.

Estimated Hours Usage Decimal No  

Indicates estimated hours for cost centers with start date and end date.

Required if Include Start Date and End Date for Cost Center is Yes.

Environment Text

100

No

Examples:

  • SAP

  • JDE

Indicates to which system the cost center applies.
Currency Text

100

Yes, for Add only.

Valid SAP Fieldglass Currency Codes

Examples:

  • USD

  • CAD

  • GBP~EUR

Determines the currency for the cost center. Values may only consist of currencies already associated to the buyer.

If multiple currencies are to be associated with the cost center, they may all be entered in this field, delimited by the tilde character (~).

If left blank in add mode, this field will default to the default currency of the buyer.

If left blank in update mode, this field retains the old value.

Owner Text

100

Yes Valid SAP Fieldglass username. The SAP Fieldglass username of the cost center’s owner. 
Reason Text

100

Required for Deletes and Inactivate Valid SAP Fieldglass reason codes.

Cost Center Closed Reason must be entered when deleting or inactivating a cost center.

If a user has his or her default language set to the default language of the company, the reason code can be in any language.

If using bulk upload, a standard reason will be applied to all deletes.

Please contact your SAP Fieldglass representative to configure this reason.

Include All Task Flag Text

3

No

Valid values are:

  • Yes

  • No

  • Blank (no value)

Determines whether all task codes will automatically be associated to the cost center.

If Yes, all task codes will be assigned to the cost center.

If No, task codes will be assigned to the cost center when initially created by the connector.

If blank, this field defaults to No.

Default Task Codes Text

100

No Valid SAP Fieldglass task codes.

Task codes are expected.

Multiple codes are separated by a tilde character '~'.

This field can only be used if Include All Task Flag is set to No.

Include All Expense Flag Text

3

No

Valid values are:

  • Yes

  • No

  • Blank (no value)

Determines whether all expense codes will automatically be associated to the cost center.

If Yes, all expense codes will be assigned to the cost center.

If No, no expense codes will be assigned to the cost center when initially created by the connector.

If blank, this field defaults to No.

Default Expense Codes Text

100

No

Valid SAP Fieldglass expense codes.

Example:

  • Code1~Code2

Expense codes are expected.

Multiple codes are separated by tilde '~'.

This field can only be used if Include All Expense Flag is set to No.

Legal Entity Text

100

Conditional Valid SAP Fieldglass Legal Entity Code.

Used if only single legal entity.

If the legal entity (division code) functionality is enabled within the company configuration, then a legal entity code will be expected here, and this legal entity will be associated with the Cost Center.

Not applicable if Legal Entities Association is None or All.

Legal Entity Association Text

100

Conditional

Valid values are:

  • Multiple

  • Single

  • None

  • All

Indicates if one or more legal entities exist.

This field appears only when the Legal Entity has been enabled in the company configuration.

If field left blank, it defaults to Single unless Legal Entity in not specified, then it defaults to ‘None’.

Segmented Object Detail Code

Text

100

No

Example:

  • IS|Admin|12001

If company configurations Contingent cost centers or Services cost centers are enabled, and the logged-in user has 'Manage' permissions set on the Cost Center Module, then this field can be entered and value will be set on the Cost Center object.
[c] Cost Center Custom Field[x] Text

100

Conditional Dependent upon Custom Field type.

Any custom field associated with the Cost Center module. The custom field name should be prefixed with ‘[c]’. For example, custom field name: ‘BU Custom Field 1’ should be ‘[c] BU Custom Field 1’.

Valid values of the custom field are configured during the setup of the SAP Fieldglass system.

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.

Do not include this field if it is not being used.

Unique Identifier

  • Cost Center Code field

Assumptions/Tips

  • When Legal Entity Association header is not specified, and Legal Entity is specified as blank, it defaults to Association type None. If Legal Entity is specified, it will default to Single.

  • If error threshold is set for upload and the threshold is reached, the warning message Threshold has been reached appears.

Configuration Considerations

#

Item

Notes

1

Cost Center Owners

Cost center owners may be used in Custom Messaging or in Approval Groups in other parts of the application. Take time to consider an appropriate and consistent structure for cost center owners so that this role may be used in the future, if necessary.

2

Cost Center Name

Cost center names appear throughout the application. If possible, utilize a consistent and useful naming convention in order to ensure uniqueness throughout your organization and meaningfulness to the users.

3

Cost Center Code

Best practice would dictate that these codes mirror the cost center codes in your AP system. Note that in SAP Fieldglass, cost center codes must be unique. Some AP systems allow for uniqueness of codes, along with another value such as currency or country. If your accounting system duplicates cost center codes, it may be best to prefix the codes in SAP Fieldglass with two-letter country codes or three-letter currency codes.

4

Reason

The internal ref that is used for this reason is CC_BULK_UPLOAD_CLOSED_REASON.