ReceivablesInvoicesreceivablesInvoiceDistributions
Allocates invoice lines to accounting segments, creating detailed distribution records for financial analysis.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction for the invoice distribution, linking the distribution to the main customer transaction. |
| DistributionId [KEY] | Long | The unique identifier for the invoice distribution, used to track the specific allocation of invoice amounts to different accounts. |
| InvoiceLineNumber | Long | The number of the invoice line to which this distribution is associated, providing a reference for how the amount is split across the invoice. |
| DetailedTaxLineNumber | Long | The tax line number associated with the invoice line, used to track the tax distribution for the specific invoice line. |
| AccountClass | String | The classification of the account for the distribution. Valid values include 'Revenue', 'Receivable', 'Freight', and 'Tax', which help categorize the type of transaction. |
| AccountCombination | String | The code combination representing the specific account for the distribution. This could include various financial dimensions, such as cost center and department. |
| Amount | Decimal | The amount of the distribution in the invoice's currency, indicating the monetary value allocated to the account specified in the distribution. |
| AccountedAmount | Decimal | The amount of the distribution in the ledger currency, representing the value after conversion from the invoice currency. |
| Percent | Decimal | The percentage of the invoice line amount that is allocated to this distribution, allowing for proportional splits of the invoice total. |
| Comments | String | User-defined comments regarding the distribution, providing additional context or explanations about the allocation. |
| CreatedBy | String | The user who created the distribution record, helping track the origin of the distribution. |
| CreationDate | Datetime | The date and time when the distribution record was created, used for tracking the creation history. |
| LastUpdateDate | Datetime | The date and time when the distribution record was last updated, allowing for tracking of modifications. |
| LastUpdatedBy | String | The user who last updated the distribution record, helping to identify who made the most recent changes. |
| AccountingDate | Date | The accounting date of the distribution, which determines when the transaction is recognized in the accounting period. |
| AllowCompletion | String | Indicates whether the distribution can be completed. A value of 'Y' means the distribution is ready to be finalized. |
| BillingDate | Date | The date when the billing was done for the invoice, marking when the invoice charge is officially recognized. |
| BillToCustomerName | String | The name of the customer being billed for the invoice distribution, helping to identify the payer. |
| BillToCustomerNumber | String | The unique number assigned to the bill-to customer, which helps identify the customer in the system. |
| BillToSite | String | The identifier of the site where the bill-to customer is located, used for geographic or logistical purposes. |
| BusinessUnit | String | The business unit under which the invoice distribution was created, used for organizational and financial reporting. |
| CrossReference | String | A reference field used to link the distribution to other records or systems, enabling cross-referencing across different transaction types. |
| CustomerTransactionId | Long | The unique identifier of the customer transaction associated with the distribution, helping to link the distribution back to the original customer transaction. |
| DocumentNumber | Long | The document number of the invoice distribution, which helps track and identify the specific document in the system. |
| DueDate | Date | The due date for the distribution's payment, indicating when the amount should be paid by the customer. |
| Finder | String | A field used for searching and locating the distribution based on various criteria, facilitating easier retrieval of records. |
| FirstPartyTaxRegistration | String | The tax registration number of the first party involved in the distribution, typically the seller or service provider. |
| InvoiceCurrencyCode | String | The currency code used for the invoice distribution, indicating the currency in which the invoice was issued. |
| InvoiceStatus | String | The current status of the invoice distribution, which could include values such as 'Paid', 'Unpaid', or 'Pending'. |
| LegalEntityIdentifier | String | The identifier of the legal entity under which the invoice distribution was created, important for legal and regulatory compliance. |
| PaymentTerms | String | The payment terms associated with the invoice distribution, outlining the payment schedule or conditions for settling the invoice. |
| PurchaseOrder | String | The purchase order number linked to the invoice distribution, referencing the original order that led to the creation of the invoice. |
| ShipToCustomerName | String | The name of the customer receiving the goods or services billed on the distribution, used for delivery tracking. |
| ShipToSite | String | The identifier of the site where the goods or services are delivered, helping to track the location of the shipment. |
| ThirdPartyTaxRegistration | String | The tax registration number of a third-party entity involved in the transaction, such as a logistics provider or intermediary. |
| TransactionDate | Date | The date on which the transaction related to the distribution was created, marking the occurrence of the financial event. |
| TransactionNumber | String | The transaction number assigned to the invoice distribution, providing a unique identifier for the distribution in transaction records. |
| TransactionSource | String | The source of the transaction that generated the invoice distribution, such as 'Sales Order' or 'Return'. |
| TransactionType | String | The type of transaction associated with the distribution, such as 'Sale', 'Refund', or 'Credit', helping classify the distribution. |