CJM_DOCUMENT_PROGRAMS_GT
This table contains intermediate data to be processed for the creation of accruals for annual volume programs.This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CJM_DOCUMENT_PROGRAMS_GT_PK |
DOCUMENT_PROGRAM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_PROGRAM_ID | NUMBER | Yes | Unique identifier for the document program. | ||
| PROGRAM_HEADER_ID | NUMBER | 18 | Identifier of CJM_PROGRAMS_ALL_B table. | ||
| PROGRAM_LINE_ID | NUMBER | 18 | Identifier of CJM_PROGRAM_LINES table. | ||
| DOCUMENT_BATCH_ID | NUMBER | 18 | Identifier of document batches. | ||
| DOCUMENT_HEADER_ID | NUMBER | 18 | Identifier of the document headers. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Identifier of the document lines. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| BU_ID | NUMBER | 18 | Yes | Identifier of the business unit for which accruals are created. | |
| PARTY_ID | NUMBER | 18 | Unique identifier of the party. | ||
| VENDOR_ID | NUMBER | 18 | Program header level supplier information. | ||
| VENDOR_SITE_ID | NUMBER | 18 | Program header level supplier site information. | ||
| CUST_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the customer account. | ||
| TRX_BILL_TO_SITE_USE_ID | NUMBER | 18 | Unique identifier for the bill-to site use for the selected sales order customer account site. This column stores the bill-to business purpose that is assigned to the sales order customer account site. | ||
| BILL_TO_CUST_ACCOUNT_ID | NUMBER | 18 | Unique identifier for the bill-to customer account. | ||
| BILL_TO_SITE_USE_ID | NUMBER | 18 | Unique identifier for the usage of bill-to site for the selected customer account. | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Contains the ship to party site Identifier for the customer. | ||
| ITEM_ID | NUMBER | 18 | Item for which accruals are created. | ||
| CATEGORY_ID | NUMBER | 18 | Contains the item category ID information. | ||
| TRANSACTION_CURR_CODE | VARCHAR2 | 15 | Currency code of the transaction record. | ||
| TRANSACTION_CURR_AMOUNT | NUMBER | Identifies the accrual amount in the transaction currency. | |||
| TRANSACTION_DATE | DATE | Period end date for which accruals are run. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period name of the supplier calendar. | ||
| YEAR_ID | NUMBER | 18 | Identifies the calendar year for which the accruals were created. | ||
| DISCOUNT_TYPE | VARCHAR2 | 30 | Discount type at the program tier header level. | ||
| TIER_TYPE_CODE | VARCHAR2 | 30 | Tier type for a given discount table. | ||
| PROGRAM_LINE_UOM_CODE | VARCHAR2 | 3 | Unit of measure for the program line. | ||
| ACCRUAL_QTY | NUMBER | Total quantity for which accruals are created. | |||
| ACCRUAL_UOM | VARCHAR2 | 3 | Unit of measure of the accrual quantity for which accruals are created. | ||
| SEEDED_PROGRAM_TYPE_CODE | VARCHAR2 | 30 | Contains the predefined program type code. | ||
| DISTRIBUTOR_ID | NUMBER | 18 | Supplier identifier of the distributor of the supplier program. | ||
| BILL_TO_LOCATION_ID | NUMBER | 18 | Unique identifier for the bill-to location. References HR_LOCATIONS_ALL.location_id. | ||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Unique identifier for the ship-to location. References HR_LOCATIONS_ALL.location_id. | ||
| TIER_HEADER_ID | NUMBER | 18 | Tier header for which accruals are created. | ||
| CALCULATION_METHOD_CODE | VARCHAR2 | 30 | Tier calculation method supported by the program. Values are from the lookup ORA_CJM_TIER_CALC_METHOD. | ||
| INCLUDE_VOL_EXCLUDE_DIS_FLAG | VARCHAR2 | 1 | Indicates if volume must be considered and discount excluded for volume programs. | ||
| TOTAL_AMOUNT | NUMBER | Contains the aggregated amount information. | |||
| ROW_NUM | NUMBER | Row number of the aggregated data. | |||
| CURRENT_VOLUME | NUMBER | Current volume for the given supplier, item, and transaction date. | |||
| EXISTING_VOLUME | NUMBER | Indicates the existing volume for the tier header. | |||
| CUMULATIVE_VOLUME | NUMBER | Indicates the cumulative volume for the tier header. | |||
| FUNCTIONAL_CURRENCY | VARCHAR2 | 3 | Functional currency code of the given channel program. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Identifies the exchange rate type for which accruals are created. For example, CORPORATE. | ||
| PROGRAM_TIER_LINE_ID | NUMBER | 18 | Unique identifier for program tier lines. | ||
| CURRENT_TIER_LINE_NUMBER | NUMBER | User friendly alternate key for the current tier line number. | |||
| CURRENT_DISCOUNT | NUMBER | Current discount for the tier header. | |||
| PRE_QUALIFYING_TIER_LINE_NUM | NUMBER | User friendly alternate key for the pre-qualifying tier line number. | |||
| PRE_QUALIFYING_TIER_FLAG | VARCHAR2 | 1 | Indicates if the tier must start from the current tier line. | ||
| PRE_QUALIFYING_TIER_DISCOUNT | NUMBER | Discount for the pre-qualifier tier line. | |||
| PRE_QUALIFYING_TIER_MAX_VALUE | NUMBER | Maximum tier value for the pre qualifying tier line. | |||
| MAXIMUM_TIER_VALUE | NUMBER | Maximum tier value for the tier header. | |||
| MAXIMUM_TIER_DISCOUNT | NUMBER | Discount for the maximum tier in the tier header. | |||
| MAXIMUM_TIER_LINE_NUMBER | NUMBER | Discount for the maximum tier line number in the tier header. | |||
| VOLUME_EXCEEDED_FLAG | VARCHAR2 | 1 | Indicates if the volume exceeds the maximum tier value. | ||
| INVOICE_NUMBER | VARCHAR2 | 50 | Identifies the invoice number for the sales order. | ||
| INVOICE_LINE_NUMBER | NUMBER | Identifies the invoice line number for the sales order line. | |||
| PO_NUMBER | VARCHAR2 | 30 | Contains the purchase order number for the loaded sale data. | ||
| SALES_AMOUNT | NUMBER | Indicate the sales amount for the document line. | |||
| TRANSACTION_QTY | NUMBER | Indicates the transaction quantity for the document line. | |||
| TOTAL_SALES_AMOUNT | NUMBER | Indicates the total sales amount for the aggregated document lines. | |||
| TRANSACTION_UNIT_PRICE | NUMBER | Contains the transaction unit price for the original transaction. | |||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Contains the item validation identifier for the inventory organization. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CJM_DOCUMENT_PROGRAMS_GT_N1 | Non Unique | ROW_NUM |
| CJM_DOCUMENT_PROGRAMS_GT_U1 | Unique | DOCUMENT_PROGRAM_ID |