ARTS Physical Naming References

Top  Previous  Next

The table here lists the long to short name mapping used to derive ARTS physical table and column names from the entity and attribute names.

Description

Abbrv

abbreviate

abbr

abbreviation

abbr

above

abv

absolute

abs

accept

acpt

acceptable

accptbl

acceptance

acptn

acceptance

actpn

access

acs

account

acnt

accrual

acrl

accrued

acrl

action

actn

activation

acv

active

actv

activity

actv

actual

act

actual end

ae

Ad

ad

added

ad

address

ads

adjudication

adjn

adjustment

adjt

administration

admn

advance

advn

advanced shipping notice

asn

advertisement

advtsmt

advertising

adv

affiliate/affiliated

af

affiliation

afln

after

aft

against

agt

age

ag

agency

agy

agent

agnt

aggregate

aggt

agreement

agmt

aisle

asl

all

al

allocation

aln

allow

alw

allowance

alw

allowed

alw

alphabetic

alph

alternate

alt

amount

amt

analyst

anlst

anchor

achr

and

and

angle

angl

annual

ann

anonymous

anon

anonymous

annyms

answer

ans

apparel

apr

application

apln

applied/apply

aply

approval

apvl

approximate

apprx

area

ar

arm

arm

arrival

arvl

asscociated

asscd

assembly

asmb

asset

ast

assigned

asgnd

assignment

asgmt

association

asctn

assortment

asrt

at

at

attitude

attd

attribute

attr

audience

audnc

Audio

AUDO

audit

adt

authority

athy

authorization

azn

authorized

azn

Auto

A

Autozone

AZ

available/availability

avlb

average

av

award

aw

balance

blnc

bank

bk

bankruptcy

bnkrpty

banner

bnr

barcode

bcde

base

bs

basis

bss

basket

bsk

batch

BTCH

before

bfr

begin/beginning

bgn

behavior

bhvrl

behavioral

bhvrl

below

blw

benefit

bnft

benefits

bnft

bill

bl

biometric

bmc

birth

brt

bit

bt

blend/blender

bld

body

bdy

bonus

BNS

brand

brn

branded

brn

brassiere

brsr

brazil

brzl

break

brk

broker

brkr

browser

BRSR

budget/budgeted

bdg

bulk

blk

bulletin

bltn

bump bar

bmpbr

business

bsn

business unit group

bsngp

buy

buy

buyer

byr

by

by

calcium

ca

calculate

clc

calendar

cld

calories

clrs

campaign

cmpgn

cancel

cnl

capacity

cpc

capped

cap

carbohydrate

cbhyd

card

crd

care

cre

carrier

crr

cart

crt

carton

ctn

case

cs

cash

csh

cash drawer

cdrwr

catalog

ctlg

category

ctgy

ceiling

clng

celebration

clbrtn

census

cnss

center

ctl

century

cnty

certificate

cf

change

chn

channel

chnl

charge

chg

charity

chrty

check

chk

chest

chst

child

chld

choice

chc

cholesterol

cht

citation

citn

city

cty

claim

clm

class

cls

Classification

clsfn

classifier

CLSFR

click

clk

clickstream

clkstrm

client

clnt

climate

clmt

close

cl

closed

clsd

closing

cl

cloud

cld

code

cd

collar

cllr

Collateral

CLLRTL

collected

clt

collection

cln

color

clr

combination

cmbn

combine

cmbn

combined

cmbn

comment

cmt

commercial

cmcl

commission

cmn

commit

CMT

commited

CMTD

commodity

cmdty

communication

com

community

cmmnty

company

cmy

Company

co

compare

cmpr

compensation

cmpsn

competitor

cmp

complete

cmpl

completion

cmpltn

component

cmp

component

com

composite

cmpst

compound

cmpnd

computation

cmptn

concurrence

cncrn

condition

cn

constant

cnstnt

consumer

cns

contact

cnct

container

cnr

content

cntn

context

cntxt

contract

cntrt

contractor

cntr

control

ctl

conversion

cvn

coordinate

crdn

core

core

correction

crtn

correspondence

crsp

cosponsor

cospnsr

cost

cst

cost break

cbrk

count

cnt

counted

cnt

country

cy

coupon

cpn

cover

cvr

coverage

cvg

crawler

crwlr

create

crt

creation

crt

credit

cr

credit/debit

crdb

cube

cb

cumulative

cm

cumulative

cum

cup

cp

currency

cny

current

crt

custom

cstm

customer

ct

customer account

ctac

customer affiliation

ctaf

customer order

ctord

customer order line item

ctoltm

customer verify

ctvr

cycle

cycl

daily

dly

damaged

dm

data

dat

date

dt

day

dy

deal

dl

debit

db

declined

dcln

decree

dcr

default

dflt

deferred

dfr

definition

dfn

delete

dlt

delete/deletion

dlt

deliver

dv

delivery

dv

demographic

dmog

denomination

dnm

density

dnsty

department

dpt

department sales

dpts

deposit

ds

deposit redemption

dprd

depository

dsy

depreciation

dpc

depth

dpth

derivation

drvn

description

dscr

design

dgn

desired

dr

despatch

dpch

destination

dstn

detail

dtl

detection

dtctn

determination

dtrmn

developer

dvlpr

device

dvc

dew

dew

diameter

dmtr

dietary

dtry

different

df

digit

dgt

digital

dgtl

dimension

dmn

direction

drc

disability

dsblty

disbursement

dsb

discount

dsc

discrepancy

dscp

display

dply

disposal

dpsl

disposition

dpsn

distance

dst

distribution

dbn

document

dcm

documentation

dcmtn

domain

dmn

domestic

dms

Donation

dntn

donor

dnr

down

dwn

drawer

drw

drawing

drwg

dress

drs

drive

drv

drop

drp

DSD

dsd

duns

dns

duration

dur

duration/drained

drn

Duty

dty

dynamic

dyn

ean

EAN

EAN

ean

earn

ern

earned

ern

earning

ern

education

edc

effective

ef

elapsed

elpsd

electronic

eltnc

electronic signature

elsg

element

elm

eligibility

el

eligible

el

email

eml

emergence

emrgnc

emergency

emgncy

employee

em

employment

EMPLMT

enable

enbl

enabled

enbld

encoding

enc

end

end

endorsement

endsm

engine

engn

english

eng

entitlement

entltmt

entity

et

entry

enr

envelope

envl

environment

env

equipment

eq

equipment reading

eqrdg

established

est

establishment

est

estimate

estm

estimated

estm

ethnic

ethnc

ethnicity

ethn

event

ev

ex

ex

exceed/exceeded

excd

exception

excptn

exchange

exc

exempt

exm

exemption

exmptn

exit

exit

expect/expected

exp

expense

exp

expiration

ep

expire

expr

expired

exprd

Export

exprt

extended

extnd

extension

extn

external

extrn

external depository

extdst

exVAT

exvt

fabric

fbrc

face

fc

facility

fcly

facing

fcg

factor

fct

failed

fld

family

fmy

fashion

fshn

fat

fat

Feature

ftr

federal

fdl

fee

fe

feed

fd

feet

ft

fiber

fb

field

fld

file

fle

final

fnl

financial

fn

finish

fns

first

fs

fiscal

fsc

fiscal period

fsp

fiscal printer

fpr

fiscal year

fy

fixed

fx

fixture

fxtr

flag

fl

flamable

flmbl

flat

flt

fleet

fle

flexible

flx

flexogram

fog

floor

flr

flow

flw

follow

flw

food

fd

food stamp

fsmp

for

fr

force

frcd

force online

frcol

forced

frcd

forecast

frcst

forecasted

frcst

forecourt

fcrt

foreign

frg

form

frm

formality

frmlty

format

fmt

format

frmt

franchise/franchisee

fcs

freight

frgt

frequent

fq

from

fm

fuel/fuelling

fuel

fulfilled/fulfillment

flf

full

fll

function

fnc

funds

fnd

funnel

fnl

gauge

gge

gender

gnd

geo

geo

geographic

geo

geographic

geo

geophysical

geo

gift

gf

giveaway

gwy

given

gvn

global

gbl

glove

glv

goal

GL

grace

grc

grading

grdg

grams

gm

granted

grn

gross

gs

group

gp

GS1

GS1

habit

hbt

hand

hd

handle

hndl

handling

hn

hardware

hdwr

harmonized

hmzd

hazardous

hz

health

hlth

height

ht

held

hld

hierarchy

hrc

high

hgh

high/highest

hgh

hint

hnt

hip

hp

history

hstry

history

hst

holder

hldr

hole

hl

holiday

hldy

home

hm

horizontal

hrz

hospitality

hpt

host

hst

hour

hr

household

hshld

id

id

identification

idtn

identified

idn

identity

idn

idle

idl

Image

IMG

image

im

impairment

imprmnt

Import

imprt

impression

imprsn

in

in

inbound

inb

include

inc

income

incm

incorporation

incrp

increment

incrmt

index

idx

indicator

ind

individual

indvdl

influence

inflnc

influencer

inflnc

information

inf

initial

int

Initiative

INITV

inner

innr

insert

insrt

install

inst

installment

ins

Instant

instnt

instruction

instr

instructional

instr

instrunctions

instr

insurance

insr

insure

insr

intake

intk

intellectual

intllctl

intended

intd

intensity

intsy

intent

intnt

interest

intrst

intermediate

intm

International

intrntl

International Standards Organiztation

iso

International Telegraphic Union

itu

interval

intv

intra

intra

intransit

intrst

inventory

inv

inventory control document

icd

inventory control document line item

icdltm

invoice

invc

invoked

invkd

involvement

invlvmnt

iron

ir

is

is

issue

iss

issuer

issr

issuing

issg

item

itm

Java

jva

Jhook

jhk

journal

jr

journal entry

je

jurisdiction

jrdt

justification

jstfctn

key

ky

key lock

kylk

key/keyed

ky

keyboard

kbd

keyword

kywrd

killer

klr

kit

kt

label

lb

labels

lb

lading

ld

landed

lnd

language

lan

last

ls

late

lt

later

ltr

layaway

ly

lead

lead

ledger

ldg

Left

lft

leg

leg

legal

lg

legal

lgl

leisure

lsur

length

lng

level

lv

license

lsc

life

lf

life-cycle

lfc

Lifestyle

LFSTYL

limit

lm

line

ln

line display

ldpy

line item

ltm

line item group

ltmgp

linear

lnr

link

lnk

list

lst

loan

lon

local

lcl

location

lcn

lock

lck

logical

log

logistics

lgstcs

long

lng

lookup

lkp

low

lw

lower

lwr

loyalty

lylt

magnetic

mgn

magnetic ink character recognition

micr

magnetic stripe reader

msr

main

mn

maintain/maintenance

mnt

maintenance

mntnc

Major

mjr

Make

mk

managed

mgd

management

mgmt

manufacturer

mf

manufacturer

mfg

map

mp

mapping

mppng

marital

mrtl

markdown

mkd

market

mrk

market basket

mrbk

markon

mkn

markup

mkp

master

mstr

match

mtch

material

mtr

matrix

mtrx

maximum

mxm

means

mns

measure

msrmt

measurement

msrmt

media

md

member

mbr

membership

mbs

membership

mbrshp

mention

mntn

merchandise

mr

merchandise hierarchy

mrhrc

merchandise hierarchy group

mrgp

merchandise structure

mrst

merchandising

mr

message

msg

meta

mta

meter

mtr

method

mth

metric

mc

middle

mid

milligrams

mg

minimum

mnm

minute

mn

miscellaneous

msc

missing

mssg

mix

mx

mix and match

mxmh

mode

mod

model

mdl

modification

mdfn

modifier

mdfr

modify

mdf

monetary

mnty

money

mny

monogram

mgm

month

mnth

motion

mtn

motivation

mtvn

move

mv

moved

mvd

movement

mv

multiple

mlp

multiplicand

mpd

multiplier

mpr

multiply

multy

multiply

mltpy

municipal

mncpl

municipality

mncpl

name

nm

narration

nrtn

narrative

nrtv

national

ntl

natural

ntrl

nature

ntur

negative

ng

net/nett

nt

network

ntwrk

new

nw

no

no

non-orderd

nr

non-profit

npft

non-standard

nstd

nontax

ntx

nontaxable

ntxbl

nontaxed

ntxd

nota

nta

notch

ntch

notice

ntc

nozzle

nzl

number

nmb

nutrients

nutr

nutritional

ntr

object

obj

objective

objtv

Observation

OBSVN

observe/observed

obs

occasion

occn

occupation

OCCPTN

of

of

off

off

offer

ofr

office

ofc

offline

ofl

offset

ofs

on

on

open

opn

open/opening

opn

operating

opr

operation

oprn

operations

oprn

operator/operating

opr

or

or

order

ord

organization

orgn

orientation

orintn

origin

org

original

orgl

originator

orgr

other

oth

out

ot

outbound

otb

outer

outr

over

ovr

override/overriden

ovrd

owner

ownr

pack

pck

packing/package/packaging

pckg

page

pg

paid

pd

palette

plte

parameter

prmr

parent

prnt

part

prt

partition

prtn

partner

prtnr

party

prty

password

pwd

pattern

pttrn

payable

pyb

payment

pym

payment against

pymagt

payment on account

pyan

payroll

pyrl

pays

py

peg

pg

peg count

pgct

penalty

pnty

per

pr

percent

pe

percentage

prct

period

prd

perishable

prsh

permanent

prn

permissability/permission

prms

perpetual

prptl

persistence

prstnt

persistent

prstnt

person

prs

personal

prsl

Personality

prsnlty

petroleum

ptrlm

petty

pty

phone/telephone

ph

photograph

pgph

physical

phy

pickup

pkp

Piece

pc

PINPad

ppd

place

plc

placement

plcmnt

plan

pln

planogram

pog

plate

plt

plus

pls

point

pnt

Point of Sale/Point of Service

pos

points

pnt

POS

ps

position

pstn

positive

pstv

post

pst

postal

pstl

posted

pstd

postpay

pspy

precalculated

prcalc

precalculation

precalc

precedence

prcdn

precipitation

prcptn

precount

PRECNT

preference

prfc

Prefix

prfx

prepared

ppr

prepay

prpy

prepriced

pcd

pre-requisite

prqt

present

prsnt

preticketed

prptd

price

prc

price derivation

prdv

primary

prmry

principle

prcnpl

print

PRNT

print/printer

prt

printer

ptr

printer

PRNTR

privacy

prvy

probe

pbe

process

pcs

processing

prcs

processor

pcsr

product

pdt

professional

prfsl

program

prgm

prohibit

prhbt

prohibit/prohibition

prh

prohibited

prhbt

prohibition

prhbt

promotion

prm

promotional

prml

proof

prf

property

pry

proportion

prptn

prorate

prrt

prorated

prrt

prospect

prsp

protect

prtct

protein

prtn

protocol

prtcl

protocol

prtcl

protrata

prrt

provider

pvr

province

prvn

psychographic

psychgrph

published

pblshd

pump

pmp

purchase

pch

purpose

prps

qualification

QLFCN

qualify

QFLY

qualifying

QFLYNG

quality

qlty

quantity

qty

quarter

qrt

query

qry

question

qst

race

rc

random

rn

range

rnge

rate

rt

rating

rtg

raw

raw

read

rd

reader

rdr

reading

rdg

realtime

rltm

reason

rsn

rebate

rbt

receipt

rct

receivable/payable

rpl

receive/received/receiving

rcv

recipe

rcp

Recipient

rcpnt

recommended

rcm

reconciliation

rcn

record

rcd

Recycle

rcycl

redeem

rdm

redeemable

RDMBL

redeemed

rdm

redeemed

rdmd

redemption

rdm

reduction

rdn

refer

rfc

reference

rfc

referenced

rfd

referencing

rfng

referer

rfrr

referral

rfc

refund

rfd

region

rgn

register

rgst

registration

rgstn

regular

reg

related

rltd

relationship

rltn

relative

rltv

religion

rlgn

religious

rlg

remark

rmrk

rental

rnt

rented

rnt

repeat

rpt

replace

rpl

replenishment

rplmt

reporting

rp

repository

rpsty

representative

rps

request

rqs

requested

rqsd

required

rq

RequiredDailyAllowance

rda

requirement

rqmt

requisition

rqn

rerun

rrn

reserve

rsv

reserved

rsvd

reset

rst

resolution

rsltn

resource

rs

response

rsps

responsibility

rspy

responsible

rsp

restock

restk

restricted

RSTRCTD

restriction

RSTRCTN

restriction

RSTRCTN

restriction

RSTRCTN

result

rslt

resumed

rsm

retail

rtl

retail store group

strgp

retailer

rtlr

return

rtn

revenue

rvn

reversal

rvs

reward

rwd

Right

rt

ring

rng

risk

rsk

role

ro

rotate

rotn

rotated

rotn

rotation

rotn

round

rnd

round

rnd

rounding

rndng

rsk

risk

rule

ru

Run

rn

safe

sf

safety

sfty

salary

slr

sale

SL

sale

sls

sales

sls

sales

SLS

salutation

sln

sample

smp

satellite

stlte

saturated

strt

save

sv

scalar

SCLR

scale

scle

scan

SCN

scanned

SCNND

scanner

scnr

Schedule

schdl

scheduled

sch

scheduled end

set

scheduled start

ss

school

schl

scope

scp

score

scor

script

scrpt

seam

sm

search

srch

season

sn

second

2nd

secondary

scndry

seconds

scn

section

sctn

secular

sclr

security

scty

segment

sgmt

select

sel

sell

sl

selling

sl

send

snd

send check

sndck

sensor

snsr

sent

snt

sentiment

sntmnt

separately

sprtly

sequence

sqn

sequential

seql

serial

SRL

serialized

srz

server

SRVR

service

sv

serving

SRVNG

session

ssn

set

set

settlement

stlm

sharable

shrbl

share

shr

sheet

sht

shelf

sh

shell

shl

ship

shp

shipment

shpmt

shipped

shpd

shop

shop

shopper

shpr

shopping

shppg