SAP Business One ( B1) Database table list with a brief description.

SAP Business One ( B1) Database table list with a brief description.

ODUN : Table for storing Dunning levels definition
AOB1 : Table for storing Message recipient list
OALR : Table for storing Messages
OCRN : Table for storing Currency codes
OUPT : Table for storing User authorizations for add-on forms
UPT1 : Table for storing User permission forms
OUSR : Table for storing Users of SAP Business One application
USR3 : Table for storing User authorizations
SARI : Table for storing Overall Addon Path Defining
OUQR : Table for storing User Queries
OBGT : Table for storing Budget management
BGT1 : Table for storing Budget item details of an account
OBGD : Table for storing Budget distribution methods
OBGS : Table for storing Budget scenarios
OACT : Table for storing G/L accounts
OBTD : Table for storing Journal vouchers
JDT1 : Table for storing Journal transaction – rows
OJDT : Table for storing Journal transaction
OSTA : Table for storing Sales tax jurisdictions
OSTT : Table for storing Sales tax authority types
OSTC : Table for storing Inclusive sales tax codes
DLN1 : Table for storing Delivery note rows
DLN2 : Table for storing Delivery note rows – expenses
DLN3 : Table for storing Delivery note – expenses
OEXD : Table for storing Defines additional expenses
DRF1 : Table for storing Draft – rows
DRF2 : Table for storing Draft rows – expenses
DRF3 : Table for storing Draft – expenses
INV1 : Table for storing Invoice – rows
INV2 : Table for storing Invoice rows – expenses
INV3 : Table for storing Invoice – expenses
ODLN : Table for storing Delivery – header
ODRF : Table for storing Drafts – header
OINV : Table for storing Invoice – header
OPCH : Table for storing AP invoice – header
OPDN : Table for storing Goods receipt purchase order – header
OPOR : Table for storing Purchase order – header
OQUT : Table for storing Quotation – header
ORDN : Table for storing Returns – header
ORDR : Table for storing Order – header
ORIN : Table for storing AR credit memo – header
ORPC : Table for storing AP credit memo – header
ORPD : Table for storing Goods return – header
PCH1 : Table for storing AP invoice – rows
PCH2 : Table for storing AP invoice rows – expenses
PCH3 : Table for storing AP invoice – expenses
PDN1 : Table for storing Goods receipt purchase order – row
PDN2 : Table for storing Goods receipt purchase order rows – expenses
PDN3 : Table for storing Goods receipt purchase order – expenses
POR1 : Table for storing Purchase order – rows
POR2 : Table for storing Purchase order rows – expenses
POR3 : Table for storing Purchase order – expenses
QUT1 : Table for storing Quotation – rows
QUT2 : Table for storing Quotation rows – expenses
QUT3 : Table for storing Quotation – expenses
RDN1 : Table for storing Returns – rows
RDN2 : Table for storing Return rows – expenses
RDN3 : Table for storing Returns – expenses
RDR1 : Table for storing Order – rows
RDR2 : Table for storing Order rows – expenses
RDR3 : Table for storing Order – expenses
RIN1 : Table for storing Credit memo – rows
RIN2 : Table for storing Credit memo rows -Expenses
RIN3 : Table for storing Credit memo – expenses
RPC1 : Table for storing AP credit memo – rows
RPC2 : Table for storing AP credit memo rows – expenses
RPC3 : Table for storing AP credit memo – expenses
RPD1 : Table for storing Goods return – rows
RPD2 : Table for storing Goods return rows – expenses
RPD3 : Table for storing Goods return – expenses
OIBT : Table for storing Batch number for item
OOND : Table for storing Industries list for sales opportunities
OORL : Table for storing Relationships for sales opportunities
OSRI : Table for storing Serial numbers for items
INV5 : Table for storing Withholding tax data
OTSI : Table for storing Master header data of a tax invoice of sales document
TSI1 : Table for storing Tax invoice of sales document – rows
OTPI : Table for storing Master header data of a tax invoice of purchase document
TPI1 : Table for storing Tax invoice of purchase document – rows
OTXD : Table for storing Master header data of a tax invoice of journal entry document
TXD1 : Table for storing Tax invoice of journal entry document – rows
OCLO : Table for storing Business partner activity locations
OCLA : Table for storing Statuses for Task type activities
OCLT : Table for storing Business partner activity types
OSCN : Table for storing Customer or vendor catalog number
OCRD : Table for storing Business partners
CRD1 : Table for storing Business partner addresses
CRD2 : Table for storing Business partner payment methods
CRD3 : Table for storing Business partner account receivable payable
CRD4 : Table for storing Business partner withholding tax
CRD5 : Table for storing Business partners payment dates
OCRB : Table for storing Business partners bank accounts
OCLG : Table for storing Contact customers and vendors
OCPR : Table for storing Contact persons
OOPR : Table for storing Sales opportunities
OPR1 : Table for storing Sales opportunity – rows
OPR2 : Table for storing Sales opportunity partners
OPR3 : Table for storing Sales opportunity competition
OPR4 : Table for storing Sales opportunity interests range
OPR5 : Table for storing Sales opportunity failure reasons
OTER : Table for storing Territory segmentations
IGE1 : Table for storing Goods issue – rows
IGE2 : Table for storing Goods issue rows – expenses
IGE3 : Table for storing Goods issue – expenses
IGN1 : Table for storing Goods receipt – rows
IGN2 : Table for storing Goods receipt rows – expenses
IGN3 : Table for storing Goods receipt – expenses
OIGE : Table for storing Goods issue
OIGN : Table for storing Goods receipt
OWTR : Table for storing Stock transfers
WTR1 : Table for storing Stock transfers – rows
ITT1 : Table for storing Product tree – child
OITT : Table for storing Product tree
OWKO : Table for storing Work instructions
WKO1 : Table for storing Work instructions – rows
ITM1 : Table for storing Items – prices
OITM : Table for storing Items
OITW : Table for storing Items – warehouse
OITB : Table for storing Item groups definition
OMRV : Table for storing Stock revaluation
MRV1 : Table for storing Stock revaluation – rows
OPKG : Table for storing Package types for deliveries
OPLN : Table for storing Price lists management
OITW : Table for storing Items – warehouse
OSPP : Table for storing Special prices
SPP1 : Table for storing Special prices for specified periods
SPP2 : Table for storing Special prices for specified quantities
OWHS : Table for storing Warehouses definition
OFCT : Table for storing Sales forecast
FCT1 : Table for storing Sales forecast – rows
ORCT : Table for storing Receipt
OVPM : Table for storing Vendor payment
RCT1 : Table for storing Receipt – checks
RCT2 : Table for storing Receipt – invoices
RCT3 : Table for storing Receipt – credit vouchers
RCT4 : Table for storing Receipt – account list
VPM1 : Table for storing Payments – check rows
VPM2 : Table for storing Payments – invoices
VPM3 : Table for storing Payments – credit memos
VPM4 : Table for storing Payments – list of accounts
CHO1 : Table for storing Checks for payment – rows
OBNK : Table for storing External bank statement
OCHO : Table for storing Check for payment
OCTG : Table for storing Payment term types
OPEX : Table for storing Payment results table
PEX1 : Table for storing Payment results table – rows
OBOE : Table for storing Bill of exchange table
OBOT : Table for storing Bill of exchange transactions table
BOT1 : Table for storing Bill of exchange transactions table – rows
OCTT : Table for storing Contract template (CRM)
OINS : Table for storing Customer equipment card
OSLT : Table for storing Knowledge base solution
OQUE : Table for storing Queues list for assigning to a service calls
QUE1 : Table for storing Queue member users
OCTR : Table for storing Service contract
CTR1 : Table for storing Service contract – rows
OSCL : Table for storing Service call
OCLG : Table for storing Service call activities
INV1 : Table for storing Service call inventory expenses
OHEM : Table for storing Employees information
HEM1 : Table for storing Employee absence information
HEM2 : Table for storing Employee education
HEM3 : Table for storing Employee reviews
HEM4 : Table for storing Employee previous employment information
HEM6 : Table for storing Employee rolls information
OHTM : Table for storing List of teams
HTM1 : Table for storing Employee membership role in a team

[category gist]