AP_RECON_SUMMARY_CCID
This table stores the Payable CCIDs for a given Request_ID. The CCIDs are derived from the from and to values of the Balancing segments and natural accounts entered as a parameter by the user. If user is not entered any values for the segments, then the CCIDs will be derived from the list of accounts that are defined as payable accounts in GL.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_RECON_SUMMARY_CCID_PK |
RECON_SUMMARY_CCID_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Ledger Identification for which extract is run | |
| RECON_SUMMARY_CCID_ID | NUMBER | 18 | Yes | This is a Surrogate key as there is no natural primary key | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | The Code combinations associated for the payables category for a particular ledger id. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Identifier of the chart of accounts. | ||
| BALANCING_SEGMENT | VARCHAR2 | 25 | Value of balancing segment used to automatically balance journal entries. | ||
| NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 25 | Account that is reported on the payables reconciliation report. | ||
| 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_CCID | gl_ledgers | LEDGER_ID |
| AP_RECON_SUMMARY_CCID | gl_code_combinations | CODE_COMBINATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_RECON_SUMMARY_CCID_N1 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| AP_RECON_SUMMARY_CCID_U1 | Unique | Default | RECON_SUMMARY_CCID_ID |