Suspense Database Tables

There are several database tables that contain information related to suspense accounts and suspense records. All suspense account information is saved in the AsChartOfAccount tables. All suspense record information is saved to AsAccountingDetail and the four AsSuspense tables. An explanation of the database tables is provided below.

Suspense Accounts

Suspense accounts are created through Chart Of Accounts in the Rules Palette. The AsChartOfAccountsEntry table holds information about the account.

AsChartofAccountsEntry Database Table

Suspense Records

Suspense records can be created from the Suspense Screen in OIPA or they can be generated by the GenerateSuspense business rule when it is attached to an activity that is processed in OIPA.

Suspense Record Created from Suspense Screen

When a new suspense record is created in OIPA through the Suspense Screen, a record is written to AsSuspense.

AsSuspense table

AsSuspense Table

If dynamic fields are configured in the Suspense Screen then records are written to the AsSuspenseField table when a suspense record is updated/created.

AsSuspenseField table

AsSuspenseField Table

If dynamic fields are configured in the Suspense Screen and multiple values are present then records are written to the AsSuspenseMultiValueField table when a suspense record is updated/created. The FIELDINDEX Column identifies the multiple values.

AsSuspenseMultivalueField table

AsSuspenseMultiValueField Table

Transactionsthat Generate Suspense Records

Any time accounting is performed on a transaction that is configured with the suspense element, the information is saved to the AsAccountingDetail table. A suspense account must exist. The account is identified by the CHARTOFACCOUNTENTRYGUID.

AsAccountingDetail table

AsAccountingDetail Table

     
Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us