CMR_TRADE_OVERHEADS
This table stores overhead cost for all trade events to be processed by receipt accounting.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CMR_TRADE_OVERHEADS_PK |
TRADE_OVERHEAD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_OVERHEAD_ID | NUMBER | 18 | Yes | Trade event overhead identifier and surrogate key column. | |
| TRADE_EVENT_ID | NUMBER | 18 | Yes | Trade event identifier. References to {CST_TRADE_EVENTS.TRADE_EVENT_ID}. | |
| INV_TRANSACTION_ID | NUMBER | 18 | Inventory shipping transaction identifier. This is populated for inter-organization and transfer order transactions. | ||
| EXPENSE_POOL_ID | NUMBER | Yes | Overhead absorption bucket. Value of -99 used for cost propagation and other values are for overheads. | ||
| PROCESSED_BY_RA_FLAG | VARCHAR2 | 5 | Indicates whether overheads are processed by receipt accounting. Y = Yes, N = No. | ||
| COST_DATE | TIMESTAMP | Costed date of trade event overheads. | |||
| TRANSACTION_DATE | TIMESTAMP | Trade event transaction date for accounting the transaction overheads and cost propagation transactions. | |||
| UNIT_COST | NUMBER | Overhead's or cost propagation's unit cost. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of costing transaction. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of overheads. It should be the same as primary cost book's ledger currency and also trade event business unit's ledger currency. | ||
| UOM_CONVERSION_FACTOR | NUMBER | Conversion factor from primary unit of measure of item to overhead cost unit of measure. | |||
| 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. | ||
| LOT_NUMBER | VARCHAR2 | 80 | This stores the lot number for the inventory item. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | This stores the serial number for the inventory item. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMR_TRADE_OVERHEADS_N1 | Non Unique | Default | PROCESSED_BY_RA_FLAG, TRADE_EVENT_ID |
| CMR_TRADE_OVERHEADS_U1 | Unique | Default | TRADE_OVERHEAD_ID |