Loading Transaction Data with Translations

2 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Loading Transaction Data with Translations

To load transactions data using translations, follow the below three steps

Create Translations DLR

Create a Translations Data Load Rule (DLR) by defining data loading settings for translations, enabling you to load transaction data seamlessly.

Note:

If Translation data DLR is already created, skip to the Setup Transaction Details steps.

Navigate to Maintenance > DLR > Data Load Rules.
Click New Data Load Rule to define a new translation DLR.
Enter Name and Description.
Select a Load Type from the drop-down list.
For Load Item, select Data from the drop-down list.
For Load Sub Item, select Translations Data from the drop-down list.

Complete all the required fields on the remaining Data Load Rules steps to create a Translation DLR. Refer to Creating New Data Load Rules for detailed instructions.

Setup Transaction Details

Configure transaction details for your data source, either with translations or using the CCOA.

On Source Segments (with translations)

To set the transaction details with translations, follow the steps below

Navigate to Maintenance > DLR > Transaction Details.
Select Amount Columns from the drop-down list.
For Source Data, select On Source Segments (with translations).
Select a Translation Data Load DLR created from the drop-down list for the Transactions Data Load.
All the translated columns will be shown after the segment columns, including date columns, attributes, and amount columns. Click the plus (+) icon to add more attributes. Select any row and use the options on the right to move the position up or down.
Click Save.

CCOA

To set the transaction details with CCOA (GL data), follow the steps below

Navigate to Maintenance > DLR > Transaction Details.
Select Amount Columns from the drop-down list.
For Source Data, select CCOA.
All the translated columns will be shown after the segment columns, including date columns, attributes, and amount columns. Click the plus (+) icon to add more attributes. Select any row and use the options on the right to move the position up or down.
Click Save.

Create Transaction Data DLR to Load Data

Navigate to Maintenance > DLR > Data Load Rules.

New Data Load Rule
Click the New Data Load Rule to create a new transaction data DLR.
Enter Name and Description.
Select a Load Type from the drop-down list.
For Load Item, select Data from the drop-down list.
For Load Sub Item, select Transaction Data V2 from the drop-down list.
Note:
The Transaction Data Version 2 provides fast and more efficient processing of the Data Load Rule. You cannot rollback to Transactions Data (V1) once you use Transaction Data V2.

Select Sample Input File
Select file requirements or the structure of the data you are loading.
Define Overall Rule Settings
Include in Data File - Select Yes if a dimension is not defined within the data file, or select No if you do not want the listed parameters in the data file.
Include in Clear Data - Select segments/attributes for which you want to clear or retain data.
Source Data - Translations
Source Data - CCOA

Manipulate Input File
Manipulate the file or format of the data you are loading. The top pane displays the raw data, and the bottom pane displays the manipulated data.

Define Data Mappings
Map source data columns (Source Column) to target segments (Maps To). This mapping tells the system where and how your data will display in the columns once the load occurs.
Load Data is the final step in the Load data process. Once the Data File is chosen, click Finish.
For more information, refer to Creating New Data Load Rules.

Was this article helpful?

What's Next

Actual Data Templates

Table of contents