O'Reilly logo

Mastering SQL Queries for SAP Business One by Gordon Du

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

18 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required