Connectivity Manual C/S - Importing budgets for ledger accounts, cost units and cost centers
Importing budgets for ledger accounts, cost units and cost centers
Importing budget totals for ledger accounts, cost units and cost centers
| 1
| version_code
| CHAR
| X8
| bdvers
| Budget version
| Mandatory
| - |
| 2
| acc_nr
| INT
| X9
| ledger
| Account number
| Mandatory
| -
|
| 3
| cost_center
| CHAR
| X8
| ccent
| Cost center
| -
| -
|
| 4
| cost_unit
| CHAR
| X8
| cunit
| Cost unit
| -
| -
|
| 5
| amt_budget_debit
| DEC
| N15,2
| -
| Budget amount debit
| -
| -
|
| 6
| amt_budget_credit
| DEC
| N15,2
| -
| Budget amount credit
| -
| -
|
| 7
| qty_budget
| DEC
| N15,2
| -
| Budget quantity
| -
| - |
| 8
| method_code
| CHAR
| X8
| bdmeth
| Period allocation method
| -
| - |
| 9
| ccent_method_code
| CHAR
| X8
| 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. |
| 2
| When importing a cost center or a cost unit budget, you should not enter a ledger account number. |
Importing budget periods for ledger accounts, cost units and cost centers
| 1
| version_code
| CHAR
| X8
| bdvers
| Budget version
| Mandatory
| - |
| 2
| acc_nr
| INT
| X9
| ledger
| Account number
| Mandatory
| -
|
| 3
| cost_center
| CHAR
| X8
| ccent
| Cost center
| -
| -
|
| 4
| cost_unit
| CHAR
| X8
| cunit
| Cost unit
| -
| -
|
| 5
| fin_yr
| INT
| N4
| -
| Financial year
| -
| -
|
| 6
| amt_budget_debit
| DEC
| N10,2
| -
| Budget amount debit
| -
| -
|
| 7
| amt_budget_credit
| DEC
| N10,2
| -
| Budget amount credit
| -
| -
|
| 8
| qty_budget
| DEC
| N15,2
| -
| Budget quantity
| -
| - |
Clarification of the fields:
| 1
| This reference is only mandatory when you do not import the budget version along with the budget.
|
| 6-8
| 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 ledger accounts, cost units and cost centers
| 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.731 |
| Assortment: |
Exact Financials (v3)
|
Date: |
10-02-2009 |
| Release: |
|
Attachment: |
|
| Disclaimer |