ODBC Driver for SAP Fieldglass

Build 24.0.9060

CostCenters

Retrieve cost centers using the Cost Center Download connector.

Columns

Name Type Description
Modification Type String A - Add If the cost center already exists, SAP Fieldglass will treat it as an Update.
Cost Center Code String Value that uniquely describes the cost center.
Cost Center Name String Value that uniquely describes the cost center in more recognizable terms than the Cost Center Code.
Cost Center Description String Description of the cost center.
Is this a Rebillable Cost Object? String Indicates whether suppliers will be able to see Cost Allocation information on the Job Posting or SOW Bid.
Is this a Project Cost Center String Indicates if cost center applies to a project. Company configuration 'Require Segmented Object Detail based allocation' must be disabled.
Project Cost Center Start Date Date Indicates project cost center start date. The 'Is this a Project Cost Center' field must be set to Yes on the Cost Center, else the field is ignored.
Project Cost Center End Date Date Indicates project cost center end date. The 'Is this a Project Cost Center' field must be set to Yes on the Cost Center, else the field is ignored.
Open to Associate String Indicates if workers can associate the project cost center to themselves without requiring the permission of the cost center owner. This flag is only relevant for Project Cost Centers. If the Buyer Company has the 'Require Segmented Object Detail based allocation' company config enabled, AND the Buyer code is configured in the SysEnv 'PROJECT_COST_CENTER_WITH_SOD', then this field will be suppressed.
Estimated Hours Usage Decimal Estimated Hours Usage for Project Cost Centers. The 'Is this a Project Cost Center' field must be set to Yes on the Cost Center, else the field is ignored.
Environment String Indicates to which system that cost center applies.
Owner String The SAP Fieldglass username of the cost center's owner. Field is required unless you set the header 'Suppress Owner Validation' to True.
Reason String Cost Center Closed Reason must be entered when deleting 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 the bulk download, a standard reason will be applied to all Deletes. Please contact your SAP Fieldglass representative to configure this reason.
Include All Task Flag String Determines whether all task codes will automatically be associated to the cost center. Yes: All task codes will be assigned to the cost center. No: No task codes will be assigned to the cost center when initially created by the connector. Blank: This field defaults to No.
Include All Expense Flag String Determines whether all expense codes will automatically be associated to the cost center. Yes: All expense codes will be assigned to the cost center. No: No expense codes will be assigned to the cost center when initially created by the connector. Blank: This field defaults to No.
Default Expense Codes String Valid expense code or codes.Multiple codes must be separated by a tilde (~).This field can only be used if 'Include All Expense Flag' field is set to Yes.
Legal Entity Association String Indicates if multiple legal entities apply to the cost center.
Legal Entity String Indicates a single legal entity.
Segmented Object Detail Code String For a Buyer company that wants to use Project Cost Center with SOD, the Buyer Company must have 'Require Segmented Object Detail based allocation' company config enabled AND the Buyer code must be configured in the SysEnv 'PROJECT_COST_CENTER_WITH_SOD'.Company configurations 'Apply to Cost Center for Contingent' or 'Apply to Cost Center for Services' are available to associate Segmented Object Detail Code to Cost Center.
Currency String 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, it will default to the default currency of the buyer. If left blank in Update mode, it retains the old value.
Default Task Codes String Task codes are expected. Multiple codes are separated by the tilde character (~). This field can only be used if 'Include All Task Flag' is set to Yes.
Legal Entities String Indicates multiple legal entities. Multiple legal entities are separated by the tilde character (~).

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060