biuan SAP® BUSINESS ONE SDK
API RCR1
RCR1 - Recurring Postings - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RcurCode KEY UNIQUERecurring Postings CodenVarChar
8ORCR
Recurring Postings
PRIMARYYes
LineIdRow NumberInt
11
0
AcctCodeAccount CodenVarChar
15
AcctDescAccount DescriptionnVarChar
100
DebitDebitNum
20
CreditCreditNum
20
CurrencyCurrencynVarChar
3
InstanceInstanceInt
6
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
UserSignUser SignatureInt
6OUSR
Users
VatLineVAT RowVarChar
Y) Yes
N) No
1
N
CtrlAcctControl AccountnVarChar
15
OcrCodeDistr. RulenVarChar
8OOCR
Distribution Rule
TaxTypeTax TypeInt
6
0
TaxPostAccTax Posting AccountVarChar
N)
R) Sales Tax Account
P) Purchasing Tax Account
1
N
StaCodeAuthority CodenVarChar
8OSTA
Sales Tax Authorities
StaTypeAuthority TypeInt
11OSTT
Sales Tax Authorities Type
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
OcrCode1Costing Code 1nVarChar
8OOCR
Distribution Rule
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
WtLiableWTax-LiableVarChar
Y) Yes
N) No
1
WTaxLineWTax RowVarChar
Y) Yes
N) No
1
N
GrossValueGross ValueNum
20
ProjectProject CodenVarChar
20OPRJ
Project Codes
BPLIdBranchInt
11OBPL
Business Place

Table relationship map

SELECT statement

SELECT RCR1.RcurCode AS 'Recurring Postings Code', RCR1.LineId AS 'Row Number', RCR1.AcctCode AS 'Account Code', RCR1.AcctDesc AS 'Account Description', RCR1.Debit AS 'Debit', RCR1.Credit AS 'Credit', RCR1.Currency AS 'Currency', RCR1.Instance AS 'Instance', RCR1.VatGroup AS 'Tax Group', RCR1.UserSign AS 'User Signature', RCR1.VatLine AS 'VAT Row', RCR1.CtrlAcct AS 'Control Account', RCR1.OcrCode AS 'Distr. Rule', RCR1.TaxType AS 'Tax Type', RCR1.TaxPostAcc AS 'Tax Posting Account', RCR1.StaCode AS 'Authority Code', RCR1.StaType AS 'Authority Type', RCR1.TaxCode AS 'Tax Code', RCR1.OcrCode1 AS 'Costing Code 1', RCR1.OcrCode2 AS 'Costing Code 2', RCR1.OcrCode3 AS 'Costing Code 3', RCR1.OcrCode4 AS 'Costing Code 4', RCR1.OcrCode5 AS 'Costing Code 5', RCR1.WtLiable AS 'WTax-Liable', RCR1.WTaxLine AS 'WTax Row', RCR1.GrossValue AS 'Gross Value', RCR1.Project AS 'Project Code', RCR1.BPLId AS 'Branch' FROM RCR1 AS RCR1

Related information


Business Place OBPL SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Recurring Postings ORCR SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT SQL Table

Sales Tax Codes OSTC SQL Table

Users OUSR SQL Table

Tax Definition OVTG 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