Import Specification Fields
Import Specification Fields Used in the Account Structure
| Field Name | Description |
|---|---|
| CODE | Account code. Alphanumeric code with a maximum of 13 characters. Valid characters are A-Z,-,_,0-9. Mandatory field. |
| G_NAME | Account Name - Group Language. An alphanumeric code with a maximum of 50 characters. Mandatory field. |
| L_NAME | Account Name - Local Language. An alphanumeric code with a maximum of 50 characters. Default value = ' ' |
| G_SHORTNAME | Account Shortname - Group Language. An alphanumeric code with a maximum of 20 characters. Mandatory field. |
| L_SHORTNAME | Account Shortname - Local Language. An alphanumeric code with a maximum of 20 characters. Default value = ' ' |
| ACCT_DESC_GROUP | Account Description (online accounting manual) - Group Language. An alphanumeric code with a maximum of 2000 characters. Default value = ' ' |
| ACCT_DESC_LOCAL | Account Description (online accounting manual)
- Local Language. An alphanumeric code with a maximum of 2000 characters. Default value = ' ' |
| LEV_EXTDIM1 | Extended Dimension 1 Level to be used for a specific
account. Valid values are integers 0,1,2,3,4,5,6. Default value = 0 |
| LEV_EXTDIM2 | Extended Dimension 2 Level to be used for a specific
account. Valid values are integers 0,1,2,3,4,5,6. Default value = 0 |
| LEV_EXTDIM3 | Extended Dimension 3 Level to be used for a specific
account. Valid values are integers 0,1,2,3,4,5,6. Default value = 0 |
| LEV_EXTDIM4 | Extended Dimension 4 Level to be used for a specific account. Valid values are integers 0,1,2,3,4,5,6. Default value = 0 |
| SIGN_CHANGE | This field should be marked if a specific account
should reverse the sign convention defined in the Reconcile tab
of the General Configuration for this account
type. Valid values are 1 and -1. Default value = 1 |
| ACCT_TYPE | Account Type. Valid characters are A,L,I,C,E,R,S,T,U. Default value = A |
| DECIMALS | Number of decimals to be set for R,S,T,U account
types. Valid values are integers 0,1,2,3,4,5,6. Default value = 0 |
| CONSOLIDATE | Field which identifies if a specific account should
be consolidated. Valid values are T and F. Default value = T |
| IC_CODE | This field indicates if intercompany information
is required to be entered on a specific account, and if so, define
how information should be collected. Valid characters are I, J, M, A or ' '. I = Intercompany without transaction currency. J = Intercompany with transaction currency. M = Intercompany with Margin%. A = Acquisition Calculations. ' ' represents the default value and implies that no intercompany information will be collected for a specific account. Default value = ' ' |
| SHARES | This field indicates if the investment register
should be used for a specific account, and if so, how it should be
enabled. Valid characters are I, E or ' '. I = Investments in Group Companies, E = Investments in External Companies and ' ' means the investment register is not to be used the a specific account. Default value = ' ' |
| COMMENTS | Allow comments to be entered for a specific account. Valid values are T, F and M. Default value = F |
| SIGN_SUM1 | Value entered here determines whether an account
is required for ACCT_SUM1 and if so what sign the value on that account
should be added to the ACCT_SUM1. Valid values are 0, 1 and -1. Default value = 0 |
| ACCT_SUM1 | Summation account that a specific account should be summed to either negatively
or positively according to SIGN_SUM1. Any valid IBM® Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| SIGN_SUM2 | Value entered here determines whether an account
is required for ACCT_SUM2 and if so what sign the value on that account
should be added to the ACCT_SUM2. Valid values are 0, 1 and -1. Default value = 0 |
| ACCT_SUM2 | Summation account that a specific account should be summed to either negatively
or positively according to SIGN_SUM2. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| SIGN_SUM3 | Value entered here determines whether an account
is required for ACCT_SUM3 and if so what sign the value on that account
should be added to the ACCT_SUM3. Valid values are 0, 1 and -1. Default value = 0 |
| ACCT_SUM3 | Summation account that a specific account should be summed to either negatively
or positively according to SIGN_SUM3. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| RECONS_M1 | Reconciliation codes and references to other codes
determine how a specific account will handle opening balances and
reconciliation between accounts. It is also possible to copy opening
balances. Valid codes are +, -, I, J, K, L, ' '. Default = ' ' |
| RECONS_M1_ACCT | This field is used when the method entered for RECONS_M1 requires an account to
be used as a reference. RECONS_M1 codes that require this field to be completed with account
information are +, -, I, J, K and L. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| RECONS_M2 | Reconciliation codes and references to other codes
determine how a specific account will handle opening balances and
reconciliation between accounts. It is also possible to copy opening
balances. Valid codes are +, -, I, J, K, L, ' '. Default = ' ' |
| RECONS_M2_ACCT | This field is used when the method entered for RECONS_M2 requires an account to
be used as a reference. RECONS_M2 codes that require this field to be completed with account
information are +, -, I, J, K and L. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| CONV_M1 | Determines the method used when currency translation
is run. Currency translation codes are normally only specified for
detail accounts. Valid codes are B, M, D, N, E, F, G, K, L, I, C, O, P, U, V, X, A, A2, A3, ' '. Default = ' ' |
| CONV_M1_ACCT | This field is used when the method entered for CONV_M1 requires an account to be
used as a reference. CONV_M1 codes that require this field to be completed with account information
are I, C, O, P, A, A2 and A3. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| CONV_M2 | Determines the method used when currency translation
is run. Currency translation codes are normally only specified for
detail accounts. Valid codes are B, M, D, N, E, F, G, K, L, I, C, O, P, U, V, X, A, A2, A3, ' '. Default = ' ' |
| CONV_M2_ACCT | This field is used when the method entered for CONV_M2 requires an account to be
used as a reference. CONV_M2 codes that require this field to be completed with account information
are I, C, O, P, A, A2 and A3. Any valid Controller Account code or valid account code defined during the import of external structures. Valid characters are A-Z,-,_,0-9. Default = ' ' |
| ID_CODE | This field indicates if the intercompany transactions
for a specific account should to be enabled to use extended dimension
1. Valid values are T and F. Default = F |
| NONREV_JOU | Indicates if a specific account should be copied
according to the alternative rules for non-reversing journals when
copying journals. This is only applicable when the same option is
selected in the General 3 tab of the General Configuration. Valid values are T and F. Default = F |
| REV_JOU | Indicates if a specific account should be copied
according to the alternative rules for reversing journals when copying
journals. This is only applicable when the same option is selected
in the General 3 tab of the General Configuration. Valid values are T and F. Default = F |
| CALC_ACCT | Indicates if a specific account will be used as
a calculation account for key ratios. This can only be applied to
statistical accounts with account types R, S, T and U. Valid values are 0 and 1. Default value = 0 or blank |
Import Specification Fields Used in the Company Structure
| Field | Description |
|---|---|
| CODE | Company code Alphanumeric code with a maximum of 6 characters. Mandatory field. |
| NAME_GROUP | Company name - Group Language Alphanumeric code with a maximum of 50 characters. Mandatory field. |
| NAME_LOCAL | Company name - Local Language Alphanumeric code with a maximum of 50 characters. |
| SHORTNAME_GROUP | Company Short Name - Group Language. Alphanumeric code with a maximum of 20 characters. Mandatory field. |
| SHORTNAME_LOCAL | Company Short Name - Local Language. Alphanumeric code with a maximum of 20 characters. |
| CO_TYPE | Company Type (Group or Subsidiary). Acceptable values are B, K and D. B= Group Adjustment Company, K=Group and D=Subsidiary. Mandatory field. |
| CONV_METHOD | Conversion Method. Valid values are 1 and 2. 1=Current Method and 2=monetary/non-monetary method. Default value = 1 |
Import Specification Fields Used in the Extended Dimension Structures
| Field | Description |
|---|---|
| CODE | Extended Dimension 1-4 code. Alphanumeric code with a maximum of 4 characters. Mandatory field. |
| OVCODE | Next higher level in dimension structure for CODE
defined. Alphanumeric code with a maximum of 4 characters. Mandatory field. |
| NAME_GROUP | Extended Dimension 1-4 Name - Group Language. Alphanumeric code with a maximum of 50 characters. Mandatory field. |
| NAME_LOCAL | Extended Dimension 1 -4 Name - Local Language. Alphanumeric code with a maximum of 50 characters. Mandatory field. |
| ACTIVE | This field indicates whether the CODE should be
active or inactive in the extended dimension 1-4 structure. Valid values are T or F Default value = T |
| SORTORD | Sort order of extended dimension 1 structure. Numeric values from 0 (zero) upwards. Default value = 0 |
| ADJUST | This field defines if CODE will be used as an adjustment
dimension. Please note this only applies to Extended Dimension 1. Acceptable values are T or F. Default value = F |
Import Specification Fields Used in Currency Rates
| Field | Description |
|---|---|
| CURRENCY_CODE | Currency Code. Alphabetic code with a maximum of 3 characters. Mandatory field. |
| CURRENCY_TYPE | Currency Type defines the conversion code used
for a specific account. For example, B for Closing Rate, M for Period
Average rate (YTD) or D for Period Average Rate. Valid characters are B,D,M where B=Closing Rate, D=Period Average Rate and M= Year To Date Average Rate. Mandatory field. |
| RATE | This field represents the currency rate that will
apply for a specific period, actuality, currency code and currency
type. Numeric value with a maximum of 5 digits and 6 decimals. Mandatory field. |
| UNIT | The unit amount would normally be collected from
the currency configuration. It is possible to change the unit value
temporarily when entering currency rates. Mandatory field. |
| PERIOD | The period that a currency code and currency type
will apply for. Numeric value with a maximum of 4 characters to define a period. Mandatory field. |
| ACTUALITY | The actuality that a currency code and currency type will apply for. Uppercase alphanumeric code with a maximum of 2 characters. Actuality code must already exist in the Controller database. Mandatory field. |