biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Bin Field Configuration / Bin Field Configuration
DTW Administration / Setup / Inventory / Bin Locations / Bin Field Configuration
API Bin Location Fields Service / Bin Location Field
OBFC - Bin Field Configuration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
FldType KEY UNIQUEField TypeVarChar
S) Warehouse Sublevel
A) Bin Location Attribute
1
BUSINESS_KYes
FldNumField NumberInt
6
DispNameDisplay NamenVarChar
20
ActivatedActive [Y/N]VarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
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
TransferedYear Transfer [Y/N]VarChar
1
N
InstanceInstanceInt
6
0
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DftNameDefault Field NamenVarChar
20

Table relationship map

SELECT statement

SELECT OBFC.AbsEntry AS 'Internal Number', OBFC.FldType AS 'Field Type', OBFC.FldNum AS 'Field Number', OBFC.DispName AS 'Display Name', OBFC.Activated AS 'Active [Y/N]', OBFC.UserSign AS 'User Signature', OBFC.DataSource AS 'Data Source', OBFC.Transfered AS 'Year Transfer [Y/N]', OBFC.Instance AS 'Instance', OBFC.LogInstanc AS 'Log Instance', OBFC.CreateDate AS 'Creation Date', OBFC.UserSign2 AS 'Updating User', OBFC.UpdateDate AS 'Date of Update', OBFC.DftName AS 'Default Field Name' FROM OBFC AS OBFC

Related information


Bin Location Field BinLocationField Object· Table: OBFC
The bin location field you can specify and activate. Warehouse sublevels ? The smaller units of space in a warehouse. SAP Business One lets you define up to 4 warehouse sssssssssublevels Bin location attributes ? The attributes you...
   Parent: Bin Location Fields Service BinLocationFieldsService Service· Table: OBFC

Bin Location Fields Service BinLocationFieldsService Service· Table: OBFC
The BinLocationFieldsService service enables you to look up and update bin location fields. Source table: OBFC.

OBFC 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