Load Chart of Accounts (ACC)
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). |