CustomerCorrespondenceTransaction

The customer correspondence provides the details of document sent to a customer, such as a dunning letter and invoice copy.

Expand all

Collapse all

Business Views

** Available for extracting data

• customerCorrespondenceTransactionsExtract**

  The customer correspondence provides the details of document sent to a customer, such as a dunning letter and invoice copy.

  Label, Plural Label

  Customer Correspondence Transactions, Customer Correspondence Transactions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • dunningTransactionId (int64)

    Identifier of the dunning transaction.

    Label

    Dunning Transaction ID

    Properties

    • searchable
    • sortable
    • not nullable
  • stageNumber (int32)

    The number of the stage of this payment schedule in the dunning. Mutually exclusive attribute with column AGING_BUCKET_LINE_ID.

    Label

    Stage Number

    Properties

    • searchable
  • 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
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • customerTransaction (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

  • dunning (CustomerCorrespondence)

    The customer correspondence transaction provides the transaction details of dunning.

    Business Object

    CustomerCorrespondence

    Expand all

    Collapse all

    Fields

    • dunningId (int64)

      Unique identifier of the dunning.

      Label

      Dunning 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

Back to Top