Subscription Profiles
The subscription profile extract view object contains information on billing, revenue options, and so on about the subscription profile.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionProfileExtractPVO
Primary Keys : SubscriptionProfileId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountingRuleId | The accounting rule ID of the subscription profile. |
| BillFirstPpOption | The first bill option of the subscription profile. |
| BillFirstPpThreshold | The first bill threshold of the subscription profile. |
| BillFirstPpThresholdType | The first bill threshold type of the subscription profile. |
| BillGenerationMethodCode | The bill generation method code of the subscription profile. |
| BillLastPpOption | The last bill option of the subscription profile. |
| BillLastPpThreshold | The last bill threshold of the subscription profile. |
| BillLastPpThresholdType | The last bill threshold type of the subscription profile. |
| BillService | The bill service of the subscription profile. |
| BillingDateCode | The billing date code of the subscription profile. |
| BillingFrequency | The billing frequency of the subscription profile. |
| BillingOffsetDays | The billing offset days of the subscription profile. |
| BillingSystem | The billing system of the subscription profile. |
| CloseCreditMethod | The close credit method of the subscription profile. |
| CoverageInvoiceText | The coverage invoice text of the subscription profile. |
| CreateZeroCreditMemoFlag | Indicates whether zero credit memo created. |
| CreatedBy | The user who created the subscription profile. |
| CreationDate | The date and time when the subscription profile was created. |
| CreditMemoOption | The credit memo option of the subscription profile. |
| CreditType | The credit type of the subscription profile. |
| CustomerAcceptance | The customer acceptance of the subscription profile. |
| DefaultRevenueActionAmend | The default revenue amend action of the subscription profile. |
| DefaultRevenueActionRenew | The default revenue renew action of the subscription profile. |
| DynamicSuffixFlag | Indicates dynamic suffix of the subscription profile. |
| EnableAdvBipTemplateFlag | Indicates bip template is enabled of the subscription profile. |
| EnableProrateByDayYn | Indicates prorate by day is enabled of the subscription profile. |
| HeaderNumberPrefix | The header number prefix of the subscription profile. |
| HeaderNumberSuffix | The header number suffix of the subscription profile. |
| HeaderNumberingMethod | The header numbering method of the subscription profile. |
| InterfaceOffsetDays | The interface offset days of the subscription profile. |
| InternalApproval | The interval approval of the subscription profile. |
| InvoiceAttachmentCategory | The invoice attachment category of the subscription profile. |
| InvoiceAttachmentEntityName | The invoice attachment entity name of the subscription profile. |
| InvoiceBipReportCode | The invoice bip report code of the subscription profile. |
| InvoicingRuleId | The invoice rule identifier of the subscription profile. |
| LastUpdateDate | The date and time when the subscription profile was last updated. |
| LastUpdateLogin | The session login associated with the last update of the subscription profile. |
| LastUpdatedBy | The user who last updated the subscription profile. |
| LayoutTemplate | The layout template of the subscription profile. |
| LineAutonumberEnabledYn | Indicates line auto number is enabled or not. |
| NegotiationLanguage | The negotiation language of the subscription profile. |
| NumberingDeterminantType | The numbering determinant type of the subscription profile. |
| ObjectVersionNumber | The object version number of the subscription profile. |
| OnCmBillNotAr | Determine whether on account credit memo is created for bill lines which had not been originally invoiced from Receivables. |
| PartialPeriodStart | The period start of the subscription. Defaulted from the subscription profile. The values are Calendar month, Service start, and so on. |
| PartialPeriodType | The period type of the subscription. Defaulted from the subscription profile. The values are Actual, Fixed, and so on. |
| PaymentTermId | The payment term ID of the subscription. This is defaulted from the subscription profile. |
| PaymenttermCustomermasterYn | Indicates whether payment term should be defaulted from customer data or from subscription profile. |
| PenaltyChargeName | The penalty charge name of the subscription product. |
| PreviewBipReportCode | The BI Publisher report code used in generating the subscription preview. |
| PriceDuringBillingYn | Indicates whether subscription product is priced during the billing or not. |
| PricingApplicationCode | The pricing application code of the subscription profile. |
| RevenueOptionAmend | The revenue amend option of the subscription profile. |
| RevenueOptionBillAdj | The revenue bill line adjustments option of subscription profile. |
| RevenueOptionClose | The revenue close option of subscription profile. |
| RevenueOptionPricingTerm | The revenue pricing term option of subscription profile. |
| RevenueOptionRenew | The revenue renew option of subscription profile. |
| RevenuePeriodBillAdj | The revenue period bill line adjustments of subscription profile. |
| RevenuePeriodPricingTerm | The revenue period pricing term of subscription profile. |
| SubscriptionInvoiceText | The subscription invoice text of the subscription profile. |
| SubscriptionProfileDesc | The profile description of subscription profile. |
| SubscriptionProfileId | The profile identifier of subscription profile. |
| SubscriptionProfileName | The profile name of subscription profile. |
| SubscriptionProfilePuid | The unique profile identifier of subscription profile. |
| SuffixText | The suffix text of subscription profile. |
| SyncRenewedLineOnSuspYn | Indicates renewed line on suspend is synced or not. |
| TransactionTypeName | The transaction type name of subscription profile. |
| TrxTypeSeqId | The unique identifier of the transaction type sequence. |
| UsageCapture | The usage capture of subscription profile. |
| UsgInvoiceLayoutTemplate | The usage invoice layout template of subscription profile. |
| UsgevtAllowanceInvtemplate | The usage event allowance invoice template of subscription profile. |
| UsgevtCommitmentInvtemplate | The usage event commitment invoice template of subscription profile. |
| UsgevtEstimateInvtemplate | The usage event estimate invoice template of subscription profile. |
| UsgevtRegularInvtemplate | The usage event regular invoice template of subscription profile. |
| WithholdProrationUsgYn | Indicates whether usage proration should be withheld for the subscription. |