Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublinesbillingPlans

Tracks the billing plans linked to sales orders, including schedule and payment terms.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the billing plan to the parent order and enabling tracking of the billing details across all order lines.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line related to the order, helping to associate the billing plan with the specific line item being billed.
BillingNumberOfPeriods Int Number of billing periods in a recurring invoice, representing how many timeframes the billing plan spans across for the recurring charges.
BillingPeriodEndDate Date End date of the billing period, marking the conclusion of the billing timeframe. The application sets this to the contract's end date for the first period, adjusting it for subsequent periods if necessary.
BillingPeriodNumber Int Timeframe number representing a specific billing period, helping to track and sequence billing timeframes in a recurring billing cycle.
BillingPeriodStartDate Date Start date of the billing period, marking the beginning of the billing timeframe. For the first period, this is set to the contract's start date, and adjusted for subsequent periods if applicable.
BillingPlanId [KEY] Long Unique identifier for the billing plan, used to associate a sales order line with a specific recurring billing or milestone plan.
BillingPlanTypeCode String Code that identifies the type of billing plan, such as periodic (for recurring billing) or milestone-based (for specific payment events tied to the contract).
BillingPlanType String Name describing the type of billing plan, providing context for how the billing is structured (for example, monthly, milestone-based).
BillingTransactionDate Date Date when the first invoice for the billing plan occurs, used to mark the start of the recurring billing cycle or identify the date for the next invoice.
CancellationEffectiveDate Date Date when recurring billing is canceled, marking when no further billing occurs for the plan, and indicating the end of the customer’s commitment.
NetBillingAmountForEachPeriod Decimal Net amount billed for each billing period, representing the charge for the specific timeframe in the billing plan.
OverridePeriod Int Billing period that includes an override amount, typically used to adjust the amount or quantity for a particular billing period.
OverridePeriodAmount Decimal Amount applied as an override for a specific billing period, used to adjust or modify the normal billing amount for that period.
OverridePeriodQuantity Decimal Quantity to apply for calculating the recurring billing or credit for the overridden period, affecting the total billable amount.
PeriodicityCode String Code representing the frequency of the recurring billing, such as Day, Week, Month, Quarter, or Year.
Periodicity String Name of the frequency of the recurring invoice, providing a clearer description of how often the billing occurs (for example, monthly, annually).
SourceBillingPlanId String Unique identifier for the billing plan assigned by the source application, linking the sales order line to an external billing system for tracking.
Finder String Tool or method used to search and locate the billing plan details within the system, facilitating easy retrieval and management of billing information.
FromDate Date Start date from which the billing plan is valid, marking the beginning of the billing cycle or period for the order line.
HeaderId Long Unique identifier for the order header related to the billing plan, helping to associate the billing plan with the parent order.
OrderKey String Key used to uniquely identify the order line associated with the billing plan, ensuring accurate tracking of billing details for specific items.
OrderNumber String Order number assigned to the sales order, used to track and manage the order across various stages in the fulfillment and billing process.
SourceTransactionNumber String Transaction number from the source system, used to link the billing plan to its originating transaction in the external system.
SourceTransactionSystem String Name of the source transaction system, providing context for where the billing plan originated and ensuring proper integration with external systems.
ToDate Date End date until which the billing plan is valid, marking when the billing plan ends or when the final recurring charge is applied.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175