Financial planning step configuration through a CSV file
Use a comma-delimited, CSV with these columns:
- Column A: Organization unique name
The organization unique name must match the ID that is used in the database. For applications that are based on Designer, you can find the ID of your organizations in the Id column in Designer.
For applications that are based on Business Modeling, you can find the ID of your organizations through Business Modeling. Select .
- Column B: Organization description
You can add a description for your reference. When you import a hierarchical configuration from the CSV file, the content of this column is not imported.
- Column C and subsequent columns: Accounts
For each account, the first row contains the account ID; the second row represents the account description. Each row indicates whether the account is activated for the corresponding organization from column A.
Valid values: 0: not activated, 1: activated.
Financial planning step configuration
This example shows sample data for a financial planning step configuration.
This table shows columns A through G with sample data. Column B contains optional descriptions that you can add for your reference. These descriptions are not imported when you import financial planning step configuration from the CSV file. The first row for columns C through G contains the account ID, the second row contains the account description.
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
A110100 |
A110200 |
A250100 |
A210100 |
A240100 |
||
| Property, Plant, and equipment | Investment property | Cash and cash equivalents | Inventories | Prepaid expenses | ||
C401 |
Purchase | 1 | 1 | 1 | 1 | 1 |
C402 |
Logistics | 1 | 1 | 0 | 1 | 1 |
C403 |
Production | 0 | 0 | 0 | 0 | 1 |
In this example, all five accounts are activated for the purchase
organization, C401. For the logistics
organization, C402, four accounts are activated. For the
production organization, C403, only one
account is activated.