ServiceEntrySheets
Retrieve service entry sheets using the Service Entry Sheet Download connector.
Columns
| Name | Type | Description |
| Company Code | String | Buyer Code. |
| Company Name | String | Buyer Name. |
| Line Item ID | String | Line Item ID, including Event ID, Schedule ID, Fee ID, Timesheet ID, or Expense Sheet ID. |
| External Line Item ID | String | External ID for the line item. |
| Line Item Name | String | Name of the SOW Line Item. Not applicable to Time Sheets or Expense Sheets. Pull blank value for Time sheet or expenses sheet. |
| Line Item Type | String | The type of document: ES = Expense Sheet PE = Event PS = Schedule TS = Timesheet TU = Fee |
| Revision? | String | Indicates whether the SOW Line Item is a revision to a different Line Item. |
| Original Line Item ID | String | SOW Line Items that are revised will show their Original SOW Line Item ID in this field, to indicate from which SOW Line Item the revision was created |
| Original External Line Item ID | String | SOW Line Items that are revised will show their previous Line Item's External ID. |
| Supplier Code | String | Supplier Code for Buyer. |
| Supplier Name | String | Supplier Name. |
| Vendor ID | String | The Vendor ID value associated to the Supplier. |
| Service Date | Date | The date most typically associated with completion of work for the Line Item. Varies by Line Item module. |
| Submit Date | Date | The date when the line item was submitted. |
| Project ID | String | SOW Statement of Work Reference or Contingent Work Order Reference. |
| PO Number | String | Optional purchase order number from the SOW or Work Order related to the invoice. |
| Master SOW ID | String | Statement of Work ID of the Master SOW.Defaults to blank for contingent work order. |
| Master SOW PO Number | String | Optional purchase order number from the Master SOW related to the invoice.Defaults to blank for contingent work order. |
| Legal Entity Code | String | Legal Entity Code related to the Line Item. |
| Legal Entity Name | String | Legal Entity Name related to the Line Item. |
| Site Code | String | Site Code related to the Line Item. |
| Site Name | String | Site Name related to the Line Item. |
| Capitalized? | String | Indicates if line item is to be capitalized. This value can be edited at the characteristic level. |
| Business Unit Code | String | Business Unit Code related to the Line Item. |
| Business Unit Name | String | Business Unit Name related to the Line Item. |
| Cost Center Code | String | Cost Center Code related to the Line Item. |
| Cost Center Name | String | Cost Center Name related to the Line Item. |
| Cost Center Allocation % | Decimal | Allocation percentage associated to the Line Item's cost center.If company configuration 'Cost Allocation Percentage decimal precision' is enabled, this field shows zeros beyond the precision value set digit. |
| Cost Center Allocation Amount | Decimal | Allocation amount associated to the Line Item's cost center. |
| Currency | String | Currency of the line item. |
| Charge Code | String | Charge code for line item. Only applicable to Time Sheets and Expense Sheets and for the Schedule, Event and Fee definition. Schedule Event and Fee definition pull blank value. |
| General Ledger Account Code | String | General Ledger Account Code related to the Line Item.Mutually exclusive with Segmented Object Detail. |
| Hours | Decimal | Line Item Hours, if applicable. |
| Rate Category Code | String | Line Item Rate Category Code. Only applicable to Time Sheets. For Expense sheet, Schedule, Event, Fee definition, pull blank value. |
| Rate | Decimal | Line item rate. |
| 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 is set. More than one string can appear for a cost center. This field is mutually exclusive with GL Account fields. |
| Units | Decimal | The number of units being billed. Not applicable to Events. |
| Unit of Measure Code | String | The unit of measure code for the Units listed. Not applicable to Expense Sheets or Events. |
| Unit of Measure Name | String | The unit of measure name for the Units listed. Not applicable to Expense Sheets or Events. |
| 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. |
| 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. Defaults to blank for timesheet and expense sheet. |
| Library Definition Name | String | The name of the SOW library definition used to create the Line Item. Only applicable to SOW Characteristics. For Fee Responses, the library is pulled from the Fee Definition. This field is blank when the characteristic is not copied from the definition library. Defaults to blank for timesheet and expense sheet. |
| Charged Amount | Decimal | Amount for the individual charge detail of the SOW Line Item. |
| Total Line Item Amount | Decimal | Total Line Item Amount. |