ReceivablesAdjustment

An adjustment refers to any modification made to the accounts receivable balance of an organization. It provides information related to adjustments such as adjustment number, adjustment date, receivables activity, accounting date, installment number, installment balance, and adjustment status. The adjustment information is used to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. If an adjustment is created with a receipt, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the receipt ID when the adjustment is created against the invoice, debit memo, or chargeback.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesAdjustmentsExtract**

  An adjustment refers to any modification made to the accounts receivable balance of an organization. It provides information related to adjustments such as adjustment number, adjustment date, receivables activity, accounting date, installment number, installment balance, and adjustment status. The adjustment information is used to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. If an adjustment is created with a receipt, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the receipt ID when the adjustment is created against the invoice, debit memo, or chargeback.

  Label, Plural Label

  Receivables Adjustments, Receivables Adjustments

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedAmount (big-decimal)

    The accounted amount of the adjustment in the ledger currency.

    Label

    Accounted Amount

    Properties

    • not nullable
  • accountingDate (date)

    The adjustment accounting date.

    Label

    Accounting Date

    Properties

    • not nullable
  • adjustmentAmount (big-decimal)

    The adjustment amount.

    Label

    Adjustment Amount

    Properties

    • not nullable
  • adjustmentCreationType (enumeration: AdjustmentCreationType)

    The lookup codes for the AR_LOOKUPS adjustment creation type. Valid values are: CHARGES, FREIGHT, INVOICE, LINE and TAX.

    Label

    Adjustment Creation Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AdjustmentCreationType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • A
    • C
    • E
    • M
    • X
  • adjustmentDate (date)

    The date the adjustment was applied to the installment.

    Label

    Adjustment Date

  • adjustmentId (int64)

    The identifier of the adjustment.

    Label

    Adjustment ID

    Properties

    • searchable
    • sortable
    • not nullable
  • adjustmentTaxAccountingRuleCode (string)

    The numeric code that identifies the tax accounting rule used to create the accounting for the adjustment.

    Label

    Adjustment Tax Account Rule

  • approvedBy (string)

    The identifier of the user who approved the adjustment.

    Label

    Approved By

  • comments (string)

    The user-entered comments about the adjustment.

    Label

    Comments

  • createdBy (string)

    The user who created the adjustment.

    Label

    Created By

    Properties

    • not nullable
  • createdFrom (string)

    The name of the process that created the adjustment.

    Label

    Created From

    Properties

    • not nullable
  • documentNumber (int64)

    The document sequence number assigned to the adjustment.

    Label

    Document Number

  • freightAdjusted (big-decimal)

    The freight amount adjusted as part of the adjustment.

    Label

    Freight Adjusted

  • lineAdjustedAmount (big-decimal)

    The line amount adjusted as part of the adjustment.

    Label

    Line Adjusted Amount

  • multipleReportingCurrencyAccountedAmount (string)
  • nonrecoverableLineAmount (big-decimal)

    The nonrecoverable adjustment amount on the transaction line.

    Label

    Nonrecoverable Line Amount

  • nonrecoverableTaxAmount (big-decimal)

    The nonrecoverable tax amount of the adjustment.

    Label

    Nonrecoverable Tax Amount

  • number (string)

    The number of the adjustment automatically generated from AR_ADJUSTMENT_NUMBER_S.

    Label

    Number

    Properties

    • not nullable
  • postable (enumeration: PostableIndicator)

    The option that indicates whether the adjustment is postable. Valid values are: Y - postable, Null - not postable.

    Label

    Postable

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: PostableIndicator

    Valid Values

    • N
    • Y
  • postedDate (date)

    The date the adjustment was posted to General Ledger.

    Label

    Posted Date

  • postedFlag (boolean)

    Indicates whether the record is posted to General Ledger. If true, then the record is posted to General Ledger. If false, then the record isn't posted.

    Label

    Posted

    Properties

    • searchable
  • reason (string)

    The code that indicates the reason for the adjustment.

    Label

    Reason

  • receivablesChargesAdjusted (big-decimal)

    The adjustment charges associated with the adjustment.

    Label

    Receivables Charges Adjusted

  • taxAdjusted (big-decimal)

    The adjusted tax amount of the adjustment.

    Label

    Tax Adjusted

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • type (enumeration: AdjustmentType)

    The name of the adjustment lookup type under AR_LOOKUPS.

    Label

    Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AdjustmentType

    Properties

    • not nullable

    Valid Values

    • CHARGES
    • FREIGHT
    • INVOICE
    • LINE
    • TAX
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • ussglTransactionCode (string)

    The value of the USSGL Transaction Code flexfield.

    Label

    USSGL Transaction Code

  • ussglTransactionCodeContext (string)

    The context value of the USSGL Transaction Code flexfield.

    Label

    USSGL Transaction Code Context

  Expand all

  Collapse all

  Reference Object

  • account (GeneralLedgerAccount)

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • chartOfAccountsId (string)

      The unique identifier of the chart of accounts.

      Label

      Chart of Accounts

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable
    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • activity (ReceivablesActivity)

    A receivables activity represents various transactions and events that occur within the accounts receivables of a business. This activity encompasses a wide range of actions related to managing and processing receivables. The receivables activity includes details such as business unit, name, description, activity type, active option, GL account source, tax rate code source, and distribution set for miscellaneous receipts. Receivables activities provide default accounting information for all activities in Receivables other than transactions and receipts. The receivables activity types are Adjustment, Bank Error, Bills Receivable Funds Recovery, Credit Card Chargeback, Credit Card Refund, Earned Discount, Late Charges, Miscellaneous Cash, Payment Netting, Prepayments, Receipt Write-offs, Refund, Short Term Debt, and Unearned Discount.

    Business Object

    ReceivablesActivity

    Expand all

    Collapse all

    Fields

    • businessUnitId (int64)

      The identifier of the business unit associated with the receivables activity.

      Label

      Business Unit ID

      Properties

      • searchable
      • sortable
      • not nullable
    • receivablesTransactionId (int64)

      The identifier of the receivables activity.

      Label

      Receivables Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • cashReceipt (ReceivablesReceipt)

    Business Object

    ReceivablesReceipt

    Expand all

    Collapse all

    Fields

    • cashReceiptId (int64)

      The identifier of the cash receipt.

      Label

      Cash Receipt ID

      Properties

      • searchable
      • sortable
      • not nullable

  • chargeback (ReceivablesTransaction)

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • consolidatedInvoice (BalanceForwardBill)

    The balance forward bill contains information about balance forward bills, including bill number, bill-to customer number, customer site, bill-from, bill-to, billing date, due date, currency, amount due, beginning balance, ending balance, payment terms, payments, adjustments, credits, current charges, tax, and late charges. Balance forward bills are generated by the Generate Balance Forward Bill process. The balance forward bill contains all transactions created within the period specified by the balance forward billing cycle.

    Business Object

    BalanceForwardBill

    Expand all

    Collapse all

    Fields

    • consolidatedInvoiceId (int64)

      The identifier of the balance forward bill.

      Label

      Consolidated Invoice ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerTransaction (ReceivablesTransaction)

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • distributionSet (ReceivablesDistributionSet)

    Business Object

    ReceivablesDistributionSet

    Expand all

    Collapse all

    Fields

    • distributionSetId (int64)

      The identifier of the distribution set.

      Label

      Distribution Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentSequence (DocumentSequence)

    A document sequence is a unique number assigned to documents and is useful in tracking the transactions.

    Business Object

    DocumentSequence

    Expand all

    Collapse all

    Fields

    • docSequenceId (int64)

      The unique identifier of the document sequence.

      Label

      Document Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • lateCharge (ReceivablesLateCharge)

    The Receivables Late Charge business object provides the details of the late charges assigned to a transaction.

    Business Object

    ReceivablesLateCharge

    Expand all

    Collapse all

    Fields

    • interestHeaderId (int64)

      The identifier of the interest header. This is a primary key of the Interest Header view object.

      Label

      Interest Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • lateChargeLine (ReceivablesLateChargeLine)

    The Receivables Late Charge Line business object provides the details of the late charge calculations on each transaction line.

    Business Object

    ReceivablesLateChargeLine

    Expand all

    Collapse all

    Fields

    • interestLineId (int64)

      The identifier of the late charge interest line. This is a primary key of the Late Charge Interest Line view object.

      Label

      Interest Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentSchedule (ReceivablesTransactionPaymentSchedule)

    A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

    Business Object

    ReceivablesTransactionPaymentSchedule

    Expand all

    Collapse all

    Fields

    • paymentScheduleId (int64)

      The identifier of the payment schedule.

      Label

      Payment Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptActivity (ReceivablesReceiptActivity)

    The Receivables Receipt Activity provides the details of the accounting entries for both the cash and credit memo applications, which includes the amount applied, status and related details. Cash applications represent cash receipt applications. If the cash receipt isn't confirmed, applications of that receipt aren't reflected in the payment schedule of the transaction the receipt is applied against.

    Business Object

    ReceivablesReceiptActivity

    Expand all

    Collapse all

    Fields

    • receivableApplicationId (int64)

      The identifier of the receipt application to the transaction.

      Label

      Receivable Application ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • receiptBatch (ReceivablesManualReceiptBatch)

    Business Object

    ReceivablesManualReceiptBatch

    Expand all

    Collapse all

    Fields

    • batchId (int64)

      The identifier of the receipt batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable

  • statusLookupType (ERPLookupCode)

    The approval status of the adjustment. Valid values are: A - Approved, U - Unaccrued adjustments, R - Rejected, and any other codes for unapproved.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • subledgerAccountingEvent (SubledgerAccountingEvent)

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • applicationId (int64)

      The unique identifier of the source application that represents a functional area.

      Label

      Application

      Properties

      • searchable
      • sortable
      • not nullable
    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • subsequentTransaction (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionHistory (BillsReceivableTransactionHistory)

    The Bills Receivable Transaction History business object provides the details of each bills receivable transaction, including activities and the life cycle of bills receivable events.

    Business Object

    BillsReceivableTransactionHistory

    Expand all

    Collapse all

    Fields

    • transactionHistoryId (int64)

      The identifier of the transaction history for a bill receivable.

      Label

      Bills Receivable Transaction History Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionLine (ReceivablesTransactionLine)

    A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

    Business Object

    ReceivablesTransactionLine

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the Receivable transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top