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

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