biuan SAP® BUSINESS ONE SDK
API ORCP
ORCP - Recurring Transaction Template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CodeTemplate CodenVarChar
8
DscriptionDescriptionnVarChar
50
IsRemovedIs RemovedVarChar
Y) Yes
N) No
1
N
DocObjTypeLinked Document TypenVarChar
-1)
23) Sales Quotation
17) Sales Order
15) Delivery
16) Return
203) A/R Down Payment
13) A/R Invoice
14) A/R Credit Memo
-13) A/R Reserve Invoice
(-0) (-
1470000113) Purchase Request
540000006) Purchase Quotation
22) Purchase Order
20) Goods Receipt PO
21) Goods Return
204) A/P Down Payment
18) A/P Invoice
19) A/P Credit Memo
-18) A/P Reserve Invoice
(-1) (-
59) Goods Receipt
60) Goods Issue
1250000001) Inventory Transfer Request
67) Inventory Transfer
20
-1
DraftEntryLinked Draft EntryInt
11ODRF
Drafts
FrequencyFrequencyVarChar
D) Daily
W) Weekly
M) Monthly
Q) Quarterly
S) Semiannually
A) Annually
O) One Time
1
M
RemindSub-FrequencyInt
-1)
1) On Sunday
2) On Monday
3) On Tuesday
4) On Wednesday
5) On Thursday
6) On Friday
7) On Saturday
101) Every 1
102) Every 2
103) Every 3
104) Every 4
105) Every 5
106) Every 6
107) Every 7
108) Every 8
109) Every 9
110) Every 10
115) Every 15
130) Every 30
145) Every 45
160) Every 60
1001) On 1
1002) On 2
1003) On 3
1004) On 4
1005) On 5
1006) On 6
1007) On 7
1008) On 8
1009) On 9
1010) On 10
1011) On 11
1012) On 12
1013) On 13
1014) On 14
1015) On 15
1016) On 16
1017) On 17
1018) On 18
1019) On 19
1020) On 20
1021) On 21
1022) On 22
1023) On 23
1024) On 24
1025) On 25
1026) On 26
1027) On 27
1028) On 28
1029) On 29
1030) On 30
1031) On 31
6
1001
StartDateExecution Start DateDate
8
EndDateExecution End DateDate
8
LogInstancLog InstanceInt
11
0
CreateUserCreated by UserInt
6OUSR
Users
CreateDateCreation DateDate
8
CreateTimeCreation TimeInt
6
UpdateUserUpdated by UsernVarChar
6OUSR
Users
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
6
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N

Table relationship map

SELECT statement

SELECT ORCP.AbsEntry AS 'Internal Number', ORCP.Code AS 'Template Code', ORCP.Dscription AS 'Description', ORCP.IsRemoved AS 'Is Removed', ORCP.DocObjType AS 'Linked Document Type', ORCP.DraftEntry AS 'Linked Draft Entry', ORCP.Frequency AS 'Frequency', ORCP.Remind AS 'Sub-Frequency', ORCP.StartDate AS 'Execution Start Date', ORCP.EndDate AS 'Execution End Date', ORCP.LogInstanc AS 'Log Instance', ORCP.CreateUser AS 'Created by User', ORCP.CreateDate AS 'Creation Date', ORCP.CreateTime AS 'Creation Time', ORCP.UpdateUser AS 'Updated by User', ORCP.UpdateDate AS 'Update Date', ORCP.UpdateTime AS 'Update Time', ORCP.DataSource AS 'Data Source' FROM ORCP AS ORCP

Related information


ORCP SQL Table

Users OUSR SQL Table

Drafts ODRF 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