Happy Business Starts Here

0 Kudos

Accounting period does not align to revenue schedule via API

We download RevenueSchedule data through API by following query: 

 

SELECT Account.ID, RevenueSchedule.Amount, RevenueSchedule.BillingTransactionId, RevenueSchedule.CreatedById, RevenueSchedule.CreatedDate, RevenueSchedule.Currency, RevenueSchedule.Description, RevenueSchedule.FinanceTransactionType, RevenueSchedule.Id, RevenueSchedule.Number, RevenueSchedule.RecognitionPeriodEnd, RevenueSchedule.RecognitionPeriodStart, RevenueSchedule.ReferenceId, RevenueSchedule.RevenueScheduleDate, RevenueSchedule.Rule, RevenueSchedule.TransactionDate, RevenueSchedule.TransactionNumber, RevenueSchedule.UndistributedAmount, RevenueSchedule.UpdatedById, RevenueSchedule.UpdatedDate FROM RevenueSchedule WHERE UpdatedDate > '2017-08-01T00:00:00-0700' 

 

Also download RevenueScheduleItem data through query: SELECT RevenueSchedule.ID,RevenueScheduleItem.Amount, RevenueScheduleItem.CreatedById, RevenueScheduleItem.CreatedDate, RevenueScheduleItem.Currency, RevenueScheduleItem.Id, RevenueScheduleItem.UpdatedById, RevenueScheduleItem.UpdatedDate FROM RevenueScheduleItem  WHERE UpdatedDate > '2017-08-01T00:00:00-0700' .

 

In order to get the AccountingPeriod for the RevenueSchedule and RevenueScheduleItem if we include AccountingPeriod.Name, AccountingPeriod.ID in the above queries, are we going to get the AccountingPeriod for the those tables' data?