Results for “document_source_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ECE_MVSTO_DETAILS is a table owned by the EC schema within the Oracle e-Commerce Gateway module. It stores detail-level information for the outbound Movement Statistics transaction, a statutory reporting process used primarily to satisfy European Union Intrastat and related trade-statistics obligations. Where the header-level Movement Statistics record captures the transaction as a whole, ECE_MVSTO_DETAILS preserves the individual movement lines required for regulatory submission, including territory, transport, valuation, weight, and reference data.

From a Data Vault modeling perspective, the documented metadata classifies this object heuristically as standalone. This classification suggests the table functions primarily as a satellite-like structure capturing descriptive attributes, rather than acting as a canonical hub or link. Because it carries foreign keys to multiple operational tables without an obvious central business hub, a warehouse designer may prefer to model it as a satellite attached to a Movement Statistics hub, with links to picking, movement parameter, and security group dimensions.

Key Information Stored

ECE_MVSTO_DETAILS contains 303 documented columns in the ETRM 12.2.2 schema, reflecting the extensive data required for Intrastat and movement-statistics declarations. The most operationally significant columns include:

• MOVEMENT_ID — Foreign key to MTL_MOVEMENT_STATISTICS and the column forming unique index ECE_MVSTO_DETAILS_U1, serving as the principal business-key candidate linking detail to the movement header.
• TRANSACTION_RECORD_ID and TRANSACTION_HEADER_ID — Together forming unique index ECE_MVSTO_DETAILS_U2, providing an alternate business-key candidate for transaction-level identification.
• ENTITY_ORG_ID — Foreign key to MTL_MOVEMENT_PARAMETERS, anchoring the record to the movement-parameter setup of the reporting entity.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org security scoping.
• PERIOD_NAME and SET_OF_BOOKS_PERIOD — Identify the accounting period to which the statistical movement belongs.
• MOVEMENT_TYPE, MOVEMENT_NATURE_CODE, TRANSACTION_NATURE — Classify the nature of the movement for regulatory reporting.
• ORIGIN_TERRITORY_CODE, DESTINATION_TERRITORY_CODE, DISPATCH_TERRITORY_CODE — Territory identifiers used in Intrastat box reporting.
• TRANSPORT_MODE and PORT — Capture logistics attributes required for statistical declarations.
• INVENTORY_ITEM_ID, MTL_TRANSACTION_ID, SHIPMENT_LINE_ID, PICKING_LINE_ID — Links back to the originating inventory, shipment, and picking transactions.
• MOVEMENT_AMOUNT, TRANSACTION_QUANTITY, TRANSACTION_UOM_CODE, TOTAL_WEIGHT — Financial and quantitative measures used in reporting.
• EDI_SENT_FLAG — Indicates whether the movement record has been transmitted via EDI.
• ATTRIBUTE1 through ATTRIBUTE15 — Flexfield-style descriptive columns available for customer extension.

The surrogate primary key is not separately enumerated in the documented metadata; the unique indexes U1 and U2 identify the business-key candidates.

Common Use Cases and Queries

Typical reporting scenarios involve extracting movement statistics for submission, reconciling EDI transmission status, and auditing statutory declarations. Representative SQL patterns include:

• Retrieving all detail lines for a given movement: SELECT * FROM EC.ECE_MVSTO_DETAILS WHERE MOVEMENT_ID = :movement_id;
• Identifying records pending EDI transmission: SELECT TRANSACTION_RECORD_ID, MOVEMENT_ID FROM EC.ECE_MVSTO_DETAILS WHERE EDI_SENT_FLAG = 'N';
• Summarizing movement amounts by destination territory and period for Intrastat reporting: SELECT DESTINATION_TERRITORY_CODE, PERIOD_NAME, SUM(MOVEMENT_AMOUNT) FROM EC.ECE_MVSTO_DETAILS GROUP BY DESTINATION_TERRITORY_CODE, PERIOD_NAME;

Related Objects

The most significant related objects, derived from the documented foreign-key relationships, are:

• MTL_MOVEMENT_STATISTICS — Joined via ECE_MVSTO_DETAILS.MOVEMENT_ID; the parent header for movement statistics.
• MTL_MOVEMENT_PARAMETERS — Joined via ENTITY_ORG_ID; defines movement-reporting configuration.
• SO_PICKING_LINE_DETAILS — Joined via PICKING_LINE_DETAIL_ID; source picking detail.
• SO_PICKING_LINES_ALL — Joined via PICKING_LINE_ID; source picking line.
• FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; supports multi-org security.
• MTL_TRANSACTIONS and RCV_TRANSACTIONS — Referenced via MTL_TRANSACTION_ID and RCV_TRANSACTION_ID for inventory and receiving origin.