ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
Adds descriptive flexfields at the line item level, extending invoice functionality with custom fields.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier of the customer transaction associated with the invoice line descriptive flexfield, linking it to a specific invoice. |
| ReceivablesinvoicelinesCustomerTransactionLineId [KEY] | Long | The unique identifier for the invoice line associated with the descriptive flexfield, enabling accurate tracking of line-level details. |
| CustomerTrxLineId [KEY] | Long | The unique identifier of the invoice line descriptive flexfield, helping to differentiate between different lines within a single invoice. |
| _FLEX_Context | String | The context segment of the descriptive flexfield that provides additional business-specific classification or categorization for the invoice line. |
| _FLEX_Context_DisplayValue | String | The displayed value of the descriptive flexfield context, providing a human-readable format for understanding the context of the invoice line. |
| AccountingDate | Date | The accounting date associated with the invoice line, specifying the date for financial reporting and revenue recognition. |
| AllowCompletion | String | Indicates whether the invoice line's processing can be completed, helping to manage the status of line-level operations. |
| BillingDate | Date | The date when the invoice line was billed, important for managing billing schedules and cash flow projections. |
| BillToCustomerName | String | The name of the bill-to customer associated with the invoice line, identifying the customer responsible for the payment. |
| BillToCustomerNumber | String | The customer number of the bill-to customer, linking the invoice line to the specific customer record. |
| BillToSite | String | The bill-to site identifier associated with the invoice line, detailing the address or location where the invoice is sent. |
| BusinessUnit | String | The business unit under which the invoice line was created, useful for organizational reporting and managing financial transactions across business units. |
| CrossReference | String | A reference field used to link the invoice line with other transactions, providing a cross-reference to related business activities. |
| CustomerTransactionId | Long | The unique identifier of the customer transaction tied to the invoice line, allowing for traceability and reporting of customer-specific transactions. |
| DocumentNumber | Long | The document number for the invoice line, ensuring that each transaction line has a unique identifier for tracking and auditing purposes. |
| DueDate | Date | The due date for the payment of the invoice line, helping to track payment schedules and ensuring timely collections. |
| Finder | String | A reference field used to quickly locate the invoice line within the system, typically used for searching or filtering related records. |
| FirstPartyTaxRegistration | String | The tax registration number of the first party involved in the transaction, essential for tax reporting and compliance. |
| InvoiceCurrencyCode | String | The currency code associated with the invoice line, ensuring accurate reporting and conversion when processing international transactions. |
| InvoiceStatus | String | The status of the invoice line, such as 'Pending', 'Paid', or 'Partially Paid', helping to track the progress of payment. |
| LegalEntityIdentifier | String | The unique identifier of the legal entity responsible for the invoice line, ensuring proper financial and legal tracking for reporting. |
| PaymentTerms | String | The payment terms for the invoice line, detailing when the payment is due and any applicable discounts or penalties. |
| PurchaseOrder | String | The purchase order number associated with the invoice line, linking the transaction to a specific procurement order. |
| ShipToCustomerName | String | The name of the customer receiving the goods or services for the invoice line, relevant for shipping and delivery processes. |
| ShipToSite | String | The identifier of the ship-to site associated with the invoice line, specifying where the goods or services are being delivered. |
| ThirdPartyTaxRegistration | String | The tax registration number of a third party involved in the transaction, needed for tax compliance when a third party is responsible for taxes. |
| TransactionDate | Date | The date when the transaction related to the invoice line occurred, used for tracking and reporting purposes. |
| TransactionNumber | String | The transaction number assigned to the invoice line, serving as a unique identifier for each transaction within the invoicing system. |
| TransactionSource | String | The source of the transaction that generated the invoice line, such as 'Sales Order' or 'Credit Memo', helping to categorize the invoice line. |
| TransactionType | String | The type of transaction that generated the invoice line, such as 'Sale', 'Refund', or 'Adjustment', classifying the nature of the business activity. |