VRM_RECON_SUMMARY_CCID
VRM_RECON_SUMMARY_CCID stores the Revenue Management(VRM) General Ledger account code combination for a given scheduled process request. The values for the general ledger account code combinations are derived from the list of accounts that are defined as "Sales Revenue" and "Deferred Sales Revenue" accounts using Financial Category setup. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
VRM_RECON_SUMMARY_CCID_PK |
RECON_SUMMARY_CCID_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECON_SUMMARY_CCID_ID | NUMBER | 18 | Yes | Internal identifier of the account code combination used in revenue and billing reconciliation. | |
| LEDGER_ID | NUMBER | 18 | Yes | Internal identifier of the ledger sending the reconciliation data. | |
| 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 | Yes | The code combinations associated for the Sales Revenue and Deferred Sales Revenue category for a particular ledger. | |
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Chart of accounts identifier. | |
| FINANCIAL_CATEGORY | VARCHAR2 | 30 | Yes | Indicates the financial category setup for the natural account segement corresponds to the code combination. Possible values are REVENUE and DEFERRED REVENUE. | |
| 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 |
|---|---|---|
| VRM_RECON_SUMMARY_CCID | gl_code_combinations | CODE_COMBINATION_ID |
| VRM_RECON_SUMMARY_CCID | gl_ledgers | LEDGER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_RECON_SUMMARY_CCID_N1 | Non Unique | Default | CODE_COMBINATION_ID, FINANCIAL_CATEGORY |
| VRM_RECON_SUMMARY_CCID_N2 | Non Unique | Default | REQUEST_ID |
| VRM_RECON_SUMMARY_CCID_U1 | Unique | Default | RECON_SUMMARY_CCID_ID |