CustomerStatementDelivery

The Customer Statement Delivery provides all the necessary details for delivering customer statements via email, including delivery method, recipient email addresses, and email content metadata, facilitating automated and auditable statement distribution in Oracle Fusion Receivables

Expand all

Collapse all

Business Views

** Available for extracting data

• customerStatementDeliveriesExtract**

  The Customer Statement Delivery provides all the necessary details for delivering customer statements via email, including delivery method, recipient email addresses, and email content metadata, facilitating automated and auditable statement distribution in Oracle Fusion Receivables

  Label, Plural Label

  Statement Deliveries, Statement Deliveries

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • contactEmailAddress (string)

    The email address of the customer bill-to contact who receives printed transactions.

    Label

    Contact Email Address

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • emailBody (string)

    The default text to use in the body of the email that accompanies the delivery of transactions using email.

    Label

    Email Body

  • emailSubject (string)

    The default text to use in the subject line of the email that accompanies the delivery of transactions using email.

    Label

    Email Subject

  • fromEmailAddress (string)

    The email address that sends transactions to customers using email.

    Label

    From Email Address

  • fromEmailName (string)

    The user name that sends statements to customers using email.

    Label

    From Email Name

  • replyToEmailAddress (string)

    The reply-to email address for customers to use that receive transactions using email.

    Label

    Reply-to Email Address

  • statementDeliveryId (int64)

    Identifier of the printed statement delivery details.

    Label

    Statement Delivery ID

    Properties

    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • customerAccountSite (CustomerAccountSite)

    The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.

    Business Object

    CustomerAccountSite

    Expand all

    Collapse all

    Fields

    • customerAccountSiteId (int64)

      Identifier of the customer account site.

      Label

      Customer Account Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • deliveryMethod (ERPLookupCode)

    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

Back to Top