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.

Expand all

Collapse all

Business Views

** Available for extracting data

• balanceForwardBillsExtract**

  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.

  Label, Plural Label

  Balance Forward Bills, Balance Forward Bills

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • billLevel (string)

    The option in the customer profile that indicates whether balance forward billing is enabled at the account level or site level.

    Label

    Bill Level

  • billTemplateName (string)

    The print template used to print balance forward bills and to preview balance forward bills online. Valid values are Balance Forward Bill Summary and Balance Forward Bill Details.

    Label

    Bill Template Name

  • billingDate (date)

    The billing date of the balance forward bill.

    Label

    Billing Date

  • billingNumber (string)

    The balance forward billing number assigned to the balance forward bill and transactions included in the bill.

    Label

    Billing Number

    Properties

    • not nullable
  • consolidatedInvoiceId (int64)

    The identifier of the balance forward bill.

    Label

    Consolidated Invoice ID

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • cutoffDate (date)

    The cutoff date for transactions to include in the balance forward bill.

    Label

    Cutoff Date

  • dueDate (date)

    The balance forward bill due date, as determined by the billing cycle.

    Label

    Due Date

  • endingBalance (big-decimal)

    The ending balance of the balance forward bill.

    Label

    Ending Balance

  • lastBillingDate (date)

    The previous billing date of the balance forward bill.

    Label

    Last Billing Date

  • lastChargeDate (date)

    The last date of the calculation period for late charges on the balance forward bill.

    Label

    Late Charge Date

  • openingBalance (big-decimal)

    Either the beginning balance or the balance carried over from the last billing period of the balance forward bill.

    Label

    Opening Balance

  • startDate (date)

    The billing period start date on the balance forward bill.

    Label

    Billing Cycle Start Date

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

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

    The sum of all adjustments on the balance forward bill.

  • totalCreditsAmount (big-decimal)

    The sum of all credits on the balance forward bill.

  • totalFinanceChargesAmount (big-decimal)

    The sum of all late charges on the balance forward bill.

  • totalReceiptsAmount (big-decimal)

    The sum of all receipts on the balance forward bill.

  • totalTaxAmount (big-decimal)

    The total tax amount on the balance forward bill.

  • totalTransactionAmount (big-decimal)

    The sum of all transactions on the balance forward bill.

  • unpaidReason (string)

    The reason why the balance forward bill isn't paid.

    Label

    Unpaid Reason

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

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

  • billType (ERPLookupCode)

    The balance forward bill type assigned to the customer account or site profile. A list of accepted values is defined in the AR_BPA_TM_TMPLT_FORMAT lookup type.

    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

  • 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

  • consolidatedBillingCycle (ReceivablesInvoiceBillingCycle)

    This provides the details of the Receivables Invoice Consolidated Billing Cycle that manages time-based criteria for combining eligible charge lines from multiple sources into invoices within the Receivables system.

    Business Object

    ReceivablesInvoiceBillingCycle

    Expand all

    Collapse all

    Fields

    • consolidatedBillingCycleId (int64)

      Billing cycle identifier used for consolidation.

      Label

      Consolidated Billing Cycle ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • remitToAddressRule (ReceivablesRemitToAddressRule)

    The Receivables Remit-to Address Rule business object provides the details of the assignment of a remit-to address to customer bill-to sites in a country or specific parts of a country.

    Business Object

    ReceivablesRemitToAddressRule

    Expand all

    Collapse all

    Fields

    • addressSequenceId (int64)

      The sequence identifier of the remit-to address.

      Label

      Address Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • status (ERPLookupCode)

    The print status of the balance forward bill. Valid values are: Pending and Printed.

    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