Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9060

SalesOrdersForOrderHublinesbillingPlans

The Billing Plans resource manages the billing plan for the sales order.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublinesbillingPlans
LinesFulfillLineId [KEY] Long LinesFulfillLineId of SalesOrdersForOrderHublinesbillingPlans
BillingNumberOfPeriods Int Number of timeframes in a recurring invoice.
BillingPeriodEndDate Date End date of the billing timeframe. The application sets this date to the contract end date of the first billing timeframe. If the invoice does not cover the full billing timeframe, then the application sets the end date to the billing end date of the subsequent billing timeframe.
BillingPeriodNumber Int Timeframe number for the billing start date, end date, or transaction date.
BillingPeriodStartDate Date Start date of the billing timeframe. The application sets this date to the contract start date of the first billing timeframe. If the invoice does not cover the full billing timeframe, then the application sets the start date to the billing start date of the subsequent billing timeframe.
BillingPlanId [KEY] Long Value that uniquely identifies the billing plan.
BillingPlanTypeCode String Abbreviation that identifies the type of billing plan, such as periodic or milestone.
BillingPlanType String Name of the billing plan type.
BillingTransactionDate Date Date when the first invoice occurs when the sales order uses a recurring invoice. If the invoice covers only part of an invoice timeframe, then this attribute stores the date of the subsequent invoice.
CancellationEffectiveDate Date Date when recurring billing stops and no future billing occurs.
NetBillingAmountForEachPeriod Decimal Net amount that the application bills for each billing timeframe.
OverridePeriod Int Timeframe that includes an override amount. For example, the first invoice is for timeframe 1, the second invoice is for timeframe 2, and so on.
OverridePeriodAmount Decimal Override amount to apply on the timeframe.
OverridePeriodQuantity Decimal Quantity to use when calculating recurring billing or credit for the override timeframe.
PeriodicityCode String Timeframe of the recurring invoice. Values include Day, Week, Month, Quarter, or Year.
Periodicity String Name of the timeframe of the recurring invoice.
SourceBillingPlanId String Value that identifies the billing plan. The source application assigns this value.
Finder String Finder of SalesOrdersForOrderHublinesbillingPlans
FromDate Date FromDate of SalesOrdersForOrderHublinesbillingPlans
HeaderId Long HeaderId of SalesOrdersForOrderHublinesbillingPlans
OrderKey String OrderKey of SalesOrdersForOrderHublinesbillingPlans
OrderNumber String OrderNumber of SalesOrdersForOrderHublinesbillingPlans
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHublinesbillingPlans
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHublinesbillingPlans
ToDate Date ToDate of SalesOrdersForOrderHublinesbillingPlans

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060