ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF
Allows custom descriptive flexfields for transaction-level data on invoice lines, providing extended tracking and analysis.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the transaction details of the invoice line. |
| ReceivablesinvoicelinesCustomerTransactionLineId [KEY] | Long | The unique identifier of the invoice line associated with the transaction details, helping to link tax, payment, and other transaction details. |
| CustomerTrxLineId [KEY] | Long | The unique identifier for each separate transaction line related to the invoice, ensuring precise tracking and management of individual transactions. |
| _FLEX_Context | String | The context segment of the descriptive flexfield for the transaction line, providing additional business-specific information for the transaction. |
| _FLEX_Context_DisplayValue | String | The displayed value of the descriptive flexfield context, offering a more readable format for the flexfield context. |
| AccountingDate | Date | The date when the transaction for this invoice line is accounted for in the system, affecting financial reporting and reconciliation. |
| AllowCompletion | String | Indicates whether the transaction line entry is eligible for completion within the workflow, allowing control over whether it can be processed further. |
| BillingDate | Date | The date when the invoice for this line is billed to the customer, which may impact the timing of tax reporting and payment due dates. |
| BillToCustomerName | String | The name of the customer being billed for this transaction line, used for customer-specific processing and reporting. |
| BillToCustomerNumber | String | The account number of the customer being billed for this transaction line, linking the line to the customer's financial record. |
| BillToSite | String | The site associated with the customer for billing, helping in geographic or organizational tracking for tax or delivery purposes. |
| BusinessUnit | String | The business unit under which this transaction line is created, allowing categorization for reporting and business segment tracking. |
| CrossReference | String | A reference field used for linking this transaction line to related documents or transactions, facilitating cross-document and cross-transaction traceability. |
| CustomerTransactionId | Long | The identifier of the customer transaction associated with this line, ensuring consistency and traceability across multiple invoice and payment records. |
| DocumentNumber | Long | The document number associated with this transaction line, offering a unique reference to identify the transaction in the system. |
| DueDate | Date | The date by which payment for this transaction line is due, assisting in managing the customer's accounts receivable and collections. |
| Finder | String | A search identifier used to locate or filter the transaction line within the system for easier navigation and data retrieval. |
| FirstPartyTaxRegistration | String | The tax registration number of the first party involved in the transaction, used for compliance with tax authorities. |
| InvoiceCurrencyCode | String | The currency code used for the invoice line, indicating the currency in which the transaction is billed and taxed. |
| InvoiceStatus | String | The status of the invoice line, such as 'Paid', 'Unpaid', or 'Pending', indicating the transaction’s current state in the invoicing process. |
| LegalEntityIdentifier | String | The identifier of the legal entity responsible for the transaction line, ensuring proper allocation for tax, accounting, and legal purposes. |
| PaymentTerms | String | The payment terms assigned to the invoice line, determining the schedule and conditions under which payment is expected. |
| PurchaseOrder | String | The purchase order number associated with this transaction line, linking the transaction to the procurement process and ensuring compliance with purchase terms. |
| ShipToCustomerName | String | The name of the customer to whom the goods or services associated with this transaction line are being shipped. |
| ShipToSite | String | The site where the goods or services associated with the transaction line are delivered, aiding in logistics and geographic tax applications. |
| ThirdPartyTaxRegistration | String | The tax registration number of a third party involved in the transaction, useful for compliance if a third-party is handling tax or payment. |
| TransactionDate | Date | The date the transaction for the invoice line was made, affecting tax reporting and financial statement entries. |
| TransactionNumber | String | A unique identifier for the transaction, used to track the specific entry across systems and reports. |
| TransactionSource | String | The source of the transaction, such as an order, return, or credit, providing context on the origin of the invoice line. |
| TransactionType | String | The type of transaction related to the invoice line, such as 'Sale', 'Adjustment', or 'Refund', defining the nature of the financial event. |