File Merge from Multiple Table Extract

For Expense, this facilitates Microsoft Solomon AP Import and for Time it facilitates Microsoft Solomon GL Import.

There is an Extract Mode option "Extract Multiple Related Tables to one file".

To setup the merge file extract from multiple tables:

1. Setup the tables in the order of the file layout in the Export Table Definition in TEAIM.
2. The first tables must have only one retrieval argument in which the value must equal to the batch number and it should be a string.
3. The second table must have the same column name as the batch number retrieval argument as the first table .
4. In the profile extract set the EXTRACT_MODE to Extract Multiple Related Tables to one file" or "M".

IMPORTANT NOTE: The first table only could have one retrieval argument, and any other tables below the first table must have first table retrieval argument + any other arguments as long as they exist in the parent table.

Ex 1: The following setup is valid
Table 1 - BATCH NUM retrieval argument
Table 2 - BATCH NUM retrieval argument

Ex 2: The following setup is valid
Table 1 - BATCH NUM retrieval argument, column REPORT_ID not retrieval argument
Table 2 - BATCH NUM + REPORT_ID retrieval arguments

Ex 3: The following setup is not valid
Table 1 - BATCH NUM retrieval argument, there is no column REPORT_ID not retrieval argument
Table 2 - BATCH NUM + REPORT_ID retrieval arguments

Ex 4:The following setup is valid
Table 1: BATCH NUM retrieval argument
Table 2 - BATCH NUM retrieval argument, column REPORT_ID not retrieval argument
Table 3 - BATCH NUM + REPORT_ID retrieval arguments.

Notes:

• The only file types supported are text (tab delimited) and CSV format
• File merging supports dynamic file names such as Job number, Batch id. etc.
• If a column is not needed in the file but used as a retrieval argument, make sure the sequence number for the column is set to zero.