Running the Budget Import Field Mapping Program

Select Other Budgeting Methods (G1421), Budget Import Field Mapping.

You must perform this task in a Windows environment.

To run the Budget Import Field Mapping program from a Windows environment:

On Work With Batch Versions - Available Versions, select the version.
On Table Conversion Prompting:
- If you are working in a local environment, click Submit.
- If you are working in a server environment, select the Override Location check box and click Submit.
  On EnterpriseOne Data Sources, select the local data source so that the table conversion program can access the data that you copied into the F0902Z2.txt file.

On PC Budget Upload Field Definition, access the tabs described in this table and follow the instructions:

Tab	Instruction
Select Environments	Under Input Environment, choose the environment that has the F0902Z2.txt file mapped to your local drive. The input environment corresponds to the local database on the client machine. Under Output Environment, choose the environment that has the Account Balances - Batch File (F0902Z1) mapped to the server. The output environment corresponds to the target database that contains the F0902 table.
Table Options	Select the Run Currency Triggers option only if you use multicurrency processing. The system converts decimal places and other currency fields based on your multicurrency setup. Do not select the Clear Output Tables option. If you do, the system deletes all data in the F0902Z1 table, regardless of the user status or processing status. The data in the F0902Z1 table gets uploaded to the F0902 table later in the PC budget upload process. Do not select the Force Row by Row Processing option. The system ignores this option.
Debug Logging	Do not clear the option for Use ini settings for trace level and number of rows to process unless this applies: You want to generate a log during the upload process. Change the Trace Level field to a number between 1 and 10, with 10 providing the most detailed log. You do not want to process all input rows. Therefore, change the Number of Rows field to a number other zero.

Tab

Instruction

Select Environments

Under Input Environment, choose the environment that has the F0902Z2.txt file mapped to your local drive. The input environment corresponds to the local database on the client machine.

Under Output Environment, choose the environment that has the Account Balances - Batch File (F0902Z1) mapped to the server. The output environment corresponds to the target database that contains the F0902 table.

Table Options

Select the Run Currency Triggers option only if you use multicurrency processing. The system converts decimal places and other currency fields based on your multicurrency setup.

Do not select the Clear Output Tables option. If you do, the system deletes all data in the F0902Z1 table, regardless of the user status or processing status. The data in the F0902Z1 table gets uploaded to the F0902 table later in the PC budget upload process.

Do not select the Force Row by Row Processing option. The system ignores this option.

Debug Logging

Do not clear the option for Use ini settings for trace level and number of rows to process unless this applies:

You want to generate a log during the upload process. Change the Trace Level field to a number between 1 and 10, with 10 providing the most detailed log.
You do not want to process all input rows. Therefore, change the Number of Rows field to a number other zero.

When the program finishes, it sends a message to the work center that indicates whether the batch process completed successfully.