SORecurSubtotals
Contains subtotal data for recurring sales orders (SO), including values for absolute amounts, percentages, and totals, along with associated project, vendor, employee, and location details.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the recurring SO subtotal record. |
| Dochdrno | Int64 | The document header number associated with the recurring SO subtotal. |
| Description | String | A description of the recurring SO subtotal. |
| Absval | Double | The absolute value of the recurring SO subtotal. |
| Absedit | String | Indicates any edits made to the absolute value of the recurring SO subtotal. |
| Percentval | Double | The percentage value of the recurring SO subtotal. |
| Percentedit | String | Indicates any edits made to the percentage value of the recurring SO subtotal. |
| Total | Double | The total value of the recurring SO subtotal, combining absolute and percentage values. |
| Status | String | The status of the recurring SO subtotal, such as active or pending. |
| Taxdetail | Int64 | The tax details associated with the recurring SO subtotal. |
| Department | String | The department associated with the recurring SO subtotal. |
| Location | String | The location associated with the recurring SO subtotal. |
| Trx_absval | Double | The transaction absolute value for the recurring SO subtotal. |
| Trx_total | Double | The total transaction value for the recurring SO subtotal. |
| Projectdimkey | Int64 | The project dimension key associated with the recurring SO subtotal. |
| Projectid | String | The project identifier associated with the recurring SO subtotal. |
| Projectname | String | The project name associated with the recurring SO subtotal. |
| Vendordimkey | Int64 | The vendor dimension key associated with the recurring SO subtotal. |
| Vendorid | String | The vendor identifier associated with the recurring SO subtotal. |
| Vendorname | String | The vendor name associated with the recurring SO subtotal. |
| Employeedimkey | Int64 | The employee dimension key associated with the recurring SO subtotal. |
| Employeeid | String | The employee identifier associated with the recurring SO subtotal. |
| Employeename | String | The employee name associated with the recurring SO subtotal. |
| Record_url | String | The URL to view or access the recurring SO subtotal. |