Indexed fields
This article provides the indexed fields of the tables.
Account
- Id
- UpdatedDate
- AccountNumber
- Batch
- BillCycleDay
- BillToId
- CommunicationProfileId
- CrmId
- Currency
- DefaultPaymentMethodId
- InvoiceTemplateId
- Name
- ParentId
- SoldToId
- Status
AccountingCode
- Type
- Id
- UpdatedDate
AccountingPeriod
- Id
- UpdatedDate
- EndDate
- Name
- StartDate
Amendment
- Id
- Name
- Status
- SubscriptionId
- Type
- UpdatedDate
ApplicationGroup
- UpdatedDate
- PaymentId
- RefundId
AquaTaskLog
- JobId
- Id
- UpdatedDate
Attachment
- Id
- UpdatedDate
- AssociatedObjectType
- AssociatedObjectId
Auditloginevent
- Year
- Month
- Day
Auditsettingchangeevent
- Year
- Month
- Day
Auditobjectchangeevent
- Year
- Month
- Day
BillingRun
- Id
- CreatedById
- UpdatedDate
- BillingRunNumber
- ExecutedDate
- Status
ChargeMetrics
- ChargeNumber
- Currency
- InvoiceOwnerAccountNumber
- SubscriptionName
- SubscriptionOwnerAccountNumber
- AmendmentId
- ProductId
- ProductRatePlanId
- ProductRatePlanChargeId
- RatePlanChargeId
- StartDate
- EndDate
- CreatedDate
- UpdatedDate
Collections_CollectionsWindowInfo
- Amount_Due
- InCollections
- LastOpenInvoice
- CollectUserId
- AccountId
Collections_Commentables
- NotesId
- CollectUserId
Collections_ConnectorExecutions
- LockboxId
Collections_Groups
- Name
Collections_LockboxPayment
- LockboxRecordId
Collections_LockboxRecords
- ConnectorExecutionId
Collections_Replies
- NotesId
- CollectUserid
- CommentableId
Collections_Retryattempts
- RetryCycleId
- AttemptNumber
- Success
- CreatedDate
Collections_Retrycycles
- InvoiceId
- PaymentMethodId
- DebitMemoId
- AccountId
- AttemptNumber
- CustomerGroupId
- NextAttempt
- Currency
- Processing
- Status
Contact
- Id
- UpdatedDate
- AccountId
- Country
- FirstName
- PersonalEmail
ContactSnapshot
- Id
- UpdatedDate
- ContactId
Country
- Id
CreditBalanceAdjustment
- AccountId
- AccountingPeriodId
- Id
- UpdatedDate
CreditMemo
- MemoNumber
- Status
- InvoiceId
- AccountId
- Id
- UpdatedDate
CreditMemoApplication
- Id
- UpdatedDate
- EffectiveDate
- AccountId
- ApplicationGroupId
CreditMemoApplicationItem
- EffectiveDate
- ApplicationGroupId
- Id
- UpdatedDate
CreditMemoItem
- SubscriptionId
- InvoiceItemId
- RatePlanChargeId
- CreditMemoId
- Id
- UpdatedDate
CreditMemoPart
- Id
- UpdatedDate
- AccountId
- CreditMemoId
CreditMemoPartItem
- Id
- UpdatedDate
- TaxationItemId
- CreditMemoPartId
- DebitMemoItemId
- InvoiceItemId
- DebitTaxationItemId
- CreditMemoItemId
- CreditTaxationItemId
CreditTaxationItem
- CreditMemoItemId
- TaxationItemId
- Id
- UpdatedDate
DebitMemo
- MemoDate
- MemoNumber
- Status
- InvoiceId
- AccountId
- Id
- UpdatedDate
DebitMemoItem
- SubscriptionId
- InvoiceItemId
- ProductRatePlanChargeId
- RatePlanChargeId
- DebitMemoId
- Id
- UpdatedDate
DebitTaxationItem
- DebitMemoItemId
- TaxationItemId
- Id
- UpdatedDate
DiscountAppliedMetrics
- DiscountRatePlanChargeId
- RatePlanChargeId
- Id
- UpdatedDate
DiscountApplyDetail
- Id
- UpdatedDate
- RatePlanChargeId
FXCustomRate
- Id
- UpdatedDate
- CurrencyFrom
- CurrencyTo
- RateDate
Feature
- Id
- UpdatedDate
- FeatureCode
- Status
Invoice
- AccountId
- InvoiceDate
- InvoiceNumber
- SourceId
- Status
- Id
- UpdatedDate
InvoiceAdjustment
- AccountId
- InvoiceId
- AccountingCode
- AdjustmentNumber
- ReasonCode
- Status
- Id
- UpdatedDate
InvoiceHistory
- InvoiceId
- Id
InvoiceItem
- InvoiceId
- RatePlanChargeId
- AccountingCode
- SubscriptionId
- Id
- UpdatedDate
InvoiceItemAdjustment
- AccountId
- AccountingCode
- AdjustmentNumber
- InvoiceId
- SourceId
- Status
- Id
- UpdatedDate
InvoicePayment
- InvoiceId
- PaymentId
- Id
- UpdatedDate
JournalEntry
- AccountingPeriodId
- Currency
- Number
- Status
- Id
- UpdatedDate
JournalEntryItem
- Id
- UpdatedDate
JournalRun
- Number
- Status
- TargetEndDate
- TargetStartDate
- Id
MemoHistory
- MemoId
- Id
NonSubscriptionInvoiceItem
- InvoiceId
- RatePlanChargeId
- AccountingCode
- SubscriptionId
- Id
- UpdatedDate
- BookingReference
NotificationHistoryCallout
- Id
- ObjectId
- AccountId
- CreateTime
NotificationHistoryEmail
- Id
- NotificationId
- ObjectId
- AccountId
- EventName
- CreatedOn
- Status
NotificationHistoryEmailEvent
- Id
- AccountId
- NotificationId
- EmailHistoryId
- EventTimestamp
- EventType
- EventSubtype
- CreatedDate
- UpdatedDate
OrderAction
- Id
- UpdatedDate
- SubscriptionVersionAmendmentId
- OrderId
OrderActionRatePlan
- Id
- OrderActionId
- RatePlanId
- UpdatedDate
OrderContact
- Id
- UpdatedDate
- Country
- FirstName
OrderElp
- Id
- InvoiceOwnerId
- OrderItemId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderItem
- Id
- UpdatedDate
- EndDate
- StartDate
- RatePlanChargeId
- OrderActionId
OrderLineItem
- Id
- UpdatedDate
- ItemName
- ItemNumber
- ItemState
- ItemType
- OrderId
- ProductCode
- ProductRatePlanChargeId
- UOM
- RelatedSubscriptionNumber
OrderMrr
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- OrderItemId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderMrrDefault
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderQuantity
- Id
- UpdatedDate
- InvoiceOwnerId
- OrderItemId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderQuantityDefault
- Id
- UpdatedDate
- InvoiceOwnerId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderTcb
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- OrderItemId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderTcbDefault
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderTcv
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- OrderItemId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
OrderTcvDefault
- Id
- UpdatedDate
- DiscountChargeId
- InvoiceOwnerId
- SubscriptionOwnerId
- RatePlanChargeId
- OrderActionId
Orders
- Id
- UpdatedDate
- OrderDate
- OrderNumber
- AccountId
Payment
- AccountId
- EffectiveDate
- GatewayOrderId
- GatewayState
- PaymentMethodId
- PaymentMethodSnapshotId
- PaymentNumber
- ReferenceId
- Source
- SourceName
- Status
- Id
- UpdatedDate
PaymentApplication
- EffectiveDate
- AccountId
- PaymentId
- ApplicationGroupId
- Id
- UpdatedDate
PaymentApplicationItem
- EffectiveDate
- TaxationItemId
- PaymentApplicationId
- ApplicationGroupId
- DebitTaxationItemId
- Id
- UpdatedDate
PaymentGatewayReconciliationEventLog
- Id
- GatewayReferenceId
- PaymentReconciliationJobId
PaymentItem
- Id
- UpdatedDate
- PaymentItemNumber
- InvoiceItemId
- InvoicePaymentId
- PaymentId
- TaxationItemId
PaymentMethod
- AccountId
- AchAccountName
- AchBankName
- AchCountry
- Active
- IsSystem
- BusinessIdentificationCode
- Country
- CreditCardMaskNumber
- PaypalBaid
- Type
- Id
- UpdatedDate
PaymentMethodSnapshot
- AccountId
- Country
- CreditCardCountry
- PaymentMethodId
- Id
- UpdatedDate
PaymentMethodTransactionLog
- Id
- TransactionId
- PaymentMethodId
PaymentPart
- Id
- UpdatedDate
- PaymentId
- InvoiceId
- AccountId
PaymentPartItem
- Id
- UpdatedDate
- DebitMemoItemId
- DebitTaxationItemId
- InvoiceItemId
- PaymentPartId
- TaxationItemId
PaymentReconciliationAttempt
- Id
- PaymentReconciliationJobId
PaymentReconciliationJob
- Id
- JobNumber
- Status
PaymentReconciliationLog
- Id
- Status
PaymentRun
- Id
- UpdatedDate
- PaymentRunNumber
PaymentTransactionLog
- Id
- CreatedDate
- GatewayReasonCode
- TransactionDate
- TransactionId
- PaymentId
ProcessedUsage
- UsageId
- BillingPeriodEndDate
- BillingPeriodStartDate
- Id
- UpdatedDate
Product
- Name
- SKU
- Id
- UpdatedDate
ProductDiscountApplyDetail
- Id
- UpdatedDate
- ProductRatePlanChargeId
ProductFeature
- Id
- UpdatedDate
- FeatureId
- ProductId
ProductRatePlan
- ProductId
- Name
- Id
- UpdatedDate
ProductRatePlanCharge
- deleted
- BillCycleDay
- ChargeModel
- Id
- UpdatedDate
ProductRatePlanChargeTier
- Id
- UpdatedDate
- ProductRatePlanChargeId
ProductRatePlanCurrency
- IsActive
- Currency
- ProductRatePlanId
- Id
- UpdatedDate
Ramp
- Id
- OrderId
- UpdatedDate
RampInterval
- Id
- RampId
- UpdatedDate
RampIntervalDeltaMetrics
- Id
- ProductRatePlanChargeId
- RampIntervalId
RampIntervalDeltaMrr
- Id
- RampIntervalDeltaMetricsId
RampIntervalDeltaQuantity
- Id
- RampIntervalDeltaMetricsId
RampIntervalMetrics
- Id
- ProductRatePlanChargeId
- RampIntervalId
- RatePlanChargeId
RampIntervalMrr
- Id
- RampIntervalMetricsId
RatePlan
- AmendmentId
- SubscriptionId
- Id
- UpdatedDate
RatePlanCharge
- RatePlanId
- OriginalId
- Id
- UpdatedDate
RatePlanChargeTier
- Currency
- Id
- UpdatedDate
RealTimeRatingProcessedUsage
- UsageId
- BillingPeriodEndDate
- BillingPeriodStartDate
- Id
- UpdatedDate
Refund
- AccountId
- PaymentMethodSnapshotId
- PaymentMethodId
- ReasonCode
- RefundNumber
- SourceType
- Id
- UpdatedDate
RefundApplication
- AccountId
- ApplicationGroupId
- EffectiveDate
- RefundId
- Id
- UpdatedDate
RefundApplicationItem
- Id
- UpdatedDate
RefundInvoicePayment
- InvoicePaymentId
- RefundId
- Id
- UpdatedDate
RefundItem
- Id
- UpdatedDate
- RefundItemNumber
- RefundInvoicePaymentId
- PaymentItemId
RefundPart
- Id
- UpdatedDate
- PaymentId
- RefundId
- CreditMemoId
- AccountId
RefundPartItem
- Id
- UpdatedDate
RefundTransactionLog
- Id
- TransactionDate
- TransactionId
- RefundId
RevenueChargeSummary
- AccountId
- Number
- Id
- UpdatedDate
RevenueChargeSummaryItem
- AccountingPeriodId
- Amount
- Id
- UpdatedDate
RevenueEvent
- Number
- Id
- UpdatedDate
RevenueEventCreditMemoItem
- Number
- Id
- UpdatedDate
RevenueEventDebitMemoItem
- Number
- Id
- UpdatedDate
RevenueEventInvoiceItem
- Number
- Id
- UpdatedDate
RevenueEventInvoiceItemAdjustment
- Number
- Id
- UpdatedDate
RevenueEventItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueEventItemCreditMemoItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueEventItemDebitMemoItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueEventItemInvoiceItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueEventItemInvoiceItemAdjustment
- AccountingPeriodId
- Id
- UpdatedDate
RevenueEventType
- Name
- SystemId
- Id
- UpdatedDate
RevenueSchedule
- BillingTransactionId
- Number
- RevenueScheduleDate
- AccountId
- Id
- UpdatedDate
RevenueScheduleCreditMemoItem
- CreditMemoItemId
- Number
- RevenueScheduleDate
- Id
- UpdatedDate
RevenueScheduleDebitMemoItem
- DebitMemoItemId
- Number
- AccountId
- Id
- UpdatedDate
RevenueScheduleInvoiceItem
- Number
- InvoiceItemId
- AccountId
- Id
- UpdatedDate
RevenueScheduleInvoiceItemAdjustment
- Number
- AccountId
- InvoiceItemAdjustmentId
- Id
- UpdatedDate
RevenueScheduleItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueScheduleItemCreditMemoItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueScheduleItemDebitMemoItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueScheduleItemInvoiceItem
- AccountingPeriodId
- Id
- UpdatedDate
RevenueScheduleItemInvoiceItemAdjustment
- AccountingPeriodId
- Id
- UpdatedDate
State
- Id
Subscription
- Id
- AccountId
- ContractEffectiveDate
- CreatorAccountId
- CreatorInvoiceOwnerId
- InvoiceOwnerId
- Name
- OriginalId
- PreviousSubscriptionId
- Status
- SubscriptionVersionAmendmentId
- TermStartDate
- Version
- UpdatedDate
SubscriptionProductFeature
- Id
- UpdatedDate
- FeatureId
- RatePlanId
TaxableItemSnapshot
- Id
- TaxableItemId
TaxationItem
- Id
- UpdatedDate
- InvoiceItemId
UpdaterBatch
- BatchId
- InternalStatus
- RequestId
- Status
- UpdaterAccountId
- Id
- UpdatedDate
UpdaterDetail
- BillingAccountId
- RecordId
- Status
- TransactionId
- UpdaterBatchId
- PaymentMethodId
- Id
- UpdatedDate
Usage
- AccountId, UOM, StartDateTime (composite index)
- UOM
- Id
- UpdatedDate
- ImportId
User
- Id