Load General Ledger (ATR)
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. |