biuan SAP® BUSINESS ONE SDK
API USRN
USRN - 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 USRN.ItemCode AS 'Item No.', USRN.SysNumber AS 'System Number', USRN.DistNumber AS 'Serial Number', USRN.MnfSerial AS 'Manufacturer Serial No.', USRN.LotNumber AS 'Lot Number', USRN.ExpDate AS 'Expiration Date', USRN.MnfDate AS 'Manufacturing Date', USRN.InDate AS 'Admission Date', USRN.GrntStart AS 'Mfr Warranty Start Date', USRN.GrntExp AS 'Mfr Warranty End Date', USRN.CreateDate AS 'Creation Date', USRN.Location AS 'Location', USRN.Status AS 'Status', USRN.Notes AS 'Details', USRN.DataSource AS 'Data Source', USRN.UserSign AS 'User Signature', USRN.Transfered AS 'Transferred', USRN.Instance AS 'Instance', USRN.AbsEntry AS 'Abs. Entry', USRN.ObjType AS 'Object Type', USRN.itemName AS 'Item Description', USRN.LogInstanc AS 'Log Instance', USRN.UserSign2 AS 'Updating User', USRN.UpdateDate AS 'Update Date', USRN.CostTotal AS 'Total Cost of Batches', USRN.Quantity AS 'Quantity', USRN.QuantOut AS 'Output Quantity', USRN.PriceDiff AS 'Price Difference', USRN.Balance AS 'Batch Balance', USRN.TrackingNt AS 'CCD Tracking Note', USRN.TrackiNtLn AS 'CCD Tracking Note Line' FROM USRN AS USRN

Related information


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