SSIS Components for SAP Fieldglass

Build 24.0.9060

RequisitionLineItems

Retrieve all high-level requisition information using the Requisition Line Item Detail Download connector. This connector differs from the Requisition Detail Download in that it adds SOW characteristic details. Each payment characteristic is added as a separate line and its corresponding details is sourced from the SOW.

View Specific Information

The component will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the component.

  • Include supports the '=' operator. This parameter specifies if work order or SOW details will be retrieved. Available values are: Work Order, SOW, and Both. By default, both types are retrieved.

For example, the following queries are processed server-side:

SELECT * FROM RequisitionLineItems WHERE Include = 'Work Order'
SELECT * FROM RequisitionLineItems WHERE Include = 'SOW'

Columns

Name Type Description
Object ID String SAP Fieldglass Work Order or SOW object reference.
Revision Int Revision number corresponding to the object reference.
Description String Job Posting Title or SOW Name
Status String SAP Fieldglass SOW/Work Order Status
External ID String An external identifier used by the client for tracking purposes.
Buyer Ref String Buyer reference
Master SOW Ref String SAP Fieldglass Master SOW ID.
Master SOW External Ref String An external identifier for Master SOW used by the client for tracking purposes.
Master SOW String Indicates if Object Id refers to a Master SOW.
Master SOW PO Number String Optional purchase order number from the Master SOW.
Object Owner Username String Username of object owner, latest revision.
Object Owner Employee ID String Employee ID of Work Order/SOW owner, latest revision.
Object Creator Username String Username of object creator, latest revision
Object Creator Employee ID String Employee ID of Work Order/SOW creator, latest revision.
Object Create Date Date The date the SOW/Work Order was created.
Object Start Date Date Start date of the Work Order/SOW. Indicates the latest revision start date.
Object End Date Date End date of the Work Order/SOW. Indicates the latest revision end date.
Actual End Date Date When the SOW is closed this field indicates when the SOW needs to be closed
Closed Reason String Closed reason for SOW/Work Order
Supplier Code String Supplier Code for the SOW/Work Order
Vendor ID String The Vendor ID value associated to the Supplier
Remit to Address Code String Remit to address (if any) specified by the Supplier on the Work Order/SOW.
Site Code String SAP Fieldglass Site object for SOW/Work Order, latest revision.
Location Code String SAP Fieldglass Location object for SOW/Work Order, latest revision.
Business Unit Code String SAP Fieldglass Business Unit Code.
Primary Cost Center Code String Primary Cost Center Code identified on the SOW.
Primary Cost Center Name String Primary Cost Center Name identified on the SOW.
Account Category String Identifies the type of Cost Center: Internal Order, Cost Center, WBS Element.
Cost Center Allocation Amount Decimal Indicates amount to be allocated to cost center if not using allocation percentages.Applicable for SOW Work Orders only.
Allocation % Decimal Allocation % is the percent value for whichever object (Cost Center % or GLA % or SOD %) is driving the cost allocation. If company configuration 'Cost Allocation Percentage decimal precision' is enabled, this field shows zeros beyond the precision value set digit.Applicable for SOW Work Orders only.
Primary Cost Center Owner Employee ID String Employee ID of the primary cost center owner.
General Ledger Account String Pass the GL Account for Cost Center associated. This field only appears if company configuration 'Require GLA Allocation on Job Postings and Statements of Work' is enabled.
Segment Object Detail String Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if 'Enable Segmented Object Detail' configuration set. More than one string can appear for a cost center.
Legal Entity Code String Legal Entity Code related to the SOW or the Work Order, latest revision.Required if 'Enable Legal Entity' configuration set.
Legal Entity Name String Legal Entity Name related to the SOW or the Work Order, latest revision
PO Number String Populated with the value of the SAP Fieldglass PO Number field where populated.
Committed Spend Decimal Amount of committed spend/revised committed spend excluding tax or adjustment for Work Order or the Maximum Budget Amount (without Site Tax or any Adjustments) from the SOW.
Cumulative Committed Spend Decimal Value of Cumulative Committed Spend from the Work Order / Work Order Revision or the Presented Budget Amount (without Site Tax or any Adjustments) from the SOW.
Spend to Date Decimal Cumulative spend across all revisions for Work Order or Spend to Date from the SOW.
Currency String ISO Currency code from SOW/Work Order.
Job Seeker/Worker Name String SAP Fieldglass Job Seeker Name object for the Work Order latest revision and Worker Name object for SOW with SOW workers on latest SOW revision.
Job Seeker ID String Job Seeker ID
Line Item ID String SAP Fieldglass SOW Line item ID.
External Line Item ID String An external identifier used by the client for tracking purposes.
Line Item Description String Description of SOW line item
Line Item Name String Name of the SOW Line Item.
Line Item Type String Valid SOW Line Item Type. All Fee Definitions, Schedules in Created status and Management Events in Pending status.
Sequence Number Int The sequence number assigned automatically by the Fieldglass application.
Buyer Defined Sequence Number Int The sequence number assigned manually by the buyer.
Units Decimal The number of units being billed for schedules or fees.
Maximum Units Int Maximum units allowed for schedules or fee characteristics.
Unit of Measure String The unit of measure code for the Units listed.
Unit of Measure Name String The unit of measure name for the Units listed
Line Item Rate Decimal Line Item Rate
Requested Amount Decimal Requested Amount for work order/SOW
Charged Amount Decimal Amount for the individual charge detail of the SOW Line Item.
Total Line Item Amount Decimal Total Line Item Amount.
Due Date Date The due date noted for the SOW Line Item. This field is only applicable for Schedules.
Library Definition Code String The Code of the library definition used to create the Line Item. Only applicable to SOW Characteristics. For Fee Responses, the library is pulled from the Fee Definition.
Library Definition Name String The Name of the library definition used to create the Line Item Only applicable to SOW Characteristics. For Fee Responses, the library is pulled from the Fee Definition.
Line Item Cost Center Code String Cost center code for line item
Line Item Cost Center Name String Cost center name for line item
Line Item Cost Center Allocation Amount Decimal Amount allocated to line item cost center
Line Item General Ledger Account String The GL Account for associated Cost Center. This field only appears if company configuration 'Require GLA Allocation on Job Postings and Statements of Work' is enabled.
Line Item Segment Object Detail String Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if 'Enable Segmented Object Detail' configuration set. Note - more than one string can appear for a cost center.
Line Item Allocation % Decimal Allocation % is the percent value for whichever object (Cost Center % or GLA % or SOD %) is driving the cost allocation for the SOW Line Item.
Commodity Code String Description of the commodity code from the Contingent Work Order, Statement of Work, Event, Fee, or Schedule. This field must be manually configured to be in the download file template.
Commodity Description String Description of the commodity code from the Contingent Work Order, Statement of Work, Event, Fee, or Schedule. This field must be manually configured to be in the download file template.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Include String This parameter specifies if work order or SOW details will be retrieved. Available values are Work Order, SOW, and Both. Defaults to Both.

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