Results
This table shows the content that would be added to the CPM database given the example in this section. Even though little structure data is provided to the Import Wizard in the example, the wizard can assign values to items that are required within the database but are not required by the Import Wizard. In this example, the boxed columns are provided to the Import Wizard. The remaining columns are assigned default values by the wizard.
ID | Name | Description | Parent | Hierarchy | Currency | Consolidate | % Own | Group |
---|---|---|---|---|---|---|---|---|
0 | No company | No company | * | Total Company | USD | Y | 100 | Total Company |
1 | Total Company | Total Company | * | Total Company | USD | Y | 100 | Total Company |
2 | Operations | Operations | Total Company | Total Company | USD | Y | 100 | TC Eliminations |
3 | North America | North America | Operations | Total Company | USD | Y | 100 | Division |
4 | US | US | North America | Total Company | USD | Y | 100 | Cost Center |
5 | New York | New York | US | Total Company | USD | Y | 100 | Unit |
7 | Los Angeles | Los Angeles | US | Total Company | USD | Y | 100 | Unit |
9 | Canada | Canada | North America | Total Company | USD | Y | 100 | Country |