| Copy Company Data (tccom0214m000) |  |
| This session is one step in the procedure to copy company data. Refer to To copy a multicompany structure for details. Use this session to correct the company numbers and/or the enterprise-unit codes in the company-data export files before you import the export files in the database tables of the target companies. ERP LN changes the specified source-company numbers in the target-company numbers and the specified source enterprise-unit codes in the target enterprise-unit codes in those database-table fields in which the company- number domain (tcncmp) and the enterprise-unit domains (tcemm.grid and tgbrg.unit) occur. You can run this session multiple times. For example, you can first run the session to change the company numbers, and then run the session again to change some or all of the enterprise unit codes. To replace company numbers Replacing company numbers is mandatory. If you copy a structure of multiple companies, you must run this session from each source company. For example: you copy data from source companies 400 and 401 to target companies 600 and 601 respectively. After exporting data from the source companies you must: switch to company 400 and run this session to correct the references in the files that were exported from company 400: all references to company 400 and 401 must be replaced by references to company 600 and 601 respectively. switch to company 401 and run this session to correct the references in the files that were exported from company 401: all references to company 400 and 401 must be replaced by references to company 600 and 601 respectively. To replace enterprise units You must only replace enterprise unit codes if the following conditions are both true: The source companies and the target companies use the same central company. The enterprise units in the target companies are linked to different financial companies than the enterprise units in the source companies. Related topics To copy a multicompany structure To copy a multicompany structure - Procedure details To copy a multicompany structure - Example Infor ERP LN 6.1 User's Guide for how to set up a company English (U9503C US) Infor ERP LN 6.1 User's Guide for Multicompany Structures English (U9504B US) Infor ERP LN 6.1 User's Guide for Multicompany Table Sharing English (U9505C US)
Fields | Description
Specify Field Separator | Specify the field separator that is used in the sequential files that contain the exported data of the current company: this is the same separator as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session. The field separator can be one of the following: A pipe (|) A caret followed by one uppercase alphabetic character, for example, ^A, ^B, and so on.
Directory for Table Files | The directory where the sequential files of the current company are stored. This is the same directory as the one that was specified during the export in the Create Sequential Dump of Table (ttaad4226m000) session.
Companies to Copy | Select this check box to replace the source-company numbers in the company-data export files by the target-company numbers. If you only want to change the enterprise unit codes in the company-data export files, you must clear this check box.
Companies to Copy | Enter the source company numbers and the corresponding target company numbers by which they must be replaced. If you copy a number of companies that form a structure, you must specify all the company numbers of that structure. The following rules apply: You can specify the company numbers in any order. The source company number and the target company number are separated by a greater-than symbol (>) only. For example: enter 400>600 if the source company is 400 and the target company is 600. The source company>target company number combinations are separated by a semicolon (;). Company numbers must consist of three digits. Use leading zeros if necessary, e.g. 001. Do not include spaces. Be careful when typing the input values for this field. Source company numbers for which you do not specify a target company number in this field are not changed. This may be very wrong because, after loading the sequential files, the target multicompany structure will contain references to the source companies. Example A multicompany structure, consisting of companies 400, 401, 402 and 403, is copied as follows: Company 400 to company 600 Company 401 to company 601 Company 402 to company 602 Company 403 to company 603 You must enter 400>600;401>601;402>602;403>603 to correct the company numbers in the sequential files.
Enterprise Units to Copy | Select this check box to replace the source enterprise unit codes in the company-data export files by the target enterprise unit codes. You must only change enterprise unit codes if the following conditions are both true: The source companies and the target companies use the same central company. The enterprise units in the target companies are linked to different financial companies than the enterprise units in the source companies. If you only want to correct the company numbers in the company-data export files, you must clear this check box.
Enterprise Units to Copy | Enter the source enterprise unit codes with the corresponding target enterprise unit codes. The following rules apply: You can specify the enterprise unit codes in any order. The source enterprise unit code and the target enterprise unit code are separated by a greater-than symbol (>). The source enterprise unit code>target enterprise unit code combinations are separated by a semicolon (;). The enterprise unit codes can consist of up to six characters. Longer codes are truncated on the right. For example, EU001235 results in EU0012. ERP LN changes all lowercase letters to uppercase. Do not include spaces. Note The target enterprise unit codes must be present in the central company. Example The following replacements must be made in the company-data export files: Enterprise unit code EUL2F2 must be replaced by EUZ2F2 Enterprise unit code EUL3F2 must be replaced by EUZ3F2 Enterprise unit code EUL3F4 must be replaced by EUZ3F4 You must enter EUL2F2>EUZ2F2;EUL3F2>EUZ3F2;EUL3F4>EUZ3F4 to correct the enterprise unit codes in the sequential files.