[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_MOVEMENT_STATISTICS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_MOVEMENT_STATISTICS
|
| Subobject Name: | |
| Status: | VALID |
MTL_MOVEMENT_STATISTICS stores all relevant information for movement statistics
transactions. Each transaction is identified by a unique MOVEMENT_ID
number. The MOVEMENT_TYPE column indicates whether the movement is
a dispatch, dispatch adjustment, arrival, or arrival adjustment.
Transactions that are generated from external feeder systems
have a DOCUMENT_SOURCE_TYPE of 'MISC', and their document and
invoice references are not validated. Other movement transactions
generated from Oracle Inventory, Oracle Puchasing, Oracle Order
Management, or Oracle Shipping Execution are validated against their related document and
invoice references via the appropriate foreign key reference columns.
PARENT_MOVEMENT_ID ties multiple movements for receiving transaction
adjustments.
Each movement statistics record is associated with a status that can assume
one of the following
. Open - newly created
. Verified - record validated by the exception report
. Frozen - record reported to the government through paper based report
. EDI sent - record reported to government through EDI transaction
If the record is in Frozen or EDI sent status, the user is not allowed to
modified it nor to regenerate a paper based report or the EDI transaction.
This implies that, in case the government rejects a reported record, users
have to reset the status to open on order to modify the record and regenerate
the report. This function is implememented by the Reset Transaction Status
report. that for a given legal entity, economic zone, usage type, statistical
type and period resets the status to open for all the records.
Please note that the four logical states previously listed are implemented
in the MTL_MOVEMENT_STATISTICS table by two seperate columns:
. MOVEMENT_STATUS
. EDI_SENT: having possible values Y, N
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_MOVEMENT_STATISTICS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 MOVEMENT_ID
|
| MTL_MOVEMENT_STATISTICS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENTITY_ORG_ID
ZONE_CODE
USAGE_TYPE
STAT_TYPE
PERIOD_NAME
MOVEMENT_TYPE
MOVEMENT_STATUS
|
| MTL_MOVEMENT_STATISTICS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENTITY_ORG_ID
ZONE_CODE
USAGE_TYPE
STAT_TYPE
PERIOD_NAME
MOVEMENT_TYPE
EDI_SENT_FLAG
|
| MTL_MOVEMENT_STATISTICS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENTITY_ORG_ID
ZONE_CODE
USAGE_TYPE
STAT_TYPE
TRANSACTION_DATE
|
| MTL_MOVEMENT_STATISTICS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MOVEMENT_STATUS
|
| MTL_MOVEMENT_STATISTICS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RCV_TRANSACTION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MOVEMENT_ID | NUMBER | Yes | Movement row identifier | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PARENT_MOVEMENT_ID | NUMBER | Yes | Parent movement identifier. This column contains either the same ID as MOVEMENT_ID for rows that do not represent adjustments or the ID of the parent. | |
| ENTITY_ORG_ID | NUMBER | Yes | Legal entity identifier | |
| ZONE_CODE | VARCHAR2 | (10) | Zone Code | |
| USAGE_TYPE | VARCHAR2 | (30) | Usage Type INTERNAL or EXTERNAL | |
| STAT_TYPE | VARCHAR2 | (30) | Statistical Format i.e. INTRASTAT, EXTRASTAT, etc. | |
| CREATION_METHOD | VARCHAR2 | (30) | Yes | Movement creation method (Zoom, Manual) |
| STAT_METHOD | VARCHAR2 | (30) | Method of calculating statistical value (Manual, System) | |
| DOCUMENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Type of document out of which the movememt statistics record is created (i.e. PO, INVENTORY, SO ...) |
| PERIOD_NAME | VARCHAR2 | (15) | Reporting period name | |
| SET_OF_BOOKS_PERIOD | VARCHAR2 | (15) | Period in which the transaction is accounted for | |
| TRANSACTION_DATE | DATE | Yes | Transaction date | |
| MOVEMENT_TYPE | VARCHAR2 | (30) | Yes | Movement type (Arrival, Arrival adjustment, Dispatch, Dispatch adjustment) |
| DISPATCH_TERRITORY_CODE | VARCHAR2 | (2) | Goods dispatch country code | |
| DISPATCH_TERRITORY_EU_CODE | VARCHAR2 | (3) | Goods dispatch European Union country code | |
| DESTINATION_TERRITORY_CODE | VARCHAR2 | (2) | Goods destination country code | |
| DESTINATION_TERRITORY_EU_CODE | VARCHAR2 | (3) | Goods destination European Union country code | |
| TRIANGULATION_COUNTRY_CODE | VARCHAR2 | (30) | used to represent the territory code in the case drop shipment | |
| TRIANGULATION_COUNTRY_EU_CODE | VARCHAR2 | (3) | used to represent the territory European Union code in the case drop shipment | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| CATEGORY_ID | NUMBER | Category identifier for commodity code | ||
| COMMODITY_CODE | VARCHAR2 | (240) | Used to specify the commodity code of the item in the movement statistic record. This column is only populated for a source type of miscellaneous. All other source types use the CATEGORY_ID column to specify the commodity code | |
| COMMODITY_DESCRIPTION | VARCHAR2 | (240) | Used to specify the commodity code description for the item in the movement statistic record. Only populated for a source type ofmiscellaneous. | |
| ORIGIN_TERRITORY_CODE | VARCHAR2 | (2) | Goods origin country code | |
| ORIGIN_TERRITORY_EU_CODE | VARCHAR2 | (3) | European Union code for origin territory | |
| MOVEMENT_AMOUNT | NUMBER | Reported amount calculated as: NVL(INVOICE_LINE_EXT_VALUE,INVOICE_LINE_EXT_VALUE + STAT_EXT_VALUE) | ||
| INVOICE_LINE_EXT_VALUE | NUMBER | Total invoice line extended value for goods,used only for transactions having an invoice. | ||
| DOCUMENT_LINE_EXT_VALUE | NUMBER | Total document line extended value; usedfor transactions not having an invoice(i.e. Inventory transactions - both Organization Transfer and Miscellaneous and Free Miscellaneous.) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency of movement transaction | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| STAT_ADJ_PERCENT | NUMBER | Statistical value adjustment expressed as a percentage | ||
| STAT_ADJ_AMOUNT | NUMBER | Statistical value adjustment expressed as afixed amount | ||
| STAT_EXT_VALUE | NUMBER | Statistical extended value (calculated asNVL(STAT_ADJ_PERCENTAGE(NVL(INVOICE_LINE_EXT_VALUE,DOCUMENT_LINE_EXT_VALUE) *STAT_ADJ_PERCENTAGE), STAT_ADJ_AMOUNT) | ||
| OUTSIDE_EXT_VALUE | NUMBER | Repair/ Process extended value | ||
| OUTSIDE_UNIT_PRICE | NUMBER | Repair/Process per unit price | ||
| WEIGHT_METHOD | VARCHAR2 | (30) | Method used for calculating weight (Manual, System) | |
| UNIT_WEIGHT | NUMBER | Per unit weight in kilograms | ||
| TOTAL_WEIGHT | NUMBER | Total weight in kilogramsType of document (PO, SO, Misc, etc) | ||
| TOTAL_WEIGHT_UOM_CODE | VARCHAR2 | (3) | Denormalized | |
| TRANSACTION_QUANTITY | NUMBER | Movement quantity | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | (3) | Movement unit of measure code | |
| PRIMARY_QUANTITY | NUMBER | Movement quantity in terms of primary unit of measure of the item | ||
| ALTERNATE_QUANTITY | NUMBER | Number of supplement units | ||
| ALTERNATE_UOM_CODE | VARCHAR2 | (3) | Alternate unit of measure | |
| DELIVERY_TERMS | VARCHAR2 | (30) | Delivery terms | |
| TRANSACTION_NATURE | VARCHAR2 | (30) | Transaction nature | |
| TRANSPORT_MODE | VARCHAR2 | (30) | Transport mode (i.e. air, sea etc) | |
| STATISTICAL_PROCEDURE_CODE | VARCHAR2 | (30) | Statistical procedure (i.e. Dispatch to final destination,Temporary dispatch for further processing, etc) | |
| AREA | VARCHAR2 | (30) | Area (province, location, or depatment code)API defaults from province in the trading partner master. | |
| PORT | VARCHAR2 | (30) | Dispatch or arrival port (harbor, airport code, etc) | |
| ITEM_COST | NUMBER | Item cost | ||
| TARIC_CODE | VARCHAR2 | (30) | taric code | |
| PREFERENCE_CODE | VARCHAR2 | (30) | preference code | |
| FLOW_INDICATOR_CODE | VARCHAR2 | (30) | flow indicator code | |
| AFFILIATION_REFERENCE_CODE | VARCHAR2 | (30) | affliliation reference code | |
| OIL_REFERENCE_CODE | VARCHAR2 | (30) | oil reference code | |
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | container type code | |
| CSA_CODE | VARCHAR2 | (30) | csa code | |
| OUTSIDE_CODE | VARCHAR2 | (30) | Indicator for movement purpose (Repair, Process, etc) | |
| COMMENTS | VARCHAR2 | (240) | Comments - free text entered manually | |
| RCV_TRANSACTION_ID | NUMBER | foreign key reference to RCV_Transactions table | ||
| PO_HEADER_ID | NUMBER | PO header identifier | ||
| PO_LINE_ID | NUMBER | PO line identifier | ||
| PO_LINE_LOCATION_ID | NUMBER | PO line location identifier | ||
| SHIPMENT_HEADER_ID | NUMBER | Receipt, shipment header identifier | ||
| SHIPMENT_LINE_ID | NUMBER | Receipt, shipment line identifier | ||
| PICKING_LINE_DETAIL_ID | NUMBER | Picking line detail identifier | ||
| PICKING_LINE_ID | NUMBER | Picking line identifier | ||
| ORDER_HEADER_ID | NUMBER | Order header identifier | ||
| ORDER_LINE_ID | NUMBER | Order line identifier | ||
| MTL_TRANSACTION_ID | NUMBER | foreign key reference to MTL_Material_Transactions table | ||
| REQUISITION_HEADER_ID | NUMBER | The unique identifier for the PO requisition tied to the movement statistic record | ||
| REQUISITION_LINE_ID | NUMBER | The unique identifier for the PO requisition line tied to the movement statistic record | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | Ship-to customer identifier - SO + Internal Req | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Ship-to customer site identifier SO + Internal Req | ||
| BILL_TO_CUSTOMER_ID | NUMBER | Bill-to customer identifier SO + Internal Req | ||
| BILL_TO_SITE_USE_ID | NUMBER | Bill-to site customer identifier SO + Internal Req | ||
| VENDOR_ID | NUMBER | Supplier identifier | ||
| VENDOR_SITE_ID | NUMBER | Supplier site identifier | ||
| FROM_ORGANIZATION_ID | NUMBER | 'From' Organization identifier - used for inventory | ||
| TO_ORGANIZATION_ID | NUMBER | 'To' Organization identifier - used for inventory | ||
| FINANCIAL_DOCUMENT_FLAG | VARCHAR2 | (30) | Yes | Financial Document Flag |
| INVOICE_BATCH_ID | NUMBER | Invoice batch identifier | ||
| INVOICE_ID | NUMBER | Invoice identifier | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | Invoice line identifier | ||
| DOCUMENT_REFERENCE | VARCHAR2 | (50) | Document reference number (for MISC type only) | |
| DOCUMENT_LINE_REFERENCE | VARCHAR2 | (30) | Line number of document (for MISC type only) | |
| DOCUMENT_UNIT_PRICE | NUMBER | Per unit document price | ||
| RECEIPT_REFERENCE | VARCHAR2 | (50) | Receipt number (for MISC type only) | |
| SHIPMENT_REFERENCE | VARCHAR2 | (50) | Shipment number (for MISC type only) | |
| SHIPMENT_LINE_REFERENCE | VARCHAR2 | (30) | Shipment line number (for MISC type only) | |
| PICK_SLIP_REFERENCE | VARCHAR2 | (50) | Pick slip number (for MISC type only) | |
| CUSTOMER_NAME | VARCHAR2 | (240) | Customer name reference (for MISC type only) | |
| DISTRIBUTION_LINE_NUMBER | NUMBER | foreign key reference to AP_Line_Distributions table | ||
| CUSTOMER_NUMBER | VARCHAR2 | (50) | Customer number reference (for MISC type only) | |
| CUSTOMER_LOCATION | VARCHAR2 | (50) | Customer location reference (for MISC type only) | |
| SHIP_TO_NAME | VARCHAR2 | (240) | ship to name | |
| TRANSACTING_FROM_ORG | VARCHAR2 | (50) | 'From' Organization reference (for MISC type only) | |
| SHIP_TO_NUMBER | VARCHAR2 | (50) | ship to number | |
| SHIP_TO_SITE | VARCHAR2 | (50) | ship to site | |
| TRANSACTING_TO_ORG | VARCHAR2 | (50) | 'To' organization reference (for MISC type only) | |
| VENDOR_NAME | VARCHAR2 | (240) | Supplier name reference (for MISC type only) | |
| VENDOR_NUMBER | VARCHAR2 | (50) | Supplier number reference (for MISC type only) | |
| VENDOR_SITE | VARCHAR2 | (50) | Supplier site reference (for MISC type only) | |
| BILL_TO_NAME | VARCHAR2 | (240) | Bill-to name reference (for MISC type only) | |
| BILL_TO_NUMBER | VARCHAR2 | (50) | Bill-to number reference (for MISC type only) | |
| BILL_TO_SITE | VARCHAR2 | (50) | Bill-to site reference (for MISC type only) | |
| INVOICE_BATCH_REFERENCE | VARCHAR2 | (50) | Invoice batch reference (for MISC type only) | |
| INVOICE_REFERENCE | VARCHAR2 | (50) | Invoice reference (for MISC type only) | |
| INVOICE_LINE_REFERENCE | VARCHAR2 | (30) | Invoice line reference (for MISC type only) | |
| INVOICE_DATE_REFERENCE | DATE | Invoice date reference | ||
| INVOICE_QUANTITY | NUMBER | Invoice quantity | ||
| INVOICE_UNIT_PRICE | NUMBER | Per unit invoice price | ||
| REPORT_REFERENCE | VARCHAR2 | (200) | Report freeze reference | |
| REPORT_DATE | DATE | Report date | ||
| EDI_SENT_FLAG | VARCHAR2 | (1) | Yes | EDI sent flag |
| EDI_TRANSACTION_DATE | DATE | EDI transaction date | ||
| EDI_TRANSACTION_REFERENCE | VARCHAR2 | (35) | EDI transaction reference | |
| MOVEMENT_STATUS | VARCHAR2 | (30) | Yes | Movement row status (Unprocessed, Open, Frozen) |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CUSTOMER_VAT_NUMBER | VARCHAR2 | (50) | Customer VAT number-used for ESL | |
| ESL_DROP_SHIPMENT_CODE | NUMBER | ESL Drop Shipment Code |
Cut, paste (and edit) the following text to query this object:
SELECT MOVEMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PARENT_MOVEMENT_ID
, ENTITY_ORG_ID
, ZONE_CODE
, USAGE_TYPE
, STAT_TYPE
, CREATION_METHOD
, STAT_METHOD
, DOCUMENT_SOURCE_TYPE
, PERIOD_NAME
, SET_OF_BOOKS_PERIOD
, TRANSACTION_DATE
, MOVEMENT_TYPE
, DISPATCH_TERRITORY_CODE
, DISPATCH_TERRITORY_EU_CODE
, DESTINATION_TERRITORY_CODE
, DESTINATION_TERRITORY_EU_CODE
, TRIANGULATION_COUNTRY_CODE
, TRIANGULATION_COUNTRY_EU_CODE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, CATEGORY_ID
, COMMODITY_CODE
, COMMODITY_DESCRIPTION
, ORIGIN_TERRITORY_CODE
, ORIGIN_TERRITORY_EU_CODE
, MOVEMENT_AMOUNT
, INVOICE_LINE_EXT_VALUE
, DOCUMENT_LINE_EXT_VALUE
, CURRENCY_CODE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, STAT_ADJ_PERCENT
, STAT_ADJ_AMOUNT
, STAT_EXT_VALUE
, OUTSIDE_EXT_VALUE
, OUTSIDE_UNIT_PRICE
, WEIGHT_METHOD
, UNIT_WEIGHT
, TOTAL_WEIGHT
, TOTAL_WEIGHT_UOM_CODE
, TRANSACTION_QUANTITY
, TRANSACTION_UOM_CODE
, PRIMARY_QUANTITY
, ALTERNATE_QUANTITY
, ALTERNATE_UOM_CODE
, DELIVERY_TERMS
, TRANSACTION_NATURE
, TRANSPORT_MODE
, STATISTICAL_PROCEDURE_CODE
, AREA
, PORT
, ITEM_COST
, TARIC_CODE
, PREFERENCE_CODE
, FLOW_INDICATOR_CODE
, AFFILIATION_REFERENCE_CODE
, OIL_REFERENCE_CODE
, CONTAINER_TYPE_CODE
, CSA_CODE
, OUTSIDE_CODE
, COMMENTS
, RCV_TRANSACTION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, PICKING_LINE_DETAIL_ID
, PICKING_LINE_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, MTL_TRANSACTION_ID
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, FINANCIAL_DOCUMENT_FLAG
, INVOICE_BATCH_ID
, INVOICE_ID
, CUSTOMER_TRX_LINE_ID
, DOCUMENT_REFERENCE
, DOCUMENT_LINE_REFERENCE
, DOCUMENT_UNIT_PRICE
, RECEIPT_REFERENCE
, SHIPMENT_REFERENCE
, SHIPMENT_LINE_REFERENCE
, PICK_SLIP_REFERENCE
, CUSTOMER_NAME
, DISTRIBUTION_LINE_NUMBER
, CUSTOMER_NUMBER
, CUSTOMER_LOCATION
, SHIP_TO_NAME
, TRANSACTING_FROM_ORG
, SHIP_TO_NUMBER
, SHIP_TO_SITE
, TRANSACTING_TO_ORG
, VENDOR_NAME
, VENDOR_NUMBER
, VENDOR_SITE
, BILL_TO_NAME
, BILL_TO_NUMBER
, BILL_TO_SITE
, INVOICE_BATCH_REFERENCE
, INVOICE_REFERENCE
, INVOICE_LINE_REFERENCE
, INVOICE_DATE_REFERENCE
, INVOICE_QUANTITY
, INVOICE_UNIT_PRICE
, REPORT_REFERENCE
, REPORT_DATE
, EDI_SENT_FLAG
, EDI_TRANSACTION_DATE
, EDI_TRANSACTION_REFERENCE
, MOVEMENT_STATUS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CUSTOMER_VAT_NUMBER
, ESL_DROP_SHIPMENT_CODE
FROM INV.MTL_MOVEMENT_STATISTICS;
INV.MTL_MOVEMENT_STATISTICS does not reference any database object
INV.MTL_MOVEMENT_STATISTICS is referenced by following:
APPS
MTL_MOVEMENT_STATISTICS
|
|
|
|