biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Production Order - Rows
API Production Orders Lines / Serial Numbers
OSRN - Serial Numbers Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items		LOT_KEYNo
SysNumberSystem NumberInt
11
DistNumberSerial NumbernVarChar
36
MnfSerialManufacturer Serial No.nVarChar
36
LotNumberLot NumbernVarChar
36
ExpDateExpiration DateDate
8
MnfDateManufacturing DateDate
8
InDateAdmission DateDate
8
GrntStartMfr Warranty Start DateDate
8
GrntExpMfr Warranty End DateDate
8
CreateDateCreation DateDate
8
LocationLocationnVarChar
100
StatusStatusVarChar
0
1) Unavailable
2) Allocated
1
NotesDetailsText
16
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
TransferedTransferredVarChar
Y) Yes
N) No
1
N
InstanceInstanceInt
6
0
AbsEntry KEY UNIQUEabs entryInt
11
PRIMARYYes
ObjTypeobject typenVarChar
20
itemNameItem DescriptionnVarChar
100
LogInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
CostTotalTotal Cost of BatchesNum
20
QuantityQuantityNum
20
QuantOutOutput QuantityNum
20
PriceDiffPrice DifferenceNum
20
BalanceBatch BalanceNum
20
TrackingNtCCD Tracking NoteInt
11OTCN
Tracking Note
TrackiNtLnCCD Tracking Note LineInt
11TCN1
Tracking Note - Line Data

Table relationship map

SELECT statement

SELECT OSRN.ItemCode AS 'Item No.', OSRN.SysNumber AS 'System Number', OSRN.DistNumber AS 'Serial Number', OSRN.MnfSerial AS 'Manufacturer Serial No.', OSRN.LotNumber AS 'Lot Number', OSRN.ExpDate AS 'Expiration Date', OSRN.MnfDate AS 'Manufacturing Date', OSRN.InDate AS 'Admission Date', OSRN.GrntStart AS 'Mfr Warranty Start Date', OSRN.GrntExp AS 'Mfr Warranty End Date', OSRN.CreateDate AS 'Creation Date', OSRN.Location AS 'Location', OSRN.Status AS 'Status', OSRN.Notes AS 'Details', OSRN.DataSource AS 'Data Source', OSRN.UserSign AS 'User Signature', OSRN.Transfered AS 'Transferred', OSRN.Instance AS 'Instance', OSRN.AbsEntry AS 'abs entry', OSRN.ObjType AS 'object type', OSRN.itemName AS 'Item Description', OSRN.LogInstanc AS 'Log Instance', OSRN.UserSign2 AS 'Updating User', OSRN.UpdateDate AS 'Update Date', OSRN.CostTotal AS 'Total Cost of Batches', OSRN.Quantity AS 'Quantity', OSRN.QuantOut AS 'Output Quantity', OSRN.PriceDiff AS 'Price Difference', OSRN.Balance AS 'Batch Balance', OSRN.TrackingNt AS 'CCD Tracking Note', OSRN.TrackiNtLn AS 'CCD Tracking Note Line' FROM OSRN AS OSRN

Related information


Serial Numbers SerialNumbers Object· Table: OSRN SRNT
SerialNumbers is a business object that represents the serial numbers and additional tracking information of items. This object is part of the Inventory and Production module. Source table: OSRN, OITL, ITL1.
   Parent: Production Orders Lines ProductionOrders_Lines Object· Table: WOR1

 v8.8  Serial Number Detail SerialNumberDetail Object· Table: OSRN
SerialNumberDetail is a business object that represents the serial number details of an item in the Inventory and Production module. Source table: OSRN.
   Parent: Serial Number Details Service SerialNumberDetailsService Service· Table: OSRN

 v8.8  Serial Number Details Service SerialNumberDetailsService Service· Table: OSRN
The SerialNumberDetailsService service enables you to look up and update serial number details information. Source table: OSRN.

OSRN SQL Table

Items OITM SQL Table

Tracking Note OTCN SQL Table

Tracking Note - Line Data TCN1 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates