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

SQL Administration / VAT Report Numbering

API OVNM

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
NumId ^KEY ^UNIQUE	Numbering ID	Int		11		PRIMARY	Yes
NumName	Numbering Name	nVarChar		10
First	First Number	nVarChar		9
Next	Next Number	nVarChar		9
Last	Last Number	nVarChar		9
YrDepend	Year-Dependent	VarChar	Y) Year-Dependent N) Year-Indepedent	1	N
DefaultNum	Default Numbering	VarChar	Y) Default Numbering N) No Default Numbering	1	N

SELECT statement

SELECT
   OVNM.NumId AS 'Numbering ID', 
   OVNM.NumName AS 'Numbering Name', 
   OVNM.First AS 'First Number', 
   OVNM.Next AS 'Next Number', 
   OVNM.Last AS 'Last Number', 
   OVNM.YrDepend AS 'Year-Dependent', 
   OVNM.DefaultNum AS 'Default Numbering'
FROM OVNM AS OVNM

Related information

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