biuan SAP® BUSINESS ONE SDK
API Document Lines / Batch Numbers
OBTN - Batch Numbers Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEYItem No.nVarChar
20OITM
Items		DIST_KEYNo
SysNumberSystem NumberInt
11
DistNumberBatch NumbernVarChar
36
MnfSerialBatch Attribute 1nVarChar
36
LotNumberBatch Attribute 2nVarChar
36
ExpDateExpiration DateDate
8
MnfDateManufacturing DateDate
8
InDateAdmission DateDate
8
GrntStartWarranty Start DateDate
8
GrntExpWarranty End DateDate
8
CreateDateCreation DateDate
8
LocationLocationnVarChar
100
StatusStatusVarChar
0
1) Not Accessible
2) Locked
1
0
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 OBTN.ItemCode AS 'Item No.', OBTN.SysNumber AS 'System Number', OBTN.DistNumber AS 'Batch Number', OBTN.MnfSerial AS 'Batch Attribute 1', OBTN.LotNumber AS 'Batch Attribute 2', OBTN.ExpDate AS 'Expiration Date', OBTN.MnfDate AS 'Manufacturing Date', OBTN.InDate AS 'Admission Date', OBTN.GrntStart AS 'Warranty Start Date', OBTN.GrntExp AS 'Warranty End Date', OBTN.CreateDate AS 'Creation Date', OBTN.Location AS 'Location', OBTN.Status AS 'Status', OBTN.Notes AS 'Details', OBTN.DataSource AS 'Data Source', OBTN.UserSign AS 'User Signature', OBTN.Transfered AS 'Transferred', OBTN.Instance AS 'Instance', OBTN.AbsEntry AS 'abs entry', OBTN.ObjType AS 'object type', OBTN.itemName AS 'Item Description', OBTN.LogInstanc AS 'Log Instance', OBTN.UserSign2 AS 'Updating User', OBTN.UpdateDate AS 'Update Date', OBTN.CostTotal AS 'Total Cost of Batches', OBTN.Quantity AS 'Quantity', OBTN.QuantOut AS 'Output Quantity', OBTN.PriceDiff AS 'Price Difference', OBTN.Balance AS 'Batch Balance', OBTN.TrackingNt AS 'CCD Tracking Note', OBTN.TrackiNtLn AS 'CCD Tracking Note Line' FROM OBTN AS OBTN

Related information


Batch Numbers BatchNumbers Object· Table: OBTN BTNT
BatchNumbers is a business object that represents the batch numbers of an item in the Inventory and Production module. This object enables you to add batch numbers for a selected item row (one record per item). Source table: OBTN, OBTW, OITL,...
   Parent: Document Lines Document_Lines Object· Table: IGE1 IGN1

 v8.8  Batch Number Detail BatchNumberDetail Object· Table: OBTN
BatchNumberDetail is a business object that represents the batch number details of an item in the Inventory and Production module. Source table: OBTN.
   Parent: Batch Number Details Service BatchNumberDetailsService Service· Table: OBTN

 v8.8  Batch Number Details Service BatchNumberDetailsService Service· Table: OBTN
The BatchNumberDetailsService service enables you to look up and update batch number details information. Source table: OBTN.

OBTN 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