Requisitions
Retrieve all high-level requisition information using the Requisition Detail Download connector.
View Specific Information
The 本製品 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 本製品.
- 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 Requisitions WHERE Include = 'Work Order' SELECT * FROM Requisitions WHERE Include = 'SOW'
Columns
| Name | Type | Description |
| Object ID [KEY] | String | SAP Fieldglass Work Order or SOW object reference. |
| Revision | Int | Revision number corresponding to the object reference. |
| Work Order Cost Center Code | String | Pass all Cost Centers on a new line, if multiples exist. |
| Primary Worker Cost Center | String | Pass the Primary Cost Center of the Worker. |
| Cost Allocation Amount | Decimal | Amount to be allocated to each cost center. |
| 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. This field is mutually exclusive with Segmented Object Detail field. |
| Segmented 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. This field is mutually exclusive with GL Account fields. Note - more than one string can appear for a cost center. |
| Allocation % | Decimal | Allocation % is the percent value for whichever object (Cost Center % or GLA %) 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. |
| 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 | Work Order/SOW end date. Indicates the latest revision end date. |
| Object Owner Employee ID | String | Employee ID of Work Order/SOW owner, latest revision. |
| Object Owner Username | String | Username of object owner, latest revision. |
| Object Creator Employee ID | String | Employee ID of Work Order/SOW creator, latest revision. |
| Object Creator Username | String | Username of object creator, latest revision. |
| Description | String | Job Posting Title or SOW Name. |
| 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 latest SOW revision. |
| Job Seeker ID | String | Fieldglass Job Seeker ID for the Work Order latest revision. Blank for SOW workers. |
| Legal Entity | String | Legal Entity code associated to work order. Company configuration Enable Legal Entity must be turned on for Contingent. |
| 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. |
| 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. |
| Remit to Address Code | String | Remit to address (if any) specified by the Supplier on the Work Order/SOW. |
| Currency | String | ISO Currency code from SOW/Work Order. |
| 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 | Called Cumulative Committed Spend. 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. |
| PO Number | String | Populated with the value of the SAP Fieldglass PO Number field where populated. |
| External ID | String | An external identifier used by the client for tracking purposes. External SOW ID |
| Unit Of Measure | String | Rate unit of measure. |
| Calculated Cumulative Amount | Decimal | Cumulative cost center amounts. |
| Primary Cost Center Owner Employee ID | String | Employee ID of the primary cost center owner. |
| 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. |
| Account Category | String | Identifies the type of Cost Center. |
| 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. |
| 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. |
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. |