biuan SAP® BUSINESS ONE SDK
API ORCL
ORCL - Recurring Transaction Instances Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
RcpEntryTemplate EntryInt
11ORCP
Recurring Transaction Template
InstanceRecurrence InstanceInt
11
0
PlanDateScheduled DateDate
8
StatusRecurrence StatusVarChar
N) Not Executed
E) Executed
R) Removed
1
N
DocObjTypeDocument Object TypenVarChar
13) Invoice
112) Draft
20
DocEntryCreated Doc EntryInt
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


Recurring Transaction Template ORCP SQL Table



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