1. Tables and Views for Financials
  2. IEX_ESSBASE_BALANCES

IEX_ESSBASE_BALANCES

IEX_ESSBASE_BALANCES table stores information about the receivable transactions, receipts and adjustments.This table is used to temporarily store the data and populate the same into essbase cube for calculation of various metrics.

Details

  • Schema: FUSION

  • Object owner: IEX

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

IEX_ESSBASE_BALANCES_PK

IEX_ESSBASE_BALANCES_ID

Columns

Name Datatype Length Precision Not-null Comments
IEX_ESSBASE_BALANCES_ID NUMBER 18 Yes Unique identifier of this essbase balance table.
DOCUMENT_TYPE VARCHAR2 80 Yes The type of Document which is populated from the lookup_type AR_DOCUMENT_TYPE.This maps to Document Type dimension in the cube.
TRX_AMOUNT NUMBER Invoice, debit memo, credit memo and chargeback amount in functional currency. Deposits and Guarantees are excluded.
RECEIPT_AMOUNT NUMBER Receipt application, unapplication or reversal amount in functional currency.
ADJ_AMOUNT NUMBER Adjustment amount in functional currency.
PROMISE_AMOUNT NUMBER Promise to pay in functional currency.
NSF_AMOUNT NUMBER Non Sufficient Fund amount in functional currency.
TRX_AMOUNT_GLOBAL NUMBER Invoice or Debit Memo or Credit Memo or Charge Back amount in global currency. Deposits and Guarantees are excluded.
RECEIPT_AMOUNT_GLOBAL NUMBER The receipt application, unapplication or reversal amount in global currency.
ADJ_AMOUNT_GLOBAL NUMBER Adjustment amount in global currency.
PROMISE_AMOUNT_GLOBAL NUMBER Promise to pay in global currency.
NSF_AMOUNT_GLOBAL NUMBER Non Sufficient Fund amount in global currency.
SCORE NUMBER The object score for a party, account, or bill to customer.
AVERAGE_TERMS NUMBER The product of relative amount and due days from RA_TERMS_LINES used for calculation of weighted average terms metric.
ACTIVITY_DATE DATE Yes The transaction date for Invoice or Debit Memo or Credit Memo or Chargeback, Application and unapplication or reversal date for receipts and adjsutment application date for adjustments. This maps to time dimension in the cube.
PS_DUE_DATE DATE Yes Due date from PAYMENT_SCHEDULE_ID is populated for document type invoice, chargeback, debit memos, and credit memos For document type receipt, due date column contains the due date of the payment_schedule _id to which receipt is applied,unapplied or reversed. In case of adjustments this column stores the due date of the of payment_schedule_id being adjusted.
PS_CLOSED_DATE DATE Yes GL_CLOSED_DATE from payment schedules is populated for the object type invoices. For open invoices the close date is null.
CURRENCY VARCHAR2 15 Yes The functional currency which is dervied from the ledger to which business unit is associated with. This maps to currency dimension in the cube.
BU_NAME VARCHAR2 240 Yes The business unit name is stored.This maps to business unit dimension in the cube.
PARTY_NAME VARCHAR2 360 Yes Name of the party from HZ_PARTIES. This maps to customer dimension in the cube.
ACCOUNT_NUMBER VARCHAR2 450 Yes The account number conctenated with party name from HZ_CUST_ACCOUNTS Table is stored. This forms the part of customer dimension hierarchy in the cube.
PARTY_SITE_NAME VARCHAR2 700 Yes The party site name concatenated with party name and account number from HZ_PARTY_SITES table is stored. This forms the part of customer dimension hierarchy in the cube.
COLLECTOR_NAME VARCHAR2 30 Yes Collector Name associated in profile tab at business level. This maps to Collector dimension in the cube.
SALESREP_NAME VARCHAR2 360 Sales Representative Name. This maps to Sales Representative dimension in the cube.
COUNTRY VARCHAR2 60 Country from HZ_LOCATIONS. This is part of location dimension hierarchy in the cube.
STATE VARCHAR2 60 State Code from HZ_LOCATIONS. This is part of location dimension hierarchy in the cube.
COUNTY VARCHAR2 60 County from HZ_LOCATIONS. This is part of location dimension hierarchy in the cube.
CITY VARCHAR2 60 City from HZ_LOCATIONS. This is part of location dimension hierarchy in the cube.
POSTAL_CODE VARCHAR2 60 Zip Code from HZ_LOCATIONS. This is part of location dimension hierarchy in the cube.
LOCATION VARCHAR2 120 Location concatenated with LOCATION_ID from HZ_LOCATIONS is stored in this column. This will be part of location hierarchy in the cube.
PROFILE_CLASSIFICATION VARCHAR2 80 Yes Profile classification from HZ_CUST_PROFILE_CLASSES.
AGING_BUCKET_NAME VARCHAR2 80 Yes The aging bucket information popluated from the lookup_type IEX_AGING_BUCKETS.
PAYMENT_SCHEDULE_ID NUMBER 18 Yes Foreign Key to AR_PAYMENT_SCHEDULES.PAYMENT_SCHEDULE_ID.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
IEX_ESSBASE_BALANCES_U1 Unique FUSION_TS_TX_IDX IEX_ESSBASE_BALANCES_ID