Transaction Details

Load "daily" transactional data. The source columns are associated with the translations defined. Access the Translation Details page by navigating to Maintenance > DLR > Transaction Details.

Description of Fields on the Transaction Detail Page

Clear all data prior to new data load

• If you enable Clear all data prior to new data load when the transactional data is loaded, the system will clear all the data for Actuals and the distinct time periods available in the new data load file.

• If you disable Clear all data prior to new data load, the system will clear pre-existing transactional data with following conditions:

  • Scenario will be Actuals.

  • The distinct time periods available in the new data load file.

  • The segment combinations available in the new data load file.

No of Amount columns

• Specify how many amount columns are required.

• A Single Value creates one amount column.

• A Debit amount and credit amount creates two columns, one for debits and one for credits.

Source data is available in

• Select the location of the source data.

• If the source data resides in the source segments, select the translation to apply to the transaction as the Translation Data Load field is opened for this selection.

Translation data load

• Organizations that operate multiple companies with disparate general ledgers using different schemas of chart of accounts require data translations or mappings for the data to be loaded into the Planful suite.

• Select the translation you would like to apply to the transaction, which copies the structure from the Data Load Rules that you select here (if you use Translations as the source).

• Remember, a translations, is a way of translating or rendering data. For example, one might translate data from a local currency to a common currency.

Attribute Type

The Common COA (Chart of Accounts) segment defaults are displayed based on the setup on the Define Financial Segments page

Attribute Name

Enter the name of the attribute based on the segments defined for the Common COA and attributes setup for those segments. For example, some Common COA names are; Company, Account, Project.

Attribute data type

• varchar - Select this option to associate a data type with a variable character field. Variable character fields have a user-defined length and can hold letters and numbers.

• URL - Select this option to load a reference URL. You can click the URL hyperlink when you view the Transactions Drill-Through reports.

Attribute length

Enter the maximum amount of characters for the field.

File extension

Select the file extension type of the file you want to load. The options are CSV (comma delimited value), txt, and xls. If you select .CSV, or .txt, the following options are opened:

• Column Delimiter – Separates each column with the selection you make (comma/tab/semicolon).

• Row Delimiter – Separates each row with the selection you make ({CR}{LF}/{CR}/{LF}semicolon/comma/tab).

• Text Qualifier – Differentiates the field data from the delimiter with double or single quotes.

First row has column names

Specify whether you want the first row to contain the column name or not.

Please select a file

Select a CSV, txt, or xls file type from your desktop to load to Planful.