OPVL - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Lender - Pelecard

DTW Inventory / Pick and Pack

API OPVL

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
Code ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
Name	Name	nVarChar		50
ConsolNum ^KEY ^UNIQUE	Vendor Code	nVarChar		2			CONSOL_NUM	Yes
DataSource	Data Source	VarChar	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
UserSign	User Signature	Int		6	OUSR Users

Table relationship map

SELECT statement

SELECT
   OPVL.Code AS 'Internal Number', 
   OPVL.Name AS 'Name', 
   OPVL.ConsolNum AS 'Vendor Code', 
   OPVL.DataSource AS 'Data Source', 
   OPVL.UserSign AS 'User Signature'
FROM OPVL AS OPVL

Related information

OPVL SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

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