DelinquentCustomer

The delinquent customer business object provides the delinquency summary information of all delinquent customers, accounts, or sites. This information is used by collector or collections agents to assess the status of accounts and to prioritize actions that may need to be taken to resolve the debt.

Expand all

Collapse all

Business Views

** Available for extracting data

• delinquentCustomersExtract**

  The delinquent customer business object provides the delinquency summary information of all delinquent customers, accounts, or sites. This information is used by collector or collections agents to assess the status of accounts and to prioritize actions that may need to be taken to resolve the debt.

  Label, Plural Label

  Delinquent Customers, Delinquent Customers

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountNumber (string)

    The account number of the bill-to customer assigned to the invoice.

    Label

    Account Number

  • agingBucketFive (big-decimal)

    The unpaid amount in the fifth aging bucket of a 7- bucket aging report.

    Label

    Aging Bucket 5

  • agingBucketFour (big-decimal)

    The unpaid amount in the fourth aging bucket of a 7 - bucket aging report.

    Label

    Aging Bucket 4

  • agingBucketOne (big-decimal)

    The unpaid amount in the first aging bucket of a 7 - bucket aging report.

    Label

    Aging Bucket 1

  • agingBucketSeven (big-decimal)

    The unpaid amount in the seventh aging bucket of a 7- bucket aging report.

    Label

    Aging Bucket 7

  • agingBucketSix (big-decimal)

    The unpaid amount in the sixth aging bucket of a 7- bucket aging report.

    Label

    Aging Bucket 6

  • agingBucketThree (big-decimal)

    The unpaid amount in the third aging bucket of a 7 - bucket aging report.

    Label

    Aging Bucket 3

  • agingBucketTwo (big-decimal)

    The unpaid amount in the second aging bucket of a 7 - bucket aging report.

    Label

    Aging Bucket 2

  • businessLevel (string)

    The business level at which the delinquency is calculated. A list of accepted values is defined in the IEX_BUSINESS_LEVEL lookup type.

    Label

    Business Level

  • collectorName (string)

    Name of the collector assigned to the delinquency.

    Label

    Collector Name

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • currency (string)

    Currency code of the country of customer.

    Label

    Currency

    Properties

    • not nullable
  • customerDisplayName (string)

    The customer name, account, or site associated with this record.

    Label

    Customer Display Name

  • customerName (string)

    Name of the customer.

    Label

    Customer Name

  • customerNumber (string)

    Customer number.

    Label

    Customer Number

  • delinquencies (int64)

    Total number of delinquencies per customer.

    Label

    Delinquencies

  • delinquencySummaryId (int64)

    Unique identifier of the delinquency summary.

    Label

    Delinquency Summary ID

    Properties

    • searchable
    • sortable
    • not nullable
  • disputedInvoiceAmount (big-decimal)

    Disputed invoice amount related to the delinquency.

    Label

    Disputed Invoice Count

  • disputedInvoiceCount (big-decimal)

    Count of the disputed invoices related to the delinquency.

    Label

    Disputed Invoice Amount

  • firstDueDate (date)

    Oldest unpaid due date for the customer.

    Label

    First Due Date

  • lastPaidDate (date)

    Last payment date for customer.

    Label

    Last Paid Date

  • newlyDelinquentCustomerFlag (boolean)

    Indicates if newly delinquent customer. Valid values are Y and N.

    Label

    Newly Delinquent Customer

  • openChargebackAmount (big-decimal)

    Chargeback amount related to the delinquency record.

    Label

    Open Chargeback Amount

  • openChargebackCount (int64)

    Count of the chargebacks related to the delinquency.

    Label

    Open Chargeback Count

  • openCreditMemoAmount (big-decimal)

    Credit memo amount related to the delinquency record.

    Label

    Open Credit Memo Count

  • openCreditMemoCount (big-decimal)

    Count of the credit memos related to the delinquency.

    Label

    Open Credit Memo Amount

  • openDebitMemoAmount (big-decimal)

    Debit memo amount related to the delinquency record.

    Label

    Open Debit Memo Amount

  • openDebitMemoCount (int64)

    Count of the debit memos related to the delinquency.

    Label

    Open Debit Memo Count

  • openInvoiceAmount (big-decimal)

    Invoice amount related to the delinquency record.

    Label

    Open Invoice Amount

  • openInvoiceCount (int64)

    Count of the invoices related to the delinquency.

    Label

    Open Invoice Count

  • score (big-decimal)

    Score value for customer.

    Label

    Score

  • site (string)

    Location of the delinquent customer.

    Label

    Site

  • 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
  • totalAmountDue (big-decimal)

    The total amount due for the customer, account or site.

    Label

    Total Amount Due

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • workStatus (string)

    The type of status related to the delinquency.

    Label

    Work Status

  • workStatusDate (date)

    Date on which the status was created or updated.

    Label

    Work Status Date

  Expand all

  Collapse all

  Reference Object

  • agingBucket (CollectionsAgingBucket)

    The collections aging bucket provides periods within which all customer transactions will be classified, such as 7 buckets aging definition and 4 buckets aging definition.

    Business Object

    CollectionsAgingBucket

    Expand all

    Collapse all

    Fields

    • agingBucketId (int64)

      Identifier for the aging bucket method.

      Label

      Aging Bucket 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

  • collector (Party)

    A collector represents the functionality and details related to a customer's collector responsible for collecting past due amounts from customers and sending dunning letters. The details include the collector's name, reference set, type, employee, and inactive date.

    Business Object

    Party

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • searchable
      • sortable
      • not nullable
      • overridable

  • contact (Party)

    A collector represents the functionality and details related to a customer's collector responsible for collecting past due amounts from customers and sending dunning letters. The details include the collector's name, reference set, type, employee, and inactive date.

    Business Object

    Party

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • searchable
      • sortable
      • not nullable
      • overridable

  • customer (Party)

    The Customer party represents an entity (either an individual or an organization) that purchases goods or services and to whom invoices and payment requests are issued.

    Business Object

    Party

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • searchable
      • sortable
      • not nullable
      • overridable

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccountSiteBusinessPurpose (CustomerAccountSitePurpose)

    The Customer Account Site Business Purpose business object provides the details of the business purposes assigned to customer account sites, for example Bill-to, Ship-to, and Statements. Each customer account site can have one or more business purposes.

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • predelinquentStrategy (CustomerCollectionsStrategy)

    The customer collections strategy configuration used when running strategy management for collection based on a score and contains work items.

    Business Object

    CustomerCollectionsStrategy

    Expand all

    Collapse all

    Fields

    • strategyId (int64)

      Unique identifier of the strategy.

      Label

      Strategy ID

      Properties

      • searchable
      • sortable
      • not nullable

  • strategy (CustomerCollectionsStrategy)

    The customer collections strategy configuration used when running strategy management for collection based on a score and contains work items.

    Business Object

    CustomerCollectionsStrategy

    Expand all

    Collapse all

    Fields

    • strategyId (int64)

      Unique identifier of the strategy.

      Label

      Strategy ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top