Unique identifier for the assignment related to the expense report, typically assigned to a person responsible for submitting or reviewing the report.

Code that categorizes the type of audit applied to the expense report, such as audits based on original receipts or image-based receipts.

Describes the reason for returning the expense report to the individual, usually due to missing or incorrect documentation during the audit process.

Indicates whether the expense report includes corporate card transactions where the payment liability is split between both the company and the individual.

Identifier for the individual who is currently responsible for approving the expense report.

Type of exchange rate used to calculate the reimbursable amounts for foreign currency expenses.

The date the expense report was saved or submitted, typically representing the end of the reporting period.

A unique identifier for the expense report, used for referencing and operations like updates and deletions.

A unique identifier for the expense report used during insert, update, and delete operations, ensuring proper tracking across systems.

A unique reference number for the expense report that adheres to company-specific numbering conventions.

The total amount of the expense report, calculated in the reimbursement currency. Also includes the total in the approver’s preferred currency if applicable.

Current approval status of the expense report, such as Approved, Pending Manager Approval, or Paid.

The date when the expense report transitioned to its current approval status.

The date on which the expense report received final approval from all necessary approvers.

The date when receipts for the expense report, in the form of images, were received and processed.

Status code representing the current state of imaged receipts for the expense report, such as 'Required', 'Missing', or 'Received'.

Explanation for why imaged receipts are not included with the expense report, potentially due to issues like receipt clarity or submission delays.

Unique identifier for the business unit or department to which the expense report belongs.

Identifier for the initial approver selected by the individual submitting the expense report, prior to any reassignments.

Identifier of the parent expense report, if the current report is a revision or related to another earlier report.

Code representing the method of payment used for the expenses on this report, such as 'check', 'cash', or 'credit card'.

Unique identifier for the individual who owns the expense report, often tied to their employee or user account.

Identifier for the person who created the expense report, typically the individual submitting the expenses for review and approval.

Description of the business purpose or activities that justify the expenses submitted in the report.

A unique filing number for receipts, manually entered by the auditor to track and verify receipts submitted with the report.

The date on which receipts for the expense report were physically received or digitally submitted for auditing.

Status of the receipts for the expense report, indicating whether receipts are 'Missing', 'Required', or 'Received'.

Currency code representing the currency used for reimbursing the individual for expenses incurred.

Indicates how the expense report was created, for example, via a mobile app on iOS or Android.

The date the expense report was formally submitted for review and approval.

Identifier for the business trip associated with the expense report, which helps link the report to travel-related costs.

Explanation for why an outstanding cash advance has not been applied against the current expense report.

Reason why an outstanding cash advance has not been deducted from the current expense report's total amount.

Indicates the user who created the expense report or row in the system, typically a person responsible for data entry.

Timestamp indicating when the expense report or row was initially created in the system.

Timestamp showing the last time the expense report or row was modified, reflecting any updates or changes.

Login session identifier associated with the user who last updated the record.

Name or identifier of the user who made the most recent update to the expense report or row.

Indicates the specific business unit or department within the organization associated with the expense report.

Indicates whether the expense report is ready to be submitted for review, often depending on the completion of required fields and validations.

Indicates whether corporate card transactions can be matched to corresponding expenses in the report to ensure accurate reimbursement.

Lists any errors or issues that occurred during the submission process, such as missing required fields or incorrect data.

Name of the individual for whom the expense report was created, typically matching their employee or user account information.

The status of the original receipts required for the expense report, indicating whether they are 'Required', 'Missing', or 'Received'.

The status of the imaged receipts required for the expense report, indicating whether they are 'Required', 'Missing', or 'Received'.

Overall status of the expense report, which could be 'Draft', 'Submitted', 'Approved', 'Paid', or other relevant stages.

Lookup value describing the meaning of the Audit Code, providing clarity on the type of audit applied.

List of individuals who are currently waiting for approval or are responsible for approving the expense report.

This field is reserved for insert operations only; for updates or deletions, appropriate child table operations should be used.

This field is reserved for insert operations only; for updates or deletions, appropriate child table operations should be used.

This field is reserved for insert operations only; for updates or deletions, appropriate child table operations should be used.

This field is reserved for insert operations only; for updates or deletions, appropriate child table operations should be used.

This field is reserved for insert operations only; for updates or deletions, appropriate child table operations should be used.

This column is used as a generic reference, possibly tied to specific search operations or queries.

Date associated with the system’s effective date for data operations, possibly used to ensure accurate historical data retrieval.

Query parameter that helps fetch records which are effective as of the specified start date.

Name of the service provider for transportation or travel services, such as a car rental company or an airline.

Unique identifier assigned to an individual who is responsible for the expense, typically the employee or contractor.

Explanation provided by an auditor for adjusting the reimbursable amount, offering context for the changes made.

Code that identifies the specific reason an auditor made adjustments to the reimbursable amount for an individual.

Unique identifier for an alternate tax withholding group, used for tax purposes in the context of payroll or expenses.

Total amount charged to the corporate card account for the expense incurred.

Currency code associated with the amount billed to the corporate card account.

Unique identifier for the corporate card associated with a specific transaction.

Date when a person checks out from a location, typically for accommodations-related expenses.

Username or identifier of the user who initially created the expense record.

Timestamp representing the exact date and time when the expense record was created.

Unique transaction identifier for a specific credit card transaction, allowing for easy reference and tracking.

Amount recorded for a daily expense receipt, expressed in the currency of the receipt.

Total business-related distance traveled during the day, typically used for mileage or per diem calculations.

The maximum allowable daily expense for a trip or project, helping to manage travel expenses.

Identifier for the location where a trip or travel begins, typically used in conjunction with other travel data.

Detailed description of the specific expense item, providing context and clarification for the expense.

Starting point or departure location of a trip, used for travel and itinerary management.

Final destination or arrival location of the trip, aiding in expense categorization for travel.

Code identifying the unit of measurement for travel distances, such as KILOMETER or MILE.

The final date for an expense that spans multiple days, marking the conclusion of the expense period.

Timestamp marking the exact end date and time of an expense that spans several days.

Odometer reading recorded at the end of a business-related trip to track vehicle usage.

Rate at which one currency is exchanged for another, useful for conversions during international travel or expenses.

Code that categorizes the expense item (for example, BUSINESS, PERSONAL) to assist in classification and reporting.

Code identifying how the expense was created, such as via mobile apps or web portals.

Unique identifier for a specific expense item within the system.

Alternate unique identifier for an expense item, used in operations like inserts, updates, or deletes.

Reference number used to identify and track specific expenses within reports or systems.

Unique identifier for a complete expense report that includes multiple related expenses.

Code indicating the source of an expense, such as CASH or CORPORATE_CARD.

Identifier for a template used to structure the expense report or for expense creation.

Code indicating the category of the expense, such as AIRFARE, CAR_RENTAL, or ACCOMMODATIONS.

Unique identifier for a specific type of expense, such as lodging, meals, or transportation.

Expense limit for a particular flight class, such as ECONOMY or BUSINESS.

Total duration of the flight in hours, used for travel time tracking and reimbursement.

Identifier for the specific airline flight, providing details on the travel itinerary.

Types of fuel eligible for reimbursement, typically based on the vehicle and type of trip.

Indicates whether an image of the receipt is required for an expense to be processed.

Identifier for the parent expense item in a set of itemized expenses, used for hierarchical expense reporting.

Amount on the receipt to be reimbursed for business-related expenses.

Amount on the receipt that is for personal use, not eligible for reimbursement.

Unique identifier for a travel reservation, such as a flight or hotel booking.

Reason or explanation for why an expense was incurred, often required for validation or auditing purposes.

Indicates whether a justification is required for a specific expense item.

Timestamp indicating when the expense record was last updated.

Login session associated with the last update made to the expense record.

User who made the last modification to the expense record.

License plate number of the vehicle used during the expense period.

Location where the expense was incurred, such as a city or event venue.

Unique identifier for a specific location where the expense was incurred.

Indicates whether the trip is considered long-term, typically based on duration or nature of the trip.

Date the long-term trip began, used for trip planning and expense allocation.

Merchant-assigned receipt or invoice number to track the specific transaction.

Name of the merchant or business where the expense was incurred.

Unique reference number assigned by the merchant, used for transaction tracking.

Tax registration number assigned to the merchant by tax authorities, useful for reporting and compliance.

Unique identifier assigned to the merchant for tax purposes, used for reporting and compliance.

Unique identifier for a specific mileage reimbursement policy, helping to apply the correct reimbursement rules.

Number of individuals attending an event, such as a business dinner or meeting, for which expenses are claimed.

Number of days the expense occurred or was incurred, typically used for per diem calculations.

Number of people sharing a vehicle or other transport, used for calculating shared mileage or expenses.

Unique identifier for the business unit or department associated with the expense.

Total reimbursement for carrying passengers in a vehicle, used in mileage or transport reimbursements.

Name of a passenger traveling with the individual who incurred the expense.

Type of rate applied for mileage reimbursement based on the number of passengers in the vehicle.

Code indicating the entity responsible for the payment of the transaction, such as an employee or company.

Unique identifier assigned to the person responsible for the expense, typically the employee or contractor.

Portion of the receipt marked as personal, not eligible for reimbursement.

Indicates whether the expense was short-paid due to noncompliance with company policies.

Indicates whether the expense violates any company policies, typically for auditing purposes.

Indicates whether a policy warning has been applied to the expense, often due to minor issues.

Code that explains the reason for a policy warning applied to an expense item.

Unique identifier for the individual who prepared the expense report.

Mileage rate applied per passenger in a vehicle for the purpose of calculating reimbursements.

Total amount on the receipt, typically in the receipt's currency, to be reimbursed or tracked.

Currency code for the receipt, indicating the currency in which the expense was incurred.

Date the receipt for the expense was generated, typically for verification and record-keeping.

Indicates whether a declaration is required for missing receipts in order to process the expense.

Indicates whether receipts are missing for the expense, affecting processing and reimbursement.

Indicates whether receipts are required for a specific expense item.

Indicates whether the receipt for an expense has been verified by an auditor.

Amount to be reimbursed to the individual, calculated in the reimbursable currency.

Currency code for the reimbursement, typically matching the currency used for the expense.

Number assigned to an expense item, indicating the order in which items are entered into the expense report.

Date when the expense was incurred or when the first day of a multi-day expense begins.

Timestamp indicating the date and time when the expense occurred or the trip started.

Odometer reading at the start of a trip, used for mileage calculation.

Code that indicates the tax classification for an expense, used for compliance and reporting.

Code indicating the class of ticket for travel, such as BUSINESS or ECONOMY.

Unique identifier for a specific airline or travel ticket.

Code indicating the travel method used, such as CAR, TRAIN, or FLIGHT.

Code for the type of travel, such as DOMESTIC or INTERNATIONAL.

Total distance traveled during a business trip, used for mileage reimbursement calculations.

Unit of measure for the number of days for per diem calculations.

Indicates whether the expense has failed validation checks and requires correction.

Error messages generated during validation, providing details on issues with the expense.

Warning messages generated during validation, indicating potential issues with the expense.

Code for the category of vehicle used, such as COMPANY, PRIVATE, or RENTAL.

Type of vehicle used, for which mileage reimbursement may be applicable (for example, CAR, MOTORCYCLE, VAN).

Code that indicates the geographical zone for mileage reimbursement or trip planning.

Code that specifies the lookup type for defining geographical zones used in calculating mileage rates.

Business unit associated with the expense, used for departmental and financial tracking.

Name of the individual incurring the expense.

Template associated with the expense item, used to categorize and standardize expenses.

Expense type categorizing the expense, such as travel, lodging, or meals.

Currency of the receipt for the expense, providing clarity on exchange rates or reimbursement needs.

Currency used for reimbursing an expense, which may differ from the receipt currency.

Unit of measurement used for travel distances, such as KILOMETER or MILE.

Class of ticket for travel (for example, BUSINESS, ECONOMY).

Source of the expense, such as Cash or Corporate Card.

Unique reference number for tracking the object version or transaction.

Identifier for the credit card upload process, used for tracking and processing.

Indicates whether an attachment is associated with the expense.

Status of the expense report (for example, Approved, Pending, Submitted).

Code representing the authorization number for a credit card transaction.

Name of the travel type, either Domestic or International.

Category of the vehicle used for the expense, such as COMPANY, PRIVATE, or RENTAL.

Name of the type of vehicle used for the expense, such as CAR, MOTORCYCLE, or VAN.

Name of the fuel type used for a vehicle expense.

Meaning of the tax classification code, defining the tax treatment for the expense.

Code indicating the country where the expense was incurred, relevant for tax and reporting purposes.

Date when the expense was automatically submitted for processing or approval.

Exact date and time when the transaction related to the receipt occurred, helping to differentiate transactions on the same day.

Amount of tip given as part of the expense transaction.

Indicates whether the user has confirmed or visited the expense entry, ensuring accuracy.

Status of the validation process for the expense, with values such as errors, warnings, or successful validation.

Indicates whether the expense is prepaid, such as a booked flight or hotel.

Indicates the attendees for an expense item. Used in insertion processes for events and gatherings.

Custom field for expense data that can only be used during insert operations.

Contains error messages for the expense item during insertion processes.

Indicates matched expenses, used for linking related transactions.

Indicates itemization of the expense, used in insertion processes for detailed breakdown.

Indicates any duplicate expenses detected, requiring action for correction.

Data on how the expense is distributed across accounts or departments.

Finder value used for locating specific expenses.

System effective date used for tracking the validity of data.

Date the data became effective, used for filtering records by date.

Unique identifier for the invoice, used for tracking and managing invoices in the system.

Alternative unique identifier for the invoice, used for insert, update, and delete operations to manage invoice records.

The unique number assigned to the supplier invoice, used for referencing and identifying the invoice.

Currency code used on the invoice, which can be manually specified or defaulted from the Supplier Site or invoicing business unit.

Currency used to make a payment for the invoice, specified during invoice creation or defaulted from the Supplier Site or business unit settings.

The total amount of the invoice in the transaction currency, specified when creating the invoice.

The date on the supplier invoice, which can be set during creation or defaulted to the system date.

The name of the business unit for the invoice, set during creation and cannot be changed after the invoice is created.

The name of the supplier associated with the invoice, provided during invoice creation and cannot be changed afterward.

Unique identifier for the supplier associated with the invoice.

Procurement business unit linked to the supplier site for identifying the correct supplier site in the invoice.

The physical location of the supplier where goods and services are delivered. This value must be set at invoice creation and is immutable afterward.

Unique identifier for the requester who initiated the goods or services request, used in invoice approval workflows.

Name of the person requesting the goods or services associated with the invoice.

Name of the invoice group, assigned for reporting and payment purposes, required during invoice creation based on business unit settings.

The source of the currency conversion rate for the invoice, used when dealing with non-functional currencies.

Date when the conversion rate is applied to convert amounts to another currency, essential for non-functional currency invoices.

The rate used to convert one currency into another for the invoice, essential for non-functional currency invoices.

The accounting date for the invoice, determining when the invoice is recorded in accounting. It can be defaulted or manually provided.

A textual description of the invoice for clarification or additional information.

Code used to identify the method of payment delivery associated with the invoice.

The text on electronic payment instructions used by the bank for processing payments, such as printing a check or holding it for collection.

Flag indicating whether the invoice is to be paid independently of other invoices for the same supplier.

The code that identifies the source of the invoice, such as a spreadsheet, external system, or user-defined source.

The source system from which the invoice was created, such as external systems or spreadsheets.

The type of invoice, such as Standard, Prepayment, Credit Memo, or Debit Memo, defined by the invoice amount and other parameters.

Groups invoices for a single payment run, categorizing suppliers into specific groups like Employees, Merchandise, or Government.

The date when the invoice was received, which can be used to calculate the due date for payments.

User-defined code for categorizing the reason for the payment.

Code from a government or central bank that provides additional details on the reason for payment, used for regulatory reporting.

User comments explaining the reason for the payment, which can be entered during invoice creation.

First remittance message used for payment processing, providing additional payment details.

Second remittance message used for payment processing.

Third remittance message used for payment processing.

Terms used to calculate payment dates, installments, and discount amounts, based on agreements with the supplier.

Date used along with payment terms to determine due dates and discount dates.

The date when goods were received, used for calculating the invoice payment due date.

Code used to identify the method of payment, such as check, cash, or credit card.

Indicates how the payer will make the payment, which can be defaulted from supplier or profile-level payment settings.

Tax registration number of the supplier, used for tax reporting and compliance.

Unique identifier for the first party tax registration.

Tax registration number of the first party, used for legal and financial purposes.

The name of the legal entity associated with the invoice, either manually entered or defaulted.

The identifier for the legal entity, used for tracking and compliance purposes.

Account combination for recording liabilities associated with the invoice.

Category of the document, used for organizing and classifying invoice types.

Manual sequence number used when sequential document numbering is enabled.

Voucher number assigned to the invoice if document numbering is not used.

Indicates the validation state of the invoice, typically 'Not Validated' by default.

Approval state of the invoice, showing whether it is approved, pending, or rejected.

Indicates whether the invoice has been paid.

Accounting state of the invoice, showing whether it has been processed in the accounting system.

Date after which a prepayment invoice can be applied to other invoices. This applies only to temporary prepayments.

Indicates whether the invoice has been canceled.

The amount paid against the invoice.

The base amount of the invoice before any adjustments or currency conversions.

Purchase order number associated with the invoice, used to match invoices to purchase orders.

The party associated with the invoice.

The party site associated with the invoice, providing further details about the location or entity.

The calculated tax amount that ensures consistency with the physical document.

Classification of transactions that require special documentation for tax purposes, like international transactions.

Country where the transaction occurred, used for taxation and reporting purposes.

Attribute used for routing invoice images.

Additional attribute used for routing invoice images.

Another attribute used for routing invoice images.

Additional routing attribute used for invoice image processing.

Routing attribute used for invoice image processing.

Indicates the coding status of the invoice, showing whether it has been correctly accounted for.

Date for budgetary calendar periods used for funds checks.

Status of funds availability for the invoice.

Date the invoice was canceled.

Username of the person who canceled the invoice.

Unique identifier for a remittance, used for tracking payments.

Check digit for validating the unique remittance identifier.

Timestamp when the invoice record was created.

Username of the person who created the invoice.

Username of the person who last updated the invoice.

Timestamp when the invoice was last updated.

Session login associated with the user who last updated the invoice.

Bank account number to which the payment for the invoice is remitted.

Supplier's International Bank Account Number (IBAN), used for international payments.

Unique identifier for the external bank account associated with the supplier.

Indicates who is responsible for bank charges, such as the payer or payee.

Priority assigned to the payment for processing based on urgency.

First reference key for invoice tracking.

Second reference key for invoice tracking.

Third reference key for invoice tracking.

Fourth reference key for invoice tracking.

Fifth reference key for invoice tracking.

Product table used to categorize the invoice.

Document number for the invoice image.

Details of the invoice lines, used for itemizing the products or services.

Details of prepayments applied to the invoice.

Details of available prepayments for the invoice.

Global descriptive flexfield for additional invoice data.

Details of installments for the invoice.

User-defined descriptive flexfield for the invoice.

Search term or identifier used to locate and retrieve specific invoices.

Date used to fetch resources that are effective as of a specified start date.

Unique identifier for the invoice associated with the descriptive flexfield, used to link the flexfield data to its corresponding invoice.

Unique identifier to be used for insert, update, and delete operations, preferred over InvoicesInvoiceId to manage descriptive flexfield data.

The unique identifier for the invoice to which the descriptive flexfield data is linked, used to track and manage the flexfield's association.

Use this unique identifier for insert, update, and delete operations to handle flexfield data, providing a more flexible approach than InvoiceId.

Custom description of the invoice, providing additional information or context related to the descriptive flexfield.

Custom date field for the invoice's descriptive flexfield, capturing a relevant date associated with the invoice.

Custom comments related to the descriptive flexfield, allowing users to add further context or explanations regarding the invoice.

Context name for the descriptive flexfield, helping define the purpose or use of the flexfield in relation to the invoice.

Display value for the descriptive flexfield context, providing a human-readable version of the context name for better user understanding.

Search term or identifier used to locate and retrieve specific descriptive flexfield records, aiding in efficient data retrieval.

Reference number used to map child aggregates to parent tables, linking descriptive flexfield data with other related entities.

Date parameter used to fetch resources that are effective as of a specified start date, ensuring time-sensitive data is retrieved accurately.

Unique identifier of the invoice associated with the installment, linking the installment data to the corresponding invoice.

Unique identifier for managing insert, update, and delete operations in place of InvoicesInvoiceId for handling invoice installments.

The unique number assigned to an invoice installment, helping to track and identify the installment within the larger invoice.

Unique identifier used for managing insert, update, and delete operations related to invoice installments, preferred over InstallmentNumber.

The outstanding amount of the invoice installment that has not yet been paid.

Discount amount available on the first discount date, which can be provided during invoice creation or derived from payment terms.

Date when the first discount becomes available, either provided during invoice creation or calculated based on payment terms.

The date when the installment is due for payment, either provided during invoice creation or determined from payment terms.

Total amount due for the installment, representing the full amount before any discounts or adjustments.

Reason provided for placing or releasing the hold on the installment, allowing flexibility in managing payment statuses.

Priority number for paying this installment, influencing the order in which installments are processed.

Discount amount available on the second discount date, similar to the first discount amount, either provided or derived from payment terms.

Date when the second discount becomes available, derived from payment terms or specified during invoice creation.

Discount amount available on the third discount date, provided or calculated based on terms.

Date when the third discount is available, calculated based on the payment terms or provided at invoice creation.

Net amount associated with the first installment of the invoice, after applying any discounts or adjustments.

Net amount for the second installment of the invoice, reflecting any changes due to discounts or other factors.

Net amount for the third installment of the invoice, calculated after all applicable adjustments.

Indicates whether a scheduled payment is currently on hold due to validation issues or other reasons.

The user or system entity responsible for placing the installment on hold, for traceability and accountability.

Type of hold applied to the installment, detailing the nature of the issue (for example, validation failure).

Method used by the payer to settle the installment, such as check, cash, or credit, which can be defaulted or manually entered.

Code representing the payment method, uniquely identifying the chosen payment method.

Timestamp indicating when the hold on the installment was placed or released.

Bank account number for the supplier where the payment is made, either manually entered or populated from the supplier profile.

Unique identifier for the supplier's external bank account, prioritized over the bank account if both are provided.

Username of the individual who created the installment record, ensuring accountability for data entry.

Timestamp when the installment record was created, helping track the creation time of the installment.

Timestamp indicating when the installment record was last updated, providing visibility into its most recent changes.

Username of the individual who last updated the installment record, adding traceability for changes.

Session login associated with the user who last updated the installment, helping identify the update session.

Name of the remit-to address where the payment for the installment should be sent, either provided or defaulted from the supplier profile.

Name of the remit-to supplier where payment should be directed, defined at invoice creation or sourced from the supplier profile.

First remittance message for payment processing, provided during invoice creation or updated later as needed.

Second remittance message for payment processing, with similar functionality as RemittanceMessageOne.

Third remittance message, serving the same purpose as RemittanceMessageOne and Two, for detailed payment instructions.

Field for user-defined descriptive flexfield data related to the installment, used for custom data during insert operations.

Global descriptive flexfield field for capturing custom, global attributes associated with the invoice installment.

Search term or identifier used to locate and retrieve specific invoice installment records.

Unique identifier of the invoice related to the installment, used for tracking the installment data in relation to the invoice.

Reference number that links child aggregate records to parent tables, providing a relationship between data entities.

Date parameter used to fetch resources that are effective as of a specific start date, ensuring accurate retrieval of relevant data.

Unique identifier of the invoice associated with the invoice line, linking the line to its corresponding invoice.

Unique identifier used for insert, update, and delete operations, preferred over InvoicesInvoiceId when managing invoice lines.

Unique number assigned to each invoice line. It must be provided when creating the invoice line and cannot be updated once created.

Unique identifier for managing insert, update, and delete operations related to invoice lines, preferred over LineNumber.

The amount of the invoice line in the invoice currency. This value must be provided during invoice line creation.

The accounting date for the invoice line, which is used to default values in invoice distributions. It can be derived or manually entered.

Unit of measure for the quantity invoiced, such as 'kg', 'box', etc., indicating the quantity for the line item.

Name of the tax rate associated with the invoice line, defining the applicable tax rate.

Type of invoice line, such as 'Item', 'Freight', or 'Miscellaneous'. The type defines the nature of the line item.

Asset book associated with the invoice line, relevant for transferring the item to Oracle Fusion Assets.

Indicates whether the item should be tracked as an asset in Oracle Fusion Assets. Defaulted based on distribution settings.

Base amount for the invoice line before taxes and adjustments.

Description of the invoice line item, providing additional details about the line.

Region for reporting income tax on the invoice line, used for tax purposes, especially in 1099 reporting.

Inventory item identifier, corresponding to the item being invoiced.

Description of the inventory item associated with the invoice line.

Source of the invoice line, identifying how the line item is classified or categorized.

The quantity of items invoiced, including any price corrections, quantity corrections, or unmatched lines.

Accounting flexfield used for generating a distribution for the invoice line. This can be defaulted from supplier settings.

Category under which the asset line is grouped when transferring to Oracle Fusion Assets.

Price per unit of the good or service invoiced.

Indicates whether freight or miscellaneous charges should be prorated across all item lines. Default is false.

Indicates whether the invoice line is enabled for calculating and including landed cost.

Flag indicating whether the invoice line has been discarded and should no longer be considered.

Flag indicating whether the invoice line has been canceled.

Income tax type applicable to the supplier, such as 1099 tax classification for certain suppliers.

Tax rate code applied to the invoice line for tax calculation purposes.

Tax rate applied to the invoice line, indicating the percentage for tax calculation.

Tax classification code used to categorize the invoice line for tax purposes.

Indicates whether distributions should be generated for the invoice line during accounting.

Budgetary calendar period date applicable for funds checking.

Status of funds available for the invoice line, used in budget tracking.

Current approval status of the invoice line, indicating whether it is approved, pending, etc.

Distribution set used for generating distributions for the invoice line.

Name of the withholding tax group applied to the invoice line.

Code identifying the location where goods were shipped to for the invoice line.

Location where the goods or services were delivered, as specified for the invoice line.

Customer location associated with the invoice line delivery.

User-entered amount ensuring the calculated tax matches the physical document.

Deemed price at which the product is valued for tax calculation purposes.

Type of product, such as goods or services, determined by the inventory item attributes.

Taxable nature of a non-inventory item, used for tax calculation and reporting purposes.

Code path used to uniquely identify a product category for tax reporting.

Classification used for any tax requirements not defined by standard fiscal classification types.

User-entered code for a custom fiscal classification.

Tax driver used to determine applicable taxes for the invoice line.

Code identifying the intended use for tax purposes, used to help determine tax rates.

Tax classification used by tax authorities to categorize a product.

Code used to uniquely identify the product fiscal classification.

Type of product fiscal classification used for tax purposes.

Transaction category assigned to the invoice line for tax calculation.

Code path used to uniquely identify a transaction business category.

Name of the person who requested the goods or services, used in the invoice approval workflow.

Category used to group purchases for tax and reporting purposes.

Indicates the matching type used for the invoice line, such as Purchase Order Match.

Option used to control how the invoice line is matched, such as 2-way or 3-way matching.

Basis used to perform the match between the invoice line and purchase orders or receipts.

Purchase order number matched to the invoice line.

Purchase order line number matched to the invoice line.

Schedule line number from the purchase order matched to the invoice line.

Receipt number associated with the invoice line.

Receipt line number associated with the invoice line.

Consignment advice number associated with the invoice line.

Line number of the consignment advice matched to the invoice line.

Indicates whether this invoice line is the final match to a purchase order schedule, preventing further matching.

Start date for multiperiod accounting for the invoice line.

End date for multiperiod accounting for the invoice line.

Account used for accruals in multiperiod accounting.

User who created the invoice line.

Date when the invoice line was created.

Date when the invoice line was last updated.

User who last updated the invoice line.

Login session associated with the user who last updated the invoice line.

Unique identifier for the requester of the goods or services.

Prepayment number linked to the invoice line.

Prepayment line number associated with the invoice line.

Indicates whether the prepayment is included on the invoice.

Secondary reference key used to uniquely identify the invoice line.

Product table associated with the invoice line.

Global descriptive flexfield for additional attributes related to the invoice line.

Project descriptive flexfield used for managing project-specific invoice line data.

Used for managing distribution details of the invoice line.

Descriptive flexfield for user-defined attributes related to the invoice line.

Search term or identifier used to locate and retrieve specific invoice line records.

Unique identifier for the invoice related to the line item.

Reference number linking the child aggregates to parent tables.

Date parameter used to fetch resources that are effective as of the specified start date.

Unique identifier of the invoice associated with the invoice distribution, linking the distribution to the main invoice.

Unique identifier used for insert, update, and delete operations, preferred over InvoicesInvoiceId when managing invoice distributions.

Unique line number for the invoice, representing the invoice line to which the distribution is associated.

Unique identifier for managing insert, update, and delete operations related to invoice lines, preferred over InvoicelinesLineNumber.

Unique identifier for the invoice distribution record. It links the distribution to its associated invoice line.

Unique identifier for managing insert, update, and delete operations related to invoice distributions, preferred over InvoiceDistributionId.

Line number associated with the invoice distribution, identifying its sequence and relationship to the invoice.

Type of the distribution line, such as 'Item', 'Freight', or 'Miscellaneous', used to categorize the distribution.

Tax type associated with the supplier's 1099 classification. It can be used to determine the applicable tax type for the invoice distribution.

Current accounting status of the invoice distribution, indicating whether it has been processed for accounting.

Indicates the matching status of the invoice distribution, showing whether the distribution has been matched with related documents such as purchase orders.

Indicates whether the invoice distribution has passed validation and if all invoice holds have been released. The default value is 'Not Validated'.

Date when the invoice distribution is recorded in accounting. It can be provided during creation or populated from the invoice header.

The total amount of the invoice distribution, which must be provided during creation and represents the allocated value for that distribution.

Asset book associated with the invoice distribution, used for asset tracking in Oracle Fusion Assets.

The accounting flexfield used for the distribution's account. This can be provided manually or defaulted from the invoice line.

Indicates whether the invoice distribution is associated with an asset and should be tracked in Oracle Fusion Assets.

Base amount before tax and other adjustments for the invoice distribution.

Indicates whether the invoice distribution has been canceled. Default is false; set to true if the distribution has been canceled.

Description of the invoice distribution, providing details about the allocation or item represented by the distribution.

Tax reporting region for the invoice distribution, used for 1099 suppliers to determine the income tax region.

Indicates whether the invoice distribution is part of a reversal. Default is false; set to true for reversal entries.

Quantity of items invoiced for the distribution, matching the quantity invoiced for the related line.

Unit of measure for the invoiced quantity, such as 'kg', 'box', etc.

Price per unit of the invoiced items in the distribution.

Purchase order distribution line number matched to the invoice distribution.

Purchase order number associated with the invoice distribution.

Purchase order line number matched to the invoice distribution.

Purchase order schedule line number matched to the invoice distribution.

Receipt number associated with the invoice distribution, representing goods receipt for the invoice line.

Receipt line number associated with the invoice distribution.

Consignment advice number linked to the invoice distribution.

Line number of the consignment advice linked to the invoice distribution.

Line number associated with the item distribution, helping to link the distribution to specific items.

Indicates whether this invoice distribution is the final match for a purchase order, preventing further matches for that purchase order.

Start date for multiperiod accounting applied to the invoice distribution.

End date for multiperiod accounting applied to the invoice distribution.

Account used for accruals in multiperiod accounting, representing deferred expenses for the distribution.

Name of the tax regime applied to the invoice distribution, helping to classify the distribution for tax purposes.

Name of the tax applied to the invoice distribution, such as 'VAT', 'Sales Tax', etc.

Indicates whether the tax paid on the invoice distribution is recoverable, used for tax reporting and management.

The tax rate applied to the invoice distribution for the calculation of tax amount.

Name of the tax rate applied to the invoice distribution.

Type of tax applied to the invoice distribution, such as 'Sales Tax', 'Excise Tax', etc.

A tax driver used to determine applicable taxes for the distribution. Can be populated from the source document or entity setup.

Code that uniquely identifies the intended use for tax purposes in the invoice distribution.

User who created the invoice distribution.

Date when the invoice distribution was created.

User who last updated the invoice distribution.

Date when the invoice distribution was last updated.

Login session associated with the user who last updated the invoice distribution.

Prepayment number linked to the invoice distribution.

Prepayment line number linked to the invoice distribution.

Prepayment distribution line number linked to the invoice distribution.

Amount of the prepayment available to apply to the invoice distribution.

Charge identifier for the distribution line, used for managing charges applicable to the distribution.

Line number used for the allocation of the invoice distribution.

Line number for the allocation of the distribution in the system.

Budgetary date for funds check related to the invoice distribution.

Funds status for the invoice distribution, indicating whether funds are available for the distribution.

Search term or identifier used for locating invoice distribution records.

Unique identifier for the invoice associated with the distribution.

Reference number linking child aggregates to parent tables.

Date parameter used to fetch resources effective as of the specified start date.

The unique identifier of the credit memo transaction, used to link and reference the specific credit memo in the system.

The unique identifier of the credit memo. Use this value for insert, update, and delete operations, wherever applicable, instead of CustomerTransactionId.

The unique number assigned to the credit memo, used to track and identify the credit memo for financial processing.

The date when the credit memo was created or processed, serving as the reference date for accounting and payment activities.

The user who created the credit memo record, providing an audit trail for the creation process.

The date and time when the credit memo was created, which helps in tracking the timeline of credit memo entries.

The user who last updated the credit memo record, ensuring traceability of modifications.

The date and time when the credit memo was last updated, marking the latest modification.

The currency code representing the currency in which the credit memo was issued, essential for multi-currency transactions.

The business unit under which the credit memo is created. It defines the division within the organization that manages the transaction.

The type of transaction assigned to the credit memo, such as Refund, Adjustment, or Reversal, which classifies the purpose of the credit memo.

The source system or process that generated the credit memo, helping to track and categorize the origin of the transaction.

The accounting date for the credit memo, used for posting to financial ledgers and determining the relevant period for recognition.

The identifier of the legal entity under which the credit memo is created, distinguishing the entity for legal and tax purposes.

The reason provided for creating the credit memo, such as a pricing error, customer refund, or returned goods.

The account number of the bill-to customer, representing the customer who is being billed for the credit memo.

The site number of the bill-to customer, specifying the physical location or branch where the billing occurs.

The name of the bill-to customer, used for addressing the credit memo to the correct entity.

The amount of the credit memo in the entered currency, reflecting the financial value being credited.

The document sequence number assigned to the credit memo, serving as a unique reference for document tracking and filing.

A reference field from the transaction source used to track the original transaction or related documents for auditing purposes.

An additional reference document or code used by the customer to provide further context or details regarding the credit memo.

The date when the customer requested the credit memo, used to establish the timeline for customer interactions.

The balance-forward bill date, relevant if the credit memo applies to an ongoing billing cycle.

The purchase order number linked to the credit memo, allowing for reconciliation between purchase and payment records.

Any special instructions accompanying the credit memo, providing additional guidance for processing or customer service.

The user-provided comments detailing important notes about the credit memo, useful for internal reference or customer communication.

The country used for tax purposes related to the credit memo, determining the applicable tax jurisdiction.

The date when the items associated with the credit memo were shipped, used for freight and shipping reconciliations.

The shipping carrier responsible for transporting goods related to the credit memo.

The waybill reference number for the freight shipment, used to track the movement of goods.

The point of transfer for ownership of goods, indicating where the risk and responsibility shift from seller to buyer.

Defines the method of currency conversion used for the credit memo, such as Spot, Corporate, User, or Fixed, for multi-currency transactions.

The currency conversion rate applied to the credit memo transaction, converting it to the ledger currency.

The date used to determine the conversion rate for the credit memo transaction, ensuring accurate exchange rate usage.

The tax registration number of the company issuing the credit memo, used for tax reporting and compliance.

The tax registration number of the customer receiving the credit memo, necessary for tax reporting and compliance.

The name of the customer receiving the goods or services billed in the credit memo.

The account number of the customer receiving the goods or services in the credit memo.

The site number where the goods or services are shipped to the customer.

The amount of freight credited by the credit memo, typically related to shipping adjustments or refunds.

The number identifying the primary salesperson associated with the credit memo transaction.

Indicates whether the credit memo is part of an intercompany transaction, involving different entities within the same organization.

The outstanding balance on the credit memo that needs to be paid by the customer.

The method used to deliver the credit memo, such as E-Mail, Paper, or XML, for customer communication.

The status indicating whether the credit memo has been printed, for tracking physical document generation.

The date when the credit memo was printed, helping to confirm document dispatch timelines.

Indicates whether a bill should be generated for the credit memo, marking it for further processing in the billing system.

The tax classification of the credit memo, based on regulatory requirements for special documentation accompanying the transaction.

The name of the customer who is responsible for paying for the goods or services covered by the credit memo.

The site number of the customer making the payment for the credit memo.

The account number of the paying customer, who is responsible for paying the credit memo amount.

The contact details for the bill-to customer, used for correspondence regarding the credit memo.

The contact details for the ship-to customer, used for correspondence regarding shipping and delivery.

The unique number identifying the sold-to customer on the credit memo, used for internal tracking.

The date the associated purchase order was created, serving as a reference for the original transaction.

The current status of the credit memo, such as Complete, Incomplete, or Frozen, indicating its processing stage.

Internal user-defined notes related to the credit memo, typically for internal use or clarification.

The revision number associated with the purchase order, indicating any changes or updates to the original order.

An industry-standard reference used for linking credit memo transactions to payments and customer accounts.

Indicates whether the credit memo has been reviewed and is ready for completion. Valid value is 'Y' for allowed.

The reason provided for determining whether a transaction is allowed to complete, helping track the status of the transaction.

The email address of the customer or contact who receives notifications or printed versions of the credit memo.

A field used exclusively for inserting new records. For updates or deletes, child table operations should be used.

Field used exclusively for inserting new records. For updates or deletes, child table operations should be used.

This field is for inserting new records only. Use child table operations for updates or deletes.

This field is for insert-only operations. Use child table operations for updates or deletions.

This field is for insert-only operations. For updates or deletes, refer to child table operations.

This column is for insert-only use. For updates and deletions, child table operations should be used.

The date used for accounting purposes in credit memo transactions, ensuring the correct accounting period.

Indicates whether the credit memo transaction can be completed. Typically marked as 'Y' for allowed.

The identifier for the bill-to customer associated with the credit memo.

The account number of the bill-to customer for the credit memo.

The site number for the bill-to customer related to the credit memo.

The business unit associated with the credit memo, tracking which division is handling the transaction.

The currency used for the credit memo, important for multi-currency transactions.

The current status of the credit memo, indicating its processing stage.

A cross-reference number for tracking linked transactions or related documents.

The delivery method for the credit memo, such as E-Mail or Paper.

The document number assigned to the credit memo for tracking purposes.

Indicates whether the credit memo is part of an intercompany transaction, typically marked as 'Y' for intercompany.

The primary salesperson associated with the credit memo transaction.

Indicates whether the credit memo has been printed.

The purchase order number linked to the credit memo.

The name of the ship-to customer for the credit memo.

The site number of the ship-to customer for the credit memo.

The date when the credit memo transaction occurred.

The transaction number for the credit memo.

The source system that generated the credit memo transaction.

The type of the transaction, such as adjustment or refund, associated with the credit memo.

A reference key or search term used to find the credit memo record in the system.

The unique identifier for the invoice within the Receivables module. This ID is used to reference the specific transaction for accounting and reporting purposes.

A unique identifier assigned to the invoice that replaces CustomerTransactionId for insert, update, and delete operations. This field ensures consistency across transaction modifications.

The date on which the invoice installment is due to be paid by the customer. This date is important for determining payment deadlines and overdue statuses.

The date used for applying a specific conversion rate to convert the invoice currency to the ledger currency. This date may vary from the transaction date depending on the accounting requirements.

The exchange rate applied to convert the invoice's currency to the ledger currency. This rate ensures that financial data is accurately represented in the organization's reporting currency.

The code representing the currency in which the invoice was originally issued. This field ensures that transactions are tracked and reported in the correct currency.

Any specific instructions or notes provided with the invoice, often used for internal purposes or to convey important details to the customer.

A reference to the source document that generated this invoice. This could be a sales order or purchase order that links the invoice to the originating transaction.

A unique sequential number assigned to the invoice document. This is used for document identification, record-keeping, and integration with other systems.

A unique identifier assigned to each invoice transaction. This number is used for tracking and reconciling payments and receipts related to the invoice.

The date when the invoice was created. This date is crucial for accounting and reporting purposes, marking the start of the payment cycle.

The type of transaction that this invoice represents (for example, sale, refund, adjustment). This field categorizes the invoice for proper handling and accounting.

The source of the transaction that led to the creation of this invoice. It can help identify whether the invoice was generated from a manual entry or an automated process.

The account number of the customer being billed. This is used for customer identification and managing accounts receivable.

The unique identifier for the billing site of the customer. It helps in distinguishing different locations or divisions within a customer’s organization that receive billing.

User-defined comments attached to the invoice for providing additional context or instructions that may be relevant for processing or customer communication.

Notes intended for internal use only, often to provide details for staff members regarding invoice adjustments, exceptions, or special handling instructions.

The conditions under which payment is expected for this invoice, such as net 30, net 60, or due upon receipt. These terms define the time frame for the customer’s payment.

A unique identifier for the legal entity under which the invoice is generated. This helps to distinguish between different legal entities within the organization for compliance and tax reporting.

The categorization of conversion rates applied to the invoice, such as Spot, Corporate, User, or Fixed. This determines which exchange rate is used during the conversion process.

The purchase order number associated with this invoice. This links the invoice to the corresponding purchase order for the goods or services provided.

The date when the purchase order was issued. This date helps track the timeline from order to invoicing, ensuring proper alignment of accounting periods.

The revision number of the purchase order linked to the invoice. This is useful when changes are made to a purchase order after its initial creation.

The tax registration number of the deploying company. This is required for tax reporting and ensures the company’s compliance with tax regulations.

The tax registration number of the bill-to customer. This number is important for tax purposes and to verify the customer’s tax status.

The accounting rule applied to the invoice for revenue recognition, such as 'In Advance' or 'In Arrears'. This determines how and when revenue from the invoice is recognized.

The name of the customer receiving the goods or services. This may differ from the bill-to customer and is used to accurately track shipments and deliveries.

The unique registry identifier of the customer receiving the shipment. This identifier ensures proper tracking of the shipment within the customer’s account.

The date when the balance forward bill for the customer is generated. This is used for recurring billing scenarios where the invoice consolidates multiple charges over a period.

A unique identifier assigned to the bill-to customer. This is critical for associating the invoice with the correct customer account for payment processing.

The business unit under which the invoice is created. It helps in categorizing transactions by the part of the organization responsible for the transaction.

Indicates the current status of the invoice, such as 'Complete', 'Incomplete', or 'Frozen'. This is used for tracking the progress of the invoice through the approval and payment processes.

The date that is used for accounting purposes to recognize the revenue and expenses associated with the invoice. This may differ from the transaction date.

The unique identifier for the ship-to location of the customer. This helps in managing logistics and ensuring goods are shipped to the correct site.

The name of the customer responsible for paying the invoice. This may be different from the bill-to customer if payments are made by a third party.

The identifier for the site responsible for making payments on the invoice. This is useful for tracking payments when there are multiple payment locations for a customer.

The name of the customer being billed for the goods or services. This is typically the entity responsible for paying the invoice.

The amount charged for shipping and handling related to the invoice. This amount is added to the total invoice amount if applicable.

The name of the shipping carrier responsible for delivering the goods. This field helps track which logistics provider is used for shipment.

The date when the items listed on the invoice were shipped to the customer. This date is important for tracking delivery timelines and calculating due dates.

The reference number or waybill provided by the carrier for the shipment. This helps in tracking the shipment status and handling customer inquiries.

The contact details of the bill-to customer, such as the name, phone number, and email address. This is useful for communication regarding the invoice.

The contact details of the ship-to customer, which may differ from the bill-to contact. This ensures proper communication about shipments.

The option indicating whether the invoice should be printed. This field may include options like 'Print', 'Do Not Print', or 'Print on Demand'.

The user who initially created the invoice record in the system. This information is important for auditing and tracking user actions.

The date and time when the invoice record was created in the system. This is useful for tracking the creation timeline of invoices.

The user who last updated the invoice record. This is valuable for tracking changes and ensuring proper management of invoice data.

The date and time when the invoice record was last updated. It helps to monitor any modifications to the invoice after its creation.

The account number for the customer responsible for making payments on the invoice.

A unique identifier for the sold-to customer, typically used for customer management and invoicing purposes.

The address where payments for the invoice should be sent. This ensures that payments are directed to the correct location.

The country in which the invoice transaction takes place for tax purposes. This country determines the applicable tax rates and regulations.

The original amount of the invoice before any adjustments, taxes, or discounts are applied.

The remaining balance amount due on the invoice after partial payments or adjustments.

Indicates whether the invoice requires prepayment for goods and services. This can help manage upfront payment requirements before order fulfillment.

Identifies whether the invoice is part of an intercompany transaction, which typically involves transactions between different legal entities within the same organization.

The classification assigned to the invoice for tax purposes, required by tax authorities for documentation compliance.

The bank account number associated with the customer for payment purposes. This is useful for processing electronic payments.

The unique authorization request identifier for credit card payments, generated by the tokenization service to authorize the payment.

The expiration date of the credit card used for payment. This ensures the validity of the credit card when processing payments.

The code representing the credit card issuer, such as Visa, MasterCard, or American Express.

A token number generated by the tokenization service corresponding to the credit card used for payment. This enhances security and prevents fraud.

The voice authorization code provided by the tokenization service when a credit card payment is manually authorized via phone.

An error code that indicates why a credit card authorization failed, helping to diagnose issues during payment processing.

The error message associated with a failed credit card authorization, providing additional information about the failure.

The last name of the credit card holder, used for verification purposes when processing payments.

The first name of the credit card holder, used for verification purposes when processing payments.

The method by which the payment for the invoice is received, such as Credit Card, Bank Transfer, or Cash.

The identifier of the primary salesperson associated with the invoice. This is used for commission calculations and sales tracking.

A unique reference used to identify a payment transaction across systems, ensuring proper reconciliation and payment matching.

Indicates whether the invoice has been printed at least once, used for managing print statuses in billing operations.

The date when the invoice was last printed. This helps to track the history of printed invoices.

The date when the invoice was initially printed. This serves as the original print date for historical reference.

The method used to deliver printed invoices, such as email, paper, or portal upload. This determines how invoices are distributed to customers.

The email address of the bill-to customer who will receive the invoice if delivered electronically.

Indicates whether the invoice can be completed based on its review status. A value of 'Y' indicates that the transaction can be completed.

The reason for completing or finalizing the transaction, indicating why the invoice is ready for closure.

Used for inserting data into the invoice. For updates and deletions, the corresponding child table operations should be used.

Used for inserting invoice installment details. Updates and deletions should be handled through child table operations.

Used for inserting invoice distribution details. Updates and deletions are handled through child table operations.

A field used for inserting notes related to the invoice. For updates and deletions, child table operations should be used.

Used for inserting generalized data fields (GDF) related to the invoice. Updates and deletions are handled through child table operations.

Used for inserting invoice line item details. Updates and deletions are handled through child table operations.

Used for inserting transaction-specific DFF (Descriptive Flexfields) data. Updates and deletions are handled through child table operations.

A field used for searching specific invoice records within the database.

The tax registration number of the company issuing the invoice.

The tax registration number of the customer receiving the invoice.

The unique identifier of the standard receipt, used to reference and manage the receipt in the system.

The unique identifier for the standard receipt. This value should be used in insert, update, and delete operations, replacing StandardReceiptId where applicable.

The unique number assigned to the standard receipt, used for tracking and managing the receipt in the financial system.

A unit within the organization that performs specific business functions. Business units are used to classify receipts for reporting and management purposes.

The method of payment or receipt used, such as cash, check, or bank transfer.

The date when the standard receipt was created or processed.

The document sequence number associated with the standard receipt, used for document management and identification.

The total amount of the standard receipt in the receipt's currency.

The currency used for the standard receipt, reflecting the type of money in which the receipt is issued.

The type of conversion rate used for converting the receipt currency into the ledger's functional currency.

The date on which the conversion rate was applied to the receipt, typically aligned with the transaction date.

The specific conversion rate between the receipt's currency and the ledger's functional currency, used for financial reporting.

The state of the current payment entry progress, indicating the status of funds applied to the receipt. Valid states include APPLIED, UNAPPLIED, UNIDENTIFIED, INSUFFICIENT FUNDS, REVERSE PAYMENT, and STOP PAYMENT.

The current status of the entered payment, indicating the processing stage. Valid statuses include CONFIRMED, CLEARED, APPROVED, and REMITTED.

The name of the bank used for remitting funds related to the standard receipt.

The name of the specific bank branch handling the remittance for the standard receipt.

The account number at the remittance bank where the funds for the standard receipt are deposited.

The date when the funds for the standard receipt were deposited by the remittance bank.

An option that allows for overriding the remittance account used during the receipt process.

The name of the customer associated with the standard receipt, typically reflecting the payer or the entity receiving the receipt.

The Tax Indentification Number (TIN) of the customer associated with the standard receipt, used for tax reporting and identification.

The customer site associated with the receipt, indicating the physical or legal address associated with the transaction.

The account number of the customer within the receivables system, used for account tracking and reconciliation.

The name of the bank where the customer holds their account, used for financial transactions related to the receipt.

The specific branch of the bank where the customer holds their account, used for detailed banking operations.

The bank account number held by the customer, which is linked to the standard receipt for payment processing.

The portion of the receipt that has not yet been applied to any transactions or balances in the system.

The portion of the receipt that has been accounted for in the ledger currency, used for financial reporting.

The date when the standard receipt is accounted in the financial records.

The date when the standard receipt reaches maturity and payment is expected or due.

The date when the receipt was postmarked, typically used for cash receipt processing or deposit timing.

Indicates whether the receipt is at risk with the remittance bank, typically referring to issues like a potential reversal or a stop payment.

The specialist within the receivables department responsible for managing and overseeing the standard receipt.

User-defined comments providing additional context or information about the receipt.

The token number generated by a tokenization service provider to securely represent a credit card number used for the standard receipt.

The identifier associated with the credit card authorization request used to verify the transaction.

The first name of the credit card holder who is associated with the standard receipt.

The last name of the credit card holder associated with the standard receipt.

The code representing the credit card issuer, such as Visa, MasterCard, or American Express.

The expiration date of the credit card used for the payment of the standard receipt.

The voice authorization code provided by the tokenization service for phone-based credit card authorization.

The category of the reversal, if the standard receipt is reversed, indicating the reason for the reversal.

The reason for reversing the standard receipt, used for tracking and reporting purposes.

The date when the standard receipt was reversed, if applicable.

Comments associated with the reversal of the standard receipt, used to document the reason for reversal.

The name of the batch to which the standard receipt belongs, typically used for organizing and processing multiple receipts together.

The date when the receipt batch was processed, used for tracking the timing of grouped receipt entries.

A standardized reference code used to identify the transaction and its payments between the customer and the bank.

The user who created the standard receipt record, used for auditing and tracking purposes.

The date and time when the standard receipt record was created in the system.

The date and time when the standard receipt record was last updated in the system.

The user who last updated the standard receipt record, used for auditing and tracking purposes.

This field is used for insert operations and should not be used for update or delete actions directly. Refer to the child table for these operations.

This field is used for insert operations only. For updates and deletions, refer to the child table's operations.

This field is used for insert operations only. For updates and deletions, refer to the child table's operations.

A generic identifier used for finding the standard receipt in queries or searches.

The code that defines the party type (for example, 'Supplier',' Customer') for the tax profile.

The name of the party (company or individual) associated with the tax profile.

The unique identifier for the party to which the tax registration belongs.

The site number associated with the party's tax registration.

The code representing the tax regime under which the registration is issued, such as VAT.

The tax code applicable to the tax registration for the party.

The code indicating the tax jurisdiction (location) where the tax registration is valid.

Specifies the basis of the tax point (for example, delivery-based or invoice-based) for tax reporting.

The type of tax registration, such as VAT or Sales Tax, that is associated with the party.

The status of the tax registration, indicating whether it is active, pending, etc.

The name of the party representing the taxpayer in the registration.

The reason for obtaining the tax registration, such as starting business operations.

The date from which the tax registration is valid.

The date until which the tax registration is valid.

The registered address associated with the tax registration.

The type of validation used for ensuring the correctness of the tax registration.

The level of validation applied to prevent duplicate tax registration numbers (for example, ERROR, WARNING).

The code for the specific validation rule applied to tax registration numbers.

The unique tax registration number assigned by the tax authority.

The source code indicating where the tax registration originates from.

The tax authority responsible for issuing the tax registration.

Indicates whether this is the default registration for the party. The default is FALSE.

The rounding rule applied to tax calculations for this registration. Defines how rounding is performed (for example, round up, round down).

Indicates whether the tax registration includes tax in its calculations (default is FALSE).

The bank account number associated with the tax registration.

The tax classification code relevant to this tax registration.

The validation level applied to ensure no duplicate tax registration numbers are used.

The country where the tax registration is applicable.

The country code used to identify the tax registration jurisdiction.

The unique identifier for the bank branch associated with the tax registration.

The unique identifier for the bank where the party's tax-related transactions are managed.

The unique identifier for the collecting tax authority associated with the registration.

The unique identifier for the legal location tied to the tax registration.

The unique identifier for the tax profile associated with the party.

Defines the level of rounding applied to tax amounts during calculations, such as HEADER or LINE.

The unique identifier of the tax authority managing the tax registration.

The system-generated identifier for the tax registration record.

A unique identifier to be used for insert, update, and delete operations, instead of RegistrationId.

Indicates whether the party tax profile allows offset tax calculations. Default is FALSE.

Specifies the rounding level for taxes in the party's tax profile.

Indicates whether the party's tax profile supports inclusive tax calculations. Default is FALSE.

The classification code for tax purposes associated with the party's tax profile.

The rounding rule code associated with the party's tax profile.

Indicates whether the party tax profile is applied during the tax determination process.

The code used to validate the tax registration number for the party.

A helper field for searching or filtering tax registration records.