ReceivablesInvoicesreceivablesInvoiceLines
Outlines each item or service included in a receivables invoice, capturing unit price, quantity, and tax details.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the invoice line, used to link the line to a specific customer invoice. |
| CustomerTransactionLineId [KEY] | Long | The unique identifier of an individual invoice line, allowing for detailed tracking and reference of each product or service on the invoice. |
| LineNumber | Decimal | The sequential number of the invoice line, providing order to the items listed on the invoice. |
| Description | String | A textual description of the product or service being invoiced, offering a clear explanation of what is being billed. |
| Quantity | Decimal | The number of units for the product or service being billed on the invoice line. |
| UnitSellingPrice | Decimal | The price of a single unit of the product or service on the invoice line. |
| TaxClassificationCode | String | The code that helps in determining the tax treatment of the product or service, impacting the tax calculations. |
| SalesOrder | String | The sales order number associated with the invoice line, linking the invoice to the original sales order. |
| AccountingRuleDuration | Long | The number of accounting periods over which revenue is to be recognized for this invoice line, applying to rules that require deferred revenue recognition. |
| RuleEndDate | Date | The date when the revenue scheduling rule concludes for this invoice line, impacting revenue recognition schedules. |
| RuleStartDate | Date | The date when the revenue scheduling rule begins for the invoice line, marking the start of the revenue recognition process. |
| AccountingRule | String | The specific revenue scheduling rule applied to the invoice line, determining how revenue is recognized over time. |
| Warehouse | String | The location from which inventory items on the invoice line are shipped, important for inventory tracking and logistics. |
| MemoLine | String | A memo line that provides additional context or explanation for the item on the invoice line. |
| UnitOfMeasure | String | The unit of measure used for the product or service on the invoice line, such as 'each', 'box', or 'kilogram'. |
| ItemNumber | String | The identifier of the inventory item listed on the invoice line, linking it to a specific product in the inventory system. |
| AllocatedFreightAmount | Decimal | The freight charge allocated to this specific invoice line, reflecting the transportation cost for the item. |
| AssessableValue | Decimal | The base value used to calculate tax on the product or service, influencing tax rates and amounts. |
| SalesOrderDate | Date | The date when the sales order was created, helping link the invoice line to the sales process. |
| LineAmount | Decimal | The total monetary value of the invoice line, calculated as the quantity multiplied by the unit selling price. |
| CreatedBy | String | The name of the user who created the invoice line, for tracking purposes. |
| CreationDate | Datetime | The date and time when the invoice line was created in the system. |
| LastUpdatedBy | String | The name of the user who last updated the invoice line, providing audit trail information. |
| TransacationBusinessCategory | String | The classification for tax purposes of the business nature of a transaction, as designated by a tax authority. |
| UserDefinedFiscalClassification | String | A custom classification used for tax purposes, allowing businesses to apply additional tax rules to specific invoice lines. |
| ProductFiscalClassification | String | The tax classification of the product sold on the invoice line, as determined by tax regulations. |
| ProductCategory | String | The tax category of a non-inventory-based product on the invoice line, used to apply specific tax rules. |
| ProductType | String | The type of product sold (for example, Goods or Services), influencing how tax is calculated and reported for this invoice line. |
| LineIntendedUse | String | The intended use of the product on the invoice line as classified for tax purposes, affecting how taxes are applied. |
| LineAmountIncludesTax | String | Indicates whether the amount for the invoice line includes tax, is exclusive of tax, or is determined by tax settings. |
| TaxInvoiceDate | Date | The date the tax invoice document was generated, marking the official date for tax reporting purposes. |
| TaxInvoiceNumber | String | The unique number assigned to the tax invoice, which is used for tax reporting and legal compliance. |
| TaxExemptionCertificateNumber | String | The identification number for the certificate that exempts a party or product from tax, used for tax compliance purposes. |
| TaxExemptionHandling | String | Indicates how tax exemption should be handled for the invoice line. Valid options are Standard, Require, or Exempt. |
| TaxExemptionReason | String | The reason for granting tax exemption to a product or party on the invoice line, such as 'Non-profit' or 'Government Exemption'. |
| AccountingDate | Date | The date that the invoice line’s financial transactions are accounted for, affecting financial reporting and journal entries. |
| AllowCompletion | String | Indicates whether the invoice line can be marked as completed and finalized, ensuring all necessary processes are completed. |
| BillingDate | Date | The date when the invoice line was billed, which may differ from the transaction date and affects payment schedules. |
| BillToCustomerName | String | The name of the customer being billed for the goods or services listed on the invoice line. |
| BillToCustomerNumber | String | The account number of the customer being billed, used for customer identification and tracking. |
| BillToSite | String | The address or location where the bill is sent, helping with accurate invoicing and shipping. |
| BusinessUnit | String | The business unit responsible for the transaction, important for internal reporting and financial management. |
| CrossReference | String | A reference code used to link the invoice line to related documents or transactions, facilitating tracking and auditing. |
| CustomerTransactionId | Long | The unique identifier for the customer transaction tied to the invoice line, enabling the connection of multiple lines to a single transaction. |
| DocumentNumber | Long | The document number for the invoice, used for identification and referencing the invoice line within the system. |
| DueDate | Date | The due date for payment of the invoice line, helping to manage accounts receivable and payment schedules. |
| Finder | String | A searchable identifier that helps users quickly locate specific invoice lines within the system. |
| FirstPartyTaxRegistration | String | The tax registration number for the seller or service provider, used for tax reporting and compliance. |
| InvoiceCurrencyCode | String | The currency code of the invoice, indicating the currency in which the goods or services are billed. |
| InvoiceStatus | String | The current status of the invoice line, such as 'Paid', 'Unpaid', or 'Pending', to track the invoice’s payment state. |
| LegalEntityIdentifier | String | The identifier of the legal entity responsible for the invoice, used for compliance and financial reporting. |
| PaymentTerms | String | The terms under which the invoice is to be paid, such as 'Net 30' or 'Due on Receipt'. |
| PurchaseOrder | String | The purchase order number associated with the invoice line, linking the invoice to the original order. |
| ShipToCustomerName | String | The name of the customer receiving the goods or services, useful for shipping and delivery purposes. |
| ShipToSite | String | The location where the goods or services are shipped, critical for logistics and fulfillment. |
| ThirdPartyTaxRegistration | String | The tax registration number for a third party involved in the transaction, necessary for tax reporting and compliance. |
| TransactionDate | Date | The date when the transaction generating the invoice line occurred, impacting the financial reporting period. |
| TransactionNumber | String | The number assigned to the transaction that generated the invoice line, used for traceability. |
| TransactionSource | String | The origin of the transaction, such as 'Sales Order' or 'Credit Memo', providing context for the invoice. |
| TransactionType | String | The type of transaction linked to the invoice line, such as 'Sale', 'Refund', or 'Adjustment', influencing tax and financial reporting. |