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

SQL Banking / Retorno Operation Codes

API OROC

SBO SQL database table details

Field	Description	Type	Constraints	Size	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11	PRIMARY	Yes
OccurCode	Occurrence Code	Int		11
MovemnCode	Movement Code	Int		6
BoeStatus	BoE Status	VarChar	G) Generated S) Sent D) Deposited P) Paid C) Canceled L) Closed F) Failed V) BoE to Vendor	1
Descript	Description	nVarChar		127
Color	Color	Int		11
FileFormat	File Format	nVarChar		100
BankCode	Bank Code	nVarChar		30

SELECT statement

SELECT
   OROC.AbsEntry AS 'Internal Number', 
   OROC.OccurCode AS 'Occurrence Code', 
   OROC.MovemnCode AS 'Movement Code', 
   OROC.BoeStatus AS 'BoE Status', 
   OROC.Descript AS 'Description', 
   OROC.Color AS 'Color', 
   OROC.FileFormat AS 'File Format', 
   OROC.BankCode AS 'Bank Code'
FROM OROC AS OROC

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