User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help 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
