CJM_PROGRAM_BUDGET_SUMMARY
CJM_PROGRAM_BUDGET_SUMMARY is a table containing the summary of accrual records created in the CJM_PROGRAMS_UTILIZED_ALL_B table. It contains the Sum of Planned Amount, Committed Amount, Utilized, Earned and Paid Amounts for the given Channel Program and Budget Combination. This table is used to display the checkbook summary of the Channel program.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_PROG_BUDGET_SUMMARY_PK |
PROG_BUDGET_SUM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROG_BUDGET_SUM_ID | NUMBER | 18 | Yes | Unique identifier for the CJM_PROGRAM_BUDGET_SUMMARY table. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. | ||
| 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. | ||
| 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. | ||
| PROGRAM_HEADER_ID | NUMBER | 18 | Identifies the Channel Program Header ID for which Accruals are created. | ||
| BUDGET_ID | NUMBER | 18 | Identifies the Budget against which the Accruals are created. | ||
| BUDGET_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Budget source currency code. | ||
| BUDGET_COMMITTED_AMT | NUMBER | Committed amount in budget currency. | |||
| BUDGET_UTILIZED_AMT | NUMBER | Utilized amount in budget currency. | |||
| BUDGET_EARNED_AMT | NUMBER | Earned amount which gets posted to GL in the budget currency. | |||
| BUDGET_PAID_AMT | NUMBER | Paid Amount in budget currency. | |||
| PROGRAM_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Channel Program Currency Code. | ||
| PROGRAM_COMMITTED_AMT | NUMBER | Committed amount in Channel Program currency. | |||
| PROGRAM_UTILIZED_AMT | NUMBER | Utilized amount in Channel Program currency. | |||
| PROGRAM_EARNED_AMT | NUMBER | Earned amount in Channel Program currency. | |||
| PROGRAM_PAID_AMT | NUMBER | Paid amount in Channel Program currency. | |||
| YEAR_ID | NUMBER | 18 | Identifies the Accounting Year for which the amounts were accrued and paid. | ||
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| UTILIZED_ACCTD_AMT | NUMBER | Indicates the utilized amount in ledger currency. | |||
| EARNED_ACCTD_AMT | NUMBER | Indicates the earned amount in ledger currency. | |||
| PAID_ACCTD_AMT | NUMBER | Indicates the paid amount in ledger currency. | |||
| PROGRAM_IN_PROGRESS_AMT | NUMBER | Indicates the amount in program currency, associated with the claim in Open, Approval Pending, and Approval Rejected statuses. | |||
| IN_PROGRESS_ACCTD_AMT | NUMBER | Indicates the amount in ledger currency, associated with the claim in Open, Approval Pending, and Approval Rejected statuses. | |||
| SOURCE_TRX_AMT | NUMBER | Total purchases or sales based on the program currency. | |||
| SOURCE_TRX_ACCTD_AMT | NUMBER | Total purchases or sales based on the ledger currency. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER2 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER3 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER4 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER5 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER6 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER7 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER8 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER9 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER10 | NUMBER | 22 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_PGM_BUDGET_SUMMARY_N1 | Non Unique | Default | PROGRAM_HEADER_ID |
| CJM_PGM_BUDGET_SUMMARY_U1 | Unique | Default | PROG_BUDGET_SUM_ID |