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

API OVRW

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
RunName	Wizard Run Name	nVarChar		100
RunDate	Wizard Run Date	Date		8
Status	Status	VarChar	E) Executed S) Saved D) Draft C) Canceled	1		E
UserSign	User Signature	Int		11	OUSR Users
LedgerType	Ledger Type	VarChar	S) Sales P) Purchase	1		S
DebitAcc	Debit Account	nVarChar		15	OACT G/L Accounts
PostDate	Posting Date	Date		8
JESeries	Journal Entry Series	nVarChar		6		0
APTISeries	A/P Tax Invoice Series	nVarChar		6		0
DateType	Date Type	VarChar	R) Posting Date D) Due Date T) Document Date	1		R
DateFrom	Date From	Date		8
DateTo	Date To	Date		8
IncCorAlt	Include Corr. and Alter.	VarChar	Y) Yes N) No	1		N
BPLId	Active Branch	Int		11	OBPL Business Place

Table relationship map

SELECT statement

SELECT
   OVRW.AbsEntry AS 'Internal Number', 
   OVRW.RunName AS 'Wizard Run Name', 
   OVRW.RunDate AS 'Wizard Run Date', 
   OVRW.Status AS 'Status', 
   OVRW.UserSign AS 'User Signature', 
   OVRW.LedgerType AS 'Ledger Type', 
   OVRW.DebitAcc AS 'Debit Account', 
   OVRW.PostDate AS 'Posting Date', 
   OVRW.JESeries AS 'Journal Entry Series', 
   OVRW.APTISeries AS 'A/P Tax Invoice Series', 
   OVRW.DateType AS 'Date Type', 
   OVRW.DateFrom AS 'Date From', 
   OVRW.DateTo AS 'Date To', 
   OVRW.IncCorAlt AS 'Include Corr. and Alter.', 
   OVRW.BPLId AS 'Active Branch'
FROM OVRW AS OVRW

Related information

OBPL SQL Table

OACT 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