Documentation
Back to website >

List of Abbreviations (EULANDA SQL-API)

The naming of all objects in the SQL server, such as tables, views, procedures, must follow strict rules to ensure error-free business logic and compatibility with future updates.

Table abbreviations / -Alias

Abbr.TableRemark
Article
AR Artikel  
ARI ArtikelIdent Serial numbers / batches
ARZ ArtikelZuschlag Basic data on surcharges (copper surcharges, minutes of pay, night surcharges, etc.)
JB Jumbo BOM header
JBP JumboPos BOM items
Miscellaneous
AD Adresse  
BR Brief  
VT Vertreter  
US cnUser  
WL WebLink  
MK Merkmal  
MKE MerkmalElement  
OB cnObjects System table
KR Kreditor  
KRAR KrArtikel Vendor Articlesl
KRRG KrRG Vendor discount groups
KRWG KrWG Vendor merchandise categories
SR ServiceArtikel  
Offers
AN Angebot  
ANM AngebotMwst  
ANP AngebotPos  
ANT AngebotTitel  
ANX AngebotText  
Orders
AF Auftrag Order header
AFP AuftragPos  
AFPA AuftragPosAblauf  
AFPZ AuftragPosZuschlag  
AFM AuftragMwst VAT rates
AFT AuftragTitel  
AFX AuftragText  
AFZ AuftragZuschlag  
Delivery slips
LF Lieferschein  
LFP LieferscheinPos  
LFX LieferscheinText  
LFQ LieferscheinPosQuelle  
Invoice
RE Rechnung  
REP RechnungPos  
REM RechnungMwst  
REX RechnungText  
REQ RechnungPosQuelle  
REZE RechnungZe Payment receipts
Kasse    
Purchase orders
KF KrAuftrag Order Header
KFP KrAuftragPos  
KFM KrAuftragMwst VAT rates
KFT AuftragTitel  
KFX AuftragText  
Cash
CB KasseBeleg  
CBZ KasseBelegZeile  
CC Kasse  
CK KasseKassierer  
Constants
KVA konVersandart  
KWA konWaehrung  
KZB konZiel Terms of payment
KKG konKG Customer groups (AddressGr field)
KMG konMwstGr  
KEG konErloesKonto  
KRG konRG Discount groups
KWG konWG Product categories
KNR konNr Number ranges
KLD konLand  
KBK konBank  
KOP konOptionen  
KME konMengenEH Units
Pricing
PR Preis  
PL Preisliste  
PRZ PreisZuschlag  
ZS Zuschlag  
ARZ ArtikelZuschlag  
Registry
REGB (alt: RGB) cnRegBlob The registry tables may only be accessed using the stored procedures cn_RegXX.
REGK (alt: RGK) cnRegKey
REGV (alt: RGV) cnRegValue
REGX (alt: RGT) cnRegText
Warehousing
LA (alt: LK) LagerKonto  
LKT (alt: LO) LagerOrt  
LG LagerGruppe  
LGM LagerGruppeMatrix  
LP LagerPlatz  
LBS LagerBuchungsSatz  
LT LagerTyp  
LBZ LagerBuchungsZeile  

Name Prefixes for Server Objects

Abbr.ObjectRemark
cn Stored Procedures  
cnf User features  
CK Check Constraint  
DF Default Constraint  
FK Foreign Key  
IX Index  
PK Primary Key  
TR Trigger  

Name components

Database objects that are not part of the standard scope of delivery of EULANDA® must have one of the following abbreviations as part of their names. (See also Naming Conventions)

Abbr.Remark
CNSOFT Reserved for EULANDA Software GmbH (formerly CN Software GmbH)
ESOL Reserved for additional modules created by EULANDA Software GmbH which are not included in the standard scope (Eulanda SOLutions)
SHARE Examples from the EULANDA® User Forum
USER This is the only abbreviation developers are allowed to use for their own database objects. Unless you are a solution partner and have registered an abbreviation
CUSTOM SQL procedures and views specified by EULANDA® that are not encrypted and may be modified within certain limits by developers.
Registered Solution Partners (alphabetical)
Abbr.AddressRemark
COAX COAX Computerlösungen www.coax.de
DDHANDEL dd-Handelsgesellschaft mbH www.ddhandel.de
GANOM Ganom IT Consulting www.ganom.com
GESKEEDV Geske EDV Technik www.geske-edv.de
NES Nolte Elektronik Systeme GmbH www.nes-gmbh.de
PEAR reserviert  
RUNTIME runtime software GmbH www.runtime.de
UBBD reserviert