You need to know the following in order to be able to work with the Parallel files in Query/400, after the System currency conversion has been run.
What is a parallel file?
A parallel file is a copy of a file included in the System currency conversion run. It holds the original values before the file was converted. The purpose of the parallel file is to, at any time after the conversion, be able to retrieve information such as amount in system currency as well as exchange rate values, exactly as they looked before the system currency was changed.
When is it created?
A parallel file is created during the System currency conversion run just before the conversion of the file begins.
Mandatory for all files?
It is not mandatory to create parallel files. The decision should be based on total available disk space for the installation as well as the customer needs for historic values after conversion. For further information on how to select or de-select parallel files, see About running the system currency conversion.
Note: Parallel files are not available for all files included in the standard conversion run. See the lists per application below for information about all available parallel files.
What is included?
All transactions are copied to the parallel file, i.e. open transactions as well as historic. A parallel file is thus not a complete copy of the original file. It only holds amounts in system currency and exchange rate values, and the necessary key fields needed to access the data.
Where is it stored?
All parallel files are stored in the company unique conversion library created for the system currency conversion. The library is called A7SCT01xx where xx is the company code.
How is it named?
The fixed part of the parallel file name, which is also the first part, is always SCO for DC1 Financials and DC1 Distribution. For DC1 Manufacturing the first part varies depending on the original file name. See the lists of parallel files below. The variable part of the name is the same as the ordinary physical file. For example:
| Original file name |
Parallel file name |
|---|---|
| SROPST | SCOPST |
| ANOBAL | SCOBAL |
When is it deleted?
The parallel file must be deleted manually when it is no longer needed. They can be deleted individually or all at the same time by deleting the whole company unique library.
How to join files?
Since not all information from the original file is stored in the parallel file it may be necessary to attach (in Query/400) it to the original file in order to access the information you are looking for. To find out which key fields to use for the attachment you must look in the DDS sources for each parallel file. The sources can be found in the library SCT700AP; the key fields are always defined first in the source.
See the example of a DDS source below. The line marked as A*, sequence number 006.00, defines where the key ends.
 |
Parallel files
DC1 General
| File | File description | Parallel file |
|---|---|---|
| ANOBAL | Balance file | SCOBAL |
| ANOBOB | Balance file for opening balances | SCOBOB |
| ANOBUD | Budget file | SCOBUD |
| SRONOI | Customer – sales order info | SCONOI |
DC1 Financials
| File | File description | Parallel file |
|---|---|---|
| SROCBA | Cash Book transactions | SCOCBA |
| SROCFB | PV. Cash flow forecast value file | SCOCFB |
| SROCMA | A/R customer file | SCOCMA |
| SRODAY | Expected payment deviation days | SCODAY |
| SRODTA | A/R Transaction file | SCODTA |
| SRODTAB | A/R transaction file, bills | SCODTAB |
| SRODTAR | A/R Transaction file, redefinition transactions | SCODTAR |
| SRODTGI | G/L group-id detail bookings | SCODTGI |
| SROECA | A/R EC statistics entry file | SCOECA |
| SROECF | Sales/Purchase final statistics | SCOECF |
| SROGIT | Goods-in-transit G/L postings | SCOGIT |
| SROGITH | Goods-in-transit G/L postings | SCOGITH |
| SROLEN | Liquid entry | SCOLEN |
| SROLENP | A/P Liquid entry | SCOLENP |
| SROLOGBT | Logistic accounting Trans. Log | SCOLOGBT |
| SROLOGGL | G/L Transaction log file | SCOLOGGL |
| SROLPS | A/P payment statistics | SCOLPS |
| SROLPX | A/P settlement path index | SCOLPX |
| SROLTA | A/P transaction file | SCOLTA |
| SROLTAL | A/P Transaction file, invoice lines | SCOLTAL |
| SROLTAR | A/P Transaction file, redefinition transactions | SCOLTAR |
| SROLTPG | A/P Transaction file, preliminary G/L transactions | SCOLTPG |
| SROLTPH | A/P Transaction file, preliminary A/P historic | SCOLTPH |
| SROPAY | A/R Payment statistics | SCOPAY |
| SROPIG | A/P inv matching – pre inv G/L posting | SCOPIG |
| SROPST | G/L Transaction file | SCOPST |
| SROSAD | Supplier agreement details | SCOSAD |
| SROSAQ | Suppl. agreement qty dep. prices/disco | SCOSAQ |
| SROVAT | VAT transaction file | SCOVAT |
| SROVPH | A/R Settlement path heading | SCOVPH |
| SROVPX | A/R Settlement path index | SCOVPX |
DC1 Asset Management
| File | File description | Parallel file |
|---|---|---|
| AAOABA | Asset balances | SCOABA |
| AAOABI | Asset basic information | SCOABI |
| AAOADI | Depreciation information | SCOADI |
| AAOINB | Investment budget | SCOINB |
| AAOSPL | Asset split information | SCOSPL |
| AAOTRN | Transaction file | SCOTRN |
DC1 Distribution
| File | File description | Parallel file |
|---|---|---|
| SROBAD | Basket Details | SCOBAD |
| SROBAH | Basket header | SCOBAH |
| SROBITR | Batch inventory transactions | SCOBITR |
| SROCCI | Customer Contract Item Details | SCOCCI |
| SROCLI | Calculation item line | SCOCLI |
| SROCRP | Credit profile | SCOCRP |
| SROCTLCS | Cash register code table | SCOCTLCS |
| SROCTLDH | Inventory transaction type tbl | SCOCTLDH |
| SROCTLRM | Surcharge table | SCOCTLRM |
| SROCTLRS | Requests and Returns resolution code table | SCOCTLRS |
| SROCTLSD | Signature table | SCOCTLSD |
| SRODID | Sales pricing & discount methods file | SCODID |
| SRODIH | Sales pricing & discount methods file, header | SCODIH |
| SRODIQ | Sales pricing & discount method quan | SCODIQ |
| SRODIQF | Limits table, FOC items | SCODIQF |
| SROECFST | EC statistic – stock movements | SCOECFST |
| SROFIO | FIFO file | SCOFIO |
| SROGDT | General discount file | SCOGDT |
| SROGDTF | General discount file, FOC item lines | SCOGDTF |
| SROGPH | Suppl. inv. matching-link hdr | SCOGPH |
| SROGPX | Link file inv.- reception trans | SCOGPX |
| SROGRT | Goods reception transactions | SCOGRT |
| SROHNA | Requests and Returns actions | SCOHNA |
| SROILBLG | Interactive line buy log file | SCOILBLG |
| SROIOH | Internal order proposal header | SCOIOH |
| SROIOL | Internal order proposal line | SCOIOL |
| SROISA | Invoice search additional info | SCOISA |
| SROISDCI | Invoice / Sales statistics item lines, cost info | SCOISDCI |
| SROISDPL | Invoice / Sales statistics product lines | SCOISDPL |
| SROISDSU | Invoice / Sales stat, surcharges | SCOISDSU |
| SROISH | Invoice search header | SCOISH |
| SROISL | Sales stat/invoice search str. | SCOISL |
| SROISS | Invoice search service job hdr. | SROISS |
| SROITR | Inventory transactions | SCOITR |
| SROLCA | Shipment ln costs – allocations | SCOLCA |
| SROLCC | Shipment line costs | SCOLCC |
| SROLCH | Shipment header | SCOLCH |
| SROLCL | Shipment line | SCOLCL |
| SROLIMCO | Matching tolerance limits – common | SCOLIMCO |
| SROLIMCOL | Matching tolerance line limits – common | SCOLIMCOL |
| SROLIMSU | Matching tolerance limits – suppliers | SCOLIMSU |
| SROLIMSUL | Matching tolerance line limits – suppliers | SCOLIMSUL |
| SROLSTSL | Lost sale statistic product line | SCOLSTSL |
| SRONPI | Supplier – purchase order info | SCONPI |
| SRONTW | Non-conf cert, whs stock file | SCONTW |
| SROOFL | Order flow log | SCOOFL |
| SROOLS | Sales order statistic lines | SCOOLS |
| SROORPCC | Purchase order line landed cost calcs | SCOORPCC |
| SROORPHE | Purchase order header | SCOORPHE |
| SROORPLC | PO line – landed cost details | SCOORPLC |
| SROORPLH | PO line – landed cost summary | SCOORPLH |
| SROORPLT | Lot/purchase order line | SCOORPLT |
| SROORPPL | Purchase order item line | SCOORPPL |
| SROORSHE | Sales order header | SCOORSHE |
| SROORSPL | Sales order item line | SCOORSPL |
| SROORSPLCI | Sales order item line, cost info | SCOORSPLCI |
| SROORSSC | Sales order commissions | SCOSRSSC |
| SROORSSH | Sales order service header | SCOORSSH |
| SROPCR | Item cross reference | SCOPCR |
| SROPEP | Periodic purchase information | SCOPEP |
| SROPLC | Item file – landed cost | SCOPLC |
| SROPPU | Item purchase unit price | SCOPPU |
| SROPRG | Item file | SCOPRG |
| SROPRP | Item supplier information | SCOPRP |
| SROPSS | Purchase statistics selection | SCOPSS |
| SROPUH | Purchase suggestion header | SCOPUH |
| SROPUL | Purchase suggestion lines | SCOPUL |
| SROPUS | Purchase statistics | SCOPUS |
| SROPXB | Item basic and invent. Def. | SCOPXB |
| SROQSL | Quotation line structure info. | SCOQSL |
| SROQUH | Quotation header file | SCOQUH |
| SROQUPL | Quotation item line | SCOQUPL |
| SROREC | Replenishment control codes | SCOREC |
| SRORLL | Route list | SCORLL |
| SRORSH | Sales restrictions, header | SCORSH |
| SRORTSIM | Review time analysis sim file | SCORTSIM |
| SROSAG | Service agreement | SCOSAG |
| SROSAO | Service agreement object file | SCOSAO |
| SROSCH | Credit hold detail infp | SCOSCH |
| SROSCHLH | Hold order line detail information | SCOSCHLH |
| SROSHD | Shipment address file | SCOSHD |
| SROSHL | Shipment line file | SCOSHL |
| SROSHP | Shipment header | SCOSHP |
| SROSLD | Supplier/line discount file | SCOSLD |
| SROMSQ | Sales methods quantity discount | |
| SROSND | Serial number history | SCOSND |
| SROSNT | Serial number tracking file | SCOSNT |
| SROSOO | Open order analysis | SCOSOO |
| SROSPCD | Sales Price Calculation Details | SCOSPCD |
| SROSRO | Stockroom balance | SCOSRO |
| SROSSL | Sales order line struct. Info. | SCOSSL |
| SROSSS | Sales statistics selection | SCOSSS |
| SROSXO | Item warehouse defaults | SCOSXO |
| SROTLI | Standard value amount | SCOTLI |
| SROTPD | Trading partner documents | SCOTPD |
| SROTPDX | Trading partner doc defaults | SCOTPDX |
| SROTPT | Transport link time table | SCOTPT |
| SROVEH | Vehicle table | SCOVEH |
DC1 Requests and Returns
| File | File description | Parallel file |
|---|---|---|
| SROHNL | Request lines | SCOHNL |
| SROITS | Requests and Returns history | SCOITS |
DC1 Manufacturing
| File | File description | Parallel file |
|---|---|---|
| MFACTC | Pom. Activity codes | SCACTC |
| MFCFGH | Cus. Cfg header | SCCFGH |
| MFCFGM | Cus. Cfg material | SCCFGM |
| MFCFGO | Cus. Cfg operation | SCCFGO |
| MFCFGS | Cus. Cfg simulation | SCCFGS |
| MFCMOH | Base. Cost model-overhead | SCCMOH |
| MFCROO | Cfg. Routing operations | SCCROO |
| MFEMCH | Cus. Edi/mdc cfg header | SCEMCH |
| MFEMCM | Cus. Edi/mdc cfg material | SCEMCM |
| MFEMCO | Cus. edi/mdc cfg operatio | SCEMCO |
| MFINST | Inv. Period statistics | SCINST |
| MFITRO | Base. Item routing | SCITRO |
| MFLGOP | Base. Structure log oper | SCLGOP |
| MFMOCC | Mfg. Order – oper. hst eq | SCMOCC |
| MFMOCH | Mfg. Order – header tr am | SCMOCH |
| MFMOCO | Mfg. Order – Alt products Physical file | SCMOCO |
| MFMOHA | Mfg. Order – header am | SCMOHA |
| MFMOHI | Mfg. Order – History | SCMOHI |
| MFMOHM | Mfg order – History mtrl | SCMOHM |
| MFMOHR | Mfg. Order – header | SCMOHR |
| MFMOMC | Mfg. Order – mtrl tr am | SCMOMC |
| MFMOMQ | Mfg. Order – material eq | SCMOMQ |
| MFMOMT | Mfg. Order – Material | SCMOMT |
| MFMOOC | Mfg. Order – other cost | SCMOOC |
| MFMOOP | Mfg. Order – operation | SCMOOP |
| MFMOOQ | Mfg. Order – operation eq | SCMOOQ |
| MFMOOY | Mfg. Order – oper. hist. | SCMOOY |
| MFMTOH | Base. Prod.cost overh tbl | SCMTOH |
| MFNATR | Inv. Not accepted trans | SCNATR |
| MFPCHR | Base. Prod.cost – header | SCPCHR |
| MFPCHQ | Base. Prod.cost – head eq | SCPCHQ |
| MFPCMQ | Base. Prod.cost – mtrl eq | SCPCMQ |
| MFPCMT | Base. Prod.cost – mtrl | SCPCMT |
| MFPCOP | Base. Prod.cost – operat | SCPCOP |
| MFPCOQ | Base. Prod.cost – oper eq | SCPCOQ |
| MFPEOP | Pom. Project operations | SCPEOP |
| MFPEST | Pom. Project structure | SCPEST |
| MFPHBH | Pom. Project budget hist. | SCPHBH |
| MFPHCC | Pom. Project cost codes | SCPHCC |
| MFPHHR | Pom. Project header | SCPHHR |
| MFPPEL | Pom. Project phase elemen | SCPPEL |
| MFPRMD | Pom. Project m-order det | SCPRMD |
| MFPRMO | Pom. Project ph 1 m-order | SCPRMO |
| MFPTCC | Pom. Project tot./costc. | SCPTCC |
| MFPTPC | Pom. Project tot./ph.-cc. | SCPTPC |
| MFPTPS | Pom. Project tot./phase | SCPTPS |
| MFPTRA | Pom. Project transactions | SCPTRA |
| MFPTRS | Pom. Project trans stat | SCPTRS |
| MFPTTS | Pom. Project totals | SCPTTS |
| MFSERC | Pom. Service codes | SCSERC |
| MFSMIT | Base. Simulation items | SCSMIT |
| MFSMOV | Base. Simulation costs | SCSMOV |
| MFSMWC | Base. Simulation work cnt | SCSMWC |
| MFSOPH | Req. SOP history | SCSOPH |
| MFSOPP | Req. SOP plan | SCSOPP |
| MFTLFL | Base. Tool file | SCTLFL |
| MFWCFL | Base. Work centre file | SCWCFL |
DC1 Supplier Marketing Support
| File | File description | Parallel file |
|---|---|---|
| SRORBH | SMS rebate claim header | SCORBH |
| SRORBT | SMS rebate transactions | SCORBT |
| SRORBTC | SMS credit rebate claim trans | SCORBTC |
Belgian modifications
| File | File description | Parallel file |
|---|---|---|
| BEOCDLOG | CODA logging file | SCOCDLOG |
| BEODCLTR | Declaration transactions | SCODCLTR |
| BEOINTAP | Interface file financial trans. – A/P | SCOINTAP |
| BEOINTAR | Interface file financial trans. – A/R | SCOINTAR |
| BEOINTGL | Interface file financial trans. – G/L | SCOINTGL |
| BEOLST | CODA control list log file | SCOLST |
| BEOV725D | V725 – VAT yearly listing – details | SCOV725D |
| BEOV725H | V725 – VAT yearly listing – header | SCOV725H |
| SROCTSCL | A/P control file | SCOCTSCL |
German modifications
| File | File description | Parallel file |
|---|---|---|
| DEOSNT | Serial no tracking (DE extension) | SCODESNT |