Table of Contents

GLE - General Ledger Entry

Module GLE


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
OBJTYP Object Type Text 6
OBJINR Object INR (Internal Unique ID) Text 8
TRNINR Transaction Creating Entry (Set in GLEMOD) Text 8
ACT Account Number in our Books (Mandatory) Text 34
DBTCDT Debit/Credit (Mandatory) Text 1 DBTCDT
CUR Booked in Currency (Mandatory) Text 3 CURTXT
AMT Booking Amount (Mandatory) Numeric 18
SYSCUR System Currency (Optional) Text 3 CURTXT
SYSAMT Booking Amount in System Currency (Optional) Numeric 18
VALDAT Value Date (Defaults to BUCDAT) Date 12
BUCDAT Booking Date (Defaults to Today) Date 12
TXT1 Booking Text 1 Text 40
TXT2 Booking Text 2 Text 40
TXT3 Booking Text 3 Text 40
PRN Prima Nota Text 4
EXPSES Export Session Text 8
TSYREF Treasury reference Text 35
EXPFLG Export Status ('S'tored, 'R'eleased, 'E'xported, 'A'ccepted) Text 1 Embedded

Datafield Description and Properties


Datafield INR Internal Unique ID

Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.

For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.


Datafield OBJTYP Object Type

The field specifies the table ID of the issuing contract. The unique ID of that contract is stored in the Object ID field.

The objective is to identify the type of product, or more precisely, the type of data group used to represent the type of business contract, for which this booking is effected.

This field may be ignored by external systems.


Datafield OBJINR Object INR (Internal Unique ID)

This field holds the unique ID identifying the contract within the table identified by the Object Type field.


Datafield TRNINR Transaction Creating Entry (Set in GLEMOD)

The mandatory field uniquely identifies the transaction posting this booking.

This field contains an eight-digit ID unique for the initiating transaction, and is used to collect all bookings relating to a transaction as well as for research - thus, it should be monitored by the receiving accounting system in line with auditing regulations.


Datafield ACT Account Number in our Books (Mandatory)

This mandatory field specifies the account affected by this booking.


Datafield DBTCDT Debit/Credit (Mandatory)

This mandatory field specifies whether the entry is a debit (“D”), or a credit (“C”) booking.


Datafield CUR Booked in Currency (Mandatory)

This mandatory field specifies the ISO code for the currency of the entry.


Datafield AMT Booking Amount (Mandatory)

This mandatory field specifies the booking amount in the booking currency.


Datafield SYSCUR System Currency (Optional)

Contains the system base currency


Datafield SYSAMT Booking Amount in System Currency (Optional)

The converted value of the booking amount in system base currency.


Datafield VALDAT Value Date (Defaults to BUCDAT)

This mandatory field contains the value date as accepted or supplied by the user.

Unless the original source field is defaulted or set otherwise, the content of the field defaults to “today”.


Datafield BUCDAT Booking Date (Defaults to Today)

The field specifies when this booking is effected.


Datafield TXT1 Booking Text 1

Provides additional information on the booking such as parent contract reference related to the booking and the party/role whole liability is booked.


Datafield TXT2 Booking Text 2

Provides additional information on the booking.


Datafield TXT3 Booking Text 3

Provides additional information on the booking such as the liability type of booking. Example AVL booking or AVL counter booking.


Datafield PRN Prima Nota

Prima Nota is a unique identifier for a booking entries. Unique numbers could be maintained as prima nota for different bookings from different business modules.


Datafield EXPSES Export Session

This field is for internal use and may be ignored by external systems.


Datafield EXPFLG Export Status ('S'tored, 'R'eleased, 'E'xported, 'A'ccepted)

This field is for internal use and may be ignored by external systems.

Codetable
Code Text
A Accepted
E Exported
R Released
S Stored

Datafield TSYREF Treasury reference

Treasury reference