SOWCharacteristics
Retrieve SOW characteristic information using the Approved Characteristic Download connector.
Columns
| Name | Type | Description |
| SOW Line Item ID | String | SAP Fieldglass SOW Line item ID. |
| SOW ID | String | SOW FG ID corresponding to the characteristic. |
| Revision | Int | Revision of the SOW corresponding to the characteristic. |
| Characteristic Type | String | Which type of characteristic it is. |
| Sequence Number | Int | Sequence number given in the SOW for each characteristic. |
| Buyer Defined Sequence Number | String | Buyer defined sequence number for SOW line item. Company configuration 'Allow Buyer Defined Sequence on SOW Line Items' must be enabled. |
| Name | String | Name given to the characteristic when it was entered in the SOW. |
| Description | String | Description of the characteristic. |
| Status | String | Status of the characteristic. |
| Supplier Code | String | Supplier code corresponding to the characteristic. |
| Submit Date | Date | Date when the characteristic was submitted. This field is found on event and fee characteristics. |
| Approved Date | Date | Date when the characteristic was approved. |
| Cost Center Code | String | Cost center corresponding to the characteristic. |
| Cost Center Allocation % | Decimal | Allocation % of for each of the cost center present in the characteristic. If company configuration 'Cost Allocation Percentage decimal precision' is enabled, this field shows zeros beyond the precision value set digit. |
| Cost Bearing | String | Indicates if cost center is cost bearing or for statistical purposes.Company configurations 'Enable Cost Bearing' and 'Statement of Work' must be enabled. |
| Requested Amount | Decimal | Requested amount of the characteristic. |
| Final Amount | Decimal | Final amount of the characteristic. |
| Amount | Decimal | Amount per line in the fee characteristic. |
| Maximum Budget | Decimal | Maximum budget amount of the corresponding SOW latest confirmed revision. |
| Spend to Date | Decimal | Amount spend to date on the corresponding SOW. |
| Expected Date | Date | Expected completion date of the event. |
| Unit of Measure | String | Unit of measure of schedules or fee characteristics. |
| Maximum Units | Int | Maximum units for schedules or fee characteristics. This shows the maximum amount of units allowed. |
| Units | Int | Field found on the schedules and fee characteristics. This field shows the amount unit used. |
| Rate | Decimal | Rate of the Fee characteristic. |
| Frequency | String | Field found on schedules and management events that are reoccurring. |
| Start Period | Date | Field found on schedules and management events that are reoccurring. |
| Date Range Start | Date | Field found on Schedules and Management Events that are reoccurring. |
| Date Range End | Date | Field found on Schedules and Management Events that are reoccurring. |
| Submitted By Username | String | User name of the user who submitted the characteristic to be approved. This field is found on Event and Fee characteristics. |
| Submitted By Name | String | Name of the user who submitted the characteristic to be approved. |
| Submitted By Id | String | Employee ID of the user who submitted the characteristic to be approved |
| Owner Username | String | User name of the characteristic owner. |
| Owner Name | String | Name of SOW Owner. |
| Owner ID | String | Employee ID of SOW Owner. |
| Task Code | String | 1 to 1 relationship to the characteristic. |
| Business Unit Code | String | Business Unit of the characteristic. |
| GL Account Code | String | GL Account code of characteristic Company configuration 'Require GLA Allocation on Job Postings and Statements of Work' must be 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. |
| Defined By | String | Indicates if the characteristic was defined by the buyer or the supplier. |
| Site | String | Site of the characteristic. |
| Capitalized? | String | This value can be edited at the characteristic level. |
| PO Number | String | PO Number of the characteristic. |
| Reason Code | String | The reason code associated to the SOW Line Item revision. If revising Holdback item, the reason associated with the holdback. Company configuration 'Allow Supplier to submit revised SOW Events, Fees, and Schedules' must be enabled. |
| SOW Line Item Revision Type | String | Type of Event, Fee, or Schedule revision Company configuration 'Allow Supplier to submit revised SOW Events, Fees, and Schedules' must be enabled. |
| SOW Line Item Revision Number | Int | The revision number of the SOW Line Item If revising Holdback, the revision number of the holdback. Company configuration 'Allow Supplier to submit revised SOW Events, Fees, and Schedules' must be enabled. |
| Original SOW Line Item ID | String | The SAP Fieldglass ZID of the original SOW Line Item associated to the SOW Line Item revision. If revising holdback, this must be the SAP Fieldglass ZID of the original holdback item associated with the holdback revision. Company configuration 'Allow Supplier to submit revised SOW Events, Fees, and Schedules' must be enabled. |
| 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. |
| Discount | Decimal | Discount on the characteristic. |
| Final Amount after Discount | Decimal | Final Amount after Discount on the characteristic |
| Amount after Discount | Decimal | Amount after discount per line in the fee characteristic |
| Item Category | String | Defines whether the line item is of type Limit or Standard which are planned or unplanned work. Using the Item Category of 'Limit' creates a PO Line for a specified amount. Using the Item Category Type of 'Standard' creates a PO Line where the Qty, Unit, and Unit Rate can be specified.This field only appears in the download if the sysenv= SOW_CREATION_TYPE_ENABLED is enabled and Creation Type = Integration.Only applicable for hierarchial events.This field is visible only at the last level event. |
| Product Type | String | Defines whether the line item is of type 'Material' or 'Service'. A Purchase Order from S/4 can have a mixture of both Service and Material lines which need to be visible in both SAP Fieldglass (SOW) and SAP Ariba.'Material' lines are Read Only and cannot be completed. They are excluded from budget calculation and validations in SAP Fieldglass.'Service' lines are completed in SAP Fieldglass.This field only appears in the download if the sysenv= SOW_CREATION_TYPE_ENABLED is enabled and Creation Type = Integration.Only applicable for hierarchial events.This field is visible only at the last level event. |
| Unit Tolerance % | Decimal | The percentage tolerance allowed on units and amount of 'Standard' type line items.The percentage can be up to 3 decimal places.This field only appears in the download if the sysenv= SOW_CREATION_TYPE_ENABLED is enabled and Creation Type = Integration.Only applicable for hierarchial events.This field is visible only at the last level event. |
| Units with Tolerance | Decimal | Maximum tolerance units for 'Standard' type line items.This field only appears in the download if the sysenv= SOW_CREATION_TYPE_ENABLED is enabled and Creation Type = Integration.Only applicable for hierarchial events.This field is visible only at the last level event. |
| Amount with Tolerance | Decimal | Maximum tolerance amount for 'Limit' type line items.This field only appears in the download if the sysenv= SOW_CREATION_TYPE_ENABLED is enabled and Creation Type = Integration.Only applicable for hierarchial events.This field is visible only at the last level event.This field is not visible to supplier if event's Item Category = Standard. |