Search Engine: Elastic

Article ID: 122409, created on Jul 19, 2014, last review on Aug 1, 2014

  • Applies to:
  • Business Automation 5.5


How to know the destination Plan Period of a switch plan order?



The Plan Period information is not included into Order Details, therefore it is only possible to obtain such information from PBA-E database using query example below:

pba=> select "PlanPeriodID" from "OrdDet" where "DetID" = 622693 \x\g\x
Expanded display is on.
-[ RECORD 1 ]+-----
PlanPeriodID | 8414

Here 622693 is the Details ID from the Change order (Details of type "recurring fee"). 8414 - can be found in the list of existing Plan Periods in the new (destination) Service Plan:

8414    1   Month(s)

There is a feature request to improve Order Detalization and include additional information into the Order Description: PBA-28873.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF