salesInvoiced
Tracks sales that have been invoiced, providing insights into completed billing transactions.
Columns
| Name | Type | References | Description |
| account | String | The general ledger account associated with this invoiced line item. Typically reflects the revenue, expense, or other posting account impacted by the transaction. | |
| amount | Decimal | The total gross amount billed for this line item on the invoice, including any applicable taxes, discounts, and adjustments. | |
| amountnet | Decimal | The net amount for the invoiced line item, representing the base price before taxes or additional charges are applied. | |
| class | String | The classification assigned to this invoice line item for financial reporting or segmentation purposes, such as business unit, product line, or market segment. | |
| costestimate | Decimal | The estimated cost of the item or service being invoiced. Used in gross profit calculations and profitability forecasting. | |
| department | String | The internal department responsible for the sale or delivery of the item or service. Supports departmental financial reporting and budgeting. | |
| employee | String | The sales representative credited with this invoice, used for tracking performance, commissions, and team attribution. | |
| entity | String | The customer or client receiving the invoice. This identifies the buyer in the sales transaction. | |
| estgrossprofit | Decimal | The estimated gross profit for this line item, calculated as the net amount minus the estimated cost. Helps assess the profitability of the transaction. | |
| estgrossprofitpercent | Double | The estimated gross profit margin expressed as a percentage of the revenue, offering a relative measure of profitability for this line item. | |
| item | String | The specific product or service being billed on this line of the invoice. | |
| itemcount | Double | The quantity of the product or service sold and included in the invoice line. | |
| location | String | The warehouse, store, or other location responsible for fulfilling the order. Useful for inventory tracking and regional reporting. | |
| memo | String | An optional note or comment associated with this invoice line item. May contain internal details, special terms, or customer-facing information. | |
| partner | String | The partner, such as an affiliate or reseller, associated with the transaction. Used for tracking partner sales and allocating credit or commissions. | |
| subsidiary | String | The legal or reporting entity under which the invoice was created. Relevant in multi-subsidiary configurations for compliance and consolidated reporting. | |
| trandate | Date | The official transaction date of the invoice. This determines accounting period recognition and aging calculations. | |
| tranline | String | The unique identifier or sequence number for this line item within the invoice transaction. | |
| transaction | String | The parent transaction record to which this invoice line belongs. Serves as a linkage for reporting and auditing purposes. | |
| type | String | The type of transaction, such as 'Invoice', 'Credit Memo', or another sales-related record. |