The demo company has 13 tables and 1,873 rows, using the real SAP Business One table and column names. Fiscal year 2025-26, figures as at 2026-03-31. This page is generated from the same definition that builds the database, so it cannot drift out of date.
OTER
Territories5 rows · key territryIDSales territories. Joined from OCRD.Territory.
| territryID | INTEGER | Territory key |
| descript | TEXT | Territory name |
OCRG
Business partner groups8 rows · key GroupCodeCustomer and supplier groupings.
| GroupCode | INTEGER | Group key |
| GroupName | TEXT | Group name |
| GroupType | TEXT | C customers, S suppliers |
OITB
Item groups8 rows · key ItmsGrpCodItem groupings. Joined from OITM.ItmsGrpCod.
| ItmsGrpCod | INTEGER | Item group key |
| ItmsGrpNam | TEXT | Item group name |
OWHS
Warehouses4 rows · key WhsCodeStock locations.
| WhsCode | TEXT | Warehouse code |
| WhsName | TEXT | Warehouse name |
| City | TEXT | City |
| State | TEXT | State |
| StateCode | TEXT | GST state code, for place of supply |
OCRD
Business partners48 rows · key CardCodeCustomers and suppliers in one table, split by CardType.
| CardCode | TEXT | Business partner code |
| CardName | TEXT | Business partner name |
| CardType | TEXT | C customer, S supplier |
| GroupCode | INTEGER | → OCRG.GroupCode |
| LicTradNum | TEXT | GSTIN |
| Territory | INTEGER | → OTER.territryID |
| City | TEXT | City |
| State | TEXT | State |
| StateCode | TEXT | GST state code |
| Balance | REAL | Account balance |
| CreditLine | REAL | Credit limit |
| U_GSTStatus | TEXT | Active or Cancelled — a UDF, as at most sites |
OITM
Items36 rows · key ItemCodeItem master.
| ItemCode | TEXT | Item code |
| ItemName | TEXT | Item description |
| ItmsGrpCod | INTEGER | → OITB.ItmsGrpCod |
| InvntryUom | TEXT | Inventory unit of measure |
| LastPurPrc | REAL | Last purchase price |
| U_HSN | TEXT | HSN code — a UDF at most Indian sites |
| GSTRate | REAL | GST rate percent |
OITW
Item / warehouse97 rows · key ItemCode, WhsCodeStock per item per warehouse.
| ItemCode | TEXT | → OITM.ItemCode |
| WhsCode | TEXT | → OWHS.WhsCode |
| OnHand | REAL | Quantity in stock |
| AvgPrice | REAL | Moving average cost |
OINV
A/R invoices — header240 rows · key DocEntryOne row per sales invoice. DocStatus O is open, C is closed.
| DocEntry | INTEGER | Internal key |
| DocNum | INTEGER | Document number users see |
| CardCode | TEXT | → OCRD.CardCode |
| CardName | TEXT | Copied name at posting time |
| DocDate | TEXT | Posting date |
| DocDueDate | TEXT | Due date |
| DocTotal | REAL | Document total including tax |
| PaidToDate | REAL | Amount settled |
| VatSum | REAL | Total GST |
| DiscSum | REAL | Discount |
| DocStatus | TEXT | O open, C closed |
| Territory | INTEGER | → OTER.territryID |
INV1
A/R invoices — lines471 rows · key DocEntry, LineNumInvoice lines. Joined to OINV on DocEntry.
| DocEntry | INTEGER | → OINV.DocEntry |
| LineNum | INTEGER | Line number from 0 |
| ItemCode | TEXT | → OITM.ItemCode |
| Dscription | TEXT | Line description — note the spelling, it is SAP's |
| Quantity | REAL | Quantity |
| Price | REAL | Unit price before tax |
| LineTotal | REAL | Line total before tax |
| GrossBuyPr | REAL | Cost at time of sale, for margin |
| WhsCode | TEXT | → OWHS.WhsCode |
| VatGroup | TEXT | Tax code |
| VatSum | REAL | GST on the line |
OPCH
A/P invoices — header140 rows · key DocEntrySupplier invoices.
| DocEntry | INTEGER | Internal key |
| DocNum | INTEGER | Document number |
| CardCode | TEXT | → OCRD.CardCode |
| CardName | TEXT | Supplier name at posting time |
| DocDate | TEXT | Posting date |
| DocDueDate | TEXT | Due date |
| DocTotal | REAL | Total including tax |
| PaidToDate | REAL | Amount settled |
| VatSum | REAL | Total GST — the input tax credit at stake |
| DocStatus | TEXT | O open, C closed |
PCH1
A/P invoices — lines270 rows · key DocEntry, LineNumSupplier invoice lines.
| DocEntry | INTEGER | → OPCH.DocEntry |
| LineNum | INTEGER | Line number |
| ItemCode | TEXT | → OITM.ItemCode |
| Dscription | TEXT | Line description |
| Quantity | REAL | Quantity |
| Price | REAL | Unit price |
| LineTotal | REAL | Line total before tax |
| WhsCode | TEXT | → OWHS.WhsCode |
| VatSum | REAL | GST on the line |
ORDR
Sales orders — header60 rows · key DocEntryOpen orders are the pipeline.
| DocEntry | INTEGER | Internal key |
| DocNum | INTEGER | Document number |
| CardCode | TEXT | → OCRD.CardCode |
| CardName | TEXT | Customer name |
| DocDate | TEXT | Order date |
| DocDueDate | TEXT | Delivery date |
| DocTotal | REAL | Order value |
| DocStatus | TEXT | O open, C closed |
OINM
Inventory movements486 rows · key TransNumEvery stock movement. The ageing questions live here.
| TransNum | INTEGER | Movement key |
| ItemCode | TEXT | → OITM.ItemCode |
| Warehouse | TEXT | → OWHS.WhsCode |
| DocDate | TEXT | Movement date |
| InQty | REAL | Quantity in |
| OutQty | REAL | Quantity out |
| TransValue | REAL | Value of the movement |
| TransType | INTEGER | Source document type |
Nothing matches that. Try a table name like OINV, or a column like LicTradNum.