CJM_PROGRAMS_UTILIZED_ALL_B
CJM_PROGRAMS_UTILIZED_ALL_B contains all Accrual records generated via both the Channel Program Accrual Engine ESS Job as well as the Manual Adjustment process. This table contains all accrual records created for a Direct Sales Order, Indirect Sales Order, Increased Earned, Decrease Earned, Increase Paid and Decrease Paid Adjustment records. Accruals with gl_posted_flag set to Y are calculated as the Earned Amount, while the sum of all accruals for a given Program and Budget Combination is considered the Utilized amount.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_PGM_UTIL_ALL_B_PK |
UTILIZATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| UTILIZATION_ID | NUMBER | 18 | Yes | Identifies the unique identifier for the CJM_PROGRAMS_UTILIZED_ALL_B 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. | |||
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| 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 | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Unique identifier for the legal entity. If an identifier is not specified, the default legal entity of the business unit is assigned by the system. | Obsolete | ||
| 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. | |||
| BUDGET_ID | NUMBER | 18 | Identifies the Budget against which the Accruals are created. | Obsolete | ||
| UTILIZATION_TYPE | VARCHAR2 | 30 | Identifies the type of utilization, such as Accrual, Utilized, or Adjustment record. Values are from Lookup ORA_CJM_UTILIZATION_TYPE. | |||
| ADJUSTMENT_TYPE | VARCHAR2 | 30 | Identifies the Type of Adjustment, such as INCREASE_EARNED, DECREASE_EARNED, INCREASE_PAID , DECREASE_PAID. Values are from the Lookup ORA_CJM_ADJUSTMENT_TYPE. | |||
| ADJUSTMENT_TYPE_ID | NUMBER | 18 | Identifies the Adjustment type ID for the different Adjustment Types. | |||
| 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 Lookup ORA_CJM_DOCUMENT_TYPE. | |||
| OBJECT_ID | NUMBER | 18 | Contains the Unique identifier for the Object Type, the Invoice ID in the case of INVOICE, the resale header ID in the case of Third Party Orders, and Order Header ID in the case of Sales Order. | |||
| 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 table. | |||
| CHARGE_DEFINITION_CODE | VARCHAR2 | 120 | This code is created in the Pricing module and it represents the unique combination of Charge Type, Charge Sub Type, and Price Type Code. This will be used as the alternate key for FOM integration for charge and Charge Components table. | |||
| PRICE_PERIODICITY_CODE | VARCHAR2 | 120 | This code is populated when the price type code is Recurring. It contains values, such as Weeks, Months , Hours, and so on. This will be used as the alternate key for FOM integration for charge and Charge Components table. | |||
| PRICE_ELEMENT_CODE | VARCHAR2 | 120 | The price element code for which Channel Charges are created. This will be used as the alternate key for FOM integration for charge and Charge Components table. This will be used as the alternate key for FOM integration for charge and Charge Components table. | |||
| PRICING_SOURCE_TYPE_CODE | VARCHAR2 | 30 | For Channel Charges, this contains the value as 'PRICING_TERM'. This will be used as the alternate key for FOM integration for charge and Charge Components table. | |||
| PRICING_SOURCE_ID | VARCHAR2 | 30 | The pricing source ID contains the pricing term ID applied to a sales order for which charge components are generated in Fusion Order Management. This will be used as the alternate key for FOM integration for charge and Charge Components table. | |||
| ITEM_LEVEL_CODE | VARCHAR2 | 30 | Identifies the Product Level Code for which Exclusion is created (example: ITEM or ALL_ITEMS). Value will be populated in this column using the look up code 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 PRODUCT, and the category ID in the case of PRODUCT_FAMILY. | |||
| TRANSACTION_CURR_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. | ||||
| TRANSACTION_CURR_AMOUNT_REM | NUMBER | Identifies the Accrual remaining Amount in the Transaction currency, for example it contains the accrual remaining amount not yet claimed. | ||||
| TRANSACTION_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Transaction Currency Code, for example order currency code in the case of a Direct Sales Order. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Identifies the Exchange Rate Type for which Accruals are created (example: CORPORATE). | |||
| EXCHANGE_RATE_DATE | DATE | Identifies the Exchange Rate date on which the Accruals were created. | ||||
| EXCHANGE_RATE | NUMBER | Contains the Exchange Rate of Transactional Currency to Functional Currency. | ||||
| ACCTD_AMOUNT | NUMBER | Identifies the Accrual Amount functional currency. | ||||
| ACCTD_AMOUNT_REMAINING | NUMBER | Identifies the Accrual remaining Amount functional currency. | ||||
| PROGRAM_AMOUNT | NUMBER | Identifies the Accrual Amount in the Channel Program currency. | ||||
| PROGRAM_AMOUNT_REMAINING | NUMBER | Identifies the Accrual remaining amount in the Channel Program currency. | ||||
| PROGRAM_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Channel Program Currency code in which the budget is requested. | |||
| BUDGET_AMOUNT | NUMBER | Identifies the Accrual Amount in the Budget Currency. | Obsolete | |||
| BUDGET_AMOUNT_REMAINING | NUMBER | Identifies the Accrual remaining Amount in the Budget Currency. | Obsolete | |||
| BUDGET_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the budget source currency code. | Obsolete | ||
| GL_DATE | DATE | Identifies the General Ledger Posting Date. This contains the Actual Shipment date or the Invoice date in the case of a Direct Sales order (Based on GL posting profile) and Invoiced date in the case of RMA orders. | ||||
| REQUESTED_GL_DATE | DATE | General Ledger posting date.Contains the actual shipment date or the invoice date in the case of a direct sales orders (based on GL posting profile) and invoiced date in case of RMA orders. For manual adjustments,this is a user entered field and can be a past date or system date. While posting the records to GL, as per sweep fix, if the period is closed, the records gets posted this is a user entered field and can be a past date or system date. While posting the records to GL, as per sweep fix, if the period is closed, the records gets posted in the next open GL period and this column is updated with the actual GL posted date. | ||||
| MANUAL_ADJUSTMENT_ID | NUMBER | 18 | Foreign key reference from CJM_MANUAL_ADJUSTMENTS_ALL_B table for manual adjustment records. One set of user Input for Manual Adjustment record can create multiple records in CJM_PROGRAM_UTILIZED_ALL_B table in case of Decreased_Earned Adjustments if First In First Out Logic will gets executed. | |||
| INVOICE_SOURCE_CODE | VARCHAR2 | 50 | Alternate key for the invoice ID, along with the invoice number. | |||
| GL_POSTED_FLAG | VARCHAR2 | 1 | Identifies if the Accrual Record was posted in GL. This column is set to Y if the record posted successfully, F if the GL posting failed due to any errors with the Accrual record and the record will then be reprocessed in the next run, and N if the Accrual Record is not yet posted to GL. | |||
| ADJUSTMENT_DATE | DATE | Identifies the creation date of the Charge components in the case of a Direct Sales Order and the Program Accrual Engine start date in the case of backdated Adjustment Records. | ||||
| PARTY_ID | NUMBER | 18 | If a Beneficiary is defined for a channel program, this contains the party ID for CUSTOMER in the case of CUSTOMER, BILL To, SHIP TO, PARTY. Otherwise, it contains the party_id for the Sales Order customer. | |||
| CUST_ACCOUNT_ID | NUMBER | 18 | Contains the cust_account_id in the case Beneficiary is of type CUSTOMER, BILL_TO and Null in the case of SHIP_TO, PARTY AND VENDOR. If there is no Beneficiary, it contains the account identifier of the sales order customer. | |||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | This will always contain the cust_account_id for Sales Order Customer. | |||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Contains the Bill To site use ID if BENEFICIARY is BILL_TO, or this contains NULL for other Beneficiary types. If there is no Beneficiary, it 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 or this contains NULL for other Beneficiary types. If there is no Beneficiary, it contains the ship to party site ID of sales order customer. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period name of the supplier calendar. | |||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Bill-to location information for invoice line transactions for the annual programs aggregated records. | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Ship-to location information for invoice line transactions for the annual programs aggregated records. | |||
| VENDOR_ID | NUMBER | 18 | Contains the Vendor ID for Vendor Rebate Program. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Contains the Vendor site ID for the Vendor Rebate Program. | |||
| ACCRUAL_QTY | NUMBER | Contains the Quantity information for which the Accrual record was created. | ||||
| ACCRUAL_UOM | VARCHAR2 | 15 | Contains the UoM information for which the Accrual record was created. | |||
| REFERENCE_TYPE | VARCHAR2 | 30 | Identifies the Reference Type. For example, it contains BATCH in the case of an Indirect sales Order and SD_REQUEST in case of Ship and Debit Offer. Values are from Lookup ORA_CJM_UTIL_REFERENCE_TYPE. | |||
| REFERENCE_ID | NUMBER | 18 | Identifies the Reference ID. For example, it contains the Resale Batch ID in the case of an Indirect Sales Order. | |||
| INVOICE_SOURCE_APPLICATION | VARCHAR2 | 30 | Invoice source application for which invoice details are stored. Possible values are AR and AP. | |||
| INVOICE_DATE | DATE | Contains the invoiced date for the sales order. This will be referenced from DOO_FULFILL_LINE_DETAILS.BILLING_TRANSACTION_DATE column. | ||||
| INVOICE_ID | NUMBER | 18 | Contains the invoice ID generated for the sales Order. This will be 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. This will be referenced from DOO_FULFILL_LINE_DETAILS.BILLING_TRANSACTION_NUMBER column. | |||
| INVOICE_LINE_NUMBER | NUMBER | Identifies the Invoice Line Number for the Fulfillment Lines. This will be referenced from column RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER column. | ||||
| WAYBILL_NUMBER | VARCHAR2 | 30 | Waybill or airbill number for the shipment. This will be referenced from DOO_FULFILL_LINE_DETAILS.WAYBILL_NUMBER column. | |||
| BILL_OF_LADING_NUMBER | VARCHAR2 | 120 | A carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address. This will be referenced from DOO_FULFILL_LINE_DETAILS.BILL_OF_LADING_NUMBER column. | |||
| ACCRUAL_TYPE | VARCHAR2 | 30 | Identifies whether the accrual record is created for CUSTOMER or SUPPLIER. Value will be populated in this column using the look up code ORA_CJM_ACCRUAL_TYPES. | |||
| BENEFICIARY_TYPE | VARCHAR2 | 30 | Identifies the Beneficiary Type like CUSTOMER, BILL_TO, SHIP_TO etc. for which Accruals are created. Lookup ORA_CJM_BENEFICIARY_TYPE will be used to validate the value for this column. | |||
| SHIPMENT_DATE | DATE | Identifies the Actual Shipment Date for the Sales Order. | ||||
| SHIPMENT_NUMBER | VARCHAR2 | 30 | Identifies the Shipment Number for the Sales Order. This will be referenced from DOO_FULFILL_LINE_DETAILS.DELIVERY_NAME column. | |||
| ORIG_UTILIZATION_ID | NUMBER | 18 | Identifies the Original utilization ID. This column holds the Values in the case of Split Scenarios or RMA with a reference order. | |||
| YEAR_ID | NUMBER | 18 | Identifies the Calender Year for which the Accruals were created. | |||
| COST_PRICE | NUMBER | Identifies the Cost Price which needs to be considered for the Vendor Rebate Program. | Obsolete | |||
| COST_PRICE_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Cost Price Currency Code which needs to be considered for the Vendor Rebate Program. | Obsolete | ||
| DISCOUNT_TYPE | VARCHAR2 | 30 | Identifies the Discount Type for the Vendor Rebate Program. | |||
| DISCOUNT_AMOUNT | NUMBER | Identifies the Discount Type for the Vendor Rebate Program. | ||||
| DISCOUNT_AMOUNT_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the Discount Amount Currency code for the Vendor Rebate Program. | Obsolete | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Identifies the Invoice Line Id for the Sales order Line. This will be referenced from DOO_FULFILL_LINE_DETAILS.CUSTOMER_TRX_LINE_ID 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. | |||
| DOCUMENT_PROGRAM_ID | NUMBER | 18 | Foreign key reference from CJM_DOCUMENT_PROGRAMS table. | |||
| ACCRUAL_TRX_TYPE | VARCHAR2 | 30 | Transaction information for the accrual quantity, accrual UOM and transaction unit price for which the accrual record is created. Possible values are RECEIPT, INVOICE and ORDER | |||
| TRANSACTION_UNIT_PRICE | NUMBER | Transaction unit price for the accrual record. | ||||
| PROGRAM_LINE_UOM_CODE | VARCHAR2 | 3 | Program Line UOM Code for the Accrual record. | |||
| ACCRUAL_QTY_IN_PROG_LINE_UOM | NUMBER | Accrual Quantity in program line UOM. Contains the converted value if the program line UOM and transaction UOM are different. | ||||
| EARNED_ACCRUALS_EVENT | VARCHAR2 | 30 | GL posting event value for earned accruals. | |||
| RECEIPT_ID | NUMBER | 18 | Identifier of the receipt associated with the utilization. | |||
| RECEIPT_NUMBER | VARCHAR2 | 50 | Receipt number associated with the utilization. | |||
| PO_HEADER_ID | NUMBER | 18 | Identifier of the purchase order associated with the utilization. | |||
| PO_NUMBER | VARCHAR2 | 30 | Purchase order number associated with the utilization. | |||
| TRANSACTION_ID | NUMBER | 18 | Unique identifier for the receiving transaction associated with the utilization. | |||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Unique identifier of the document shipment schedule from CJM_DOCUMENT_LINES_ALL table. | |||
| MATCH_OPTION | VARCHAR2 | 25 | Indicates whether the shipment invoice should match the purchase order or the receipt. This is the same column from CJM_DOCUMENT_LINES_ALL table. | |||
| SEEDED_PROGRAM_TYPE_CODE | VARCHAR2 | 30 | Predefined program type values. Values are from the lookup ORA_CJM_SEEDED_PROGRAM_TYPE. | |||
| DISTRIBUTOR_SITE_ID | NUMBER | 18 | Supplier site ID of the distributor for the supplier rebate program. | |||
| ACCRUAL_QTY_IN_INV_UOM | NUMBER | For the receipt match option, indicates the receipt quantity for the receipt UOM. For the order match option, indicates the quantity for the PO UOM. | ||||
| ALTERNATE_SOURCE_ID | NUMBER | 18 | Contains the alternate source information. | Obsolete | ||
| CATEGORY_ID | NUMBER | 18 | Reference to the unique identifier of the item category the item belongs to. | |||
| SOURCE_TRX_AMOUNT_IN_PRG_CURR | NUMBER | Source transaction amount in the program currency. | ||||
| SOURCE_TRX_AMOUNT_IN_TRX_CURR | NUMBER | Source transaction amount in the transaction currency. | ||||
| SOURCE_TRX_ACCTD_AMOUNT | NUMBER | Source transaction amount in the ledger currency. | ||||
| DISTRIBUTOR_ID | NUMBER | 18 | Supplier identifier of the distributor for the supplier program. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cjm_programs_utilized_all_tl | cjm_programs_utilized_all_b | UTILIZATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CJM_PROG_UTIL_ALL_B_N1 | Non Unique | Default | PROGRAM_HEADER_ID | Obsolete |
| CJM_PROG_UTIL_ALL_B_N10 | Non Unique | Default | PO_NUMBER | |
| CJM_PROG_UTIL_ALL_B_N11 | Non Unique | Default | MANUAL_ADJUSTMENT_ID | |
| CJM_PROG_UTIL_ALL_B_N12 | Non Unique | Default | GL_POSTED_FLAG, SEEDED_PROGRAM_TYPE_CODE, OBJECT_TYPE, MATCH_OPTION | |
| CJM_PROG_UTIL_ALL_B_N13 | Non Unique | Default | TRANSACTION_ID | |
| CJM_PROG_UTIL_ALL_B_N14 | Non Unique | Default | PROGRAM_HEADER_ID, ITEM_ID | |
| CJM_PROG_UTIL_ALL_B_N15 | Non Unique | Default | PO_LINE_LOCATION_ID | |
| CJM_PROG_UTIL_ALL_B_N16 | Non Unique | Default | ADJUSTMENT_DATE | |
| CJM_PROG_UTIL_ALL_B_N2 | Non Unique | Default | VENDOR_ID, VENDOR_SITE_ID, BU_ID | |
| CJM_PROG_UTIL_ALL_B_N3 | Non Unique | Default | UTILIZATION_TYPE | |
| CJM_PROG_UTIL_ALL_B_N4 | Non Unique | Default | OBJECT_TYPE, OBJECT_ID | |
| CJM_PROG_UTIL_ALL_B_N5 | Non Unique | Default | ADJUSTMENT_TYPE_ID | |
| CJM_PROG_UTIL_ALL_B_N6 | Non Unique | Default | OBJECT_LINE_ID, PRICING_SOURCE_ID | |
| CJM_PROG_UTIL_ALL_B_N7 | Non Unique | Default | INVOICE_NUMBER | |
| CJM_PROG_UTIL_ALL_B_N8 | Non Unique | Default | ITEM_ID | Obsolete |
| CJM_PROG_UTIL_ALL_B_N9 | Non Unique | Default | RECEIPT_NUMBER | |
| CJM_PROG_UTIL_ALL_B_U1 | Unique | Default | UTILIZATION_ID |