Skip Headers

Oracle Inventory Movement Statistics User's Guide
Release 12.1
Part Number B31584-02
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Movement Statistics Data

This appendix covers the following topics:

European Union Member Countries

The countries that make up the European Union are as follows. Note that the European Union Economic Zone is pre-seeded in the system.

European Union Countries
Code Country
AT Austria
FR France
BE Belgium
IE Ireland
DK Denmark
IT Italy
DE Germany
LU Luxembourg
FI Finland
NL Netherlands
GB United Kingdom
PT Portugal
GR Greece
SE Sweden
ES Spain

Movement Statistic Field Definitions

The following is an alphabetized listing of the fields, and their definitions, used in the Movement Statistics forms and reports. The following is an alphabetized listing of the fields, and their definitions, used in the Movement Statistics forms and reports

Adjustment Percentage

This field is not populated by the Movement Statistics Processor.

This field will adjust the Statistical Value by the percentage entered. A negative percentage will decrease the Statistical Value, a positive percentage will increase the Statistical Value.

Note that the Statistical Value is not displayed on-line The adjusted Statistical Value will be displayed on the Movement Statistics Standard Summary or Standard Detail Reports. Also, note that if you enter an adjustment percentage, the Adjustment Amount will automatically be calculated for you.

You may manually enter this value on the Movement Statistics Detail form or use the Call Out Program.

Adjustment Amount

This field is not populated by the Movement Statistics Processor.

This field will adjust the Statistical Value by the amount entered. A negative amount will decrease the Statistical Value, a positive amount will increase the Statistical Value.

The Statistical Value is not displayed on-line. The adjusted Statistical Value will be displayed on all the Movement Statistics Standard Summary or Standard Detail Reports. Note that if you enter an adjustment amount, the Adjustment Percentage will automatically be calculated for you.

You may manually enter this value on the Movement Statistics Detail form or use the Call Out Program.

Adjustment to

Refers to the Movement Number of original movement record. This field will only be populated on adjustment movement records, otherwise it is blank. For example, if the current record is an adjustment movement record, this field refers to the movement record that is being adjusted

Affiliation Reference

This field is not populated by the Movement Statistics Processor.

You may update this field manually or by using the Call Out Program to insert an affiliation reference code.

Alternate Quantity

This field is not populated by the Movement Statistics Processor.

This field is used if a commodity code requires a Supplementary Unit.

In the Commodity Codes nomenclature, the commodity codes for which supplementary units have to be used, such as number of items, pairs, dozens, etc. - are indicated. This is done because, for some products it is necessary to define the quantity or volume of a product. This measurement in terms of the supplementary unit must be entered for the commodity code marked by an asterisk in the nomenclature. You must not enter the unit itself.’ from: Intrastat - Guide 2001

Alternate UOM

This field is not populated by the Movement Statistics Processor.

This field is used if a commodity code requires a Supplementary Unit.

’In the Commodity Codes nomenclature, the commodity codes for which supplementary units have to be used, such as number of items, pairs, dozens, etc. - are indicated. This is done because, for some products it is necessary to define the quantity or volume of a product. This measurement in terms of the supplementary unit must be entered for the commodity code marked by an asterisk in the nomenclature. You must not enter the unit itself.’ from: Intrastat - Guide 2001

Area

This field is not populated by the Movement Statistics Processor.

This field is used to enter the predefined code which specifies the area the goods arrived or departed from a specific EC member state. The pre-seeded list for Area is too large to display in this document. You may manually enter this value by selecting from the pre-seeded list of values on the Movement Statistics Detail form or use the Call Out Program.

Batch

The batch number that processed either the Purchase Order or Sales Order invoice. The batch number is generated by your system when processing invoices.

Comments

This field is not populated by the Movement Statistics Processor.

A free text field. You may manually enter free text comments in this field or use the Call Out Program.

Commodity

Goods are classified by means of commodity codes.

The commodity code for the INTRASTAT transaction -- a predefined character code which uniquely identifies a class of products. The European Community has a set of harmonization codes that are 8 characters with a ninth digit - check digit.

The Commodity Code is an 8 digit number taken from the Intrastat Classification Nomenclature (ICN) which is common to all EU countries. The coding system distinguishes between the various types of goods (for example, steel, foodstuffs, machinery) and goes into considerable detail. It is often ambiguous - for example, if you are shipping a consignment of screws intended as spare parts for motor vehicles, you have an option to declare them either specifically as 73181569 under a code for ’screws’ or else more vaguely under the code 87089910 for ’Vehicle spare parts.’ It is quite possible, if the exporter is a manufacturer of screws and the importer is a manufacturer of vehicles, that the seller could use one code for the export declaration, and the buyer a different code for the import declaration.

In the Movement Statistics module, Commodity Codes and Descriptions are derived from the category set defined at setup time in the Movement Statistics Parameters form: the commodity code for a movement statistics record is the category to which the item involved in the transaction is assigned within that category set.

In the Movement Statistics module, this is known as the Commodity Code and includes the field Commodity Code Description.

CSA Code

This field is not populated by the Movement Statistics Processor.

The Canadian Standard Association (CSA) develops standards that covers the electrical/electronic, communications, quality management systems, environmental, construction, gas, healthcare, and public safety fields. Each standard is coded.

You must enter the CSA Code manually or by using the Call Out program.

Customer Name

For sales order transactions, the customer name is displayed.

Customer Number

For sales order transactions, the customer number is displayed.

Customer Site

For sales order transactions, the customer site is displayed.

Date (Invoice)

The date the invoice was created.

Delivery Terms

The current list of EU Delivery Codes are sometimes referred to as Incoterms and were established in part by the International Chamber of Commerce (ICC) to determine at which point the transfer of title takes place in a transaction where goods are bought or sold.

Delivery Codes are required to perform Intrastat reporting. The current set of valid EU delivery codes are setup automatically in the Movement Statistics module. Additional Delivery Codes may be added as necessary to the Movement Statistics Module.

The Movement Statistics module uses lookups to select the value for Delivery Code. Following is a list of pre-seeded data provided for this purpose.

In the Movement Statistics module, the Delivery Code for a movement transaction is defaulted from the Freight on Board (FOB) point (of a transaction) and verified against the valid Delivery Codes. Current valid Delivery Codes:

The default Delivery Code for all Source types is CIF - Cost, Insurance, and Freight

Delivery Name

For sales order transactions, the delivery name is displayed.

Destination Country

The country code to which the goods are shipped.

In the Movement Statistics module, Dispatch Country is defined to be the country to which the goods are being shipped. For example, if a PC was shipped from France to a customer in Spain, the Destination Country would be Spain.

Destination Country
Source Type Destination Country
RECV - Purchase Order Receipt Ship to Location
TRNI / TRNR - Inventory Move Transactions To Organization
RTNR - Return to Vendor Ship to Location
ADJI - Customer Return Ship to Location
XFER - inventory In-transit Transfer To Organization
Sales Order Ship to Location
Purchase Order Ship to Location
Inventory Move Transactions To Organization
Return to Vendor (RTV) Ship to Location
RMA Ship to Location
Drop Shipments Triangulation
Internal Sales Order / Internal Requisitions To Organization

Dispatch Country

The Dispatch Country is the country code from which the goods are shipped.

In the Movement Statistics module, Dispatch Country is defined to be the country from where the goods are shipped. For example, if a PC was shipped from France to a customer in Spain, the Dispatch Country would be France.

Dispatch Country
Source Type Dispatch Country
RECV - Purchase Order Receipt Vendor Site
TRNI / TRNR - Inventory move Transactions From Organization
RTNR - Return to Vendor Ship from Location
ADJI - Customer Return From Organization
XFER - inventory in-transit Transfer From Organization
Sales Order Ship from Location
Purchase Order Vendor Site
Inventory Move Transactions From Organization
Return to Vendor (RTV) Ship from Location
RMA From Organization
Drop Shipments Triangulation
Internal Sales Order From Organization

Document Number

The document number for the INTRASTAT transaction (as defined by the document type). The document number / transaction cross-reference:

Inventory, Purchasing, and Order Management Source Types

Source Type / Document Number
Source Type Document Number
Sales Order Sales Order Number
Purchase Order PO Number
Inventory Move Transactions Transaction ID
Return to Vendor (RTV) RTV Number
RMA RMA Number
Drop Shipments Order Number
internal Sales Order / Internal Requisitions Requisition Number

Document Reference

This field is not populated by the Movement Statistics Processor.

For Miscellaneous movement records (manually created records) you may enter free text information regarding the document in this field.

Document Line Reference

This field is not populated by the Movement Statistics Processor.

For Miscellaneous movement records (manually created records) you may enter free text information regarding the document line in this field.

Economic Zones

In the Movement Statistics module, you define economic zones as an association of countries.

Exchange Rate

The Exchange Rate is the rate used to convert between the transaction currency to the functional currency.

In the Movement Statistics module, the Exchange Rate is entered by the user. The Exchange Rate is calculated by multiplying the Transaction currency by the Set of Books exchange rate to arrive at the Functional (reporting) currency exchange rate.

Flow Indicator

This field is not populated by the Movement Statistics Processor. Flow Indicator Code refers to the flow of goods and the pre-seeded values include:

0 - Bonded warehouse goods out to home country with an origin of home country

1 - Bonded warehouse export of goods

2 - Bonded warehouse storage under customs regulation

3 - Bonded warehouse goods out to home country

4 - Bonded warehouse storage of tax exempt goods

5 - Bonded warehouse movement of tax exempt goods

6 - Import / intra EU arrival

7 - Export / intra EU dispatch

You may manually enter this value by selecting from a pre-seeded list of values on the Movement Statistics Detail form or use the Call Out Program.

Functional (Reporting) Currency

In the Movement Statistics module, the Functional Currency is the currency used in reporting movement transactions (either paper based or electronically). All movement transactions transacted in another currency (the Transaction Currency) will require conversion. The Exchange Rate is the rate used to convert between the transaction currency to the functional / reporting currency.

For countries in the EU that have converted to the Euro, all transactions not in the Euro must be converted into the Euro.

GL Period

The General Ledger period in which the transaction took place.

Invoice Line

The invoice line number.

Invoice Number

The invoice number, usually generated by the system that processes invoices. This field is populated only if the transaction has been invoiced.

Invoice Quantity

The quantity invoiced as it appears on the invoice. This field is populated only if the transaction has been invoiced.

Invoice Unit Price

The invoice unit price as it appears on the invoice. This field is populated only if the transaction has been invoiced.

Invoice Extended Value

The invoice extended value calculated by multiplying the invoice unit price by the invoice quantity. This field is populated only if the transaction has been invoiced.

Inventory Item / Item Description

The item and item description.

In the Movement Statistics module, the ID of the transacted item as well as the description of the transacted item.

Inventory Organization

The inventory organization where the transaction took place is displayed.

Legal Entity / Economic Zones Associations

In the Movement Statistics module, users can specify the list of economic zones for which movement statistics need to be generated for a legal entity.

Mineral Oil Reference

This field is not populated by the Movement Statistics Processor. This field refers to the type of oil being transacted. The pre-seeded values include:

01 - Boiling Point Benzene, Refinery Resource Gasoline, Motor Fuel, Lub Oil, or Propane

02 - Other special Benzene, Feedstock Gasoline, Fuel Oil, Lub Gel, or Propane / Butane

03 - Waste Oil or Other

04 - Unmarketable Oil Products

05 - Other Heavy Oil Products

You may manually enter this value by selecting from a pre-seeded list of values on the Movement Statistics Detail form or use the Call Out Program.

Movement Amount

This field is calculated by the Movement Statistics Processor by multiplying the document unit price by the document quantity.

For example, in the a sales order transaction, the unit price and quantity are obtained from the sales order. In a purchase order transaction, the unit price and quantity are obtained from the purchase order.

Movement Number

In the Movement Statistics module, a unique numeric movement ID is assigned to each movement transaction. The Movement Number is generated by the Movement Statistics module automatically.

Movement Type

The Movement Type indicates whether the movement transaction is a: Arrival - report on all arrival movement statistics – receipt of goods transactions into economic zone countries

In the Movement Statistics module, the Movement Type is determined and assigned based on the Source Type, as follows:

Source Type / Movement Type
Source Type Movement Type
Sales order Dispatch
Purchase Order Arrival
Inventory Move Transactions Arrival / Dispatch (2 movement transactions; from Org - dispatch, to org- arrival)
Return to Vendor (RTV) Dispatch
RMA Arrival
Drop Shipments Both Arrival and Dispatch
Internal Sales Order / Internal Requisitions Dispatch
RECV - Purchase Order Arrival
TRNI / TRNR - Inventory Move Transactions Arrival / Dispatch (2 movement transactions: from Org - dispatch, to Org - arrival)
RTNR - Return to Vendor Dispatch
ADJI - Customer Return Arrival
XFER - Inventory In-transit Transfer Arrival / Dispatch (2 movement transactions: from Org - dispatch, to Org - arrival

Movement Status

Each movement statistics record is associated with a status that can assume one of the following values:

In the Movement Statistics module, once a movement statistics record has been reported to the government either on paper or using EDI, the record is set in a frozen status to avoid any modification or multiple reporting. Users have the option to reset the status of a reported batch of records in case they are refused by the authorities.

Origin

The country of origin is defined to be the country where the goods took on their current state. For example, if a PC were assembled in the US and then sold out of a distribution office from France to a customer in Spain, the country of origin would be the US.

In the Movement Statistics module, the purchase order receipt transaction correctly lists the Country of Origin of the item on the PO lines. For all other movement transactions, proper country of origin data is not available and the Country of Origin attribute is defaulted from the Dispatch Country.

Using the example above -- if a PC were assembled in the US and then sold out of a distribution office from France to a customer in Spain, the country of origin would be the US – the country of origin would be reported as follows in the Movement Statistics module:

Country of Origin
Source Type Country of Origin Dispatch Country Destination Country
RECV - Purchase Order Receipt US France Spain
TRNI / TRNR - Inventory Transactions France* France Spain
RTNR - Return to Vendor France* France Spain
ADJI - Customer Return France* France Spain
XFER - Inventory In-transit Transfer France* France Spain

* Dispatch Country is used at the Country of Origin

Outside Cost Price Code

If the transaction involves outside processing, the price code is displayed.

Outside Costs Unit Price

If the transaction involves outside processing, the outside processing unit price is displayed.

Outside Costs Extended Value

If the transaction involves outside processing, the outside processing extended value is calculated by multiplying the outside unit price by the transaction quantity.

Period Name

The reporting period when the transaction took place.

PO Number

The purchase order number generated by the system that processed the purchase order.

PO Line

The purchase order line number.

Port

This field is not populated by the Movement Statistics Processor.

The port is the port or airport of unloading in the case of arrivals and the port or airport of loading in the case of dispatches. The pre-seeded list is too large to display in this document.

You may manually enter this value by selecting from a pre-seeded list of values on the Movement Statistics Detail form or use the Call Out Program.

Report Reference

The Movement Statistics Official Summary report assigns a report reference number to all movement records that have been processed by the Official Summary Report. This report also updates the status of movement records to FROZEN.

Process Organization

For Oracle Process Manufacturing transactions, the Process Organization is displayed.

Quantity

The transaction quantity (in the transaction / source type specified).

In the Movement Statistics module, this field is also known as Quantity and is in the transaction unit of measure.

Receipt Number

The purchase order receipt number. The receipt number is generated by the system that processed the receipt.

Release Number

The release number of a purchase order release. This field is populated only if the transaction has a release number.

Reporting Tools

Movement Statistics reporting requirements includes reporting the total statistical and transaction value, the total weight, and the total number of records per reporting period.

The Movement Statistics module reports the total quantities for the default unit of measure and the sum of the value of the transactions per reporting period:

SO Line

The sales order line number.

SO Number

The sales order number generated by the system that processed the sales order.

Source Type

In the Movement Statistics module, movement transactions are known as Source Types. Valid Inventory, Purchasing and Order Management transaction types are as follows:

Statistical Procedure

This field is not populated by the Movement Statistics Processor.

In general, Statistical Procedure refers to the commercial nature of a shipment and to some extent replicates the information in the transaction nature code.

The pre-seeded list of Statistical Procedures is too large to display in this document.

You may manually update this field by selecting from the seeded list of values on the Movement Statistics Detail form or use the Call Out Program to insert your own Statistical Procedure values.

Transaction Nature Codes

The transaction nature code – code based on the characteristics of the transaction. A one or two digit code which identifies the class of transaction in which the movement of goods was involved for example sale, loan, and demo.

The Movement Statistics module uses lookups to select the value for Transaction Nature, Following is a list of pre-seeded data provided for this purpose.

In the Movement Statistics module, the Transaction Nature Code for a movement transaction is determined and assigned based on the Source Type and verified against the valid Transaction Codes.

The default Transaction Nature Codes for the specified Source Types (as used by the Movement Statistics module) are as follows:

Transaction Nature Codes
Transaction Nature (default) Source Type Transaction Nature Description
1 Sales Order Transaction involving ownership change
1 Purchase Order Transaction involving ownership change
1 RECV - Purchase Order Transaction involving ownership change
2 RMA Returned goods
2 ADJI - Customer Return Returned goods
4 Return to Vendor (RTV) goods for processing or repair
4 RTNR Goods for processing or repair
6 Inventory Move Transactions Movement of goods without the transfer of ownership except process or repair
6 TRNI / TRNR - Inventory Move Transactions movement of goods without the transfer of ownership except process or repair
6 XFER - Inventory In-transit Transfer Movement of goods without the transfer of ownership except process or repair
9 Drop Shipments Other
9 Internal Sales Order / Internal Requisitions Other
12 Consignment transaction An arrival record with Transaction code = 12 is created for consigned receipts
21 Returned goods A dispatch record with Transaction code = 21 is created for consigned returns

Movement Statistics Record Status

A movement statistics record can have one of the following values:

  1. OPEN: This is the initial status of all movement statistics records. At the time the Movement Statistics Processor creates a record, the record status is OPEN. You can modify a record in this status.

  2. VERIFIED: A record’s status is updated from OPEN to VERIFIED after the Movement Statistics Exception Report is then run. The Exception Report validates all records with a status of OPEN and all records that pass validation (that is, the record is error-free according to validation rules) will have a status of VERIFIED. Only movement records that pass validation will have a status of VERIFIED. All movement records with errors will remain in status OPEN. You can modify a record in this status but the record status will revert to OPEN.

  3. EDI: If a record is transmitted via EDI, the statuses of those records are updated to EDI. Only records with the status of VERIFIED may be updated to EDI. You can not modify a record in this status.

  4. FROZEN: The Movement Statistics Official Summary Report will update all VERIFIED movement records to FROZEN. Once a movement record’s status has been updated to FROZEN, it may not be modified. You can not modify a record in this status.

  5. EXPORT: If a record is extracted by the Data Export File concurrent program, the record status is updated to EXPORT (from FROZEN). You can not modify a record in this status.

  6. PENDING: If a movement record has not been invoiced and the Reference Period Rule is Invoiced Based the record will have a status of PENDING. The Reference Period Rule must be set to Invoiced Based for a movement record to have a status of PENDING. If the Reference Period Rule is Shipment Based, movement records will not have a status of PENDING. You can modify a record in this status.

  7. IGNORE: Only a movement record with a status of OPEN or VERIFIED may be updated to IGNORE. Once a record status of a record has been updated to IGNORE, the Movement Statistics Processor will no longer process the record, nor will this record be reported on any Movement Statistics Report. The Data Export concurrent program will not process records with a status of IGNORE. Movement records will remain in status of IGNORE unless manually updated on-line or by the running the Movement Statistics Reset Status concurrent program. You can modify a record in this status.

Modification Methods

You can use one of the following methods to modify a record status:

Supplementary Units

The requirement for Supplementary Units is part of the Intrastat Classification Nomenclature (ICN), and only applies to certain classes of products. The nature of the Supplementary Unit depends on the product; commonly, it may be the number of units, or the volume in liters, or the area in square meters, for example:

Supply Name

For purchase orders, the supplier number.

Supply Site

For purchase orders, the supplier site (address).

Supply Reference

This field is not populated by the Movement Statistics Processor.

Currently you may manually update the fields with the following values: ‘0’ for transactions based on CSA Codes or ‘1’ for transactions not based on CSA Codes. You may insert your own codes using the Call Out Program

TARIC Code

This field is not populated by the Movement Statistics Processor.

The TARIC (Integrated Tariff of the European Communities) code is designed to show the various rules applying to specific products when imported into the EU. This includes the provisions of the harmonized system and the combined nomenclature but also additional provisions specified in Community legislation such as tariff suspensions, tariff quotas, and tariff preferences, that exist for the majority of the Community’s trading partners. In trade with third countries, the 10-digit Taric code must be used in customs and statistical declarations. (From: Office of Agricultural Affairs, US Mission to the European Union.)

You must enter the TARIC Code manually or by using the Call Out program.

Total Weight

The total weight is calculated by multiplying unit weight by quantity.

Transaction Date

The date of the of the movement statistics transaction. In the Movement Statistics module, this is known as the Transaction Date. The date is derived from each valid Source Type:

Inventory, Purchasing, and Order Management Source Types
Source Type Transaction Date
Sales Order Sales Order Date
Purchase Order PO Date
Inventory Move Transactions Transaction Date
Return to Vendor RTV Date
RMA RMA Date
Drop Shipments Order Date
Internal Sales Order / Internal Requisitions Requisition Date

Transaction Reference

This field is not populated by the Movement Statistics Processor.

For Miscellaneous movement records (manually created records) you may enter free text information regarding the transaction in this field.

Transport Code

The Mode of Transportation code. A one-digit code indicating how the goods are transported.

The Movement Statistics module uses lookups to select the value for Transport Mode Code. The following is a list of pre-seeded data for this purpose.

In the Movement Statistics module, the Transportation Mode Code is defaulted from the freight carrier of the movement transactions and verified against the valid EU Transportation Mode Codes.

The valid EU Transportation Mode Codes are as follows:

  1. Transport by sea

  2. Transport by rail

  3. Transport by road

  4. Transport by air

  5. Consignments by post

  6. Fixed transport installations

  7. Transport by inland waterways

  8. Own propulsion

The default Transportation Code for all source types is 3- Transport by road

In the UK, upon creating a movement transactions, you must show the active mode of transport at the international border, as known to the trader.

Transport Container

This field is not populated by the Movement Statistics Processor.

This field is not populated by the Movement Statistics Processor. You may update this field manually with a value of ‘0’ indicating that a transport container was not used, or ‘1’ indicating that a transport container was used.

You may also use the Call Out Program to insert a transport container code.

Transaction Currency

In the Movement Statistics module, the Transaction Currency is the currency used in the transaction. The currency on the Source Type is the Transaction Currency. The Exchange Rate is the rate used to convert between the transaction currency to the functional or reporting currency.

For example, suppose that the Source Type is Sales Order with a currency of US Dollars, but the reporting currency is the Euro. The Movement Statistics module will use the exchange rate (as defined by the user) to convert between USD and Euro.

Transaction Nature Codes Used by Movement Statistics
Code Meaning Description
1 1 Transaction involving the change of ownership
10 10 Transaction involving the change of ownership
11 11 Transaction involving the change of ownership
12 12 consignment transaction involving the change of ownership
13 13 Barter transaction involving change of ownership
14 14 Traveler personal expenses
15 15 Lease transaction involving change of ownership
16 16 Credit note for 10 transaction
17 17 Type 10 shown on supplementary, not VAT return
18 18 Type 10 shown on VAT not supplementary return
2 2 Returned goods
20 20 Returned goods and replacement goods
21 21 Returned goods
22 22 replacement of returned goods
23 23 replacement of unreturned goods
26 26 Credit note for type 20 transaction
28 28 type 20 shown on Vat return not supplementary return
30 30 Free of charge transactions involving change of ownership
31 31 EU program free of charge transaction
32 32 Other government free of charge transaction
33 33 Other free of charge transaction
36 36 Credit note for type 30 transaction
37 37 Type 30 shown on supplementary, not VAT return
38 38 Type 30 shown on VAT , not supplementary return
4 4 Goods for processing or repair
40 40 Goods for processing or repair
41 41 Goods for processing
42 42 Goods for repair or maintenance
43 43 Goods for free of charge repair or maintenance
46 46 Credit note for type 40 transaction
47 47 Type 40 shown on supplementary, not VAT return
48 48 Type 40 shown on VAT, not supplementary return
5 5 Goods returned following process or repair
51 51 Goods returned following processing
52 52 Goods returned following repair or maintenance
53 53 Goods returned following free of charge repair or maintenance
56 56 Credit note for type 50 transaction
57 57 Type 50 shown on supplementary, not VAT return
58 58 Type 50 shown on VAT, not supplementary return
6 6 Movement of goods without the transfer of ownership except process or repair
60 60 Movement of goods without transfer of ownership
61 61 Movement of goods involving lease or rental
62 62 Other movement of goods not involving ownership change
66 66 Credit note for type 60 transaction
67 67 Type 60 shown on supplementary, not VAT return
68 68 type 60 shown on VAT, not supplementary return
7 7 Joint defense or intergovernmental programs
70 70 Joint defense or intergovernmental programs
71 71 Joint defense or intergovernmental programs
72 72 Airbus program
76 76 Credit note for type 70 transaction
77 77 Type 70 shown on supplementary, not VAT return
78 78 Type 70 shown on VAT, not supplementary return
8 8 Supply of building materials and equipment
80 81 Supply of building materials and equipment
81 81 Supply of building materials and equipment
86 86 Credit note for type 80 transactions
87 87 Type 80 shown on supplementary, not VAT return
88 88 Type 80 shown on VAT, not supplementary return
9 9 Other transactions
90 90 Other transactions
91 91 Other transactions
92 92 Receiving of goods, put in inventory for distribution to customers afterward
96 96 Credit note for type 90 transaction
97 97 Type 90 shown on supplementary, not VAT return
98 98 Type 90 shown on VAT not supplementary return
99 99 Other transactions

Triangulation

The country involved in a triangular trade transaction. This field is populated only for triangulation transactions.

Your customer is located in Germany and places a sales order with you in France and you source the order from the Netherlands. In this case, the triangulation country would be the Netherlands.

Unit Price

The price of a single unit of the item transacted in the movement record.

Unit Weight

The weight of a single unit of the item transacted in the movement record.

Usage Type / Statistical Type

Movement transactions are divided into two groups, as follows: For each legal entity / economic zones users define which statistical types, such as INTRASTAT or EXTRASTAT, need to be recorded for each type of movement (Internal - movement of goods within countries of the economic zone - or External movement of goods from a country of the economic zone to a country outside the zone).

Usage Type, Statistical Type, and Description
Usage Type Statistical Type Description
Internal Intrastat Movement transactions within the economic zone, for example the EU.
External Extrastat Movement transactions outside of the economic zone, for example, between France and the US.

The Movement Statistics module determines Usage Type and Statistical Type based on the Dispatch and Destination Country codes.

Unit of Measure (UOM)

The unit of measure for the transaction quantity. In Movement Statistics this is known as the UOM.

Value

Value is defined as the monetary value of the movement in the default currency for the legal entity.

Oracle’s movement statistics solution calculates value as follows:

Value = unit price * transaction quantity

Outside Value

The Outside Value is calculated by multiplying the outside unit price by the transaction quantity. Outside value includes the price of services.

Invoice Value

The Invoice Value is calculated by multiplying the invoice price (as recorded on the Invoice) by the invoice quantity. The Invoice Value is displayed in the Transaction Currency.

Transaction Value The Transaction Value is calculated by multiplying the Invoice amount by the Exchange Rate (the parameter value you enter when running the Movement Statistics report). The Transaction Value is displayed in Functional Currency.

Statistical Value

The value of the movement or transaction of goods exclusive of VAT but inclusive of transport costs within the border of own EC member state multiplied by the exchange rate (the parameter value you enter when running the Movement Statistics report). The Transaction Value is displayed in Functional Currency. This value is the delta between the Transaction Value and the Statistical Value. This is a manual modification

User Defined Validation Rules

The following Source Types (transaction types) may be modified in a user defined Validation Rule Set:

  1. Customer Return

  2. Inventory

  3. Internal Order

  4. Miscellaneous

  5. Purchase Order

  6. Sales Order

The source types above use the following Attribute Names (fields)

  1. Transaction Code

  2. Transportation Mode

  3. Port Deliver Terms

  4. Statistical Procedure Code

  5. Area

  6. Outside Code

  7. Outside Cot Unit Price

  8. Outside Cost Extended Value

  9. Supply Reference

  10. Oil Reference Code

  11. Container Type Code

  12. Flow Indicator Code

  13. Affiliation Reference Code

Note: Each Source Type uses all 13 of the Attribute Names (fields) listed. You must define a property for each Attribute Name.

When defining your Attribute Rule Set, you must defined one of the following Attribute Rule Set Property combinations:

Export Data File Format

The following is the format of the data export file created by the Movement Statistics Data Export concurrent program.

Arrival Record Format

  1. The Country of Consignment is the dispatch country

  2. Invoice Value, Invoice Number, and Invoice Currency: if an invoice exists, these fields are populated. If no invoice exists, the Invoice Value is populated with the Movement Amount, Invoice Number, and Invoice Currency are not populated

  3. Province / Department / German State Code: all refer to the Area.

Arrival Data Export File
Field Name Description Position Length
Commodity Code The Intrastat Nomenclature commodity code 1 8
Consignment Country (2 digit) The trading partner country, for arrivals, the country of dispatch, for dispatches, and the destination country. 9 2
Consignment Country (3 digit) The trading partner country, for arrivals, the country of dispatch, for dispatches, and the destination country. 11 3
Transaction Nature A one or two digit code based on the characteristics of the transaction. It identifies the class of transaction in which the movement of goods was involved, for example sale, loan, or demo 14 2
Transport Mode A one-digit code indicating how the goods are transported. 16 1
Statistical procedure / Regim This code denotes the commercial nature of the shipment (similar to the transaction nature). 17 5
Port The Port is the location of transshipment associated with the movement transaction. 22 5
Area / Province / Department / German State Code Area / Province / Department / German State Code Predefined code which specifies the area the goods arrived or departed from a specific EC member state. 27 10
Incoterms / Delivery Terms The current list of EU Delivery Codes are sometimes referred to as Incoterms and were established in part by the International Chamber of Commerce (ICC) to determine at which point the transfer of title takes place in a transaction where goods are bought or sold. 37 3
Incoterm Supplement For France (only), the standard delivery terms / incoterms must be declared together with an extra character (a 1 or 2) which indicates whether transportation costs are paid in France or elsewhere. 40 1
Weight (Net Mass) The weight (mass) of the transaction in Kilograms. 41 15*
Supplementary Units The Supplementary Units is part of the Intrastat Classification Nomenclature (ICN), and only applies to certain classes of products. The nature of the Supplementary Unit depends on the product; commonly, it may be the number of units, or the volume in liters, or the area in square meters. 56 15*
Origin Country (3 digits) The country from which the goods originated. 71 2
Statistical Value The value of the movement or transaction of goods exclusive of VAT but inclusive of transport costs within the border of own EC member state multiplied by the exchange rate. 73 15*
Invoice Value Local Currency The value to the invoice in the local currency specified. 88 15*
Invoice Value Foreign Currency The value to the invoice in the foreign currency specified. 103 15*
Invoice Number The invoice number of the transactions if there is one available. 118 25
Invoice Foreign Currency (Currency Code) The invoice reporting currency. 143 3
Trading Partner VAT Number The VAT number of the trading partner. 146 20
Free Text Free text area 166 200

*The maximum length is 15 digits or 12 digits + 2 decimals (a total of maximum 15 characters long).

Dispatch Record Format

Note the following for the Dispatch data export file:

  1. The Country of Consignment is the destination country

  2. Invoice Value, Invoice Number, and Invoice Currency: if an invoice exists, these fields are populated. If no invoice exists, the Invoice Value is populated with the Movement Amount, Invoice Number, and Invoice Currency are not populated

  3. Province / Department / German State Code: all refer to the Area

Dispatch Record Format
Field Name Description Position Length
Commodity Code The Intrastat Nomenclature commodity code. 1 8
Consignment Country (2 digit) The trading partner country, for arrivals, the country of dispatch, for dispatches, and the destination country. 9 2
Consignment Country (3 digit) The trading partner country, for arrivals, the country of dispatch, for dispatches, and the destination country. 11 3
Transaction Nature A one or two digit code based on the characteristics of the transaction. It identifies the class of transaction in which the movement of goods was involved for example sale, loan, or demo. 14 2
Transport Mode A one-digit code indicating how the goods are transported. 16 1
Statistical Procedure / Regim This code denotes the commercial nature of the shipment (similar to the transaction nature). 17 5
Port The Port is the location of transshipment associated with the movement transaction. 22 5
Area / Province / Department / German State Code Predefined code which specifies the area the goods arrived or departed from a specific EC member state. 27 10
Incoterms/Delivery Terms The current list of EU Delivery Codes are sometimes referred to as Incoterms and were established in part by the International Chamber of Commerce (ICC) to determine at which point the transfer of title takes place in a transaction where goods are bought or sold. 37 3
Incoterm Supplement For France (only), the standard delivery terms / incoterms must be declared together with an extra character (a 1 or 2) which indicates whether transportation costs are paid in France or elsewhere. 40 1
Weight (Net Mass) The weight (mass) of the transaction in Kilograms. 41 15*
Supplementary Units The Supplementary Units is part of the Intrastat Classification Nomenclature (ICN), and only applies to certain classes of products. The nature of the Supplementary Unit depends on the product; commonly, it may be the number of units, or the volume in liters, or the area in square meters. 56 15*
Origin Country (3 digit) The country from which the goods originated. 71 2
Statistical Value The value of the movement or transaction of goods exclusive of VAT but inclusive of transport costs within the border of own EC member state multiplied by the exchange rate. 73 15*
Invoice Value Local Currency The value to the invoice in the local currency specified. 88 15*
Invoice Value Foreign Currency The value to the invoice in the foreign currency specified. 103 15*
Invoice Number The invoice number of the transactions if there is one available. 118 25
Invoice Foreign Currency (Currency Code. The invoice reporting currency. 143 3
Trading Partner VAT Number The VAT number of the trading partner. 146 20
Free Text Free text area. 166 200

*The maximum length is 15 digits or 12 digits + 2 decimals (a total of maximum 15 characters long).