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 |