This appendix covers the following topics:
The countries that make up the European Union are as follows. Note that the European Union Economic Zone is pre-seeded in the system.
| 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 |
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
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.
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.
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
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.
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
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
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.
The batch number that processed either the Purchase Order or Sales Order invoice. The batch number is generated by your system when processing invoices.
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.
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.
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.
For sales order transactions, the customer name is displayed.
For sales order transactions, the customer number is displayed.
For sales order transactions, the customer site is displayed.
The date the invoice was created.
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:
EXW - ex works
FVA - Free Carrier
FAS - Free Alongside Ship
FOB - Free on Board
CFR- Cost and Freight (C&F)
CIF - Cost, Insurance, and Freight
CPT - Carriage Paid to Agreed Destination
DAF - Delivered at Frontier
DES - Delivered ex Ship
DEQ Delivered ex Quay
DDU - Delivered Duty Unpapid
DDP - Delivered Duty Paid
XXX - delivery terms other than above
The default Delivery Code for all Source types is CIF - Cost, Insurance, and Freight
For sales order transactions, the delivery name is displayed.
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.
| 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 |
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.
| 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 |
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 |
|---|---|
| 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 |
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.
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.
In the Movement Statistics module, you define economic zones as an association of countries.
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.
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.
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.
The General Ledger period in which the transaction took place.
The invoice line number.
The invoice number, usually generated by the system that processes invoices. This field is populated only if the transaction has been invoiced.
The quantity invoiced as it appears on the invoice. This field is populated only if the transaction has been invoiced.
The invoice unit price as it appears on the invoice. This field is populated only if the transaction has been invoiced.
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.
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.
The inventory organization where the transaction took place is displayed.
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.
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.
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.
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.
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
Arrival Adjustment - report on all adjustments to prior period arrival movement statistics
Dispatch - report on all dispatch movement statistics – sales order / movement of goods transactions from economic zone countries
Dispatch Adjustment - report on all adjustments to prior period dispatch movement statistics
In the Movement Statistics module, the Movement Type is determined and assigned based on the Source Type, as follows:
| 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 |
Each movement statistics record is associated with a status that can assume one of the following values:
Each movement statistics record is associated with a status that can assume one of the following values:
Verified - record validated by the exception report
Frozen - record reported to the government through paper based report
EDI sent - record reported to the government through EDI transaction
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.
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:
| 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
If the transaction involves outside processing, the price code is displayed.
If the transaction involves outside processing, the outside processing unit price is displayed.
If the transaction involves outside processing, the outside processing extended value is calculated by multiplying the outside unit price by the transaction quantity.
The reporting period when the transaction took place.
The purchase order number generated by the system that processed the purchase order.
The purchase order line number.
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.
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.
For Oracle Process Manufacturing transactions, the Process Organization is displayed.
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.
The purchase order receipt number. The receipt number is generated by the system that processed the receipt.
The release number of a purchase order release. This field is populated only if the transaction has a release number.
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:
Statistical value
Transaction Value
Total Weight
Number of movement transactions
The sales order line number.
The sales order number generated by the system that processed the sales order.
In the Movement Statistics module, movement transactions are known as Source Types. Valid Inventory, Purchasing and Order Management transaction types are as follows:
purchase order Receipts
Return to Vendor (RTV)
Sales Orders
Return Material Authorization (RMA)
Supplier Drop Shipments (triangulation)
Multiorg Intercompany Drop Shipments
Inventory interorganization Movements
Internal Requisitions and Internal Sales Orders
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.
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 (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 |
A movement statistics record can have one of the following values:
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.
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.
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.
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.
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.
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.
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.
You can use one of the following methods to modify a record status:
Movement Statistics Reset Status Concurrent Program: This concurrent program will update all records, except those with a status of IGNORE, within a specified legal entity and period to OPEN. You may update movement records with a status of IGNORE to OPEN with this concurrent program.
Movement Statistics Exception Report: This report will update a record’s status from OPEN to VERIFIED after being validated (only records that are successfully validated will have their status updated to VERIFIED, record that fail validation will remain with a status of OPEN.
Movement Statistics Processor: The processor creates movement statistics records with a status of OPEN or PENDING.
Movement Statistics Data Export File: The status of all movement statistics records processed by this concurrent program are updated to EXPORT.
EDI: Any record transmitted via Oracle’s e-Commerce Gateway will have their status updated to EDI.
Movement Statistics Official Summary: This concurrent program will update the status of all VERIFIED records to FROZEN.
Online: Individual movement records may be updated on-line using the Movement Statistics Detail form. Movement records may be updated in the following manner:
from IGNORE to OPEN
from VERIFIED to IGNORE
from OPEN to VERIFIED
from OPEN to IGNORE
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:
Live animals: the number of animals shipped
Skis: the number of pairs
Diamonds: carats
For purchase orders, the supplier number.
For purchase orders, the supplier site (address).
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
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.
The total weight is calculated by multiplying unit weight by quantity.
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:
| 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 |
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.
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:
Transport by sea
Transport by rail
Transport by road
Transport by air
Consignments by post
Fixed transport installations
Transport by inland waterways
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.
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.
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.
| 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 |
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.
The price of a single unit of the item transacted in the movement record.
The weight of a single unit of the item transacted in the movement record.
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 | 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.
The unit of measure for the transaction quantity. In Movement Statistics this is known as the UOM.
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
The following Source Types (transaction types) may be modified in a user defined Validation Rule Set:
Customer Return
Inventory
Internal Order
Miscellaneous
Purchase Order
Sales Order
The source types above use the following Attribute Names (fields)
Transaction Code
Transportation Mode
Port Deliver Terms
Statistical Procedure Code
Area
Outside Code
Outside Cot Unit Price
Outside Cost Extended Value
Supply Reference
Oil Reference Code
Container Type Code
Flow Indicator Code
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:
required / not updateable
not required / updateable
required / updateable
not required / not updateable
The following is the format of the data export file created by the Movement Statistics Data Export concurrent program.
The Country of Consignment is the dispatch country
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
Province / Department / German State Code: all refer to the Area.
| 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).
Note the following for the Dispatch data export file:
The Country of Consignment is the destination country
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
Province / Department / German State Code: all refer to the Area
| 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).