SODocumentSubtotals
Contains subtotal information for sales order (SO) documents, including values such as absolute amounts, percentages, totals, and relevant dimension keys for various categories like project, vendor, employee, and item.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the SO document subtotal record. |
| Dochdrno | Int64 | The header number of the SO document to which this subtotal belongs. |
| Description | String | A description of the SO document subtotal. |
| Absval | Double | The absolute value of the subtotal, typically representing a monetary amount. |
| Percentval | Double | The percentage value of the subtotal, used for calculating proportional values. |
| Total | Double | The total value of the SO document subtotal, combining absolute and percentage values. |
| Absedit | String | Indicates any edits made to the absolute value of the subtotal. |
| Percentedit | String | Indicates any edits made to the percentage value of the subtotal. |
| Status | String | The current status of the subtotal, such as active or pending. |
| Department | String | The department associated with the SO document subtotal. |
| Location | String | The location associated with the SO document subtotal. |
| Trx_absval | Double | The transaction absolute value for the SO document subtotal. |
| Trx_total | Double | The total transaction value for the SO document subtotal. |
| Docentrykey | Int64 | A unique key for the document entry associated with this subtotal. |
| Projectdimkey | Int64 | The project dimension key associated with the SO document subtotal. |
| Projectid | String | The project identifier associated with the SO document subtotal. |
| Projectname | String | The project name associated with the SO document subtotal. |
| Vendordimkey | Int64 | The vendor dimension key associated with the SO document subtotal. |
| Vendorid | String | The vendor identifier associated with the SO document subtotal. |
| Vendorname | String | The vendor name associated with the SO document subtotal. |
| Employeedimkey | Int64 | The employee dimension key associated with the SO document subtotal. |
| Employeeid | String | The employee identifier associated with the SO document subtotal. |
| Employeename | String | The employee name associated with the SO document subtotal. |
| Itemdimkey | Int64 | The item dimension key associated with the SO document subtotal. |
| Itemid | String | The item identifier associated with the SO document subtotal. |
| Itemname | String | The item name associated with the SO document subtotal. |
| Record_url | String | The URL to view or access the SO document subtotal. |