Tables

These are the tables used within the system that are currently documented. The remaining tables will be added in future releases. In the meantime, if you have questions on undocumented tables, please direct them to your MICROS support person.

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  R  S  T  U  V  W  X  Z

A

ABUSEDSTOCK

ACALLOC

ACALLOCATE

ACCOUNTACADJREASON

ACCOUNTDEPT

ACCOUNTDISC

ACCOUNTLEDGER

ACCOUNTREASON

ACCOUNTREBATE

ACCOUNTSTOCKADJREASON

ACCOUNTTAX

ACCOUNTTAXDETAIL

ACCOUNTTENDER

ACCTINTFADJ

ACDETAIL

ACDETAIL1

ACDTL

ACEXPIRYRULES

ACHDR

ACHEADER

ACHEADER1

ACLEDGER

ACMOVEMENT

ACREASONS

ACSTATEMENTBALANCE

ACTERMS

ACTRANSCODE

ALERTDATA

ALERTEMAIL

ALERTMSG

ALERTMSGCONTACT

ALERTMSGDATA

ALERTMSGEMAIL

ALERTSENT

ALLOCCOMPARE

ALLOCDETAIL

ALLOCHEADER

ALLOCITEM

ALLOCPODELIVERY

ALLOCPOITEM

ALLOCPOQTY

ALLOCPOSUPP

APN

AREACLASS

AREACOSTSELLTRADUNIT

AREADEPT

AREAREPORTTRADUNIT

AUDITCHG

AUDITMAINTDEF

AUDITMAINTVALUE

AUDITTABLE

B

B2BAUDIT

B2BEMAIL

B2BEMAILTEMPLATE

B2BMSGTEMPLATE

B2BREQUEST

B2BSENDFILE

BANKDTL

BANKENTRY

BANKFIGURES

BANKHDR

BANKING

BANKINGDEF

BANKINGDTL

BANKINGHDR

BANKSAFEDTL

BANKTRANS

BARSTOCKTAKE

BOORDERDTL

BOORDERHDR

BUDGET

BUDGETSTENA

BUYERDTL

BUYERHDR

BUYINGREVIEWDTL

BUYINGREVIEWHDR

C

CACHECHECK

CARDTYPE

CATEGORY

CHARTSALES

CLAIMDETAIL

CLAIMHEADER

CLASS

CODAEXPORTDTL

CODAEXPORTHDR

COMMISSIONDTL

COMMISSIONHDR

COMMISSIONLEVEL

COMMSCONFIG

COMPSELL

CONTROLS

COST

COSTSELLDELTA

CURRENCYCODE

CURRENCYRATE

CURRENCYSTRUCTURE

CUSTCARDS

CUSTCONTACT

CUSTDISPLAYDTL

CUSTDISPLAYHDR

CUSTFISCALINFO

CUSTOMER

CUSTOMERCATEGORY

CUSTOMERINVOICE

CUSTOMERLOCATIONSUMMARY

CUSTOMERSUMMARY

CUSTORDERCHG

CUSTORDERED

CUSTORDERHDR

CUSTORDERITEM

CUSTORDEROPTICAL

CUSTORDERSERIAL

CUSTORDERSERVICE

CUSTORDERSORDERED

CUSTORDERTENDER

CUSTPOINTS

CUSTPOINTSDELTA

CUSTPRICEITEM

CUSTPRICEITEMSELL

CUSTTYPE

D

DAILYINFO

DAILYSALES

DAILYSALESSERIAL

DAILYSALESSPLIT

DEALLEVEL

DELIVERY

DELIVERYAREA

DELIVERYAREATYPE

DELIVERYCHARGE

DELIVERYCHARGEDET

DELIVERYSLOT

DEPT

DISCHDR

DISCLANGUAGE

DISCLOCATION

DISCLOCATIONUSAGE

DISCOUNT

DISCOUNTRATE

DISCQUALIFYGROUP

DISCQUALIFYITEM

DISCREWARDITEM

DISCSECURITY

DPTCATGR

DRSINTALLSETUP

DRSLICENCE

DRSSERVICES

DRSSERVICESSTATUS

DTPROPERTIES

DYNAPOSPROFILE

E

E5EXPORT

EFTCARD

ERRMSG

ERRORMSG

ERRTYPE

F

FAMILY

FILEDOWNLOAD

FILEUPLOAD

FILEVERSIONS

FISCALBELGIUM

FISCALDTL

FISCALHDR

FISCALSINTEGRA

FOREIGNEXCHANGE

FREIGHT

FREIGHTRATE

FTPOPTS

G

GENERALLANGUAGE

GRDETAIL

GRHEADER

GROUPMODIFIER

GROUPS

H

HOTELACCOUNT

I

IMAGEVERSIONS

IMPORTDTL

IMPORTHDR

INCOMINGTRANS

INVEXTRADTL

INVEXTRAHDR

INVOICEDETAIL

INVOICEHEADER

INVOICEREBATE

INVTEMPLATEDTL

INVTEMPLATEHDR

ITEM

ITEMADDONS

ITEMALTUOM

ITEMARCHIVEREQUEST

ITEMBAY

ITEMBUYER

ITEMCATEGORY

ITEMCATEGORYTYPE

ITEMCATEGORYXREF

ITEMCODES

ITEMCOSTSELLCHG

ITEMDESCDTL

ITEMDESCHDR

ITEMGIFT

ITEMGIFTDTL

ITEMGIFTHDR

ITEMINACTIVE

ITEMLANGUAGE

ITEMMODIFIER

ITEMPACKAGING

ITEMPOSMESSAGE

ITEMPOSMESSAGELOCATION

ITEMRATING

ITEMRECIPE

ITEMSCAL

ITEMSETMEALINGRED

ITEMSETMEALREPLACE

ITEMSPECIALDATES

ITEMSTOCKBAY

ITEMSTOCKMANDATORY

ITEMTAX

ITEMTAXGROUP

ITEMTERM

ITEMTRANSFER

J

JOBTYPE

K

KBDETAIL

KBHEADER

KBLEVEL

KITCHENCODE

KITDTL

KITHDR

KSNETCOMPANYCODES

L

LABDET

LABEL

LANDFACT

LANGUAGEAVAIL

LANGUAGEDATA

LASTCOUNTERS2

LICENCECODE

LOCALCACHECHANGE

LOCATIONGRADE

LOCATIONGRADECLASS

LOCATIONLANGUAGE

LOCATIONTABLESECTION

LOGAPM

LOGTABLE

LOGTABLEAUDIT

LONGMESSAGES

LPR

M

MANAGEMENTAREA

MANIFESTDTL

MANIFESTHDR

MARGINCHG

MARGINDEPT

MARGINITEM

MEDIACFG

MEDIACLP

MEDIASCH

MEDIASCHDET

MEDIASCHHDR

MEDIATRIVIA

MEDIAWORK

MEMBERCARDTYPE

MEMBERUPGRADE

MENUDTL

MENUHDR

MENULEVEL

MENUSECURITY

MESSAGES

MODIFIERDTL

MODIFIERHDR

MSG

MSGATTACHMENTS

MSGRECIPIENT

MULTILOCATIONSTOCK

N

NAVISIONEXPORT

NEXTREC

NEXTSEQNUM

NONREVENUESALES

O

OFFER

OFFERGROUP

OFFERGROUPDEPT

OFFERGROUPITEM

OPERATORSTATS

ORDERCATEGORY

ORDERCONTROL

ORDERFREQDAYS

ORDERFREQUENCY

ORDERITEM

OVERSTOCKEDITEMS

P

PACKAGINGDTL

PACKAGINGHDR

PASSENGER

PICKINGDTL

PICKINGHDR

PODETAIL

POHEADER

POINTBASIC

POINTEXTRA

POREVIEWITEM

POREVIEWORIG

POREVIEWOTHER

POREVIEWREPDTL

POREVIEWTFR

POSCREDIT

POSCREDITBAD

POSCREDITBLOCKED

POSCREDITENTRY

POSCURRENCYRATE

POSDEVICETYPE

POSKEYDTL

POSKEYHDR

POSKEYLEVEL

POSKEYMULTISIZE

POSKEYSETMEAL

POSLOGONMESSAGE

POSNOTES

POSPRINTER

POSSECURITY

POSTCODE

PREPRINTTAX

PRICELEVEL

PRICELEVELSCHED

PROCESS

PROCESSITEMS

PROCESSSECURITY

PROCESSSTATUS

PROJECTHDR

PROJECTUSER

PROMOBASELINE

PROMODTL

PROMOGRP

PROMOGRP2

PROMOHDR

PROMOITEM

PROMOTYP

PROMOUNT

PROMOUNT2

PROPOSEDSELLS

PUBLICHOLIDAYS

R

RANGE

RATINGCODE

REASONLANGUAGE

REASONS

REBATEBUCKET

REBATECLAIMED

REBATEEXTRADTL

REBATEEXTRAHDR

REBATETYPE

RELEASENOTES

REPLICATETABLE

REPLICATIONFILES

REPORTDATA

REPORTDESIGNS

REPORTDISTRIBUTION

REPORTEXPORT

REPORTEXPORTUSER

REPORTGROUPS

REPORTREQUEST

REPORTS

REPORTTRADUNIT

REQUIREDSTOCKDTL

REQUIREDSTOCKHDR

RETURNTRANS

RETURNTRANSDTL

REVALUATION

REVALUESTKDTL

REVALUESTKHDR

REWARD

REWARDAUDIT

ROUNDRULE

ROUNDRULEDTL

ROUNDRULEHDR

ROUNDRULEUSAGE

RUNNINGCOST

S

SALESADJDETAIL

SALESADJHEADER

SALESFREIGHT

SALESFREIGHTRATE

SALESMETHOD

SCHEDJOB

SCHEDULE

SECURABLECONTROLS

SECURITY

SECURITYGROUPS

SECURITYPROFILE

SECURITYPROFILEDETAIL

SELL

SELLCHANGEOVER

SELLTYPE

SERIALNUMBER

SERVERSTATS

SESSIONLOG

SETMEALAVAILHDR

SETMEALAVAILLOCATION

SHELFDTL

SHELFHDR

SHELFITEM

SHIFTCODE

SHOPPINGDTL

SHOPPINGHDR

STATBUCKET

STATDEPT

STATITEM

STATSPER

STKADJTEMPLATEHDR

STKADJTEMPLATEDTL

STOCKACCOUNT

STOCKADJ

STOCKADJREASON

STOCKAREAS

STOCKAREADTL

STOCKAUDIT

STOCKAUDITSUMMARY

STOCKBATCH

STOCKBAYDTL

STOCKBAYHDR

STOCKDETAIL

STOCKENTRY

STOCKENTRYSERIAL

STOCKENTRYSETUP

STOCKENTRYZONE

STOCKSTATS

STOCKTAKEBADITEM

STOCKTAKEDTL

STOCKTAKEHDR

STOCKTAKELINK

STORERNG

SUBGROUP

SUGGESTPERIODADJ

SUGGESTSTOCKCLASS

SUGGESTSTOCKCOVER

SUPPCHRGSTORE

SUPPCONTACT

SUPPLIER

SUPPLIERALERTCONFIG

SUPPLIERB2BCOMMS

SUPPLIERDESC

SUPPLIERFEES

SUPPTAXXREF

SUPPTERM

SUPPTERMEXCEPTION

SUPPXREF

SURVEYANSWER

SURVEYHDR

SURVEYQUESTION

SURVEYRESULT

SYSTEMTABLE

T

TABLECODE

TABLEDETAILS

TAREWEIGHT

TAREWEIGHTGROUP

TAREWEIGHTGROUPDTL

TASKHDR

TASKRESPONSE

TASKRESPONSESENT

TASKTIMEENTRY

TAX

TAXCHANGE

TAXCHANGEDETAIL

TAXGROUPDTL

TAXGROUPHDR

TAXPLAN

TAXSYSTEM

TENDER

TENDERCOMMENTS

TENDERLANGUAGE

TENDERLOCATION

TENDERSECURITY

TENDERXREF

TERMAUDIT

TFRREQDET

TFRREQHDR

TFRSENDDET

TFRSENDHDR

TILL

TILLDECLARATION

TILLDEVICES

TILLINCOMING

TILLINCOMINGST

TILLOUTGOING

TILLOUTGOINGST

TILLOUTREQUEST

TILLOUTREQUESTDETAIL

TILLREADDETAIL

TILLREADREQUEST

TILLREADSTATUS

TILLSTATUS

TIMEKEEPAUDIT

TIMEKEEPDETAIL

TIMEKEEPSUMMARY

TIMEROSTERDTL

TKTDET

TKTHDR

TKTSERIAL

TILLSTATUS

TRADALTSTOCK

TRADAUTHLIMIT

TRADCATEGORY

TRADCODE

TRADCONTACT

TRADDEPT

TRADEMAILDETAIL

TRADGROUPLEVEL

TRADINGPERIOD

TRADINGUNITTILL

TRADJOB

TRADSHELF

TRADSHIFT

TRADSTATQUERY

TRADSTATUSMSG

TRADSTOR

TRADTAXREF

TRADUNIT

TRADUNITACCOUNT

TRADUNITCLASS

TRADUNITLIST

TRADUNITNOTIFY

TRADXREF

TRANSFERDETAIL

TRANSFERHEADER

TRENDITEM

TRENDITEMDETAIL

TRHEADER

TRIP

U

UNITOFMEASURE

UNUSEDCUSTOMERNUM

UNUSEDIPN

USEDCOUNTERCODES

USERAREA

USERCODE

USERCODES

USERCUSTOMER

USERDEFFIELD

USERDEFVALUE

USERDEPT

USERFRIEND

USERJOBTYPE

USERPOS

USERROSTEREXCEPTION

USERSECURITYGROUPS

USERSETTINGS

USERSTATUS

V

VALIDDESC

VALIDDESC2

VERSAIPN

VERSAKEYMAP

VOUCHER

W

WEBCODES

WEBLOG

X

XREFDPTCATGR

XREFGENERAL

XREFITEM

XREFTAX

XREFTENDER

XREFTRADUNIT

XREFUNITOFMEASURE

Z

ZCOMMDTL

ZCOMMHDR

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)