Maintaining Intrastat Transactions
The system compiles eligible transactions automatically for Intrastat reporting. This process populates the nature of transaction code, based on the defaults that are specified on the Nature of Transaction Code pages. The values that you select on the Fiscal Regime/Stat Procedure (fiscal regime/statistical procedure) page also appear by default where they apply. You can change the default values, alter information, or delete a transaction with the Intrastat Transaction Entry pages. You can also enter a transaction that isn't included in those that are automatically compiled.
Note: You must run the Intrastat Transaction Loader process before you can change automatically compiled Intrastat transactions.
This section discusses how to maintain Intrastat transactions.
Page Name |
Definition Name |
Usage |
---|---|---|
IST_TXN_TBL1 |
Change and add an Intrastat transaction. If you are changing an existing entry, enter an Intrastat Document ID. |
|
IST_TXN_TBL2 |
Change or add Intrastat transaction details. |
|
Intrastat Txn Exchange Rate (Intrastat Transaction Exchange Rate) Page |
IST_TXN_SEC |
View additional currency information after running the Report Extract process. |
Use the Header Detail page (IST_TXN_TBL1) to change and add an Intrastat transaction.
If you are changing an existing entry, enter an Intrastat Document ID.
Navigation:
You must run the Intrastat Transaction Loader process before you can view transactions that are compiled automatically.
Note: Designated country and flow selections on Intrastat Characteristics pages determine which fields are available for entry on this page. Field labels change, based on the flow.
Flow |
Field Name |
Intrastat Characteristics Page |
Field That Is Checked on the Intrastat Characteristics Page |
---|---|---|---|
Arrivals or Dispatches |
VAT Reg Country |
Option a |
Trading Partner Registration group box - Registration Required |
Arrivals |
Consignment Country |
Option b |
Country of Consignment |
Dispatches |
Destination Country |
Option b |
Country of Destination |
Dispatches |
Region of Origin |
Option a |
Region of Origin |
Arrivals |
Region of Destination |
Option a |
Region of Destination |
Arrivals or Dispatches |
Transport Mode |
Option a |
Transport Mode |
Arrivals |
Port of Unloading |
Option a |
Port/Airport of Unloading |
Dispatches |
Port of Loading |
Option a |
Port/Airport of Loading |
Field or Control |
Description |
---|---|
Intrastat Transaction Source |
Displays one of the following values when you update an existing transaction: Billing Adjustment: Financial adjustment (against dispatches) from PeopleSoft Billing. Shipment Return: Return-to-vendor shipments (dispatches). This value also appears when a purchase order receipt contains rejected quantities that are returned to vendors. Shipment: Normal shipments from sales orders (dispatches). InterUnit Shipment: Shipments from interunit orders (dispatches). Purchasing Receipt: Purchase order receipts (arrivals). InterUnit Receipt: Interunit order receipts (arrivals). RMA Receipt (return material authorization receipts): Returns from customers (arrivals). Voucher Adjustment: Financial adjustment (against arrivals) from PeopleSoft Payables. Manual Entry: Appears when you add a transaction. |
Trading Partner Details
Field or Control |
Description |
---|---|
Partner Type |
Select either Customer or Supplier as a trading partner's designation for the transaction. |
Partner SetID |
Determines which suppliers or customers are available in the Partner ID field. |
Partner ID |
Select a supplier or customer ID. |
VAT Reg Country (value-added tax registration country) |
Select the trading partner's VAT registration country. |
VAT Registration ID (value-added tax registration ID) |
Appears by default, if the trading partner's ID exists in the system; otherwise, you enter the ID number. |
Note: Only countries that are designated as EU member states on the Country page in the Location menu are available for selection. Select Set Up Financials/Supply Chain, Common Definitions to access the Location menu.
Country, Region, Transport Mode, and Port
Select values for these fields, as required by the choices on the Intrastat Characteristics pages.
Delivery Terms
Select values for these fields, as required by the choices on the Intrastat Characteristics pages.
Field or Control |
Description |
---|---|
1st Subdivision |
Delivery terms for the transaction may be any of the following values: CFR (Cost and freight). CIF (Cost, insurance, and freight at port of arrival). CIP (Carriage and insurance paid to). CPT (Carriage paid to). DAF (Delivery at frontier). DDP (Delivered duty paid). DDU (Delivered duty unpaid). DEQ (Delivered ex-quay). DES (Delivered ex-ship). EXW (Ex-works). FAS (Free alongside ship). FCA (Franco carrier). FOB (Free on board at port of departure). Other Delivery terms that differ from the listed values. |
2nd Subdivision |
Delivery terms include: In Rprting (in reporting): Located in the territory of the declarant member state. Other EU: Located in another member state. Other: Located outside of the EU. |
Use the Line Detail page (IST_TXN_TBL2) to change or add Intrastat transaction details.
Navigation:
Field or Control |
Description |
---|---|
Item SetID |
Select the SetID if you are specifying an inventory item. |
Item ID |
Specify an inventory ID. |
Line |
Displays the number of the current line. The line number increases by one as rows are inserted. |
Commodity Cd(Commodity Code) |
Select the EU Commodity Code associated with the goods being shipped or received. If you have entered an inventory item and assigned a commodity code to that item, the system automatically populates the commodity code. Otherwise, you must enter it manually. |
Origin Country |
Select a country of origin for arrivals. |
Quantity |
The system calculates the net mass by multiplying the quantity by the unit weight. |
UOM(unit of measure) |
Select the unit of measure in which the quantity is specified. If you have entered an inventory item, the system automatically populates the standard UOM specified for this item. |
Unit Weight |
Enter the item's weight by unit. If you have entered an inventory item, the system automatically populates this field with the weight specified for this item. It is assumed that the weight is specified in kilograms. |
Net Mass |
The total weight of the goods being shipped or received. The system automatically calculates this based on the quantity and weight of the item. |
(Supplementary) UOM |
Enter the unit of measure of the supplementary units. If you have manually entered an EU Commodity Code, and if that EU Commodity Code requires that supplementary units be reported, and if the supplementary UOM has been specified on the commodity code, the system populates this automatically. |
Suppl Units (supplemental units) |
If the EU Commodity Code associated with this transaction requires the reporting of supplementary units, enter the number of units. |
Fiscal Regime |
Select a value if you are reporting in a country that requires fiscal regimes. |
Stat Procedure (statistical procedure) |
Select a value if you are reporting in a country that requires statistical procedures. |
Nature of Transaction
Field or Control |
Description |
---|---|
1st Digit and 2nd Digit |
All EU member states require the first digit for Intrastat reporting. In addition, several EU member states use a second digit to categorize transactions. These values are predefined. The appropriate set of values for this second digit is available based on what is defined on the Country Characteristics pages. |
Invoice Amount
Field or Control |
Description |
---|---|
Reporting |
The reporting currency appears. If you leave the field blank, the report extract calculates the reporting amount from the value for transaction or base currency. |
Transaction |
Enter the transaction currency. |
Base |
Enter the base currency. |
Amount |
Enter the values for each currency type. |
Statistical Value |
Enter a value. If you leave the field blank, the Report Extract process calculates the amount based on the settings on the Statistical Value Details page. |
Amount Source |
Display options include: Invoice: Appears if the amount came from an invoice, adjusted invoice, voucher, or adjusted voucher. Order: Appears if the amount came from a sales order, interunit order, purchase order, RMA order, or return to vendor order. Manual: Appears if you manually enter a transaction. |
Reporting Currency Details |
Click to access additional currency information. |
Use the Intrastat Txn Exchange Rate (Intrastat Transaction Exchange Rate) page (IST_TXN_SEC) to view additional currency information after running the Report Extract process.
Navigation:
Once the Report Extract process runs, this page appears with the exchange rate type from the Intrastat Report Extract page.
If the reporting currency is the same as either the base or transaction currency, the Report Extract process uses the base (or transaction) amount for the reporting amount. In this case, the Exchange Rate Source field displays BSE (base) or TXN (transaction). Otherwise, the Report Extract process calculates the reporting amount, in which case TBL (exchange rate table) appears.