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 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.