Use this screen to establish transfer locations for both the sending and receiving databases. If you are transferring IWO data from one database to another, the location codes must be identical in each database. You can set up the Home Location (the beginning database) in the Inter-Company Work Orders group box on the Configure Project Settings screen. You also designate the Last IWO Number used on the Project Settings screen. Costpoint uses these two fields to mark and identify entries created and transferred out of this database during the transfer process.
If you select the check box in the Active field for a location, it is not available for selection on the Project Settings screen. You cannot transfer allocations to inactive locations.
Use this screen as the first step in creating an IWO transaction. The location codes established here are available for on the Manage IWO Projects screen. You can transfer each IWO project to only one receiving project and location.
Click and enter a new alphanumeric code.
Enter an alphanumeric code that describes the location code.
Select this check box to indicate that the location is active. Leave the check box blank to indicate that the location is not active.
You cannot link inactive locations to projects.
Enter, or click to select, the functional currency of the location.
Select this check box to identify this location as an external database. If this location is for a database that is not the database which generates the IWO transfer, it is an external database. If the location is the same database from which the IWO transfer is generated, it is an internal database.
This screen uses the IWO_LOCATIONS table (populated by Manage IWO Allocations screen).
The Location field (IWO_LOC_CD) is a user-defined code used to identify either a sending or receiving database. The codes must be unique within each database, but you must establish exact, duplicate names in both the sending and receiving databases. These names are the source table for on the Project Settings screen in establishing the location code of the database. This code is later attached to transfer data to establish the source or destination databases for that data. We suggest that the code indicate the location (such as MASD or LISD). You cannot use special characters, such as &, %, and so on.
The Location Name field (IWO_LOC_NAME) is a user-defined code used to identify the location database.
The Active field (ACTIVE_FL) defines whether the location is active (check box selected) or inactive (check box not selected). Inactive locations are not available for on the Configure Project Settings screen. Inactive locations cannot receive IWO allocations. Do not associate projects with inactive locations. Make unused locations inactive, but to maintain historical data, do not delete them.
The Currency Code (S_CRNCY_CD) is the code for the functional currency of the location.
The Country Code (COUNTRY_CD) field is currently not used.
Modified by (MODIFIED_BY) is a system-used field that identifies the user ID of the person making the entry or modification.
Time stamp (TIME_STAMP) is a system-used field that identifies the time and date of the row creation or modification.
Row version (ROWVERSION) is a system-used field.