Skip to main content

Knowledge Center

Load General ledger (ATR) - INP/54604

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.

Field

Required

Length

Example

Description

EXTID

Document ID from legacy (old) system.

TRANS

Y

6

PERWAG

Transaction Type. For example: CUSCIN for sales invoices, SUPSIN for supplier invoices.

When period amounts are to be loaded, the value in this field must be set to ATRMAN (manual postings to the general ledger).

CUSMAN (Manual postings to account receivables).

PERWAG (Import of wages).

PACMAN (Manual period adjustment).

SUPMAN (Manual postings to account payables).

VATMAN (Manual VAT postings).

TYPE

Y

IMPORTED

This field says how the transactions have been created.

When period amounts are to be loaded, the value in this field must be set to IMPORTED.

Valid options:

AUTO = Automatic postings from Invoices, Credits or payments.

MANUAL = Manual postings.

AGIO = Agio postings.

IMPORTED = Postings imported from file

PERIOD

Y

201509

Fiscal period.

TRDATE

Y

2015.09.30

Transaction Date.

When period amounts are to be loaded, set this value to the last day of the month.

TRQTY

369

Transaction Quantity. Number of documents like invoices, credits of payments etc. connected to one ATR document that forms the basis of the GL entry.

When period amounts are to be loaded, set this value to 0.

DATE

Y

2015.09.03

Date of posting.

When period amounts are to be loaded, set this value to the last day of the month.

REM

Imported wages from…

Remark (Free text).

MSG

Message (Free text).

ACCCODE

Y

1210

Account number in the General ledger.

DEPNO

2040

Department number.

PRJNO

3879

Project number.

ASTNO

1001

Asset number.

DIM4

2966

Reference to Dimension register 4. Used in addition to the dimensions Department (DEP), Project (PRJ) and Assets (AST).

DIM5

Reference to Dimension register 5

DIM6

Reference to Dimension register 6

DIM7

Reference to Dimension register 7

DIM8

Reference to Dimension register 8

DIM9

Reference to Dimension register 9

DIM10

Reference to Dimension register 10

TEXT

Free text

CUR

Y

NOK

Currency

RATE

Y

1.00

Currency exchange rate.

VATCODE

Y

2

00

VAT Code.

ICTDB

Inter Company Database. Refers to a company in a corporation where there are corporate transactions.

LOC

OSL

Location.

AMOUNT

-4500.00

Amount in Transaction Currency.