CJM_MANUAL_ADJUSTMENTS_ALL_B
CJM_MANUAL_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_PROGRAMS_UTILIZED_ALL_B.MANUAL_ADJUSTMENT_ID column. One set of user input for the manual adjustment record can create multiple records in CJM_PROGRAM_UTILIZED_ALL_B 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_MANUAL_ADJ_ALL_B_PK |
MANUAL_ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| MANUAL_ADJUSTMENT_ID | NUMBER | 18 | Yes | Unique identifier for the CJM_MANUAL_ADJUSTMENTS_ALL_B table | ||
| MANUAL_ADJUSTMENT_NUMBER | VARCHAR2 | 30 | Unique adjustment number. | |||
| 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. | |||
| BU_ID | NUMBER | 18 | Yes | Business unit for which adjustments are created and accounted. | ||
| BILL_TO_BU_ID | NUMBER | 18 | Bill to Business Unit derived from the Supplier Site Assignment where the Client Business Unit is the Order Business Unit. | Obsolete | ||
| STATUS_CODE | VARCHAR2 | 30 | Identifies the status of the manual adjustment record. Values are from the lookup ORA_CJM_MANUAL_ADJ_STATUS. | |||
| ACCRUAL_TYPE_CODE | VARCHAR2 | 30 | Identifies whether the accrual record is created for CUSTOMER or SUPPLIER. Values are from the lookup ORA_CJM_ACCRUAL_TYPE. | |||
| 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 | User created adjustment type identifier from CJM_ADJUSTMENT_TYPES_B table. | |||
| BENEFICIARY_TYPE_CODE | VARCHAR2 | 30 | Identifies the beneficiary type like CUSTOMER, BILL_TO, SHIP_TO and so on for which accruals are created. Values are validated using the lookup ORA_CJM_BENEFICIARY_TYPE. | |||
| VENDOR_ID | NUMBER | 18 | Contains the vendor ID for vendor rebate program. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Contains the vendor site ID for vendor rebate program. | |||
| PARTY_ID | NUMBER | 18 | Contains the party ID for CUSTOMER if a beneficiary is defined for a channel program for CUSTOMER, BILL_TO, SHIP_TO, and PARTY. If there is no beneficiary, this contains the party ID of the sales order customer. | |||
| CUST_ACCOUNT_ID | NUMBER | 18 | Contains customer account ID if beneficiary is of type CUSTOMER, BILL_TO and is undefined for SHIP_TO, PARTY AND VENDOR. If there is no beneficiary, this contains the account ID of the sales order customer. | |||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Contains the CUST_ACCOUNT_ID of the sales order customer. | |||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Contains the bill to site use ID if beneficiary is BILL_TO and is undefined for other beneficiary types. If there is no beneficiary, this contains the bill to site use ID of the sales order customer. | |||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Contains the ship to party site ID if beneficiary is SHIP_TO and is undefined for other beneficiary types. If there is no beneficiary, this contains the ship to party site ID of the sales order customer. | |||
| PROGRAM_HEADER_ID | NUMBER | 18 | Identifies the program header ID for which accruals are created. This is a foreign key from the CJM_PROGRAMS_ALL_B table. | |||
| PROGRAM_LINE_ID | NUMBER | 18 | Identifies the program line ID for which accruals are created. This is a foreign key from the CJM_PROGRAM_LINES table. | |||
| ITEM_LEVEL_CODE | VARCHAR2 | 30 | Identifies the product level code. Values are from the lookup ORA_CJM_ITEM_LEVEL. | |||
| ITEM_ID | NUMBER | 18 | Identifies the unique identifier for the product level code, contains the inventory item ID in the case of ITEM. | |||
| OBJECT_TYPE | VARCHAR2 | 30 | Identifies the type of object for which accruals are created, such as Invoice, Third Party Order, Sales Order, and so on. Values are from the lookup ORA_CJM_DOCUMENT_TYPE. | |||
| OBJECT_ID | NUMBER | 18 | Contains the unique identifier for the object type, for example, the resale header ID for third party orders, and order header ID for sales orders. | |||
| OBJECT_LINE_ID | NUMBER | 18 | Contains the object line ID, such as fulfillment line ID in the case of a direct sales order and resale line in the case of a third party order. This will be used as the alternate key for FOM integration for charge and charge components tables. | |||
| ADJUSTMENT_AMOUNT | NUMBER | Identifies the accrual amount in the transaction currency, for example, the accrual amount is the sales order currency in the case of a direct sales order. | ||||
| ADJUSTMENT_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the transaction currency code, for example, order currency code in the case of a direct sales order. | |||
| REQUESTED_GL_DATE | DATE | General Ledger posting date. This is a user entered field, It can be a past date, which should be in the open accounting period or the system date. This cannot 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. | ||||
| INVOICE_DATE | DATE | Contains the invoiced date for the sales order, referenced from DOO_FULFILL_LINE_DETAILS.BILLING_TRANSACTION_DATE column. | ||||
| INVOICE_ID | NUMBER | 18 | Contains the invoice ID generated for the sales order. This is referenced from RA_CUSTOMER_TRX_LINES.CUSTOMER_TRX_ID column based on the CUSTOMER_TRX_LINE_ID stored in DOO_FULFILL_LINE_DETAILS table. | |||
| INVOICE_NUMBER | VARCHAR2 | 50 | Identifies the invoice number for the sales order, referenced from DOO_FULFILL_LINE_DETAILS.BILLING_TRANSACTION_NUMBER column. | |||
| INVOICE_SOURCE_CODE | VARCHAR2 | 50 | Alternate key for the invoice ID along with the invoice number. | |||
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Identifies the invoice line ID for the sales order line, referenced from DOO_FULFILL_LINE_DETAILS.CUSTOMER_TRX_LINE_ID column. | |||
| INVOICE_LINE_NUMBER | NUMBER | Identifies the invoice line number for the fulfillment lines, referenced from column RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER column. | ||||
| ADJUSTMENT_REASON_ID | NUMBER | 18 | User will pass the adjustment reason while creating the manual adjustment record and this reason id be a reference to the unique identifier for the adjustment reason created in the system for a given adjustment type. | |||
| TP_ITEM_ID | NUMBER | 18 | Unique identifier for the supplier item. | |||
| INVOICE_SOURCE_APPLICATION | VARCHAR2 | 30 | Invoice source application for which invoice details are stored. Possible values are AR and AP. | |||
| RECEIPT_ID | NUMBER | 18 | Identifier of the receipt associated with the manual adjustment. | |||
| RECEIPT_NUMBER | VARCHAR2 | 30 | Receipt number associated with the manual adjustment. | |||
| EXPECTED_RECEIPT_DATE | DATE | Expected arrival date of the shipment. | ||||
| PO_HEADER_ID | NUMBER | 18 | Identifier of the purchase order associated with the manual adjustment. | |||
| PO_NUMBER | VARCHAR2 | 30 | Purchase order number associated with the manual adjustment. | |||
| TRANSACTION_ID | NUMBER | 18 | Unique identifier for the receiving transaction associated with the manual adjustment. | |||
| PO_DATE | DATE | Indicates the purchase order date. | ||||
| TRANSACTION_DATE | DATE | Date of the receiving transaction. | ||||
| SOURCE_UTILIZATION_ID | NUMBER | 18 | Identifies the source utilization ID, which is the value of the utilization used for the adjustment. | |||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Unique identifier of the inventory organization where the receipt and shipment are created. | |||
| OWNER_ID | NUMBER | 18 | Identifier of the system user who created the adjustment. | |||
| APPROVED_BY | NUMBER | 18 | User who approved the adjustment. | |||
| APPROVED_DATE | DATE | Date when the adjustment was approved. | ||||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Unique identifier of the bill-to location. (References HR_LOCATIONS_ALL.location_id) | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Unique identifier of the ship-to location. (References HR_LOCATIONS_ALL.location_id) | |||
| ORIG_SYSTEM_SOURCE | VARCHAR2 | 240 | Source information of the originating system. | |||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Indicates the document type. Values are from the lookup CJM_DOCUMENT_TYPES. | |||
| OBJECT_LINE_REASON_CODE | VARCHAR2 | 30 | Unique identifier of the object line reason. | Obsolete | ||
| OBJECT_LINE_REASON | VARCHAR2 | 240 | Indicates the reason associated with the object line. | |||
| ORIG_OBJECT_NUMBER | VARCHAR2 | 50 | Indicates the original order number. | |||
| ORIG_OBJECT_LINE_NUM | NUMBER | 18 | Indicates the line number of original object. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Identifies the exchange rate type for the manual adjustment (example: CORPORATE). | |||
| EXCHANGE_RATE_DATE | DATE | Identifies the exchange rate date for the manual adjustment. | ||||
| ACCRUAL_REVERSAL_FLAG | VARCHAR2 | 1 | Identifies if the accrual adjustment record is a reversal. This column is set to Y if the record is marked as a reversal. | |||
| OWNER_USER_ID | NUMBER | 18 | Indicates the value for the OWNER_ID before data migration. This is the identifier for the system user who created the adjustment. | |||
| 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 | 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cjm_manual_adjustments_all_tl | cjm_manual_adjustments_all_b | MANUAL_ADJUSTMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CJM_MANUAL_ADJ_ALL_B_N1 | Non Unique | Default | ADJUSTMENT_TYPE_ID | |
| CJM_MANUAL_ADJ_ALL_B_N2 | Non Unique | Default | VENDOR_ID, VENDOR_SITE_ID, BU_ID | |
| CJM_MANUAL_ADJ_ALL_B_N3 | Non Unique | Default | OBJECT_TYPE, OBJECT_ID | |
| CJM_MANUAL_ADJ_ALL_B_N4 | Non Unique | Default | OBJECT_LINE_ID | |
| CJM_MANUAL_ADJ_ALL_B_N5 | Non Unique | Default | INVOICE_NUMBER | Obsolete |
| CJM_MANUAL_ADJ_ALL_B_N6 | Non Unique | Default | ADJUSTMENT_DATE | |
| CJM_MANUAL_ADJ_ALL_B_N7 | Non Unique | Default | UPPER("INVOICE_NUMBER") | |
| CJM_MANUAL_ADJ_ALL_B_U1 | Unique | Default | MANUAL_ADJUSTMENT_ID |