AP_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: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_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 | 25 | Yes | This is the payables reconciliation report summary reconciliation item category. | |
| RECON_ITEM_ORDER | NUMBER | 18 | Yes | Indicates the order in which the report categories will be sorted. | |
| CODE_COMBINATION_ID | NUMBER | 18 | The code combination id column will be populated for the values, which come from SLA or GL. The lookup codes for which CCIDs will be populated is: OTHER Gl_BEGIN_BALANCE INVOICES PAYMENTS PREPAY_APP_UNAPP NOT_POSTED_GL NOT_TRFD_TO_GL NON_AP_ACTIVITY GL_VARIANCE Gl_END_BALANCE NON_AP_BEGIN_BAL The data source in this case would be either SLA or GL or GL Plus. | ||
| LEDGER_ID | NUMBER | 18 | Yes | The ledger for which the data extraction is being carried out | |
| DATA_SOURCE | VARCHAR2 | 8 | Yes | Set of records from which report information is retrieved. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| BU_ID | NUMBER | 18 | The bu_id will be populated for the amounts, which have the data source as 'AP'. The amounts which have the source as AP will be stored at BU level. For example, the Begin Balance will be stored for each BU. The lookup codes for which bu_id will be populated are: AP_BEGIN_BALANCE NON_AP_BEGIN_BAL INVOICES PAYMENTS PREPAY_APP_UNAPP AP_VARIANCE AP_END_BALANCE | ||
| AP_ACCTD_AMOUNT | NUMBER | Transaction amount converted to the ledger currency and stored in subledger tables | |||
| 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 | |||
| BALANCING_SEGMENT | VARCHAR2 | 25 | Value of balancing segment used to automatically balance journal entries. | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 25 | Natural account segment of the account code combination. | ||
| 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 |
|---|---|---|
| AP_RECON_SUMMARY_DETAILS | gl_code_combinations | CODE_COMBINATION_ID |
| AP_RECON_SUMMARY_DETAILS | gl_ledgers | LEDGER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_RECON_SUMMARY_DETAILS_N1 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| AP_RECON_SUMMARY_DETAILS_U1 | Unique | Default | RECON_ITEM_ID |