Subscription

Subscriptions View Object

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

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 Party

Contains

Subscription Product

Contains

Subscription Descriptive Flexfield

Handled by

Subscription

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountingRuleId

long

Accouting Rule Id

AccountingRuleName

string

Accounting Rule Name

ApprovalNote

string

Approval Note

ApprovedDate

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

Approved Date

AssigneeId

long

Assignee Id

AssigneeType

string

Assignee Type

BillOnDay

decimal

Bill On Day

BillService

string

Bill Service

BillServiceName

string

Bill Service Name

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

BillToParty

string

Bill To Party

BillToPartyId

long

Bill-to Customer

BillToPartyName

string

Bill-to Customer

BillToSite

string

Bill To Site

BillToSiteUseId

long

Bill To Site Used Id

BillingDateCode

string

Billing Date Code

BillingDateName

string

Billing Date Name

BillingFrequency

string

Billing Frequency

BillingFrequencyName

string

Billing Frequency Name

BillingOffsetDays

int

Billing Offset Days

BillingSystem

string

Billing System

BusinessUnitId

long

Business Unit Id

BusinessUnitName

string

Business Unit Name

CalculatedCreditAmount

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

Calculated Credit Amount

CancelReason

string

Cancel Reason

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

ClosedAmount

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

Closed Amount

ClosedDate

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

Closed Date

CommunicationChannel

string

Communication Channel

CorpCurrencyCode

string

Corp Currency Code

CorrelationId

string

Correlation Id

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

Currency of the subscription

CurrencyConversionRate

string

Cuurency Conversion Rate

CurrencyConversionRateDate

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

Currency Conversion Rate Date

CurrencyConversionRateType

string

Currency Conversion Rate Type

CurrencyName

string

Currency Name

CustomerAcceptance

string

Customer Acceptance

CustomerTrxTypeSequenceId

long

Customer Transaction Type Sequence Id

DaysBeforeExpiry

long

Days Before Expiry

DaysBeforeExpiryUsed

string

Days Before Expiry Used

DefaultLanguage

string

Default Language

DefinitionOrganizationId

long

Definition Organization Id

Description

string

Subscription Description

DocumentFiscalClassification

string

Document Fiscal Classification

Duration

long

Subscription Duration

EnableRenewalRemindersFlag

boolean

Enable Renewal Reminders

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

ExemptReasonMeaning

string

Exempt Reason Meaning

GenerateBillingSchedule

string

Generate Billing Schedule

InstrAssignmentId

long

Instrument Assignment Id

InternalApproval

string

Internal Approval

InvoicedAmount

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

Invoiced Amount

InvoicingRuleId

long

Invoicing Rule Id

InvoicingRuleName

string

Invoicing Rule Name

LastUpdateDate

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

Last Update Date

LastUpdateLogin

string

Last Update Login

LastUpdatedBy

string

Last Updated By

LayoutTemplate

string

Layout Template

LegalEntityId

long

Legal Entity Id

LegalEntityName

string

Legal Entity Name

LockedFlagReadOnly

string

Locked Flag Read Only

MatrixId

long

Matrix Id

MinimumRenewalDurationUsed

long

Minimum Renewal Duration Used

MinimumRenewalPeriodUsed

string

Minimum Renewal Period Used

NegotiationLanguage

string

Negotiation Language

NotificationTemplateId

long

Notification Template Id

OverrideCreditAmount

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

Override Credit Amount

PONumber

string

PO Number

PartialPeriodStart

string

Partial Period Start

PartialPeriodType

string

Partial Period Type

PaymentMethod

string

Payment Method

PaymentMethodName

string

Payment Method Name

PaymentTermsId

long

Payment Terms Id

PaymentTermsName

string

Payment Terms Name

Period

string

Subscription Period

PerpetualFlag

boolean

Perpetual Flag

PriceAdjustmentPercentUsed

decimal

Price Adjustment Percent Used

PriceAdjustmentTypeUsed

string

Renewal Price Adjustment Used

PricedOnDate

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

Priced On Date

PricingError

string

Pricing Error

PricingSegment

string

Pricing Segment

PricingSegmentExplanation

string

Pricing Segment Explanation

PricingStrategyExplanation

string

Pricing Strategy Explanation

PricingStrategyId

long

Pricing Strategy Id

PricingSystem

string

Pricing System

PrimaryPartyId

long

Primary Party Id

PrimaryPartyName

string

Primary Party Name

PrimarySalesPerson

long

Primary Sales Person

PrimarySalesRepresentative

string

Primary Sales Representative

QuoteAccount

string

Quote Account

QuoteAddress

string

Quote Address

QuoteEmail

string

Quote Email

QuoteFax

string

Quote Fax

QuoteOrganization

string

Quote Organization

QuotePhone

string

Quote Phone

QuoteToCcEmail

string

Quote To Cc Email

QuoteToContact

string

Quote To Contact

QuoteToContactId

long

Quote To Contact Id

QuoteToContactNumber

string

Quote To Contact Number

RenewPerpetuallyFlag

boolean

Renew Perpetually Flag

RenewalCustomerAcceptance

string

Renewal Customer Acceptance

RenewalDuration

long

Renewal Duration

RenewalDurationPeriod

string

Renewal Duration Period

RenewalDurationPeriodName

string

Renewal Duration Period Name

RenewalInternalApproval

string

Renewal Internal Approval

RenewalPaymentMethodName

string

Renewal Payment Method Name

RenewalPriceAdjustmentBasis

string

Renewal Price Adjustment Basis

RenewalPriceAdjustmentPercent

decimal

Renewal Price Adjustment Percent

RenewalPriceAdjustmentType

string

Renewal Price Adjustment Type

RenewalPricingMethodUsed

string

Renewal Pricing Method Used

RenewalProcess

string

Renewal Process

RenewalProcessUsed

string

Renewal Process Used

RenewalSubscriptionProfileId

long

Renewal Subscription Profile Id

RenewalTemplateId

long

Renewal Template Id

RenewedDate

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

Renewed Date

SalesOrderId

long

Sales Order Id

SalesOrderNumber

string

Sales Order Number

SegmentExplanationMessage

string

Segment Explanation Message

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

ShipToContactPartyId

long

Ship-to Contact

ShipToParty

long

Ship To Party

ShipToPartyName

string

Ship To Party Name

ShipToPartySiteId

long

Ship To Party Site Id

ShipToSite

string

Ship To Site

ShortDescription

string

Short Description

SkipConsolidationFlag

boolean

Skip Consolidation Flag

SourceKey

string

Source Key

SourceNumber

string

Source Number

SourceSystem

string

Source System

StartDate

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

Start Date

StateTransitionFlowState

string

State Transistion Flow State

Status

string

Subscription Status

SubscriptionId

long

Subscription Id
  • Primary Key

SubscriptionInvoiceText

string

Subscription Invoice Text

SubscriptionNumber

string

Subscription Number

SubscriptionProfileId

long

Subscription Profile Id

SubscriptionProfileName

string

Subscription Profile Name

SuppressedCreditAmount

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

Suppressed Credit Amount

SystemAction

string

System Action

SystemActionDate

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

System Action Date

SystemActionObject

string

System Action Object

SystemActionObjectKey

string

System Action Object Key

SystemActionRequestId

long

System Action Request Id

SystemActionStatus

string

System Action Status

TaskId

string

Task Id

TaxClassificationCode

string

Tax Classification Code

TaxClassificationMeaning

string

Tax Classification Meaning

TaxExemptionHandling

string

Tax Exemption Handling

TaxExemptionHandlingName

string

Tax Exemption Handling Name

TermsLayoutTemplate

string

Terms Layout Template

TotalContractValue

decimal

Total Contract Value

TransactionTypeName

string

Transaction Type Name

TrxnExtensionId

long

Transaction Extension Id

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

VersionDescription

string

Version Description

WareHouseName

string

Warehouse

WarehouseId

long

Warehouse

WireNumber

string

Wire Number

flexFields

Subscription Descriptive Flexfield

Subscription Flex Fields

parties

Subscription Party

Subscription Parties

products

Subscription Product

Subscription Products