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
ARArtikel
ARIArtikelIdentSerial numbers / batches
ARZArtikelZuschlagBasic data on surcharges (copper surcharges, minutes of pay, night surcharges, etc.)
JBJumboBOM header
JBPJumboPosBOM items
Miscellaneous
ADAdresse
BRBrief
VTVertreter
UScnUser
WLWebLink
MKMerkmal
MKEMerkmalElement
OBcnObjectsSystem table
KRKreditor
KRARKrArtikelVendor Articlesl
KRRGKrRGVendor discount groups
KRWGKrWGVendor merchandise categories
SRServiceArtikel
Offers
ANAngebot
ANMAngebotMwst
ANPAngebotPos
ANTAngebotTitel
ANXAngebotText
Orders
AFAuftragOrder header
AFPAuftragPos
AFPAAuftragPosAblauf
AFPZAuftragPosZuschlag
AFMAuftragMwstVAT rates
AFTAuftragTitel
AFXAuftragText
AFZAuftragZuschlag
Delivery slips
LFLieferschein
LFPLieferscheinPos
LFXLieferscheinText
LFQLieferscheinPosQuelle
Invoice
RERechnung
REPRechnungPos
REMRechnungMwst
REXRechnungText
REQRechnungPosQuelle
REZERechnungZePayment receipts
Kasse
Purchase orders
KFKrAuftragOrder Header
KFPKrAuftragPos
KFMKrAuftragMwstVAT rates
KFTAuftragTitel
KFXAuftragText
Cash
CBKasseBeleg
CBZKasseBelegZeile
CCKasse
CKKasseKassierer
Constants
KVAkonVersandart
KWAkonWaehrung
KZBkonZielTerms of payment
KKGkonKGCustomer groups (AddressGr field)
KMGkonMwstGr
KEGkonErloesKonto
KRGkonRGDiscount groups
KWGkonWGProduct categories
KNRkonNrNumber ranges
KLDkonLand
KBKkonBank
KOPkonOptionen
KMEkonMengenEHUnits
Pricing
PRPreis
PLPreisliste
PRZPreisZuschlag
ZSZuschlag
ARZArtikelZuschlag
Registry
REGB (alt: RGB)cnRegBlobThe 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
LGLagerGruppe
LGMLagerGruppeMatrix
LPLagerPlatz
LBSLagerBuchungsSatz
LTLagerTyp
LBZLagerBuchungsZeile

Name Prefixes for Server Objects

Abbr.ObjectRemark
cnStored Procedures
cnfUser features
CKCheck Constraint
DFDefault Constraint
FKForeign Key
IXIndex
PKPrimary Key
TRTrigger

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
CNSOFTReserved for EULANDA Software GmbH (formerly CN Software GmbH)
ESOLReserved for additional modules created by EULANDA Software GmbH which are not included in the standard scope (Eulanda SOLutions)
SHAREExamples from the EULANDA® User Forum
USERThis 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
CUSTOMSQL 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
COAXCOAX Computerlösungenwww.coax.de
DDHANDELdd-Handelsgesellschaft mbHwww.ddhandel.de
GANOMGanom IT Consultingwww.ganom.com
GESKEEDVGeske EDV Technikwww.geske-edv.de
NESNolte Elektronik Systeme GmbHwww.nes-gmbh.de
PEARreserviert
RUNTIMEruntime software GmbHwww.runtime.de
UBBDreserviert