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