This page lists every change included in the ServiceCore Data Share release dated October 15, 2026, including each field's data type and whether it allows null values.
VW_COMPANY_PREFERENCE (Updated view)
We've added a new preference field showing whether your one-time invoice PDFs display the billing period, giving you visibility into this existing setting.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
VW_JOB_WORKFLOW (Updated view)
Job workflow records now include the workflow they belong to, so you can tell which workflow a job's locked version is tied to even as new versions of that workflow are published.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
VW_WORKFLOW_RENDER_JOB (New view)
You can now see a history of every workflow PDF render, including its status, the related job, and the reason for any failure.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| VARCHAR(36) | No |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| VARCHAR(20) | No |
|
| NUMBER(38,0) | Yes |
|
| VARCHAR(255) | Yes |
|
| TIMESTAMP_NTZ(9) | No |
|
| TIMESTAMP_NTZ(9) | No |
|
VW_SCHEDULE_ROUTE (New view)
Explore your new schedule routes, including their names, colors, active weekdays, and default yard, driver, vehicle, and departure settings.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| VARCHAR(255) | No |
|
| VARCHAR(30) | Yes |
|
| VARCHAR(16777216) | Yes |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| TIME | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | No |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | Yes |
|
VW_SCHEDULE_ROUTE_DAY (New view)
See how each schedule route runs on a given day, including assigned driver and vehicle, drive time and distance, and whether a driver or vehicle was left unassigned.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| DATE | No |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| TIME | Yes |
|
| VARCHAR | Yes |
|
| VARCHAR(32) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | No |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | Yes |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
VW_JOB (Updated view)
Jobs now include a schedule route ID, letting you tie recurring jobs to their schedule routes.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | Yes |
|
VW_ROUTE (Updated view)
Routes now include a schedule route ID, so you can connect each route to its matching schedule route once linking is complete.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | Yes |
|
VW_SCHEDULE_FORMULA (Updated view)
Schedule formulas now include a schedule route ID, letting you tie recurring schedules to the schedule routes they belong to.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | Yes |
|
VW_BATCH_BILLING_OPERATION (Updated view)
Batch billing operations now show when a recurring transaction failed to produce a pending transaction, making failures easy to spot and retry.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| TIMESTAMP_NTZ(9) | Yes |
|
VW_WORKFLOW_SIGNATURE (New view)
You can now see the signatures collected on completed job workflows, including who signed, when they signed, and the related job and signature file.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| VARCHAR(255) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | No |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| TIMESTAMP_NTZ(9) | Yes |
|
| NUMBER(38,0) | Yes |
|
VW_WORKFLOW_VERSION (Updated view)
The requires-signature flag on workflow versions is being retired now that signatures are recorded directly; it returns empty values until this release goes live, when the column is removed.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| BOOLEAN | Yes | Removed in this release. Returns NULL until the release date, then the column is dropped. |
VW_INVOICE_TRANSACTION (New view)
You can now see invoice-specific details, including billing type, online payment availability, failed online payment attempts, and the billing period covered by invoices raised from recurring invoices.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| VARCHAR(10) | Yes |
|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | Yes |
|
| DATE | Yes |
|
| DATE | Yes |
|
VW_WORKFLOW_FIELD_DEFINITION_ENUM_OPTION (New view)
A new view lists the fixed answer choices for dropdown-style custom workflow fields, in the order they should be displayed.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| NUMBER(38,0) | No |
|
| NUMBER(38,0) | No |
|
| VARCHAR(255) | No |
|
| NUMBER(38,0) | No |
|
VW_WORKFLOW_FIELD_DEFINITION (Updated view)
Custom workflow field definitions now include a category, so related fields can be grouped together wherever they're displayed.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| VARCHAR(50) | No |
|
| NUMBER(38,0) | No |
|
| VARCHAR(50) | Yes |
|
VW_WORKFLOW_SUBMISSION (Updated view)
Workflow submissions now record the time zone they were filled out in, so submission times can be displayed in the submitter's local time instead of always UTC.
Column | Data type | Allows null | Notes |
|---|---|---|---|
| VARCHAR(255) | Yes |
|