biuan SAP® BUSINESS ONE SDK
API OSRL
OSRL - Serial Numbers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCodeItem No.nVarChar
20OITM
Items
SerialNumSerial NumbernVarChar
17
CardCode KEYCustomer CodenVarChar
15OCRD
Business Partner
CARD_KEYNo
DocNum KEYInvoice NumberInt
11
INV_NUMNo
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OSRL.ItemCode AS 'Item No.', OSRL.SerialNum AS 'Serial Number', OSRL.CardCode AS 'Customer Code', OSRL.DocNum AS 'Invoice Number', OSRL.UserSign AS 'User Signature' FROM OSRL AS OSRL

Related information


Business Partner OCRD SQL Table

Items OITM SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates