InvDocumentSubtotals
Retrieves subtotal data for invoicing documents, including item totals, taxes, and other aggregates.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The unique identifier for the invoice document subtotals record. |
| Dochdrno | Int64 | The document header number associated with the invoice document subtotals record. |
| Description | String | The description associated with the invoice document subtotals record. |
| Absval | Double | The absolute value field of the invoice document subtotals record. |
| Percentval | Double | The percentage value field of the invoice document subtotals record. |
| Total | Double | The total value for the invoice document subtotals record. |
| Absedit | String | Indicates any editing related to the absolute value in invoice document subtotals record. |
| Percentedit | String | Indicates any editing related to the percentage value in invoice document subtotals record. |
| Status | String | The status field for the invoice document subtotals record, indicating its current state. |
| Department | String | The department associated with the invoice document subtotals record. |
| Location | String | The location associated with the invoice document subtotals record. |
| Trx_absval | Double | The transaction absolute value associated with the invoice document subtotals record. |
| Trx_total | Double | The transaction total associated with the invoice document subtotals record. |
| Docentrykey | Int64 | The document entry key for the invoice document subtotals record. |
| Projectdimkey | Int64 | The project dimension key for the invoice document subtotals record. |
| Projectid | String | The project ID associated with the invoice document subtotals record. |
| Projectname | String | The name of the project associated with the invoice document subtotals record. |
| Itemdimkey | Int64 | The item dimension key for the invoice document subtotals record. |
| Itemid | String | The item ID associated with the invoice document subtotals record. |
| Itemname | String | The name of the item associated with the invoice document subtotals record. |
| Record_url | String | The URL linking to the invoice document subtotals record. |