CJM_CUST_ADJUSTMENTS_ALL_B
CJM_CUST_ADJUSTMENTS_ALL_B contains the manual adjustment record information as per the inputs provided by the user, including all adjustment records created for Increase Earned, Decrease Earned, Increase Paid, and Decrease Paid. Primary key for this table is stored in CJM_CUSTOMER_ACCRUALS_ALL.MANUAL_ADJUSTMENT_ID column. One set of user input for the manual adjustment record can create multiple records in CJM_CUSTOMER_ACCRUALS_ALL table in case of Decrease Earned adjustments if First In, First Out logic gets executed.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_CUST_ADJUSTMENTS_ALL_B_PK |
MANUAL_ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MANUAL_ADJUSTMENT_ID | NUMBER | 18 | Yes | Unique identifier for the manual adjustment. | |
| REJECTED_DATE | DATE | Date when the adjustment was rejected. | |||
| MANUAL_ADJUSTMENT_NUMBER | VARCHAR2 | 30 | Unique number for the manual adjustment. | ||
| 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. | ||
| BU_ID | NUMBER | 18 | Yes | Business unit for which adjustments are created and accounted. | |
| STATUS_CODE | VARCHAR2 | 30 | Identifies the status of the manual adjustment record. Values are from the CJM_USER_STATUSES_B table. | ||
| USER_STATUS_ID | NUMBER | 18 | Identifies the predefined status for the manual adjustment. This is the foreign key to CJM_USER_STATUSES_B table. | ||
| ADJUSTMENT_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of adjustment, such as INCREASE_EARNED, DECREASE_EARNED, INCREASE_PAID, and DECREASE_PAID. Values are from the lookup ORA_CJM_ADJUSTMENT_TYPE. | ||
| ADJUSTMENT_TYPE_ID | NUMBER | 18 | Identifies the adjustment type from the CJM_ADJUSTMENT_TYPES_B table. | ||
| ADJUSTMENT_REASON_ID | NUMBER | 18 | Unique identifier for the adjustment reason created in the system. | ||
| ENABLE_BENEFICIARY_FLAG | VARCHAR2 | 1 | Determines if the beneficiary is in the Manual Adjustments. | ||
| BENEFICIARY_TYPE_CODE | VARCHAR2 | 30 | Identifies beneficiary type information such as CUSTOMER, BILL_TO, SHIP_TO and so on for which accruals are created. Values are validated using the lookup ORA_CJM_BENEFICIARY_TYPE. | ||
| BENEFICIARY_VALUE_CODE | NUMBER | This stores values such as customer account ID in case of CUSTOMER, bill-to site use ID in case of BILL_TO and so on. | |||
| TRX_CUST_ACCOUNT_ID | NUMBER | 18 | Contains the account ID of the bill-to customer. | ||
| TRX_BILL_TO_SITE_USE_ID | NUMBER | 18 | Contains the bill-to site use ID of the bill-to site for the customer account. | ||
| PROGRAM_HEADER_ID | NUMBER | 18 | Identifies the program header for which adjustment accruals are created. This is a foreign key to the CJM_PROGRAMS_ALL_B table. | ||
| ADJUSTMENT_AMOUNT | NUMBER | Identifies the adjustment amount in transaction currency. | |||
| ADJUSTMENT_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the transaction currency code for the adjustment, for example, the the adjustment currency code is order currency code in case of a direct sales order. | ||
| REQUESTED_GL_DATE | DATE | User specified General Ledger posting date. This can either be the system date or it can be a date in the past, however, it can't be a future date. | |||
| ADJUSTMENT_DATE | DATE | User entered field containing system or future date. System date is used if not set by the user. | |||
| ADJUST_BY_PRODUCT_FLAG | VARCHAR2 | 1 | Determines if the adjustment is at the program level or at the product level. The default value is N, which implies that the adjustment is at the program level. | ||
| INVOICE_NUMBER | VARCHAR2 | 50 | Identifies the invoice number of the transaction. | ||
| INVOICE_DATE | DATE | The invoice date for the sales order. | |||
| OWNER_ID | NUMBER | 18 | Identifier of the system user who created the adjustment. | ||
| SUBMITTED_BY | NUMBER | 18 | User who submitted the adjustment. | ||
| SUBMITTED_DATE | DATE | Date when the adjustment was submitted. | |||
| APPROVED_DATE | DATE | Date when the adjustment was approved. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | 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 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | 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_CUST_ADJUSTMENTS_ALL_B_N1 | Non Unique | Default | ADJUSTMENT_TYPE_ID |
| CJM_CUST_ADJUSTMENTS_ALL_B_N2 | Non Unique | Default | PROGRAM_HEADER_ID |
| CJM_CUST_ADJUSTMENTS_ALL_B_N3 | Non Unique | Default | ADJUSTMENT_DATE |
| CJM_CUST_ADJUSTMENTS_ALL_B_N4 | Non Unique | Default | TRX_CUST_ACCOUNT_ID, BU_ID |
| CJM_CUST_ADJUSTMENTS_ALL_B_N5 | Non Unique | Default | TRX_BILL_TO_SITE_USE_ID, BU_ID |
| CJM_CUST_ADJUSTMENTS_ALL_B_U1 | Unique | Default | MANUAL_ADJUSTMENT_ID |