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