Billing Plans

The Billing Plans view object extracts billing plan details from the sales orders, such as billing plan type, billing period, number of billing periods, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.BillingPlanExtractPVO

Primary Keys : BillingPlanId

Initial Extract Date : BillingPlanCreationDate

Incremental Extract Date : BillingPlanLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
BillingPlanBillingNumOfPeriods	Number of recurring invoices to insure.
BillingPlanBillingPeriodEndDate	End date of the billing period corresponding to the billing period number.
BillingPlanBillingPeriodNumber	Number of the billing period corresponding to the billing period start date, billing period end date, and billing transaction date.
BillingPlanBillingPeriodStartDate	Start date of the billing period corresponding to the billing period number.
BillingPlanBillingTrxDate	Date when the first invoice occurs. It applies when the sales order uses a recurring invoice. If the invoice covers only part of an invoice period, then this attribute stores the date of the subsequent invoice.
BillingPlanCancellationEffectiveDate	Date when recurring billing stops and no future billing occurs.
BillingPlanCreatedBy	User who created the billing plan row.
BillingPlanCreationDate	Date when the billing plan row was created.
BillingPlanFulfillLineId	Value that identifies the fulfillment line associated to the billing plan row. This is a foreign key to the Fulfillment Lines view object.
BillingPlanId	Value that uniquely identifies the billing plan row. This is the primary key of the Billing Plans view object.
BillingPlanLastUpdateDate	Date when the billing plan row was last updated.
BillingPlanLastUpdateLogin	Session login associated to the user who most recently updated the billing plan row.
BillingPlanLastUpdatedBy	User who most recently updated the billing plan row.
BillingPlanNetBillingAmtPerPeriod	Net amount to bill for each billing period.
BillingPlanObjectVersionNumber	Number of times the billing plan row has been updated.
BillingPlanOverridePeriod	Number of the billing period that includes an override amount. For example, the first invoice is for billing period 1, the second invoice is for billing period 2, and so on.
BillingPlanOverridePeriodAmount	Override amount to apply on the billing period.
BillingPlanOverridePeriodQuantity	Quantity that's used for calculating recurring invoice or credit for the override billing period.
BillingPlanPeriodicityCode	Code that identifies the period of the recurring invoice. A list of accepted values is defined in the lookup type ORA_DOO_BILLING_FREQUENCY_CODE.
BillingPlanSourceBillingPlanId	Value that uniquely identifies the billing plan row for the source order.
BillingPlanTypeCode	Code that identifies the type of the billing plan. A list of accepted values is defined in the lookup type ORA_DOO_BILLING_PLAN_TYPE_CODE.