biuan SAP® BUSINESS ONE SDK
DTW Inventory / Bar Codes / Bar Code Master Data
API Bar Codes Service / Bar Code
OBCD - Bar Code Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BcdEntry KEY UNIQUEBar Code Abs. EntryInt
11
PRIMARYYes
BcdCode KEYBar Code - CodenVarChar
127
BCD_CODENo
BcdNameBar Code NamenVarChar
100
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
ITEMYes
UomEntryUoM Abs. EntryInt
11OUOM
UoM Master Data
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
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8

Table relationship map

SELECT statement

SELECT OBCD.BcdEntry AS 'Bar Code Abs. Entry', OBCD.BcdCode AS 'Bar Code - Code', OBCD.BcdName AS 'Bar Code Name', OBCD.ItemCode AS 'Item No.', OBCD.UomEntry AS 'UoM Abs. Entry', OBCD.DataSource AS 'Data Source', OBCD.UserSign AS 'User Signature', OBCD.LogInstanc AS 'Log Instance', OBCD.UserSign2 AS 'Updating User', OBCD.UpdateDate AS 'Date of Update', OBCD.CreateDate AS 'Creation Date' FROM OBCD AS OBCD

Related information


Bar Code BarCode Object· Table: OBCD
The bar codes for your items. Multiple bar codes are allowed for each single UoM of an item. Source table: OBCD.
   Parent: Bar Codes Service BarCodesService Service· Table: OBCD

Bar Codes Service BarCodesService Service· Table: OBCD
The BarCodesService service enables you to add, look up, update, and remove bar codes. Source table: OBCD.

OBCD SQL Table

Items OITM SQL Table

UoM Master Data OUOM 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