Mastering SQL Queries for SAP Business One

Object codes and names

This is a complete list of the objects used in SAP Business One. For query purposes, especially for SBO_SP_TransactionNotification, this list is important.

Code	Name of objects	Description of objects
1	oChartOfAccounts	Chart of Accounts
2	oBusinessPartners	Business Partners
3	oBanks	Banks
4	oItems	Items
5	oVatGroups	Vat Groups
6	oPriceLists	Price Lists
7	oSpecialPrices	Special Prices
8	oItemProperties	Item Properties
10	oBusinessPartnerGroups	Business Partner Groups
12	oUsers	Users
13	oInvoices	Sales invoice document
14	oCreditNotes	Sales credit note document
15	oDeliveryNotes	Sales delivery note document
16	oReturns	Sales return document
17	oOrders	Sales order document ...