📚 SAP Business One SDK Help

Table Name: OSRN

Table Description: Serial Numbers Master Data

Field Description Type Size Related Default Value Constraints
ItemCode Item No. nVarChar 50 OITM      
SysNumber System Number Int 11 -      
DistNumber Serial Number nVarChar 36 -      
MnfSerial Manufacturer Serial No. nVarChar 36 -      
LotNumber Lot Number nVarChar 36 -      
ExpDate Expiration Date Date 8 -      
MnfDate Manufacturing Date Date 8 -      
InDate Admission Date Date 8 -      
GrntStart Mfr Warranty Start Date Date 8 -      
GrntExp Mfr Warranty End Date Date 8 -      
CreateDate Creation Date Date 8 -      
Location Location nVarChar 100 -      
Status Status VarChar 1 -   0 Available
            1 Unavailable
            2 Allocated
Notes Details Text 16 -      
DataSource Data Source VarChar 1 - N N Unknown
            I Interface
            U Update
            M Import
            O DI API
            S Service Layer
            W Web Client
            A Doc. Generation Wizard
            D Restore Wizard
            P Partner Implementation
            T Year Transfer
UserSign User Signature Int 6 OUSR      
Transfered Transferred VarChar 1 - N Y Yes
            N No
Instance Instance Int 6 - 0    
AbsEntry abs entry Int 11 -      
ObjType object type nVarChar 20 -      
itemName Item Description nVarChar 200 -      
LogInstanc Log Instance Int 11 -      
UserSign2 Updating User Int 6 OUSR      
UpdateDate Update Date Date 8 -      
CostTotal Total Cost of Batches Num 19.6 -      
Quantity Quantity Num 19.6 -      
QuantOut Output Quantity Num 19.6 -      
PriceDiff Price Difference Num 19.6 -      
Balance Batch Balance Num 19.6 -      
TrackingNt CCD Tracking Note Int 11 OTCN      
TrackiNtLn CCD Tracking Note Line Int 11 TCN1      
SumDec Totals Accuracy for SnB Int 6 -      
Key Unique Field
PRIMARY Yes AbsEntry
SYSTEM_KEY Yes ItemCode
    SysNumber
DIST_KEY No ItemCode
    DistNumber
LOT_KEY No ItemCode
    LotNumber