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

SQL

Marketing Documents and Receipts /

Recurring Transaction Instances

API ORCL

ORCL - Recurring Transaction Instances Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
RcpEntry	Template Entry	Int		11	ORCP Recurring Transaction Template
Instance	Recurrence Instance	Int		11		0
PlanDate	Scheduled Date	Date		8
Status	Recurrence Status	VarChar	N) Not Executed E) Executed R) Removed	1		N
DocObjType	Document Object Type	nVarChar	13) Invoice 112) Draft	20
DocEntry	Created Doc Entry	Int		11

SELECT statement

SELECT
   ORCL.AbsEntry AS 'Internal Number', 
   ORCL.RcpEntry AS 'Template Entry', 
   ORCL.Instance AS 'Recurrence Instance', 
   ORCL.PlanDate AS 'Scheduled Date', 
   ORCL.Status AS 'Recurrence Status', 
   ORCL.DocObjType AS 'Document Object Type', 
   ORCL.DocEntry AS 'Created Doc Entry'
FROM ORCL AS ORCL

Related information

ORCP 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates