Subscription Product

Subscription Products View Object

QName: {http://xmlns.oracle.com/apps/subscriptions/subscriptionManagement/subscriptionService/}Products

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Subscription Product Descriptive Flexfield

Contains

Bill Line

Contains

Charge

Contained by

Subscription

Handled by

Subscription

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountingRuleId

long

Accounting Rule Id

AccountingRuleName

string

Accounting Rule Name

AmendCreditMethod

string

Amend Credit Method

AmendCreditMethodName

string

Amend Credit Method Name

AmendDescription

string

Amend Description

AmendEffectiveDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Amend Effective Date

AmendReason

string

Amend Reason

AmendReasonName

string

Amend Reason Name

BillOnDay

decimal

Bill On Day

BillOnDayUsed

decimal

Bill On Day Used

BillToAccountDescription

string

Bill To Account Description

BillToAccountId

long

Bill To Account Id

BillToAccountNumber

string

Bill To Account Number

BillToAddress

string

Bill To Address

BillToContactId

long

Bill-to Contact

BillToContactName

string

Bill-to Contact

BillToContactNumber

string

Bill-to Contact

BillToParty

string

Bill To Party

BillToPartyId

long

Bill-to Customer

BillToPartyName

string

Bill-to Contact

BillToSite

string

Bill To Site

BillToSiteUseId

long

Bill To Site Use Id

BillingDateCode

string

Billing Date Code

BillingDateCodeUsed

string

Billing Date Code Used

BillingDateName

string

Billing Date Name

BillingFrequency

string

Billing Frequency

BillingFrequencyName

string

Billing Frequency Name

BillingFrequencyUsed

string

Billing Frequency Used

BillingOffsetDays

int

Billing Offset Days

BillingOffsetDaysUsed

int

Billing Offset Days Used

CalculatedCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Calculated Credit Amount

CancelReason

string

Cancel Reason

CancelSetId

long

Cancel Set Id

CanceledAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Canceled Amount

CanceledDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Canceled Date

CloseCreditMethod

string

Close Credit Method

CloseReason

string

Close Reason

CloseSetId

long

Close Set Id

ClosedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Closed Amount

ClosedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Closed Date

CodeUOM

string

Code UOM

CorpCurrencyCode

string

Corp Currency Code

CoverageScheduleId

long

Coverage Scheduled

CreatedBy

string

Created By

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Creation Date

CreditedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Credited Amount

CurcyConvRateType

string

Currency Conversion Rate Type

Currency

string

Product Currency

CurrencyPrecision

int

Currency Precision

DefaultRevenueAction

string

Default Revenue Action

DefinitionOrganizationId

long

Definition Organization Id

Description

string

Product Description

DocumentTypeId

long

Document Type Id

DurationQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Duration Quantity

EnablePricingTermsFlag

boolean

Enable Pricing Terms Flag

EndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

End Date

EstimatedTax

decimal

Estimated Tax

ExemptCertificateNumber

string

Exempt Certificate Number

ExemptReason

string

Exempt Reason

ExternalAssetKey

string

External Asset Key

ExternalParentAssetKey

string

External Parent Asset Key

ExternalPriceBookName

string

External Price Book Name

ExternalPriceListId

string

External Price List Id

ExternalRootAssetKey

string

External Root Asset Key

GenerateBillingSchedule

string

Generate Billing Schedule

InstrAssignmentId

long

Instr Assignment Id

InventoryItemId

long

Inventory Item Id

InventoryItemIdUOM

long

Inventory Item Id UOM

InvoiceList

anyType

Invoice List

InvoiceText

string

Invoice Text

InvoicedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Invoiced Amount

InvoicingRuleId

long

Invoicing Rule Id

InvoicingRuleIdUsed

long

Invoicing Rule Id Used

InvoicingRuleName

string

Invoicing Rule Name

IsProductCreatedFromAmendFlag

boolean

Is Product Created From Amend Flag

ItemNumber

string

Item Number

ItemUnitOfMeasure

string

Item Unit Of Measure

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Last Update Date

LastUpdateLogin

string

Last Update Login

LastUpdatedBy

string

Last Updated By

LineNumber

string

Line Number

MilestoneBasedChargeFlag

boolean

Milestone Based Charge Flag

MonthlyRecurringRevenue

decimal

Monthly Recurring Revenue

NextBillStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Next Bill Start Date

NextPricingDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Next Pricing Date

ObjectVersionNumber

int

Object Version Number

OganizationIdUOM

long

Organization Id UOM

OnetimeAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Ont time Amount

OrderFulfillLineId

long

Order Fulfill Line Id

OrderFulfillLineNumber

int

Order Fulfill Line Number

OrganizationId

long

Organization Id

OutputTaxClassification

string

Output Tax Classification

OverrideCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Override Credit Amount

OverridePricelistFlag

boolean

Override Pricelist Flag

PONumber

string

PO Number

PaymentMethod

string

Payment Method

PaymentMethodName

string

Payment Method Name

PaymentTermsId

long

Payment Terms Id

PaymentTermsName

string

Payment Terms Name

Period

string

Product Period

PerpetualFlag

boolean

Perpetual Flag

PrePaymentNumber

long

Pre Payment Number

PriceAsOf

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Price As Of

PriceDuringBillingFlag

boolean

Price During Billing Flag

PriceItemQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Price Item Quantity

PriceItemUOM

string

Price Item UOM

PriceListId

long

Price List Id

PriceListName

string

Price List Name

PriceTransactionOn

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Price Transaction On

PriceUOM

string

Price UOM

PriceUnitOfMeasure

string

Price Unit Of Measure

PricingError

string

Pricing Error

PricingTermsAdjustmentPCT

decimal

Pricing Terms Adjustment PCT

PricingTermsDuration

decimal

Pricing Terms Duration

PricingTermsPeriod

string

Pricing Terms Period

PricingTermsPricingMethod

string

Pricing Terms Pricing Method

PricingTermsStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Pricing Terms Start Date

PricingTermsType

string

Pricing Terms Type

ProductFiscClassification

string

Product Fisc Classification

ProductName

string

Product Name

ProductTotal

decimal

Product Total

ProductType

string

Product Type

Quantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Product Quantity

RecurringAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Recurring Amount

Relationships

oracle.apps.subscriptions.subscriptionManagement.subscriptionService.Relationships

Product Relationships

RenewPerpetuallyFlag

boolean

Renew Perpetually Flag

RenewalDuration

long

Renewal Duration

RenewalDurationPeriod

string

Renewal Duration Period

RenewalDurationPeriodName

string

Renewal Duration Period Name

RenewalPaymentMethodName

string

Renewal Payment Method Name

RenewalType

string

Renewal Type

RenewedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Renewed Date

RevenueOption

string

Revenue Option

SalesOrderId

long

Sales Order Id

SalesOrderLineNumber

string

Sales Order Line Number

SalesOrderNumber

string

Sales Order Number

SalesProductType

string

Sales Product Type

ShipToAccountDescription

string

Ship-to Account Description

ShipToAccountId

long

Ship-to Account

ShipToAccountNumber

string

Ship-to Account

ShipToContactId

long

Ship-to Contact

ShipToContactName

string

Ship-to Contact

ShipToContactNumber

string

Ship-to Contact

ShipToContactPartyId

long

Ship-to Contact

ShipToPartyId

long

Ship To Party Id

ShipToPartyName

string

Ship To Party Name

ShipToPartySiteId

long

Ship To Party Site Id

ShipToPartySiteName

string

Ship To Party Site Name

SourceKey

string

Source Key

SourceLineKey

string

Source Line Key

SourceLineNumber

string

Source Line Number

SourceNumber

string

Source Number

SourceSystem

string

Source System

StartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start Date

Status

string

Product Status

StatusLookupCode

string

Status Lookup Code

StatusLookupType

string

Status Lookup Type

StatusMeaning

string

Status Meaning

SubscriptionId

long

Subscription Id

SubscriptionNumber

string

Subscription Number

SubscriptionProductId

long

Subscription Product Id
  • Primary Key

SubscriptionProductPuid

string

Subscription Product Puid

SummarizedBillingFlag

boolean

Summarized Billing Flag

SuppressedCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Suppressed Credit Amount

TaxClassificationMeaning

string

Tax Classification Meaning

TaxError

string

Tax Error

TaxExemptionHandling

string

Tax Exemption Handling

TaxExemptionHandlingName

string

Tax Exemption Handling Name

TotalContractValue

decimal

Total Contract Value

TransactionTypeName

string

Transaction Type Name

TrxBusinessCategory

string

Trx Business Category

TrxnExtensionId

long

Trxn Extension Id

UnitPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Unit Price

UsageCreditedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Usage Credited Amount

UsageInvoicedAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Usage Invoiced Amount

UsageSuppressedCreditAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

Usage Suppressed Credit Amount

VersionType

string

Version Type

WareHouseName

string

Warehouse

WarehouseId

long

Warehouse

WireNumber

string

Wire Number

billLines

Bill Line

Product Bill Lines

charges

Charge

Product Charges

flexFields

Subscription Product Descriptive Flexfield

Product Flex Fields