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 |
|---|---|---|---|---|
ACCCODE | Y | 2380 | General ledger account number. | |
ACCOUNTGROUPCODE | One character for account group code. | |||
ACCSAFTCODE | SAF-T code. | |||
ACCTYPE | Y | B | Type of Account : R = Result B = Balance | |
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 | |
BACNO | 2910 | Reference to budget linked to this account. | ||
CATEGORY | Bank | Bank, Fixedasset, Receivables, Payables or ''. | ||
DEBITCREDITPOSTINGTYPE | BOTH | Possible values are: DEBIT, CREDIT or BOTH (as default). | ||
DEPNO | 2001 | Default Department number. | ||
FROMPERIOD | Y | 201503 | Account is legal from this period. (Format: YYYMM) | |
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
ISCONTROLACCOUNT | Y | Y (Yes) | ||
MANUALGLBLOCKED | Y | Y = Yes | ||
NAME | Y | VAT settlement account | Name of account. | |
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. | |||
PARENTACCCODE | Y | Y (Yes) | ||
PAYMENTBLOCKED | Y | Y = Yes | ||
SALESCREDITNOTEBLOCKED | Y | Y = Yes | ||
SALESINVOICEBLOCKED | Y | Y = Yes | ||
SALESPOSTINGADJUSTMENTBLOCKED | Y | Y = Yes | ||
ST | 1 | 4 | 1 = Open 4 = Activated 9 = Deactivated If not provided in file, status for the account will be set to 1. | |
SUPPLIERCREDITNOTEBLOCKED | Y | Y = Yes | ||
SUPPLIERINVOICEBLOCKED | Y | Y = Yes | ||
SUPPLIERPOSTINGADJUSTMENTBLOCKED | Y | Y = Yes | ||
TEXT | Round-off | Free text. | ||
TOPERIOD | 201512 | Account is legal to this period. (Format: YYYYMM) | ||
VATCODE | Y | 2 | 00 | Default Vatcode |