ReceivablesInvoicesreceivablesInvoiceTransactionDFF
Adds descriptive flexfields for the entire invoice transaction, enabling more detailed recordkeeping of billing activities.
Columns
| Name | Type | SupportedFinders | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier for the customer transaction related to the invoice, ensuring proper linkage across various transaction records. | |
| CustomerTrxId [KEY] | Long | The unique identifier for the specific customer transaction associated with the invoice, used for tracking and reporting purposes. | |
| _FLEX_Context | String | The context segment of the descriptive flexfield, capturing additional business-specific details related to the invoice transaction. | |
| _FLEX_Context_DisplayValue | String | The displayed value of the descriptive flexfield context, offering a user-friendly version of the business-specific context segment. | |
| AccountingDate | Date | InvoiceSearch | The date on which the transaction is accounted for in the financial system, impacting the period in which the transaction is recorded. |
| AllowCompletion | String | InvoiceSearch | Indicates whether the invoice transaction is allowed to be marked as completed within the processing workflow, determining if it can be finalized. |
| BillingDate | Date | InvoiceSearch | The date when the invoice transaction is officially billed to the customer, marking the start of the payment cycle. |
| BillToCustomerName | String | InvoiceSearch | The name of the customer who is being billed for the transaction, helping to identify the payer for this specific invoice. |
| BillToCustomerNumber | String | InvoiceSearch | The account number of the customer being billed, linking the transaction to the customer's financial records. |
| BillToSite | String | InvoiceSearch | The site where the bill-to customer is located, used for geographic or operational purposes in billing and tax calculations. |
| BusinessUnit | String | InvoiceSearch | The business unit responsible for generating the invoice transaction, enabling categorization and reporting by business division. |
| CrossReference | String | InvoiceSearch | A reference used for linking this transaction to related documents or transactions, enhancing traceability across systems. |
| CustomerTransactionId | Long | PrimaryKey | The identifier for the customer transaction tied to this invoice, ensuring the consistency and integrity of the transaction within the system. |
| DocumentNumber | Long | InvoiceSearch | The unique document number assigned to the invoice transaction, acting as a reference for identifying and retrieving the transaction. |
| DueDate | Date | InvoiceSearch | The date by which the invoice transaction is due for payment, impacting cash flow management and collections processes. |
| Finder | String | A search key or identifier used to easily locate or filter the transaction within the system for quick access and analysis. | |
| FirstPartyTaxRegistration | String | InvoiceSearch | The tax registration number for the first party involved in the transaction, used for tax compliance and reporting purposes. |
| InvoiceCurrencyCode | String | InvoiceSearch | The currency code associated with the invoice transaction, indicating the currency in which the transaction is billed and paid. |
| InvoiceStatus | String | InvoiceSearch | The status of the invoice transaction, such as 'Open', 'Paid', or 'Void', indicating the current state of the transaction in the invoicing process. |
| LegalEntityIdentifier | String | InvoiceSearch | The identifier for the legal entity responsible for the invoice, ensuring accurate allocation for tax, accounting, and legal purposes. |
| PaymentTerms | String | InvoiceSearch | The terms agreed upon for payment of the invoice, including details such as the due date, discounts, or payment schedules. |
| PurchaseOrder | String | InvoiceSearch | The purchase order number linked to the invoice transaction, providing a reference to the procurement process for the goods or services billed. |
| ShipToCustomerName | String | InvoiceSearch | The name of the customer to whom goods or services are shipped, used for shipping and delivery documentation. |
| ShipToSite | String | InvoiceSearch | The site or location where goods or services are delivered, allowing tracking and operational alignment with delivery processes. |
| ThirdPartyTaxRegistration | String | InvoiceSearch | The tax registration number of a third party involved in the transaction, used for tax compliance when applicable. |
| TransactionDate | Date | InvoiceSearch | The date when the invoice transaction is recorded or processed, affecting accounting periods and reporting cycles. |
| TransactionNumber | String | InvoiceSearch | A unique number assigned to the invoice transaction, serving as a primary reference for tracking and retrieving the transaction. |
| TransactionSource | String | InvoiceSearch | The source or origin of the transaction, such as an order or adjustment, providing insight into how the transaction was initiated. |
| TransactionType | String | InvoiceSearch | The type of transaction, such as 'Sale', 'Refund', or 'Credit', helping to categorize the nature of the financial event for reporting and analysis. |