biuan SAP® BUSINESS ONE SDK
SQL Recurring Postings
DTW Recurring Postings
API Journal Entries Lines / Gross Value
ORCR - Recurring Postings Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RcurCode KEY UNIQUERecurring Postings CodenVarChar
8
PRIMARYYes
RcurDescTransaction DescriptionnVarChar
50
FrequencyFrequencyVarChar
D) Daily
W) Weekly
M) Monthly
Q) Quarterly
S) Semi-annually
A) Annually
O) One Time
T) Template
N) Not executed yet
1
M
RemindSub-FrequencyInt
6
1
LastPostedLast ExecutedDate
8
NextDeu KEYNext ExecutionDate
8
BYDATENo
EntryCountEntries CounterInt
6
0
VolumeTransaction AmountNum
20
VolCurrTotal CurrencynVarChar
3
FinancVolTotal Monetary Val. of Trans.Num
20
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
TransCodeTransaction CodenVarChar
4
MemoDetailsnVarChar
50
LimitRtrnsReturns LimitVarChar
Y) Yes
N) No
1
N
ReturnsNo. of ReturnsInt
6
LimitDateDate LimitDate
8
InstanceInstanceInt
6
0
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
StampTaxStamp TaxVarChar
Y) Yes
N) No
1
N
AutoVatAutomatic VATVarChar
Y) Yes
N) No
1
N
ManageWTaxManage WTaxVarChar
Y) Yes
N) No
1
N
Ref3Reference 3nVarChar
27
DeferedTaxDeferred TaxVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ORCR.RcurCode AS 'Recurring Postings Code', ORCR.RcurDesc AS 'Transaction Description', ORCR.Frequency AS 'Frequency', ORCR.Remind AS 'Sub-Frequency', ORCR.LastPosted AS 'Last Executed', ORCR.NextDeu AS 'Next Execution', ORCR.EntryCount AS 'Entries Counter', ORCR.Volume AS 'Transaction Amount', ORCR.VolCurr AS 'Total Currency', ORCR.FinancVol AS 'Total Monetary Val. of Trans.', ORCR.Ref1 AS 'Reference 1', ORCR.Ref2 AS 'Reference 2', ORCR.TransCode AS 'Transaction Code', ORCR.Memo AS 'Details', ORCR.LimitRtrns AS 'Returns Limit', ORCR.Returns AS 'No. of Returns', ORCR.LimitDate AS 'Date Limit', ORCR.Instance AS 'Instance', ORCR.DataSource AS 'Data Source', ORCR.UserSign AS 'User Signature', ORCR.StampTax AS 'Stamp Tax', ORCR.AutoVat AS 'Automatic VAT', ORCR.ManageWTax AS 'Manage WTax', ORCR.Ref3 AS 'Reference 3', ORCR.DeferedTax AS 'Deferred Tax' FROM ORCR AS ORCR

Related information


Gross Value GrossValue Property· Table: ORCR
Returns the total amount including VAT in the journal entry line. Field name: GrossValue.
· Table: JDT1 BTF1    Parent: Journal Entries Lines JournalEntries_Lines Object· Table: JDT1 BTF1
ORCR SQL Table

Users OUSR SQL Table
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