CMR_TRADE_EVENTS_GT
This is a global temporary table used as temporary storage for trade event transactions that are processed in receipt accounting.
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 and refers to {CST_TRADE_EVENTS.TRADE_EVENT_ID}. | |
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Receipt accounting purchase order line location identifier. | ||
| SOURCE_DOC_NUMBER | VARCHAR2 | 50 | Stores purchase order number for purchase order flows and shipment number for inter-organization flows. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | External system reference of transaction. FUSION for fusion based transactions. | |
| 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 types for complex flow like global procurement purchase orders, drop-ship, internal material transfers and transfer order flows. | ||
| AGREEMENT_NUMBER | VARCHAR2 | 100 | Supply Chain Financial Orchestration agreement number between the two trade organizations. | ||
| AGREEMENT_HEADER_ID | NUMBER | 18 | Supply Chain Financial Orchestration 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. Examples include EBS, third-party systems, etc. | ||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Transactions source document type. Examples include purchase order, sales order, transfer order, inter-organization shipment, in-transit shipment. | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 50 | Transaction source document number displayed in user interface for trade event. | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | Transaction source reference document type. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 50 | Transaction reference document number corresponding to trade event. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier. | ||
| 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 identifier 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. Examples include Trade Receipt Accrual and Trade In-Transit Receipt. | |
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Identifies whether a transaction is an asset or expense. | ||
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible for intercompany invoicing. | ||
| PRICING_OPTION | VARCHAR2 | 100 | Pricing option details defined between trade organizations. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier, and it references {EGP_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID}. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | The date when this trade transaction happened. | ||
| TRANSACTION_CREATION_DATE | TIMESTAMP | Yes | System date when this trade transaction was created. | ||
| TRANSACTION_COST_DATE | TIMESTAMP | The transaction cost date is the same as the transaction date, except for backdated trade events. For backdated trade events, it will be one microsecond of the maximum effective date from the CMR_TRADE_E VENT_AVG_COST table for the given document. | |||
| RETURN_EVENT_UNIT_COST | NUMBER | Stores the trade return event cost during the average cost calculation and will be used for accounting. | |||
| TRADE_EVENT_AVG_COST_ID | NUMBER | Trade return average cost source identifier and refers to {CMR_TRADE_EVENT_AVG_COST.TRADE_EVENT_AVG_COST_ID}. | |||
| TRANSACTION_QTY | NUMBER | Transaction quantity in transaction unit of measure. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Transaction unit of measure code. | ||
| PRIMARY_QTY | NUMBER | Transaction quantity in primary unit of measure. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Stores item's primary unit of measure code. | ||
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction quantity in secondary unit of measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Stores item's secondary unit of measure code. | ||
| SOURCE_DOC_QUANTITY | NUMBER | Source document quantity in source document unit of measure. | |||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | Source document unit of measure code. | ||
| EVENT_COST_UOM_CODE | VARCHAR2 | 3 | Trade event unit cost unit of measure. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_RATE | NUMBER | Stores trade event currency conversion rate. | |||
| GL_CURRENCY_CODE | VARCHAR2 | 15 | Trade event ledger currency code. | ||
| CURRENCY_CONVERSION_DATE | DATE | Stores 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. | ||
| TXN_SOURCE_DOC_LINE_DETAIL | VARCHAR2 | 40 | Trade event source document line detail identifier. | ||
| TXN_SOURCE_REF_DOC_LINE | VARCHAR2 | 240 | Transaction source reference document line identifier. | ||
| TXN_SOURCE_REF_DOC_LINE_DETAIL | VARCHAR2 | 40 | Transaction source reference document line detail. | ||
| SOURCE_DOCUMENT_ID | VARCHAR2 | 100 | Source document identifier. For global purchase order flows, it is the po_line_location_id, and for inter-organization transfers, it is the inv_transaction_id. | ||
| INV_TRANSACTION_ID | NUMBER | 18 | Inter-organization issue transaction identifier for inter-organization transfer flows. | ||
| TRACK_PROFIT_FLAG | VARCHAR2 | 1 | Indicates tracking of internal profit in costing. | ||
| PROCESS_BY_RA_FLAG | VARCHAR2 | 1 | Indicates whether trade event is processed by receipt accounting. Y - processed, N - not processed, Z - never process. | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is consigned or owned. | ||
| 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 returned by budgetary control engine. | ||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Flag to indicate whether the transaction is budgetary control enabled or not. | ||
| ENCUMBRANCE_ACCOUNTING_FLAG | VARCHAR2 | 1 | Flag to indicate whether the transaction has encumbrance accounting enabled or not. | ||
| 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 all overhead and subinventory cost propagation 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 | The transaction identifier that triggered the ownership change. | ||
| OWNERSHIP_CHANGE_EVENT_TYPE | VARCHAR2 | 100 | Ownership change type of the event. | ||
| INCLUSIVE_TAX | NUMBER | Trade event inclusive tax amount based on tax configuration. | |||
| CREATE_ACCT_DIST_BASIS | VARCHAR2 | 1 | Indicates whether accounting will be created for consigned transactions. Y = Yes, N = No. | ||
| CONSIGNED_ACCT_DIST_BASIS | VARCHAR2 | 30 | Indicates the consigned accounting distribution basis for the cost profile. | ||
| 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. |