SSIS Components for SAP Fieldglass

Build 24.0.9060

Assignments

Retrieve all active assignments using the Assignment Download connector.

Columns

Name Type Description
Assignment ID String Unique identifier for the assignment.
External Ref String Unique external reference (identifier) for the assignment.
Type Name String The name of the assignment Type upon which this assignment is based.
Supplier Code String Supplier code.
Title String The title of the assignment.
Description String Description of assignment.
Currency String Valid three-character currency code associated with the Cost Center listed in the Cost Center Code field. Only one currency code can be given. Currency must be associated with the buyer prior to using in this upload.
Legal Entity String Legal Entity code associated to Assignment. Company configuration 'Enable Legal Entity' must be turned on for Contingent.
Business Unit Code String The business unit in which this Assignment belongs. Business unit codes must be defined in the SAP Fieldglass application, and the Assignment owner must have access to this business unit code.
Site Code String The code that identifies the site where the assignment is located. The Assignment owner must have access to this site in order to create the Assignment. Site codes must be defined in the SAP Fieldglass application.
Location Code String Code that identifies where the assignment is located. Location codes must be defined in the SAP Fieldglass application.
Start Date Date Date on which the Assignment begins.
End Date Date Date on which the Assignment ends.
Assignment Owner String Username of Assignment Owner.
Budget Decimal Budget for the assignment.
Spend to Date Decimal Spend to date = Assignment Budget - Budget approved in Service Receipt
Remaining Budget Decimal Remaining Budget = Assignment Budget - Spend to Date
Purchase Order Number String Purchase order number for the assignment.
Cost Center Code String Primary Cost Center Only For the 2020.11 release, since the new flag will not allow adding of Cost Center Codes on assignment, this field will be blank.
General Ledger Account Code String For the Primary Cost Center only Company configuration 'Require GLA Allocation on Job Postings and Statements of Work' must be enabled. For the 2020.11 release, since the new flag will not allow adding of CC Codes on assignment, this field will be blank. This field is mutually exclusive with the Segmented Object Detail field.
Segmented Object Detail String Segmented Object Detail. Segments will be separated by delimiter on the segmented object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if the 'Enable Segmented Object Detail' configuration is enabled. For the Primary Cost Center only. For the 2020.11 release, since the new flag will not allow adding of CC Codes on assignment, this will be blank. This field is mutually exclusive with the General Ledger Account Code field.
Job Code String Job code for assignment. Multiple rows will be downloaded for multiple Job Codes. For the 2020.11 release, since the new flag will not allow adding of Job Codes on assignment, this will be blank.
Rate Lookup Name String Associated Rate Lookup with a data set on the corresponding Assignment ID. The Data Set company configuration must be enabled to view this field.
PO Lines String Multiple rows will be downloaded for multiple PO Lines.This field must be manually added to the download file configuration.
[seg] User selected segment name String This field displays each of the user selectable segments (in separate columns) which are associated to the PO line. Each segment value associated to multiple cost centers per PO line appear in separate rows. The Data Set company configuration must be enabled to view this field. Valid values of the user selectable segments are picked up from the Assignment.
PO (Line n) Spend Decimal Spend associated with the PO line number of Spend Matrix.This field must be manually added to the download file configuration.
PO (Line n) Remaining Spend Decimal Remaining Spend = Line Item Spend - Spend to DateThis field must be manually added to the download file configuration.
PO (Line n) Spend to Date Decimal Spend to Date = PO line Spend - Line Spend approved in Service ReceiptThis field must be manually added to the download file configuration.
PO (Line n) Cost Center Code String Cost center associated with the PO line number .This field must be manually added to the download file configuration.
Allow Access to all Cost Centers String Indicates if assignment has access to all cost centers.
Allow Access to all Job Codes String Indicates if assignment has access to all job codes.
Allow any Resource to submit Spend against the Assignment String Indicates if any resource can submit spend against the assignment.

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