Skip to main content

Knowledge Center

Load Chart of Accounts (ACC) - INP/13911

Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.

This load may be used to update fields for an existing account (ACC). However, it is not possible to update status with this load.

Field

Required

Length

Example

Description

ST

1

4

1 = Open 4 = Activated 9 = Deactivated If not provided in file, status for the account will be set to 1.

ACCCODE

Y

2380

General ledger account number.

ACCOUNTGROUPCODE

One character for account group code.

ACCSAFTCODE

SAF-T code.

NAME

Y

VAT settlement account

Name of account.

CATEGORY

Bank

Bank, Fixedasset, Receivables, Payables or ''.

ISCONTROLACCOUNT

Y

Y (Yes)

PARENTACCCODE

Y

Y (Yes)

TEXT

Round-off

Free text.

BACNO

2910

Reference to budget linked to this account.

DEPNO

2001

Default Department number.

ACCTYPE

Y

B

Type of Account :

R = Result

B = Balance

VATCODE

Y

2

00

Default Vatcode

INCLDEP

N

Should postings to this Account include ref. to Department. N = No Y = Yes X = Can be used If not provided in file, INCLDEP will be set to N.

INCLPRJ

N

Should postings to this Account include ref. to Project. N = No Y = Yes X = Can be used If not provided in file, INCLPRJ will be set to N.

INCLAST

N

Should postings to this Account include ref. to Asset. N = No Y = Yes X = Can be used If not provided in file, INCLAST will be set to N.

INCLDIM4

N

Should postings to this Account include ref. to Dim4. N = No Y = Yes X = Can be used If not provided in file, INCLDIM4 will be set to N.

INCLDIM5

N

Should postings to this Account include ref. to Dim5. N = No Y = Yes X = Can be used If not provided in file, INCLDIM5 will be set to N.

INCLDIM6

N

Should postings to this Account include ref. to Dim6. N = No Y = Yes X = Can be used If not provided in file, INCLDIM6 will be set to N.

INCLDIM7

N

Should postings to this Account include ref. to Dim7. N = No Y = Yes X = Can be used If not provided in file, INCLDIM7 will be set to N.

INCLDIM8

N

Should postings to this Account include ref. to Dim8. N = No Y = Yes X = Can be used If not provided in file, INCLDIM8 will be set to N.

INCLDIM9

N

Should postings to this Account include ref. to Dim9. N = No Y = Yes X = Can be used If not provided in file, INCLDIM9 will be set to N.

INCLDIM10

N

Should postings to this Account include ref. to Dim10. N = No Y = Yes X = Can be used If not provided in file, INCLDIM10 will be set to N.

INCLLOC

N

Should postings to this Account include ref. to Location. N = No Y = Yes X = Can be used If not provided in file, INCLLOC will be set to N.

INCLICTDB

N

Should postings to this Account include ref. To InterComapnyDataBase. N = No Y = Yes X = Can be used If not provided in file, INCLICTDB will be set to N.

AGIO

Y

N

Agio should be set to Y for balance accounts that should be revaluated to periodic exchange rate (rate at last day of period) as part of period closure. Agio is often used on payables, receivables and bank accounts. If not provided in file, AGIO will be set to N. Y = Yes N = No

FROMPERIOD

Y

201503

Account is legal from this period. (Format: YYYMM)

TOPERIOD

201512

Account is legal to this period. (Format: YYYYMM)

MANUALGLBLOCKED

Y

Y = Yes

PAYMENTBLOCKED

Y

Y = Yes

SALESCREDITNOTEBLOCKED

Y

Y = Yes

SALESINVOICEBLOCKED

Y

Y = Yes

SALESPOSTINGADJUSTMENTBLOCKED

Y

Y = Yes

SUPPLIERCREDITNOTEBLOCKED

Y

Y = Yes

SUPPLIERINVOICEBLOCKED

Y

Y = Yes

SUPPLIERPOSTINGADJUSTMENTBLOCKED

Y

Y = Yes

OLDACCNO

OLDACCNO is only used when converting from an old chart of account to a new one. The existing Account number will be displayed in the OLDACCNO-field, and the new Account number in the ACCNO-field.

If the same chart of account will be used, this field should be empty.

DEBITCREDITPOSTINGTYPE

BOTH

Possible values are: DEBIT, CREDIT or BOTH (as default).