One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Importing budgets for sub-classifications

When importing budgets for sub-classification, you should mark the field 'Sub classification budget'.

The format for importing sub-classification budgets is shown below. The import of period budgets differ from the import of budget totals.

Importing budget totals for sub-classifications

No Field name Type Formath Ref. Description Remarks Default
1 version_code CHAR X6 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:

Field Clarification
1 This reference is only mandatory when you do not import the budget version along with the budget.

Importing budget periods for sub-classifications

No Field name Type Format Ref Description Remarks Default
1 version_code CHAR X6 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:

Field Clarification
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 > Data import > Available import formats > Budget > Importing budgets for sub-classifications

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.324.828
 Assortment: Exact Financials  Date: 02-10-2015
 Release:  Attachment:
 Disclaimer