Connectivity Manual C/S - Importing budgets for sub-classifications
Importing budgets for sub-classifications
When importing budgets for Sub-classification, you should mark the field 'Subclassification budget'.
The format for importing sub-classification budgets is shown belown. The import of period budgets differ from the import of budget totals.
Importing budget totals for sub-classifications
1
| version_code
| CHAR
| X8
| bdvers
| Budget version
| Mandatory
| -
|
2
| comp_code
| CHAR
| X3
| comp
| Sub-classification
| Mandatory
| -
|
3
| empty
| -
| -
| -
| -
| -
| -
|
4
| empty
| -
| -
| -
| -
| -
| -
|
5
| empty
| -
| -
| -
| -
| -
| -
|
6
| amt_budget_debit
| DEC
| N15,2
| -
| Budget amount debit
| -
| -
|
7
| amt_budget_credit
| DEC
| N15,2
| -
| Budget amount credit
| -
| -
|
8
| qty_budget
| DEC
| N15,2
| -
| Budget quantity
| -
| - |
9
| method_code
| CHAR8
| -
| bdmeth
| Period allocation method
| -
| -
|
10
| ccent_method_code
| CHAR8
| -
| bdccdm
| Cost center allocation method
| -
| - |
Clarification of the fields:
1
| This reference is only mandatory when you do not import the budget version along with the budget. |
Importing budget periods for sub-classifications
1
| version_code
| CHAR
| X8
| bdvers
| Budget version
| Mandatory
| -
|
2
| comp_code
| CHAR
| X3
| comp
| Sub-classification
| Mandatory
| -
|
3
| empty
| -
| -
| -
| -
| -
| -
|
4
| empty
| -
| -
| -
| -
| -
| -
|
5
| empty
| -
| -
| -
| -
| -
| -
|
6
| fin_yr
| INT
| N4
|
| Financial year
| -
| -
|
7
| amt_budget_debit
| DEC
| N15,2
| -
| Budget amount debit
| -
| -
|
8
| amt_budget_credit
| DEC
| N15,2
| -
| Budget amount credit
| -
| -
|
9
| qty_budget
| DEC
| N15,2
| -
| Budget quantities
| -
| - |
Clarification of the fields:
1
| This reference is only mandatory when you do not import the budget version along with the budget.
|
7-9
| These fields must appear 15 times in the csv file. Depending on the number of periods you want to import, the fields will be filled. If you only want to import budgets for the first 3 periods, then you fill the first 3 fields and you leave 12 fields empty. |
Connectivity Manual C/S - Contents > Data import > Exact Budget C/S > Importing budgets for sub-classifications
Main Category: |
Support Product Know How |
Document Type: |
Online help main |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
General |
Document ID: |
01.642.831 |
Assortment: |
Exact Financials (v3)
|
Date: |
10-02-2009 |
Release: |
|
Attachment: |
|
Disclaimer |