CMR_TRADE_EVENTS_GT
This table contains the trade event transactions to be processed by receipt accounting and it is a global temporary table used in processing.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_EVENT_ID | NUMBER | 18 | Yes | Trade event identifier - maps to {CST_TRADE_EVENTS.TRADE_EVENT_ID} | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | receipt accounting po line location identifier for PO based flows trade events | ||
| SOURCE_DOC_NUMBER | VARCHAR2 | 50 | to stores po number for PO flows and shipment number for interorg flows | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Reference Information from an External system (external to Cost Management). | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system | |
| ACCRUAL_TRANSACTION_ID | NUMBER | 18 | For an in-transit receipt., this refers to the associated Accrual Transaction event | ||
| PRIOR_TRANSACTION_ID | NUMBER | 18 | Prior event that is the source of the cost for this event. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity of the trade event organization. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Profit Center Business unit of the trade event organization. | ||
| BILL_TO_BU_ID | NUMBER | 18 | Bill to business unit is payable invoice business unit. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Inventory organization of the trade event. | |
| SUCCESSOR_BU_ID | NUMBER | 18 | Successor profit center Business unit in multi node complex flows. | ||
| SUCCESSOR_INV_ORG_ID | NUMBER | 18 | Successor Inventory organization in multi node complex flows. | ||
| PRIOR_BU_ID | NUMBER | 18 | Prior profit center Business unit identifier in multi node complex flows. | ||
| PRIOR_INVENTORY_ORG_ID | NUMBER | 18 | Prior Inventory organization in multi node complex flows. | ||
| AGREEMENT_TYPE | VARCHAR2 | 20 | Agreement type for complex flow: like GP PO, DS, IMT , TO flows | ||
| AGREEMENT_NUMBER | VARCHAR2 | 100 | FOS Agreement number between the two trade organizations. | ||
| AGREEMENT_HEADER_ID | NUMBER | 18 | FOS Agreement Header Identifier between the trade organization | ||
| PTR_ID | NUMBER | 18 | Identifies the of primary trade relationship of this trade event | ||
| PTR_INSTANCE_ID | NUMBER | 18 | Identifies the instance of primary trade relationship of this trade event. | ||
| FTR_ID | NUMBER | 18 | Identifies the financial trade relationship of this trade event | ||
| ORIGINATING_SYSTEM_REFERENCE | VARCHAR2 | 100 | The system from which the flow originated. E.g. EBS vs. 3rd party system etc. | ||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Trade events doc type e.g. PO, SO, TO, Inter org Shipment Number, Intransit Shipment Number. | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 50 | The Document number as displayed on the UI for the event. | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | Reference document. E.g. Notional PO, Notional SO | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 50 | Reference document number corresponding to trade event E.g. PO Number etc. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Line location and maps to {CMR_PURCHASE_ORDER_DTLS.PO_LINE_LOCATION_ID} | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution identifier in receipt accounting. | |||
| WSH_DELIVERY_DETAIL_ID | NUMBER | 18 | Shipping delivery detail for Internal drop shipment and customer drop shipment flows. | ||
| DOO_FULLFILL_LINE_ID | NUMBER | 18 | DOO Fulfillment line for Internal drop shipment and customer drop shipment flows. | ||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Transfer order line identifier for Transfer Order flows. | ||
| TRANSACTION_TYPE | VARCHAR2 | 40 | Yes | trade event transaction type in receipt accounting. Example: Trade Receipt Accrual, Trade In-transit Receipt | |
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense transaction | ||
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible for intercompany invoicing or not | ||
| PRICING_OPTION | VARCHAR2 | 100 | Pricing Option details defined between trade organizations. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier and references {EGP_SYSTEM_ITEMS_B.inventory_item_id}. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | Transaction Date - indicates trade transaction created. | ||
| TRANSACTION_CREATION_DATE | TIMESTAMP | Yes | Transaction Creation Date - system date of trade transaction date | ||
| TRANSACTION_COST_DATE | TIMESTAMP | Transaction cost date is same transaction except for backed dated trade events. For back dated trade events it will be one microsecond of max effective date from avg cost table for given document details | |||
| RETURN_EVENT_UNIT_COST | NUMBER | Stores the trade return event cost during the average logic calculation and will be used to account | |||
| TRADE_EVENT_AVG_COST_ID | NUMBER | Trade return average cost source identifier - Trade event average cost id from trade events acv cost table | |||
| TRANSACTION_QTY | NUMBER | Transaction Quantity in Transaction Unit of measure. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Transaction Unit of measure code - represents the transaction UOM. | ||
| PRIMARY_QTY | NUMBER | Transaction Quantity in primary UOM | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary Unit of measure code of the item. | ||
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction qty in secondary Unit of measure code. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary Unit of measure Code of item. | ||
| SOURCE_DOC_QUANTITY | NUMBER | Source document quantity. e.g. PO Quantity | |||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | Source document UOM code. - example - PO UOM or TO UOM. | ||
| EVENT_COST_UOM_CODE | VARCHAR2 | 3 | Unit of measure code of trade event unit cost | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate - used in consigned ownership change Trade events as rate comes from CST_INV_TRANSACTIONS | |||
| GL_CURRENCY_CODE | VARCHAR2 | 15 | Trade event ledger currency code | ||
| CURRENCY_CONVERSION_DATE | DATE | Trade event currency conversion date | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Intercompany accrual invoice currency. | ||
| TXN_DOCUMENT_SOURCE_SYSTEM | VARCHAR2 | 100 | Identifies the system from which the document is originated | ||
| TXN_SOURCE_DOC_LINE | VARCHAR2 | 40 | Source Document Line identifier column. | ||
| TXN_SOURCE_DOC_LINE_DETAIL | VARCHAR2 | 40 | Trade event Source Document Line Details if applicable | ||
| TXN_SOURCE_REF_DOC_LINE | VARCHAR2 | 240 | Transaction source reference document line. | ||
| TXN_SOURCE_REF_DOC_LINE_DETAIL | VARCHAR2 | 40 | Transaction source reference document line detail | ||
| SOURCE_DOCUMENT_ID | VARCHAR2 | 100 | Source document identifier - Global PO flows PO line location Id and Inter Organization transfers: INV Transaction id. | ||
| INV_TRANSACTION_ID | NUMBER | 18 | Transaction Identifier for Inter-Org Issue transaction for Inter-Org transfer flows. | ||
| TRACK_PROFIT_FLAG | VARCHAR2 | 1 | Indicates tracking of internal profit in costing | ||
| PROCESS_BY_RA_FLAG | VARCHAR2 | 1 | indicates trade event is processed by receipt accounting or not. Y means processed, N - not processed, Z - never process. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Consigned Flag for Consigned Trade events. 'Y' for all consigned interOrg transfers. | ||
| MANUAL_RECEIPT_REQD_FLAG | VARCHAR2 | 1 | Flag to denote Manual receipt is created or not for transfer order expense destination flow. | ||
| FUND_RESERVATION_STATUS | VARCHAR2 | 20 | Fund reservation status of transaction for budgetary control. | ||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Indicates if budgetary control enabled on the transaction. Y means enabled and other values means not enabled. | ||
| ENCUMBRANCE_ACCOUNTING_FLAG | VARCHAR2 | 1 | Indicates encumbrance accounting enabled on the transaction and it is dependent on the value of budgetary control flag. | ||
| ENCUMBRANCE_REVERSAL_ENTR_AMT | NUMBER | Encumbrance reversal amount in entered currency of transaction. | |||
| ENCUMBRANCE_REVERSAL_ACCT_AMT | NUMBER | Encumbrance reversal amount in ledger currency of transaction. | |||
| TRANSFER_ORDER_DIST_ID | NUMBER | 18 | Transfer order distribution identifier. | ||
| TRADE_OVERHEAD_ID | NUMBER | 18 | Trade overhead identifier for the all overhead and subinventory cost propagations transactions. | ||
| SHIPMENT_NUMBER | VARCHAR2 | 30 | Shipment number for inter organization transfers. | ||
| OWNERSHIP_CHANGE_DOC_NUMBER | VARCHAR2 | 50 | Ownership Change Document number | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Destination type code of ownership change document or transaction | ||
| OWNERSHIP_CHANGE_TXN_ID | VARCHAR2 | 100 | Ownership Change Transaction Identifier. | ||
| OWNERSHIP_CHANGE_EVENT_TYPE | VARCHAR2 | 100 | Ownership change type of the event. | ||
| INCLUSIVE_TAX | NUMBER | Trade event inclusive tax amount based on tax configuarion. | |||
| CREATE_ACCT_DIST_BASIS | VARCHAR2 | 1 | Create accounting for consigned transactions flag - Y or N | ||
| CONSIGNED_ACCT_DIST_BASIS | VARCHAR2 | 30 | Indicates the Consigned accounting distribution basis for the cost profile. |