SAP Business One SDK 10.0 - Database Tables Reference
-
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 |