ReceivablesInvoicesreceivablesInvoiceDFF
Enables descriptive flexfields for receivables invoices, storing additional details aligned to business processes.
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | The unique identifier associated with the customer transaction for the invoice, linking the descriptive flexfield to a specific transaction. |
| CustomerTrxId [KEY] | Long | The unique identifier of the invoice within the descriptive flexfield, allowing for specific tracking and reference of the invoice's data. |
| _FLEX_Context | String | The context segment of the invoice's descriptive flexfield, used to categorize or segment the data according to business logic or reporting needs. |
| _FLEX_Context_DisplayValue | String | The display value of the descriptive flexfield context, which provides a user-friendly label for the context segment in reports or UI elements. |
| AccountingDate | Date | The accounting date associated with the invoice, representing the date on which the invoice was recognized for financial reporting. |
| AllowCompletion | String | Indicates whether the transaction related to the invoice is ready to be completed. A value of 'Y' allows the transaction to be finalized. |
| BillingDate | Date | The date on which the invoice was generated for billing purposes, marking the start of the payment period. |
| BillToCustomerName | String | The name of the customer responsible for the payment of the invoice, identifying the party being billed. |
| BillToCustomerNumber | String | The unique number assigned to the bill-to customer, used for customer identification within the system. |
| BillToSite | String | The identifier for the specific site or location of the bill-to customer, used for regional or logistical categorization of invoices. |
| BusinessUnit | String | The business unit under which the invoice is issued, typically used for organizational purposes or for tracking different lines of business. |
| CrossReference | String | A reference field used to link the invoice to other related records or systems, providing a cross-reference point for tracking and reconciliation. |
| CustomerTransactionId | Long | The unique identifier of the customer transaction, linking the invoice to the specific customer transaction record for further tracking. |
| DocumentNumber | Long | The document number assigned to the invoice, providing a reference for the invoice document in the system. |
| DueDate | Date | The due date for the invoice payment, representing when payment for the invoice is expected. |
| Finder | String | A field used to help locate the invoice record based on various criteria or search terms. |
| FirstPartyTaxRegistration | String | The tax registration number of the first party, typically the deploying company or seller, used for tax reporting and legal purposes. |
| InvoiceCurrencyCode | String | The currency code used for the invoice, indicating the currency in which the invoice is issued and payment is expected. |
| InvoiceStatus | String | The current status of the invoice, indicating whether it is 'Paid', 'Unpaid', 'Pending', etc., providing insight into the invoice's payment progress. |
| LegalEntityIdentifier | String | The identifier of the legal entity under which the invoice was issued, important for financial reporting and legal compliance. |
| PaymentTerms | String | The payment terms associated with the invoice, specifying the conditions under which payment is due, such as net 30 days or cash on delivery. |
| PurchaseOrder | String | The purchase order number associated with the invoice, providing a link to the original purchase request or agreement. |
| ShipToCustomerName | String | The name of the customer receiving the goods or services billed on the invoice, important for logistics and delivery purposes. |
| ShipToSite | String | The site identifier for the ship-to customer, helping to track the location where the goods or services are delivered. |
| ThirdPartyTaxRegistration | String | The tax registration number of a third party involved in the transaction, such as a reseller or logistics provider, used for tax reporting. |
| TransactionDate | Date | The date when the transaction associated with the invoice was created, marking the actual occurrence of the invoiceable event. |
| TransactionNumber | String | The unique transaction number associated with the invoice, helping to identify and track the specific transaction in records. |
| TransactionSource | String | The source of the transaction that created the invoice, such as 'Sales Order' or 'Return', used for categorization and reporting. |
| TransactionType | String | The type of transaction associated with the invoice, such as 'Sale', 'Return', 'Credit', or 'Debit', used to classify the invoice. |