Subscriptions
The subscriptions view object stores details about the subscription header such as start and end dates, customer, subscription profile, and total contract value.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionHeaderExtractPVO
Primary Keys : SubscriptionId
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. |
| AlternateSubscriptionId | The alternate subscription identifier of the subscription header. |
| ApprovalNote | The note added at the time of subscription approval. |
| ApprovedDate | The date on which the subscription is approved. |
| AssigneeId | The unique identifier of the subscription assignee. |
| AssigneeType | The type of the subscription assignee. |
| 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. |
| AttributeDate1 | |
| AttributeDate10 | |
| AttributeDate2 | |
| AttributeDate3 | |
| AttributeDate4 | |
| AttributeDate5 | |
| AttributeDate6 | |
| AttributeDate7 | |
| AttributeDate8 | |
| AttributeDate9 | |
| AttributeNumber1 | |
| AttributeNumber10 | |
| AttributeNumber2 | |
| AttributeNumber3 | |
| AttributeNumber4 | |
| AttributeNumber5 | |
| AttributeNumber6 | |
| AttributeNumber7 | |
| AttributeNumber8 | |
| AttributeNumber9 | |
| BatchTag | The batch tag associated with the subscription record. |
| BillFirstPartialPeriodOption | The option used to determine how to bill the first partial period of the subscription. |
| BillFirstPartialPeriodThreshold | The threshold value applied to billing for the first partial period of the subscription. |
| BillFirstPartialPeriodThresholdType | The threshold type used to evaluate the first partial period billing threshold of the subscription. |
| BillGenerationMethodCode | |
| BillLastPartialPeriodOption | The option used to determine how to bill the last partial period of the subscription. |
| BillLastPartialPeriodThreshold | The threshold value applied to billing for the last partial period of the subscription. |
| BillLastPartialPeriodThresholdType | The threshold type used to evaluate the last partial period billing threshold of the subscription. |
| BillOnDay | The bill on day value of the subscription. This is applicable when the billing date is Day, and is defaulted from the subscription profile. |
| BillService | The bill service of the subscription. The values are Bill, Do not bill, and Bill on renewal. It's defaulted from the subscription profile. |
| BillToAcctId | The unique identifier of the account that will be billed for the subscription. |
| BillToContactId | The unique identifier of the bill-to contact for the subscription. |
| BillToPartyId | The unique identifier of the bill-to customer for the subscription. |
| BillToSiteUseId | The unique identifier of the site to be used for the subscription billing. |
| BillingDateCode | The date during the subscription period when the subscription has to be billed, such as Period start, Period end, Day, or Offset. This is defaulted from the subscription profile. |
| BillingFrequency | The billing frequency of the subscription that's defaulted from the subscription profile. |
| BillingOffsetDays | The billing offset days of the subscription. This is applicable when the billing date is set to Offset. |
| BillingSystem | The billing system of the subscription. The valid values are Oracle Fusion or Third party. |
| BusinessUnitId | The unique identifier of the business unit to which the subscription belongs. |
| CalculatedCreditAmount | The calculated credit amount of the subscription. |
| CancelDescription | The reason for canceling the subscription. |
| CancelReason | The reason with which the subscription is canceled. |
| CancelSetId | The unique set identifier of the cancellation reason for the subscription. |
| CanceledAmount | The canceled amount of the subscription. |
| CanceledDate | The date on which the subscription was canceled. |
| CloseCreditMethod | The close credit method of the subscription. This is used while terminating a subscription. |
| CloseDescription | The reason for closing the subscription. |
| CloseReason | The reason with which the subscription is closed. |
| CloseSetId | The set ID of the close reason of the subscription. |
| ClosedAmount | The closed or termination amount of the subscription. |
| ClosedDate | The date on which the subscription is closed or scheduled to be closed. |
| CommunicationChannel | The communication channel to be used for the subscription negotiation. |
| CorpCurrencyCode | The corporate currency code of the subscription. |
| CorrelationId | The correlation ID of the latest approval of the subscription. |
| CoverageInvoiceText | The coverage invoice text to be used while invoicing the subscription. |
| CreatedBy | The user who created this subscription. |
| CreationDate | The date on which the subscription was created. |
| CreditType | The credit type of the subscription. |
| CreditedAmount | The credited amount of a subscription. This is applicable when the subscription is terminated. |
| CurcyConvRateType | The currency conversion rate type used for the subscription. This value is useful when the subscription currency is different from the ledger currency. |
| CurrConversionRate | The currency conversion rate used for the subscription. This value is useful when the subscription currency is different from the ledger currency. |
| CurrConversionRateDate | The currency conversion rate date used for the subscription. This value is useful when the subscription currency is different from the ledger currency. |
| CurrConversionRateType | The currency conversion rate type of the subscription. |
| Currency | The currency of the subscription such as USD, INR, or GBP. |
| CustTrxTypeSeqId | The unique identifier of the customer transaction type sequence. |
| CustomerAcceptance | Indicates if customer acceptance is required for the subscription. |
| DaysBeforeExpiry | The days before the subscription expires. |
| DaysBeforeExpiryUsed | The days before the expiry used while creating this subscription. |
| DefinitionOrgId | The unique identifier of the item master organization associated with the subscription. The product definition is dependent on this. |
| Description | The description of the subscription. |
| DocFiscalClassification | The document fiscal classification of the subscription. |
| DuplicatedTo | The unique identifier of the duplicate subscription header. |
| ElectronicSignYn | Indicates if electronic signature is applicable for this subscription. |
| EnableAdvBipTemplateFlag | |
| EnableRenewalRemindersYn | Indicates if renewal reminders are enabled for the subscription. This indicates if renewal reminders will be sent or not for this subscription. |
| EnableUiActionsYn | Indicates if UI actions are enabled for the subscription. |
| EndDate | The date on which subscription ends. |
| EstimatedTax | The estimated tax of the subscription. |
| ExemptCertificateNumber | The tax exemption certificate number of the subscription. |
| ExemptReason | The tax exempt reason of the subscription. |
| 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 | |
| FreezePriceFlag | Indicates whether the price is frozen for the subscription. |
| InstrAssignmentId | The instrument assignment ID of the subscription. This is applicable when the payment method is credit card. |
| InternalApproval | Indicates if internal approval is required for the subscription. |
| InvoiceBipReportCode | The BI Publisher report code associated with the invoice on the subscription. |
| InvoicedAmount | The invoiced amount of a subscription. |
| InvoicingRuleId | The invoicing rule ID of the subscription. This value decides when the invoicing will take place for the subscription. |
| LastUpdateDate | The date on which this subscription got updated the last. |
| LastUpdateLogin | The session login of the user who last updated the subscription. |
| LastUpdatedBy | The user who last updated the subscription. |
| LayoutTemplate | The layout template used for the preview of the subscription. |
| LegalEntityId | The unique identifier of the legal entity associated with the subscription. |
| LineAutonumberEnabledYn | Indicates if the subscription lines are auto numbered. |
| LockedFlag | Indicates whether the subscription is locked or not. |
| MajorVersion | The major version of the subscription. |
| MassUpdateStatusYn | Indicates if the subscription is selected for mass update. |
| MinRenewalDurationUsed | The minimum renewal duration used while creating this subscription. |
| MinRenewalPeriodUsed | The renewal period used while creating this subscription. |
| NegotiationLanguage | The negotiation language of the subscription. |
| NetPrice | The net price of the subscription. |
| ObjectVersionNumber | The object version number of the subscription. |
| OldStatus | The previous status of the subscription before the latest update. |
| OutputTaxClassification | The output text classification of the subscription. |
| OverrideCreditAmount | The override credit amount of the subscription. |
| 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. |
| PaymentMethod | The payment method of the subscription. The values are Credit card, Purchase order, or Wire. |
| PaymentTermId | The payment term ID of the subscription. This is defaulted from the subscription profile. |
| PerpetualYn | The indicator if the subscription is perpetual. |
| PoNumber | The purchase order number used for the subscription payment. |
| PreviewBipReportCode | The BI Publisher report code used in generating the subscription preview. |
| PriceAdjustmentPctUsed | The price adjustment percentage used while creating this subscription by way of renewal. |
| PriceAdjustmentTypeUsed | The price adjustment type used while creating this subscription by way of renewal. |
| PricedOnDate | The priced on date of the subscription. |
| PricingError | The error message received from the pricing application while pricing the product. |
| PricingSegment | The pricing segment of the subscription. |
| PricingSegmentExplan | The pricing segment explanation of the subscription. |
| PricingStrategyExplan | The pricing strategy explanation of the subscription. |
| PricingStrategyId | The unique identifier of the pricing strategy associated with the subscription. |
| PricingSystem | The pricing system of the subscription. |
| PrimaryPartyId | The unique identifier of the primary party associated with the subscription. |
| QuoteId | The quote identifier of the subscription. |
| QuoteToCcEmail | The copy to email address to which a quote or a reminder is sent. |
| QuoteToContactId | The unique identifier of the contact to which the quote or reminder is sent. |
| RenewPerpetuallyYn | Indicates whether the subscription is renewed perpetually or not. |
| RenewalCustomerAcceptance | Indicates if customer acceptance is required for renewal. |
| RenewalDuration | The override renewal duration for the subscription. |
| RenewalDurationPeriod | The override renewal duration period for the subscription. |
| RenewalInternalApproval | Indicates if internal approval is required for renewal. |
| RenewalPaymentMethod | The renewal payment method of the subscription. The values are Purchase order, Wire, Credit card. |
| RenewalPoNumber | The purchase order number that's used to pay for the subscription renewal. |
| RenewalPriceAdjBasis | The renewal price adjustment basis of the subscription. |
| RenewalPriceAdjPercent | The renewal price adjustment percentage of the subscription. |
| RenewalPriceAdjType | The renewal price adjustment type of the subscription. |
| RenewalPriceListId | The unique identifier of the price list applied for subscription renewal. |
| RenewalPricingMethodUsed | The renewal pricing method used for the subscription. |
| RenewalProcess | The renewal process of the subscription. The values are Do not Renew, Manual, or Automatic. |
| RenewalProcessUsed | The renewal process used while this subscription is created. The values are Do not Renew, Manual, or Automatic. |
| RenewalSalesRep | The sales person used for the renewal subscription. |
| RenewalWireNumber | The wire number used for the renewal subscription payment. |
| RenewedDate | The date on which this subscription got renewed. |
| RetainSubsOnRenewFlag | |
| SalesOrderId | The sales order ID associated with the subscription. |
| SalesOrderNumber | The sales order number associated with the subscription. |
| SegmentExplanMsgName | The pricing segment explanation message name of the subscription. |
| ShipToAcctId | The unique identifier of the ship-to account for the subscription. |
| ShipToContactId | The unique identifier of the ship-to contact for the subscription. |
| ShipToParty | The ship-to party of the subscription. |
| ShipToPartySiteId | The ship-to part site ID of the subscription. |
| ShortDescription | The short description of the subscription. |
| SignedDate | The date on which the subscription is signed. |
| SkipConsolidationFlag | Indicates whether renewal consolidation for the subscription is skipped or not. |
| SourceKey | The source key of the subscription used to identify the subscription in a third-party system. |
| SourceNumber | The source number of the subscription used to identify the subscription in a third-party system. |
| SourceSystem | The source system of the subscription to identify the subscription in a third-party system. |
| StartDate | The date on which the subscription starts. |
| StateTransitionFlowState | The state transition flow state of the subscription. The default is the contract status. |
| Status | The status of the subscription, such as Draft, Active, Under Amendment, and so on. |
| SubscriptionId | The unique identifier of the subscription. This is the primary key of the subscription. |
| SubscriptionInvoiceText | The invoice text to be used while invoicing the subscription. |
| SubscriptionNumber | The public unique identifier of the subscription. |
| SubscriptionProfileId | The unique identifier of the subscription profile. |
| SuppressedCreditAmount | The suppressed credit amount of the subscription. This becomes applicable on termination of the subscription. |
| SystemAction | The system action associated with the subscription. |
| SystemActionDate | The system action date of the subscription. |
| SystemActionObject | |
| SystemActionObjectKey | |
| SystemActionRequestId | The system action request identifier of the subscription. |
| SystemActionStatus | The system action status of the subscription. |
| TaskId | The unique identifier of the task associated with the latest approval of the subscription. |
| TaxExemptionControl | The tax exemption control of the subscription. The values are Standard, Exempt, or Require. |
| TcvUsageCharge | The total contract value of all charges including usage charges of a subscription. |
| TemplateUsed | The identifier of the template used to create the subscription. |
| TemplateYn | Indicates if this is a template. |
| TermsLayoutTemplate | The layout template that defines the formatting of the subscription terms information. |
| Total | The subscription total contract value. |
| TransactionTypeName | The transaction type of the subscription. This is used while sending the subscription to invoicing by Accounts Receivables. Defaulted from the subscription profile. |
| TrxnExtensionId | The transaction extension identifier for the subscription payments done through credit card. |
| UsageCapture | The usage capture mode of the subscription. Defaulted from the subscription profile. |
| UsageContractValue | The sum of all the usage charges across all products in a subscription. |
| UsageCreditedAmount | The usage credited amount of the subscription. |
| 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. |
| UsageInvoicedAmount | The usage invoiced amount of the subscription. |
| UsageSuppressedCreditAmt | The usage suppressed credit amount of the subscription. |
| UserStatus | The user status of the subscription, such as Pending Accounts Review, Pending Finance Approval, and so on. |
| UsgInvoiceLayoutTemplate | |
| ValidationStatus | The current validation state of the subscription, showing whether the data has passed, failed, or is pending validation. |
| VersionDescription | The version description of the subscription. |
| VersionType | The version type of the subscription. |
| WarehouseId | The unique identifier of the warehouse for the subscription. |
| WarrantyYn | Indicates if the subscription under warranty. |
| WireNumber | The wire number to be used for the subscription payment. |
| WithholdProrationUsgYn |