Subscription Products
The subscription products view object stores details about the subscription product. The products object has details such as start and end dates, item, unit price, amount, bill-to details, ship-to details, billing frequency, invoice rule, payment method.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionProductExtractPVO
Primary Keys : SubscriptionProductId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountingRuleId | The unique identifier of the accounting rule to be applied, such as 3 months deferred, 6 months fixed, immediate, and so on. |
| AlignBillingDate | The align billing date of the product. |
| AlignBillingDay | The align billing day of the product. |
| AllowancePoolingGroup | |
| AmendCreditMethod | The credit method to be used on amendment of the subscription product. |
| AmendDescription | The reason to amend the subscription product. |
| AmendEffectiveDate | The date from when the subscription product amendment is effective. |
| AmendReason | The reason with which subscription product is amended. |
| Attribute1 | |
| Attribute10 | |
| Attribute11 | |
| Attribute12 | |
| Attribute13 | |
| Attribute14 | |
| Attribute15 | |
| Attribute16 | |
| Attribute17 | |
| Attribute18 | |
| Attribute19 | |
| Attribute2 | |
| Attribute20 | |
| Attribute21 | |
| Attribute22 | |
| Attribute23 | |
| Attribute24 | |
| Attribute25 | |
| Attribute26 | |
| Attribute27 | |
| Attribute28 | |
| Attribute29 | |
| Attribute3 | |
| Attribute30 | |
| Attribute4 | |
| Attribute5 | |
| Attribute6 | |
| Attribute7 | |
| Attribute8 | |
| Attribute9 | |
| AttributeCategory | The descriptive flexfield attribute category associated the subscription product. |
| AttributeDate1 | |
| AttributeDate10 | |
| AttributeDate2 | |
| AttributeDate3 | |
| AttributeDate4 | |
| AttributeDate5 | |
| AttributeDate6 | |
| AttributeDate7 | |
| AttributeDate8 | |
| AttributeDate9 | |
| AttributeNumber1 | |
| AttributeNumber10 | |
| AttributeNumber2 | |
| AttributeNumber3 | |
| AttributeNumber4 | |
| AttributeNumber5 | |
| AttributeNumber6 | |
| AttributeNumber7 | |
| AttributeNumber8 | |
| AttributeNumber9 | |
| BalanceFirstPartialPeriodOption | |
| BalanceLastPartialPeriodOption | |
| BalanceManagementError | The balance management error associated with the product. |
| BalanceProfileId | The balance profile ID of the product. |
| BalanceRegisterId | The balance register ID of the product. |
| BalanceTerminatedPartialPeriodOption | |
| BatchTag | The batch tag associated with the subscription product. |
| BillFirstPartialPeriodOption | The option used to determine how to bill the first partial period of the subscription product. |
| BillFirstPartialPeriodThreshold | The threshold value applied to billing for the first partial period of the subscription product. |
| BillFirstPartialPeriodThresholdType | The threshold type used to evaluate the first partial period billing threshold of the subscription product. |
| BillGenerationMethodCode | |
| BillLastPartialPeriodOption | The option used to determine how to bill the last partial period of the subscription product. |
| BillLastPartialPeriodThreshold | The threshold value applied to billing for the last partial period of the subscription product. |
| BillLastPartialPeriodThresholdType | The threshold type used to evaluate the last partial period billing threshold of the subscription product. |
| BillOnDay | The bill on day value of the subscription product. This is applicable when the billing date is Day, and is defaulted from the subscription header. |
| BillOnDayUsed | The bill on day used for the subscription product. |
| BillToAcctId | The unique identifier of the account that will be billed for the subscription product. |
| BillToContactId | The unique identifier of the bill-to contact for the subscription product. |
| BillToPartyId | The unique identifier of the bill-to customer for the subscription product. |
| BillToSiteUseId | The unique identifier of the site to be used for the subscription product billing. |
| BillingDateCode | The date during the subscription period when the subscription product has to be billed, such as Period start, Period end, Day, or Offset. This is defaulted from the subscription header. |
| BillingDateCodeUsed | The billing date code used for the subscription product. |
| BillingFreq | The billing frequency of the subscription product that's defaulted from the subscription header. Example values are Yearly, Monthly. |
| BillingFreqUsed | The billing frequency used for the subscription product. |
| BillingOffsetDays | The billing offset days of the subscription product. This is applicable when the billing date is set to Offset. |
| BillingOffsetDaysUsed | The billing offset used for the subscription product. |
| BillingSetId | |
| BillingSetStatus | |
| CalculatedCreditAmount | The calculated credit amount of the subscription product. |
| CancelDescription | The reason for canceling the subscription product. |
| CancelReason | The reason why the subscription product was canceled. |
| CancelSetId | The unique set identifier of the cancellation reason for the subscription product. |
| CanceledAmount | The canceled amount of the subscription product. |
| CanceledDate | The date on which the subscription product was canceled. |
| ChurnPredictionTrend | The churn prediction trend of the subscription product. |
| ChurnProbability | The churn probability of the subscription product. Churn probability is the likelihood that a subscription account won't be renewed. |
| CloseCreditMethod | The close credit method of the subscription product. This is used while terminating a subscription product. |
| CloseDescription | The reason for closing the subscription product. |
| CloseReason | The reason with which the subscription product is closed. |
| CloseSetId | The set ID of the close reason of the subscription product. |
| ClosedAmount | The closed or termination amount of the subscription product. |
| ClosedDate | The date on which the subscription product is closed or scheduled to be closed. |
| CorpCurrencyCode | The corporate currency code of the subscription. This is defaulted from the subscription header and can't be modified. |
| CoverageScheduleId | The ID of the coverage schedule associated with the subscription product. |
| CreatedBy | The user who created this subscription product. |
| CreationDate | The date on which the subscription product was created. |
| CreditIssuedYn | The indicator whether any credit has been issued for the subscription product. |
| CreditType | The credit type of the product. |
| CreditedAmount | The credited amount of the subscription product. |
| CurcyConvRateType | The currency conversion rate type used for the subscription. This value is useful when the subscription currency is different from the ledger currency. This is defaulted from the subscription header and can't be modified. |
| Currency | The currency of the subscription such as USD, INR, or GBP. Defaulted from subscription header and can't be modified. |
| CustTrxTypeSeqId | The unique identifier of the customer transaction type sequence. |
| CustomerPONumber | The purchase order number provided by the customer for the subscription product. |
| DefaultRevenueAction | The default revenue action of the subscription product. |
| DefinitionOrgId | The unique identifier of the item master organization associated with the subscription product. This value is same as the definition org ID of the subscription header. |
| DisplaySequence | The display sequence of the subscription product. |
| DocumentTypeId | The document type ID of the product. |
| DropAllowanceFlag | The drop allowance flag of the product. |
| DropOneTimeChargeYn | The indicator of whether the one time charges are dropped during the scheduled product change or not. |
| EarlyTerminationFee | The calculated early termination fee for subscription product. |
| EarlyTerminationPenalty | The option for early termination penalty for the subscription product. The valid values are Flat fee, Prorated flat fee, and Percentage of remaining term fee. |
| EligibleToReopenYn | The eligible to reopen flag of the product. |
| EnableAdvBipTemplateFlag | |
| EnablePriceEscalationsFlag | The indicator to indicate whether pricing term is enabled or not for the subscription product. |
| EnablePricingTermYn | The indicator to indicate whether pricing term is enabled or not for the subscription product. |
| EnableProrateByDayYn | Indicates whether the prorate is enabled or not for the subscription product. |
| EnableUpfrontBillingYn | The enable upfront billing flag of the product. |
| EndDate | The date on which subscription product ends. |
| EntitlementAssignmentId | The entitlement assignment ID of the product. |
| EntitlementPlanId | The entitlement plan ID of the product. |
| EntitlementType | The entitlement type of the product. |
| EstimatedTax | The estimated tax of the subscription product. |
| ExemptCertificateNumber | The tax exemption certificate number of the subscription product. |
| ExemptReason | The tax exempt reason of the subscription product. |
| ExternalAssetKey | The external asset key of the subscription product. |
| ExternalParentAssetKey | The external parent asset key of the subscription product. |
| ExternalPriceBookId | The identifier of the external price book of the subscription product. |
| ExternalPriceBookName | The name of the external price book of the subscription product. |
| ExternalRootAssetKey | The external root asset key of the subscription product. |
| ExtnAttributeChar001 | |
| ExtnAttributeChar002 | |
| ExtnAttributeChar003 | |
| ExtnAttributeChar004 | |
| ExtnAttributeChar005 | |
| ExtnAttributeChar006 | |
| ExtnAttributeChar007 | |
| ExtnAttributeChar008 | |
| ExtnAttributeChar009 | |
| ExtnAttributeChar010 | |
| ExtnAttributeChar011 | |
| ExtnAttributeChar012 | |
| ExtnAttributeChar013 | |
| ExtnAttributeChar014 | |
| ExtnAttributeChar015 | |
| ExtnAttributeChar016 | |
| ExtnAttributeChar017 | |
| ExtnAttributeChar018 | |
| ExtnAttributeChar019 | |
| ExtnAttributeChar020 | |
| ExtnAttributeChar021 | |
| ExtnAttributeChar022 | |
| ExtnAttributeChar023 | |
| ExtnAttributeChar024 | |
| ExtnAttributeChar025 | |
| ExtnAttributeChar026 | |
| ExtnAttributeChar027 | |
| ExtnAttributeChar028 | |
| ExtnAttributeChar029 | |
| ExtnAttributeChar030 | |
| ExtnAttributeChar031 | |
| ExtnAttributeChar032 | |
| ExtnAttributeChar033 | |
| ExtnAttributeChar034 | |
| ExtnAttributeChar035 | |
| ExtnAttributeChar036 | |
| ExtnAttributeChar037 | |
| ExtnAttributeChar038 | |
| ExtnAttributeChar039 | |
| ExtnAttributeChar040 | |
| ExtnAttributeChar041 | |
| ExtnAttributeChar042 | |
| ExtnAttributeChar043 | |
| ExtnAttributeChar044 | |
| ExtnAttributeChar045 | |
| ExtnAttributeChar046 | |
| ExtnAttributeChar047 | |
| ExtnAttributeChar048 | |
| ExtnAttributeChar049 | |
| ExtnAttributeChar050 | |
| ExtnAttributeChar051 | |
| ExtnAttributeChar052 | |
| ExtnAttributeChar053 | |
| ExtnAttributeChar054 | |
| ExtnAttributeChar055 | |
| ExtnAttributeChar056 | |
| ExtnAttributeChar057 | |
| ExtnAttributeChar058 | |
| ExtnAttributeChar059 | |
| ExtnAttributeChar060 | |
| ExtnAttributeChar061 | |
| ExtnAttributeChar062 | |
| ExtnAttributeChar063 | |
| ExtnAttributeChar064 | |
| ExtnAttributeChar065 | |
| ExtnAttributeChar066 | |
| ExtnAttributeChar067 | |
| ExtnAttributeChar068 | |
| ExtnAttributeChar069 | |
| ExtnAttributeChar070 | |
| ExtnAttributeChar071 | |
| ExtnAttributeChar072 | |
| ExtnAttributeChar073 | |
| ExtnAttributeChar074 | |
| ExtnAttributeChar075 | |
| ExtnAttributeChar076 | |
| ExtnAttributeChar077 | |
| ExtnAttributeChar078 | |
| ExtnAttributeChar079 | |
| ExtnAttributeChar080 | |
| ExtnAttributeChar081 | |
| ExtnAttributeChar082 | |
| ExtnAttributeChar083 | |
| ExtnAttributeChar084 | |
| ExtnAttributeChar085 | |
| ExtnAttributeChar086 | |
| ExtnAttributeChar087 | |
| ExtnAttributeChar088 | |
| ExtnAttributeChar089 | |
| ExtnAttributeChar090 | |
| ExtnAttributeChar091 | |
| ExtnAttributeChar092 | |
| ExtnAttributeChar093 | |
| ExtnAttributeChar094 | |
| ExtnAttributeChar095 | |
| ExtnAttributeChar096 | |
| ExtnAttributeChar097 | |
| ExtnAttributeChar098 | |
| ExtnAttributeChar099 | |
| ExtnAttributeChar100 | |
| ExtnAttributeChar101 | |
| ExtnAttributeChar102 | |
| ExtnAttributeChar103 | |
| ExtnAttributeChar104 | |
| ExtnAttributeChar105 | |
| ExtnAttributeChar106 | |
| ExtnAttributeChar107 | |
| ExtnAttributeChar108 | |
| ExtnAttributeChar109 | |
| ExtnAttributeChar110 | |
| ExtnAttributeChar111 | |
| ExtnAttributeChar112 | |
| ExtnAttributeChar113 | |
| ExtnAttributeChar114 | |
| ExtnAttributeChar115 | |
| ExtnAttributeChar116 | |
| ExtnAttributeChar117 | |
| ExtnAttributeChar118 | |
| ExtnAttributeChar119 | |
| ExtnAttributeChar120 | |
| ExtnAttributeChar121 | |
| ExtnAttributeChar122 | |
| ExtnAttributeChar123 | |
| ExtnAttributeChar124 | |
| ExtnAttributeChar125 | |
| ExtnAttributeChar126 | |
| ExtnAttributeChar127 | |
| ExtnAttributeChar128 | |
| ExtnAttributeChar129 | |
| ExtnAttributeChar130 | |
| ExtnAttributeChar131 | |
| ExtnAttributeChar132 | |
| ExtnAttributeChar133 | |
| ExtnAttributeChar134 | |
| ExtnAttributeChar135 | |
| ExtnAttributeChar136 | |
| ExtnAttributeChar137 | |
| ExtnAttributeChar138 | |
| ExtnAttributeChar139 | |
| ExtnAttributeChar140 | |
| ExtnAttributeChar141 | |
| ExtnAttributeChar142 | |
| ExtnAttributeChar143 | |
| ExtnAttributeChar144 | |
| ExtnAttributeChar145 | |
| ExtnAttributeChar146 | |
| ExtnAttributeChar147 | |
| ExtnAttributeChar148 | |
| ExtnAttributeChar149 | |
| ExtnAttributeChar150 | |
| ExtnAttributeChar151 | |
| ExtnAttributeChar152 | |
| ExtnAttributeChar153 | |
| ExtnAttributeChar154 | |
| ExtnAttributeChar155 | |
| ExtnAttributeChar156 | |
| ExtnAttributeChar157 | |
| ExtnAttributeChar158 | |
| ExtnAttributeChar159 | |
| ExtnAttributeChar160 | |
| ExtnAttributeChar161 | |
| ExtnAttributeChar162 | |
| ExtnAttributeChar163 | |
| ExtnAttributeChar164 | |
| ExtnAttributeChar165 | |
| ExtnAttributeChar166 | |
| ExtnAttributeChar167 | |
| ExtnAttributeChar168 | |
| ExtnAttributeChar169 | |
| ExtnAttributeChar170 | |
| ExtnAttributeChar171 | |
| ExtnAttributeChar172 | |
| ExtnAttributeChar173 | |
| ExtnAttributeChar174 | |
| ExtnAttributeChar175 | |
| ExtnAttributeChar176 | |
| ExtnAttributeChar177 | |
| ExtnAttributeChar178 | |
| ExtnAttributeChar179 | |
| ExtnAttributeChar180 | |
| ExtnAttributeChar181 | |
| ExtnAttributeChar182 | |
| ExtnAttributeChar183 | |
| ExtnAttributeChar184 | |
| ExtnAttributeChar185 | |
| ExtnAttributeChar186 | |
| ExtnAttributeChar187 | |
| ExtnAttributeChar188 | |
| ExtnAttributeChar189 | |
| ExtnAttributeChar190 | |
| ExtnAttributeChar191 | |
| ExtnAttributeChar192 | |
| ExtnAttributeChar193 | |
| ExtnAttributeChar194 | |
| ExtnAttributeChar195 | |
| ExtnAttributeChar196 | |
| ExtnAttributeChar197 | |
| ExtnAttributeChar198 | |
| ExtnAttributeChar199 | |
| ExtnAttributeChar200 | |
| ExtnAttributeChar201 | |
| ExtnAttributeChar202 | |
| ExtnAttributeChar203 | |
| ExtnAttributeChar204 | |
| ExtnAttributeChar205 | |
| ExtnAttributeChar206 | |
| ExtnAttributeChar207 | |
| ExtnAttributeChar208 | |
| ExtnAttributeChar209 | |
| ExtnAttributeChar210 | |
| ExtnAttributeChar211 | |
| ExtnAttributeChar212 | |
| ExtnAttributeChar213 | |
| ExtnAttributeChar214 | |
| ExtnAttributeChar215 | |
| ExtnAttributeChar216 | |
| ExtnAttributeChar217 | |
| ExtnAttributeChar218 | |
| ExtnAttributeChar219 | |
| ExtnAttributeChar220 | |
| ExtnAttributeChar221 | |
| ExtnAttributeChar222 | |
| ExtnAttributeChar223 | |
| ExtnAttributeChar224 | |
| ExtnAttributeChar225 | |
| ExtnAttributeChar226 | |
| ExtnAttributeChar227 | |
| ExtnAttributeChar228 | |
| ExtnAttributeChar229 | |
| ExtnAttributeChar230 | |
| ExtnAttributeChar231 | |
| ExtnAttributeChar232 | |
| ExtnAttributeChar233 | |
| ExtnAttributeChar234 | |
| ExtnAttributeChar235 | |
| ExtnAttributeChar236 | |
| ExtnAttributeChar237 | |
| ExtnAttributeChar238 | |
| ExtnAttributeChar239 | |
| ExtnAttributeChar240 | |
| ExtnAttributeChar241 | |
| ExtnAttributeChar242 | |
| ExtnAttributeChar243 | |
| ExtnAttributeChar244 | |
| ExtnAttributeChar245 | |
| ExtnAttributeChar246 | |
| ExtnAttributeChar247 | |
| ExtnAttributeChar248 | |
| ExtnAttributeChar249 | |
| ExtnAttributeChar250 | |
| ExtnAttributeChar251 | |
| ExtnAttributeChar252 | |
| ExtnAttributeChar253 | |
| ExtnAttributeChar254 | |
| ExtnAttributeChar255 | |
| ExtnAttributeChar256 | |
| ExtnAttributeChar257 | |
| ExtnAttributeChar258 | |
| ExtnAttributeChar259 | |
| ExtnAttributeChar260 | |
| ExtnAttributeChar261 | |
| ExtnAttributeChar262 | |
| ExtnAttributeChar263 | |
| ExtnAttributeChar264 | |
| ExtnAttributeChar265 | |
| ExtnAttributeChar266 | |
| ExtnAttributeChar267 | |
| ExtnAttributeChar268 | |
| ExtnAttributeChar269 | |
| ExtnAttributeChar270 | |
| ExtnAttributeChar271 | |
| ExtnAttributeChar272 | |
| ExtnAttributeChar273 | |
| ExtnAttributeChar274 | |
| ExtnAttributeChar275 | |
| ExtnAttributeChar276 | |
| ExtnAttributeChar277 | |
| ExtnAttributeChar278 | |
| ExtnAttributeChar279 | |
| ExtnAttributeChar280 | |
| ExtnAttributeChar281 | |
| ExtnAttributeChar282 | |
| ExtnAttributeChar283 | |
| ExtnAttributeChar284 | |
| ExtnAttributeChar285 | |
| ExtnAttributeChar286 | |
| ExtnAttributeChar287 | |
| ExtnAttributeChar288 | |
| ExtnAttributeChar289 | |
| ExtnAttributeChar290 | |
| ExtnAttributeChar291 | |
| ExtnAttributeChar292 | |
| ExtnAttributeChar293 | |
| ExtnAttributeChar294 | |
| ExtnAttributeChar295 | |
| ExtnAttributeChar296 | |
| ExtnAttributeChar297 | |
| ExtnAttributeChar298 | |
| ExtnAttributeChar299 | |
| ExtnAttributeChar300 | |
| ExtnAttributeChar301 | |
| ExtnAttributeChar302 | |
| ExtnAttributeChar303 | |
| ExtnAttributeChar304 | |
| ExtnAttributeChar305 | |
| ExtnAttributeChar306 | |
| ExtnAttributeChar307 | |
| ExtnAttributeChar308 | |
| ExtnAttributeChar309 | |
| ExtnAttributeChar310 | |
| ExtnAttributeChar311 | |
| ExtnAttributeChar312 | |
| ExtnAttributeChar313 | |
| ExtnAttributeChar314 | |
| ExtnAttributeChar315 | |
| ExtnAttributeChar316 | |
| ExtnAttributeChar317 | |
| ExtnAttributeChar318 | |
| ExtnAttributeChar319 | |
| ExtnAttributeChar320 | |
| ExtnAttributeChar321 | |
| ExtnAttributeChar322 | |
| ExtnAttributeChar323 | |
| ExtnAttributeChar324 | |
| ExtnAttributeChar325 | |
| ExtnAttributeChar326 | |
| ExtnAttributeChar327 | |
| ExtnAttributeChar328 | |
| ExtnAttributeChar329 | |
| ExtnAttributeChar330 | |
| ExtnAttributeChar331 | |
| ExtnAttributeChar332 | |
| ExtnAttributeChar333 | |
| ExtnAttributeChar334 | |
| ExtnAttributeChar335 | |
| ExtnAttributeChar336 | |
| ExtnAttributeChar337 | |
| ExtnAttributeChar338 | |
| ExtnAttributeChar339 | |
| ExtnAttributeChar340 | |
| ExtnAttributeChar341 | |
| ExtnAttributeChar342 | |
| ExtnAttributeChar343 | |
| ExtnAttributeChar344 | |
| ExtnAttributeChar345 | |
| ExtnAttributeChar346 | |
| ExtnAttributeChar347 | |
| ExtnAttributeChar348 | |
| ExtnAttributeChar349 | |
| ExtnAttributeChar350 | |
| ExtnAttributeClob001 | |
| ExtnAttributeClob002 | |
| ExtnAttributeClob003 | |
| ExtnAttributeClob004 | |
| ExtnAttributeClob005 | |
| ExtnAttributeClob006 | |
| ExtnAttributeClob007 | |
| ExtnAttributeClob008 | |
| ExtnAttributeClob009 | |
| ExtnAttributeClob010 | |
| ExtnAttributeClob011 | |
| ExtnAttributeClob012 | |
| ExtnAttributeClob013 | |
| ExtnAttributeClob014 | |
| ExtnAttributeClob015 | |
| ExtnAttributeClob016 | |
| ExtnAttributeClob017 | |
| ExtnAttributeClob018 | |
| ExtnAttributeClob019 | |
| ExtnAttributeClob020 | |
| ExtnAttributeClob021 | |
| ExtnAttributeClob022 | |
| ExtnAttributeClob023 | |
| ExtnAttributeClob024 | |
| ExtnAttributeClob025 | |
| ExtnAttributeNumber001 | |
| ExtnAttributeNumber002 | |
| ExtnAttributeNumber003 | |
| ExtnAttributeNumber004 | |
| ExtnAttributeNumber005 | |
| ExtnAttributeNumber006 | |
| ExtnAttributeNumber007 | |
| ExtnAttributeNumber008 | |
| ExtnAttributeNumber009 | |
| ExtnAttributeNumber010 | |
| ExtnAttributeNumber011 | |
| ExtnAttributeNumber012 | |
| ExtnAttributeNumber013 | |
| ExtnAttributeNumber014 | |
| ExtnAttributeNumber015 | |
| ExtnAttributeNumber016 | |
| ExtnAttributeNumber017 | |
| ExtnAttributeNumber018 | |
| ExtnAttributeNumber019 | |
| ExtnAttributeNumber020 | |
| ExtnAttributeNumber021 | |
| ExtnAttributeNumber022 | |
| ExtnAttributeNumber023 | |
| ExtnAttributeNumber024 | |
| ExtnAttributeNumber025 | |
| ExtnAttributeNumber026 | |
| ExtnAttributeNumber027 | |
| ExtnAttributeNumber028 | |
| ExtnAttributeNumber029 | |
| ExtnAttributeNumber030 | |
| ExtnAttributeNumber031 | |
| ExtnAttributeNumber032 | |
| ExtnAttributeNumber033 | |
| ExtnAttributeNumber034 | |
| ExtnAttributeNumber035 | |
| ExtnAttributeNumber036 | |
| ExtnAttributeNumber037 | |
| ExtnAttributeNumber038 | |
| ExtnAttributeNumber039 | |
| ExtnAttributeNumber040 | |
| ExtnAttributeNumber041 | |
| ExtnAttributeNumber042 | |
| ExtnAttributeNumber043 | |
| ExtnAttributeNumber044 | |
| ExtnAttributeNumber045 | |
| ExtnAttributeNumber046 | |
| ExtnAttributeNumber047 | |
| ExtnAttributeNumber048 | |
| ExtnAttributeNumber049 | |
| ExtnAttributeNumber050 | |
| ExtnAttributeNumber051 | |
| ExtnAttributeNumber052 | |
| ExtnAttributeNumber053 | |
| ExtnAttributeNumber054 | |
| ExtnAttributeNumber055 | |
| ExtnAttributeNumber056 | |
| ExtnAttributeNumber057 | |
| ExtnAttributeNumber058 | |
| ExtnAttributeNumber059 | |
| ExtnAttributeNumber060 | |
| ExtnAttributeNumber061 | |
| ExtnAttributeNumber062 | |
| ExtnAttributeNumber063 | |
| ExtnAttributeNumber064 | |
| ExtnAttributeNumber065 | |
| ExtnAttributeNumber066 | |
| ExtnAttributeNumber067 | |
| ExtnAttributeNumber068 | |
| ExtnAttributeNumber069 | |
| ExtnAttributeNumber070 | |
| ExtnAttributeNumber071 | |
| ExtnAttributeNumber072 | |
| ExtnAttributeNumber073 | |
| ExtnAttributeNumber074 | |
| ExtnAttributeNumber075 | |
| ExtnAttributeNumber076 | |
| ExtnAttributeNumber077 | |
| ExtnAttributeNumber078 | |
| ExtnAttributeNumber079 | |
| ExtnAttributeNumber080 | |
| ExtnAttributeNumber081 | |
| ExtnAttributeNumber082 | |
| ExtnAttributeNumber083 | |
| ExtnAttributeNumber084 | |
| ExtnAttributeNumber085 | |
| ExtnAttributeNumber086 | |
| ExtnAttributeNumber087 | |
| ExtnAttributeNumber088 | |
| ExtnAttributeNumber089 | |
| ExtnAttributeNumber090 | |
| ExtnAttributeNumber091 | |
| ExtnAttributeNumber092 | |
| ExtnAttributeNumber093 | |
| ExtnAttributeNumber094 | |
| ExtnAttributeNumber095 | |
| ExtnAttributeNumber096 | |
| ExtnAttributeNumber097 | |
| ExtnAttributeNumber098 | |
| ExtnAttributeNumber099 | |
| ExtnAttributeNumber100 | |
| ExtnAttributeNumber101 | |
| ExtnAttributeNumber102 | |
| ExtnAttributeNumber103 | |
| ExtnAttributeNumber104 | |
| ExtnAttributeNumber105 | |
| ExtnAttributeNumber106 | |
| ExtnAttributeNumber107 | |
| ExtnAttributeNumber108 | |
| ExtnAttributeNumber109 | |
| ExtnAttributeNumber110 | |
| ExtnAttributeNumber111 | |
| ExtnAttributeNumber112 | |
| ExtnAttributeNumber113 | |
| ExtnAttributeNumber114 | |
| ExtnAttributeNumber115 | |
| ExtnAttributeNumber116 | |
| ExtnAttributeNumber117 | |
| ExtnAttributeNumber118 | |
| ExtnAttributeNumber119 | |
| ExtnAttributeNumber120 | |
| ExtnAttributeNumber121 | |
| ExtnAttributeNumber122 | |
| ExtnAttributeNumber123 | |
| ExtnAttributeNumber124 | |
| ExtnAttributeNumber125 | |
| ExtnAttributeNumber126 | |
| ExtnAttributeNumber127 | |
| ExtnAttributeNumber128 | |
| ExtnAttributeNumber129 | |
| ExtnAttributeNumber130 | |
| ExtnAttributeNumber131 | |
| ExtnAttributeNumber132 | |
| ExtnAttributeNumber133 | |
| ExtnAttributeNumber134 | |
| ExtnAttributeNumber135 | |
| ExtnAttributeNumber136 | |
| ExtnAttributeNumber137 | |
| ExtnAttributeNumber138 | |
| ExtnAttributeNumber139 | |
| ExtnAttributeNumber140 | |
| ExtnAttributeNumber141 | |
| ExtnAttributeNumber142 | |
| ExtnAttributeNumber143 | |
| ExtnAttributeNumber144 | |
| ExtnAttributeNumber145 | |
| ExtnAttributeNumber146 | |
| ExtnAttributeNumber147 | |
| ExtnAttributeNumber148 | |
| ExtnAttributeNumber149 | |
| ExtnAttributeNumber150 | |
| ExtnAttributeNumber151 | |
| ExtnAttributeNumber152 | |
| ExtnAttributeNumber153 | |
| ExtnAttributeNumber154 | |
| ExtnAttributeNumber155 | |
| ExtnAttributeNumber156 | |
| ExtnAttributeNumber157 | |
| ExtnAttributeNumber158 | |
| ExtnAttributeNumber159 | |
| ExtnAttributeNumber160 | |
| ExtnAttributeNumber161 | |
| ExtnAttributeNumber162 | |
| ExtnAttributeNumber163 | |
| ExtnAttributeNumber164 | |
| ExtnAttributeNumber165 | |
| ExtnAttributeNumber166 | |
| ExtnAttributeNumber167 | |
| ExtnAttributeNumber168 | |
| ExtnAttributeNumber169 | |
| ExtnAttributeNumber170 | |
| ExtnAttributeNumber171 | |
| ExtnAttributeNumber172 | |
| ExtnAttributeNumber173 | |
| ExtnAttributeNumber174 | |
| ExtnAttributeNumber175 | |
| ExtnAttributeNumber176 | |
| ExtnAttributeNumber177 | |
| ExtnAttributeNumber178 | |
| ExtnAttributeNumber179 | |
| ExtnAttributeNumber180 | |
| ExtnAttributeNumber181 | |
| ExtnAttributeNumber182 | |
| ExtnAttributeNumber183 | |
| ExtnAttributeNumber184 | |
| ExtnAttributeNumber185 | |
| ExtnAttributeNumber186 | |
| ExtnAttributeNumber187 | |
| ExtnAttributeNumber188 | |
| ExtnAttributeNumber189 | |
| ExtnAttributeNumber190 | |
| ExtnAttributeNumber191 | |
| ExtnAttributeNumber192 | |
| ExtnAttributeNumber193 | |
| ExtnAttributeNumber194 | |
| ExtnAttributeNumber195 | |
| ExtnAttributeNumber196 | |
| ExtnAttributeNumber197 | |
| ExtnAttributeNumber198 | |
| ExtnAttributeNumber199 | |
| ExtnAttributeNumber200 | |
| ExtnAttributeTimestamp001 | |
| ExtnAttributeTimestamp002 | |
| ExtnAttributeTimestamp003 | |
| ExtnAttributeTimestamp004 | |
| ExtnAttributeTimestamp005 | |
| ExtnAttributeTimestamp006 | |
| ExtnAttributeTimestamp007 | |
| ExtnAttributeTimestamp008 | |
| ExtnAttributeTimestamp009 | |
| ExtnAttributeTimestamp010 | |
| ExtnAttributeTimestamp011 | |
| ExtnAttributeTimestamp012 | |
| ExtnAttributeTimestamp013 | |
| ExtnAttributeTimestamp014 | |
| ExtnAttributeTimestamp015 | |
| ExtnAttributeTimestamp016 | |
| ExtnAttributeTimestamp017 | |
| ExtnAttributeTimestamp018 | |
| ExtnAttributeTimestamp019 | |
| ExtnAttributeTimestamp020 | |
| ExtnAttributeTimestamp021 | |
| ExtnAttributeTimestamp022 | |
| ExtnAttributeTimestamp023 | |
| ExtnAttributeTimestamp024 | |
| ExtnAttributeTimestamp025 | |
| ExtnAttributeTimestamp026 | |
| ExtnAttributeTimestamp027 | |
| ExtnAttributeTimestamp028 | |
| ExtnAttributeTimestamp029 | |
| ExtnAttributeTimestamp030 | |
| ExtnAttributeTimestamp031 | |
| ExtnAttributeTimestamp032 | |
| ExtnAttributeTimestamp033 | |
| ExtnAttributeTimestamp034 | |
| ExtnAttributeTimestamp035 | |
| ExtnAttributeTimestamp036 | |
| ExtnAttributeTimestamp037 | |
| ExtnAttributeTimestamp038 | |
| ExtnAttributeTimestamp039 | |
| ExtnAttributeTimestamp040 | |
| ExtnAttributeTimestamp041 | |
| ExtnAttributeTimestamp042 | |
| ExtnAttributeTimestamp043 | |
| ExtnAttributeTimestamp044 | |
| ExtnAttributeTimestamp045 | |
| ExtnAttributeTimestamp046 | |
| ExtnAttributeTimestamp047 | |
| ExtnAttributeTimestamp048 | |
| ExtnAttributeTimestamp049 | |
| ExtnAttributeTimestamp050 | |
| GenBillSchReqdYn | The indicator to indicate whether a billing schedule should be generated for the subscription product. |
| GenerateFullPeriodYn | The indicator to indicate whether the billing schedule should be generated for the full period for the subscription product. |
| GracePeriod | The grace period in days before which the early termination penalty isn't applied for the subscription product. |
| GroupingRuleNumberUsed | The grouping rule number applied to the subscription product for billing or invoicing purposes. |
| InflightFlag | The indicator to indicate whether the subscription product is currently undergoing an in-flight change, such as amendment or renewal, that hasn't yet been finalized. |
| InstrAssignmentId | The instrument assignment ID of the subscription product. This is applicable when the payment method is credit card. |
| InterfaceOffsetDays | The interface offset days of the subscription product. |
| InventoryItemId | The item ID of the inventory item associated with the subscription product. |
| InvoiceBipReportCode | The invoice BIP report code of the subscription product. |
| InvoiceText | The invoice text of the subscription product. |
| InvoicedAmount | The invoice amount of the subscription product. |
| InvoicingRuleId | The invoicing rule ID of the subscription product. This value decides when the invoicing will take place for the subscription product. |
| InvoicingRuleIdUsed | The invoicing rule ID used for the subscription product. |
| ItemUom | The UOM of the inventory item associated with the subscription product. |
| LastLifecycleUpdateDate | The last lifecycle update date of the product. |
| LastUpdateDate | The date when the subscription product was last updated. |
| LastUpdateLogin | The session login of the user who last updated the subscription product. |
| LastUpdatedBy | The user who last update the subscription product. |
| LegacyRetrospectiveFlag | The legacy retrospective flag of the product. |
| MonthlyRecurringRevenue | The monthly recurring revenue of the subscription product. |
| NextBillStartDate | The date on which billing of the subscription product takes place next. |
| NextPricingDate | The date on which the subscription product will be priced next. |
| ObjectVersionNumber | The object version number of the subscription product. |
| OldStatus | The previous status of the subscription product before the latest update. |
| OnetimeAmount | The one-time amount of the subscription product. |
| OrderFulfillLineId | The order fulfill line ID associated with the subscription product. |
| OrderFulfillLineNumber | The order fulfill line number associated with the subscription product. |
| OriginalSubscriptionProductPuid | The unique identifier of the original subscription product from which the current product record was derived, used for tracking lineage across renewals or amendments. |
| OutputTaxClassification | The output text classification of the subscription product. |
| OverrideCreditAmount | The override credit amount of the subscription product. |
| OverridePricelistYn | The indicator to indicate whether price list can be overridden for a subscription product. |
| PaymentMethod | The payment method of the subscription product. The values are Credit card, Purchase order, or Wire. |
| PaymentSetId | The set ID of the payment terms of the subscription product. |
| PaymentTermId | The payment term ID of the subscription product. This is defaulted from the subscription header. |
| PenaltyValue | The penalty to be charged for the cases of early termination of a subscription product. |
| PendingActivationYn | The indicator of whether the subscription product is pending activation or not. |
| PerpetualYn | The indicator to indicate whether the subscription product is perpetual in nature. Indicates that this subscription product doesn't have an end date. |
| PmInterfaceBatchCode | The preventive maintenance interface batch code of the product. |
| PmInterfaceError | The preventive maintenance interface error of the product. |
| PmInterfaceStatus | The preventive maintenance interface status of the product. |
| PmProgramId | The preventive maintenance program ID of the product. |
| PmRequestedProgramId | The preventive maintenance requested program ID of the product. |
| PoNumber | The purchase order number used for the subscription product payment. |
| PreviousCoverageId | The previous coverage ID of the product. |
| PriceAdjustmentBasis | The price adjustment basis of the subscription product. The valid values are Net price, List price. |
| PriceAdjustmentPercent | The price adjustment percentage of the subscription product. |
| PriceAdjustmentType | The price adjustment type of the subscription product. The valid values are Markup, Markdown or Reprice. |
| PriceAsOf | The date on which the subscription product is priced. |
| PriceDuringBillingYn | Indicates whether subscription product is priced during the billing or not. |
| PriceListId | The unique identifier of the price list of the subscription product. |
| PriceListName | The price list name of the subscription product. |
| PriceTransactionOn | The date on which the subscription product transaction is priced. |
| PriceUom | The price UOM of the subscription product. |
| PricingError | The error message received from the pricing application while pricing the product. |
| PricingTermAdjustmentPct | The adjustment percentage of the pricing term that's applicable for Markup or Markdown. |
| PricingTermDuration | The duration of the pricing term of the subscription product. |
| PricingTermPeriod | The period of the pricing term of the subscription product. |
| PricingTermPricingMethod | The ,method of the pricing term of the subscription product. The valid values are Markup, Markdown and Reprice. |
| PricingTermStartDate | The start date of the pricing term of the subscription product. |
| PricingTermType | The pricing term type of the subscription product. |
| ProductChangeReason | The reason with which the existing subscription product is scheduled to be change to another product. |
| ProductChangeSchedule | The apply change option of the scheduled product change. The values are Next renewal date and From a specific date. |
| ProductChangeScheduleFrom | The date on which the scheduled product change will take place. This is applicable when the scheduled product change option is SPECIFIC_DATE. |
| ProductChangeSequenceNumber | The sequence number representing the order of product changes within a subscription, helping track multiple updates or modifications applied over time. |
| ProductFiscClassification | The document fiscal classification of the subscription product. |
| ProductName | The name representing the inventory item of the subscription product. |
| ProductNetPrice | The total contract value of the subscription product. |
| ProductNumber | The number representing the subscription product. |
| ProductTcvUsageCharge | The total contract value of all charges including usage charges of a subscription product. |
| ProductTotal | The total of the subscription product. This includes the tax amount. |
| ProductType | The product type of the product item, used for tax calculation purposes. The product type may be goods or services. |
| ProductUsageContractValue | The sum of all the usage charges of a subscription product. |
| Quantity | The quantity of the subscription product. |
| QuoteId | The quote identifier of the subscription product. |
| QuoteLineId | The quote line identifier of the subscription product. |
| RatePlanDeterminantId | The rate plan determinant identifier of the product. |
| RatePlanDocumentId | The rate plan document ID of the product. |
| RatePlanId | The rate plan ID of the product. |
| ReceiptMethodId | |
| RecurringAmount | The recurring amount of the subscription product. |
| RelatedInventoryItemId | The item identifier of the inventory item that the existing subscription product is scheduled to be changed to. |
| RelatedItemUom | The UOM of the inventory item that the existing subscription product is scheduled to be changed to. |
| RelatedProductName | The name of the inventory item that the existing subscription product is scheduled to be changed to. |
| RenewPerpetuallyYn | The renew perpetually flag of the product. |
| RenewalDuration | The renewal duration of the subscription product. |
| RenewalDurationPeriod | The renewal duration period of the subscription product. |
| RenewalPaymentMethod | The payment method to be used at the time of renewing the subscription product. |
| RenewalPoNumber | The PO number to be used at the time of renewing the subscription product. |
| RenewalPriceListId | The identifier of the renewal price list. |
| RenewalRatePlanId | The identifier of the renewal rate plan. |
| RenewalSequenceNumber | The sequence number assigned to the product during renewal. |
| RenewalType | The indicator whether the subscription product should be renewed or not. The valid values are Renew and Do not renew. |
| RenewalWireNumber | The wire number to be used for the renewal subscription product payment. |
| RenewedDate | The date on which the subscription product got renewed. |
| RequestedEntitlementPlanId | The requested entitlement plan ID of the product. |
| RequestedPriceListId | The requested price list ID of the product. |
| RequestedRatePlanId | The requested rate plan ID of the product. |
| RequestedRegisterAlignDate | The requested register align date of the subscription product. |
| ResourceSalesrepId | |
| RetainSubsOnRenewFlag | |
| RevenueOptionActivate | The revenue option activate flag of the product. |
| RevenueOptionClose | The revenue option close flag of the product. |
| SalesOrderId | The sales order ID associated with the subscription product. |
| SalesOrderLineId | The sales order line ID associated with the subscription product. |
| SalesOrderLineNumber | The sales order line number associated with the product. |
| SalesOrderNumber | The sales order number associated with the subscription product. |
| SalesProductType | The sales product type of the item associated with the subscription product. |
| ShipToAcctId | The unique identifier of the ship-to account for the subscription product. |
| ShipToContactId | The unique identifier of the ship-to contact for the subscription product. |
| ShipToPartyId | The identifier of the ship-to party of the subscription product. |
| ShipToPartySiteId | The identifier of the ship-to party site of the subscription product. |
| SourceKey | The source key of the subscription product. |
| SourceLineKey | The source line key of the subscription product. |
| SourceLineNumber | The source line number of the subscription product. |
| SourceNumber | The source number of the subscription product. |
| SourceSystem | The source system of the subscription product. |
| StartDate | The start date of the subscription product. |
| Status | The status of the subscription product. |
| SubscriptionId | The ID of the subscription to which this subscription product belongs. |
| SubscriptionProductId | The ID of the subscription product. |
| SubscriptionProductPuid | The PUID of the subscription product. This must be unique across the subscription products object. |
| SummarizedBillingYn | The indicator of whether summarized billing is applicable for this subscription product or not. |
| SuppressedCreditAmount | The suppressed credit amount of the subscription product. |
| SuspendCreditMethod | The credit method to be used while suspending a subscription product. |
| SuspendReason | The reason with which subscription product is suspended. |
| SuspendedDate | The date on which the subscription product is suspended. |
| TaxError | The error message received while tax is calculated for the subscription product. |
| TaxExemptionControl | The tax exemption control of the subscription product. The values are Standard, Exempt, or Require. |
| TransactionTypeName | The transaction type of the subscription product. This is used while sending the subscription to invoicing by Accounts Receivables. |
| TrxBusinessCategory | The tax business category specified on the subscription product for tax calculation. |
| TrxnExtensionId | The transaction extension identifier for the subscription payments done through credit card. |
| UnitPrice | The unit price of the subscription product. |
| UpfrontBillingPeriod | |
| UpfrontBillingTrigger | |
| UsageCreditedAmount | The usage credited amount of the subscription product. |
| UsageEventAllowanceInvTemplate | The invoice template used for billing allowance-based usage events. |
| UsageEventCommitmentInvTemplate | The invoice template used for billing commitment-based usage events. |
| UsageEventEstimateInvTemplate | The invoice template used for billing estimates-based usage events. |
| UsageEventRegularInvTemplate | The invoice template used for billing regular usage events. |
| UsageEventTypeId | The unique identifier of the usage event type. |
| UsageInvoicedAmount | The usage invoiced amount of the subscription product. |
| UsageSuppressedCreditAmt | The usage suppressed credit amount of the subscription product. |
| UsgInvoiceLayoutTemplate | |
| ValidationStatus | The current validation state of the product, showing whether the data has passed, failed, or is pending validation. |
| VersionType | The version type of the subscription product. |
| WarehouseId | The unique identifier of the warehouse for the subscription product. |
| WireNumber | The wire number to be used for the subscription product payment. |