SSIS Components for SAP Fieldglass

Build 24.0.9060

ActiveWorkOrders

Retrieve all active work orders using the Active Work Order Download connector.

Columns

Name Type Description
Work Order ID String Work Order ID
Revision Number Int Work Order Revision Number
Start Date Date Start Date of Work Order
End Date Date End Date of Work Order
Status String Status of the Work Order
Last Modified Date Date Last Modified Date
Activation Date Date Date this Work Order was activated
Worker First Name String Worker's First Name
Worker Last Name String Worker's Last Name
Worker ID String SAP Fieldglass Worker ID
Vendor Name String Supplier Name
Vendor Code String SAP Fieldglass Supplier code
Job Posting Title String Job Posting Title
Site Name String Site Name
Site Code String Site Code
Site Address 1 String Site Address 1
Site Address 2 String Site Address 2
Site City String Site City
Site State/Province String Site State or Province
Site Country String Site Country ISO Code
Site Zip/Postal Code String Site ZIP Code or Postal code
Legal Entity String Legal Entity code associated to Work Order or SOW. Company configuration 'Enable Legal Entity' must be turned on for Contingent and/or Services: Work Orders and Workers.
Purchase Unit String Name of Purchase Unit Company configuration 'Enable Purchase Unit' must be enabled. The User Role Permission 'Purchase Unit - View' must be enabled to view this information.
Purchase Unit Code String Code of Purchase Unit Company configuration 'Enable Purchase Unit' must be enabled. The User Role Permission 'Purchase Unit - View' must be enabled to view this information.
AP Code String Accounts Payable (AP) code associated to SOW. Company configuration 'AP Code Required' must be turned on for Services. Custom Lookup for AP Code Selection Type must exist.
Business Unit Name String Business Unit Name
Business Unit Code String Business Unit Code
Hours per Day Decimal Indicates Hours per Day
Hours per Week Decimal Indicates Hours per Week
Hours for Committed Spend Decimal Number of hours entered by the WO/WOR creator
Days for Committed Spend Decimal Number of days entered by the WO/WOR creator
Estimated Additional Spend Percentage Decimal Indicates any Additional Estimated Spend Percentage.
Total Estimated Hours Decimal Indicates total estimated hours for work order.
Estimated Expenses Percentage Decimal Indicates any estimated expenses percentage.
Adjustments applies to estimated spend Percentage Decimal Indicates any adjustments applied to spend percentage.
Remit to Address Code String Code as assigned to the RTA by Supplier.
Worker Pay Type Code String Indicates any worker pay types.Company configuration 'Use Worker Type' must be enabled.
Rate Category/UOM String Rate category for Bill Rate with unit of measure.
Bill Rate Decimal Worker's Bill Rate which is associated to the Rate Unit listed in the next field.
Currency String Currency designation
Average rate used to calculate spend Decimal Calculated average rate for work order
Billable per diem Decimal Amount that is billable per day
Maximum Expense Decimal Maximum amount for expenses
Committed spend Decimal Amount of committed spend
Cost Center Name String Cost Center Name in SAP Fieldglass. Primary Cost Center only.
Cost Center Code String Cost Center Code in SAP Fieldglass. Primary Cost Center only.
Cost Allocation percentage Decimal Percentage to allocate to cost center. If company configuration 'Cost Allocation Percentage decimal precision' is enabled, the Cost Allocation Percentage field shows zeros beyond the precision value set digit.
Cost Allocation amount Decimal Amount to be allocated to cost center.
Task Name String Name of task code
Task Code String Task code
Cumulative Committed Spend Decimal Amount accumulated for committed spend for work order(s).
Spend to Date Decimal Amount spent to date
Job Posting Owner String Name of JP owner
Job Posting Owner Employee ID String Employee ID of JP owner
Work Order Create Date Date Creation date of work order
Work Order Submit Date Date Submit date of work order
External ID String An external Work Order identifier used by the client for tracking purposes.
Purchase Order Number String PO Number
Auto Register String Indicates if auto register of workers is set.
Worker Country of Origin String Indicates worker's country of origin.Company configurations 'Allow Security ID format by Worker Country of Origin' and 'Enable Security Information' must be enabled.
Line Item Number Int Fetches Line Item Number of Cost Centers from Work Orders when Account Category Pick List is used.Not applicable for supplier downloads.
Commodity Code String Code for the commodity. This field must be manually configured to be in the download file template.
Commodity Code Description String Description of the commodity code.This field must be manually configured to be in the download file template.
Discount % Decimal Discount % of SOW Worker
Primary Location String Indicates primary location name when Company Configuration 'Allow Multiple Locations' is enabled. Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
Primary Location Code String Indicates primary location code when Company Configuration 'Allow Multiple Locations' is enabled. Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
Work Location Name String The location name. Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations.
Location Code String The location code. Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations.
Original Revision Start Date Date This field returns the Start Date from the original work order regardless of what revision the work order is currently on.

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