AR_RECON_SUMMARY_DETAILS
This table stores the extract of the data, which is required for the preparation of the summary report.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AR_RECON_SUMMARY_DETAILS_PK |
RECON_ITEM_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RECON_ITEM_ID | NUMBER | 18 | Yes | This columns is the PK of this table. This is a running sequence number derived from the database sequence. | |
RECON_ITEM_CODE | VARCHAR2 | 30 | Yes | This code is populated through the lookup. The lookup codes defined for this column are: BEGIN_BAL, NON_AR_BEGIN_BAL, TRANSACTIONS, ADJUSTMENTS, APPLIED_RECEIPT, UNAPPLIED_RECEIPT, OTHER, AR_VARIANCE, AR_END_BAL, NON_AR_ACTIVITY, NOT_TRFD_TO_GL, NOT_POSTED_GL, GL_VARIANCE and GL_END_BALANCE. | |
RECON_ITEM_ORDER | NUMBER | Yes | Reconciliation items on summary report in Oracle Business Intelligence Enterprise Edition must display in a specific, fixed order requiring hard coding. This column stores a numeric sequence value that sorts the report in the specified order. | ||
CODE_COMBINATION_ID | NUMBER | 18 | This column is populated by source data values from Subledger Accounting or GL. The lookup codes for which values are populated are: BEGIN_BAL ( GL), NON_AR_ACTIVITY, NOT_TRFD_TO_GL, NOT_POSTED_GL, GL_VARIANCE, and GL_END_BALANCE. | ||
LEDGER_ID | NUMBER | 18 | Yes | The ledger for which the data extraction is being carried out. | |
BU_ID | NUMBER | 18 | The BU_ID is populated for amounts with data source of Receivables. These amounts are stored at BU level. For example, the Begin Balance will be stored for each BU. The lookup code values for which BU_ID is populated are: BEGIN_BAL(AR), TRANSACTIONS, ADJUSTMENTS, APPLIED_RECEIPT, UNAPPLIED_RECEIPT, OTHER and AR_VARIANCE. | ||
AR_ACCTD_AMOUNT | NUMBER | This column is populated for the amounts that are extracted from receivables tables. The lookup code values for which the column is populated are: BEGIN_BAL(AR), TRANSACTIONS, ADJUSTMENTS, APPLIED_RECEIPT, UNAPPLIED_RECEIPT, OTHER and AR_VARIANCE. | |||
ACCOUNTED_DR | NUMBER | The debit amounts will be populated for the amounts that are being extracted for SLA or GL. | |||
ACCOUNTED_CR | NUMBER | The credit amounts will be populated for the amounts that are being extracted for SLA or GL. | |||
DATA_SOURCE | VARCHAR2 | 15 | The data source will have the following values depending on the lookup code and amount which is being populated: AR, SLA, GL or Plug. | ||
BALANCING_SEGMENT | VARCHAR2 | 25 | Balancing Segment | ||
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 25 | Natural Account Segment | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
AR_RECON_SUMMARY_DETAILS | gl_code_combinations | CODE_COMBINATION_ID |
AR_RECON_SUMMARY_DETAILS | gl_ledgers | LEDGER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AR_RECON_SUMMARY_DETAILS_N1 | Non Unique | Default | REQUEST_ID |
AR_RECON_SUMMARY_DETAILS_U1 | Unique | Default | RECON_ITEM_ID |