SROECT is used to transfer EU statistics (INTRASTAT) information connected to invoice documents. This file is only handled if EU reporting is YES in Work with companies. The following fields exist in SROECT:
| Field | Length | Description |
|---|---|---|
| ETACYE | 4,00 | Accounting year (Text in file: Accounting year) Not allowed. The accounting year will be completed by the system from the accounting period of the transaction. |
| ETANSC | 17,04 | Ancillary cost in system currency (Text in file: Ancillary cost in system currency) Optional. If zero the value is calculated by the system, using ancillary cost in transaction currency as base. |
| ETANTC | 17,04 | Ancillary cost in transaction currency (Text in file: Ancillary cost in transaction currency) Optional. Defines the value of ancillary cost connected to the intrastat transaction. |
| ETANVC | 17,04 | Ancillary cost in VAT currency (Text in file: Ancillary cost in VAT currency) Optional. If zero the value is calculated by the system, using ancillary cost as base. |
| ETCSNO | 18 | Commodity code (Text in file: Commodity code) Mandatory. The entered commodity code is validated against the Commodity code table. |
| ETDCOU | 4 | Country dispatched to/arrived from (Text in file: Country dispatched to/arrived from) Optional for arrivals. Mandatory for dispatches. If not entered and optional (i.e. on arrival) it will be defaulted from debtor/supplier Country. If entered the country must be an EU member. |
| ETDDAT | 8,00 | Delivery date (Text in file: Delivery date) Optional. (Century/Year/Month/Day). If entered, must be entered in format CCYYMMDD. |
| ETDPNO | 2 | Department (Text in file: Department) Mandatory. If YES in Country table for trader country this field is mandatory, and corresponding entry must exist in Department table. If Department is set to code for NO in Country table for trader country the field must be left blank. |
| ETERCD | 1 | Error code (Text in file: Error code) Not allowed. This is a work field. |
| ETINVN | 12,00 | Invoice number (Text in file: Invoice number) Mandatory. Must correspond to the invoice number to which the statistics are connected. |
| ETJONO | 5,00 | Journal number (Text in file: Journal number) Not allowed. The journal number will be completed by the system when a journal is created. |
| ETLINE | 5,00 | Order line number (Text in file: Order line number) Optional. This field can be used for reference to the Distribution order line number in conjunction with field ETORNO = order number. |
| ETMOTC | 3 | Manner of transport (Text in file: Manner of transport) Mandatory. Validated against the Manner of transport table. |
| ETNOTR | 3 | Nature of transaction (Text in file: Nature of transaction) Mandatory. Validated against the Nature of transaction table. |
| ETOCOU | 4 | Country of origin (Text in file: Country of origin) Mandatory for flow arrivals. Optional for flow dispatches validated against the Country table. |
| ETORNO | 12,00 | Order number (Text in file: Order number) Optional. This field can be used as a reference to the Distribution order number. |
| ETPOVA | 4 | Port of arrival/dispatch (Text in file: Port of arrival/dispatch) Mandatory. If sea transport is set to YES in the corresponding Manner of transport table entry. Not allowed if sea transport is set to NO. |
| ETPRDC | 35 | Item (Text in file: Item) Optional. If entered and DIS installed, checked towards DIS Item file. |
| ETQTY | 15,03 | Stock quantity (Text in file: Stock quantity) Optional. This field can be used for quantity in stock units. |
| ETQTYN | 1 | Quantity statistics Y/N (Text in file: Quantity statistics Y/N) Optional. If field left blank YES will be defaulted. |
| ETQUAN | 13,03 | Weight in Kilo (Text in file: Quantity) Optional/Mandatory/Not allowed. Mandatory if quantity statistics is set to YES and if a reporting unit is defined for the commodity code. Not allowed if quantity statistics is set to NO. |
| ETREFX | 15,00 | Reference number (Text in file: Reference number) Mandatory. Field must hold value of the reference number indicating the related invoice/credit note. |
| ETRPQT | 15,03 | Quantity reporting unit (Text in file: Quantity reporting unit) Mandatory/Not allowed. If commodity code entered has a reporting unit defined and quantity statistics set to, if you have entered a value for delivered/received (used) quantity and the conversion factor is defined between delivered and reported unit this field, if left blank, will be defaulted with the amountCalculated by the system. |
| ETRUNI | 5 | Reporting unit (Text in file: Reporting unit) Mandatory/Not allowed. If commodity code used is defined with reporting unit then reporting this field is mandatory, however it will be defaulted with the Reporting unit for the commodity code value if left blank. If the commodity code is defined without Reporting unit this field must be left blank. If a reporting unit is defined, it must correspond to the reporting unit defined for the commodity code. |
| ETSQ70 | 7,00 | Sequence number (Text in file: Sequence number) Not allowed. Will be completed by the system when a journal is created. |
| ETSTAP | 5 | Statistical procedure (Text in file: Statistical procedure) Optional. If not entered the field will be defaulted from the value defined for trader country in the Country table. |
| ETSYID | 1 | System id 1/2/3 (Text in file: System id 1/2/3) Mandatory. Must be 2 or 3 (2 = A/R, 3 = A/P). |
| ETTCUR | 4 | Transaction currency (Text in file: Transaction currency) Mandatory. Must be the same as base transaction (invoice/credit note). |
| ETTODC | 3 | Terms of delivery (Text in file: Terms of delivery) Optional. This is used for calculating the border value. If entered, validated against the Terms of delivery table. Note: “999” is also accepted. |
| ETUNIT | 5 | Delivered/Received (Text in file: Delivered/Received unit) Mandatory/Not allowed. Not allowed if Quantity statistics (ETQTYN) is set to NO. Mandatory if code for Quantity statistics is set to YES and Delivered/Received quantity (ETHQTY) has been defined. If unit is entered it will be validated against the Unit table. |
| ETUSED | 1 | Status (Text in file: Status) Not allowed. This is a work field. |
| ETVCUR | 4 | VAT reporting currency (Text in file: VAT reporting currency) Not allowed. The VAT reporting currency will be completed by the system using the trader country definition. |
| ETAMSY | 17,03 | Amount in system currency (Text in file: Amount in system currency) Optional. If value is zero, it will be calculated from amount in transaction currency. |
| ETAMTR | 17,03 | Amount in transaction currency (Text in file: Amount in transaction currency) Mandatory. Value of transaction in transaction currency. |
| ETAMVC | 17,03 | Amount VAT currency (Text in file: Amount VAT currency) Optional. If value is zero, it will be calculated from amount in transaction currency. |
| ETHQTY | 15,03 | Delivered/Received (used) quantity (Text in file: Delivered/Received used quantity). Mandatory/Not allowed. Mandatory if quantity statistics is set to YES and Delivered/Received unit has been defined. Not allowed if Quantity statistics (ETQTYN) is set to NO. |