biuan SAP® BUSINESS ONE SDK
API SCR2
SCR2 - Special Ledger - Analytical Accounting Configuration Rule Goals: Revenues & Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6OSCR
Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses
PRIMARYYes
GoalNumRule Goal NumbernVarChar
6
TransTpValTransaction Type NumberInt
6
TransTpFldTransaction Type Table FieldnVarChar
20
PrfCntValDistribution Rule CodenVarChar
8OOCR
Distribution Rule
PrfCntFldDistribution Rule Table FieldnVarChar
20
DebitActDebit AccountnVarChar
15OACT
G/L Accounts
CreditActCredit AccountnVarChar
15OACT
G/L Accounts
RevSidesRevert Debit/Credit SidesVarChar
N) No
Y) Yes
1
N
SrcTableMain Source TablenVarChar
10
SrcFieldMain Source Table FieldnVarChar
20
SrcFieldFCSource Field, Foreign CurrencynVarChar
20
SrcFieldSCSource Field, System CurrencynVarChar
20
CalcCalculation ExpressionnVarChar
127
CalcFCExpression for Foreign CalculationnVarChar
127
CalcSCExpression for System CalculationnVarChar
127
CalcCondCalculation ConditionnVarChar
127
CalcCondFCCondition for Foreign CalculationnVarChar
127
CalcCondSCCondition for System CalculationnVarChar
127
CurrFldTable Field with CurrencynVarChar
20
CallProcRecalculation Stored Procedure NamenVarChar
50
ExtCondExtended Special DatanVarChar
127

Table relationship map

SELECT statement

SELECT SCR2.RuleID AS 'Rule Identification Number', SCR2.GoalNum AS 'Rule Goal Number', SCR2.TransTpVal AS 'Transaction Type Number', SCR2.TransTpFld AS 'Transaction Type Table Field', SCR2.PrfCntVal AS 'Distribution Rule Code', SCR2.PrfCntFld AS 'Distribution Rule Table Field', SCR2.DebitAct AS 'Debit Account', SCR2.CreditAct AS 'Credit Account', SCR2.RevSides AS 'Revert Debit/Credit Sides', SCR2.SrcTable AS 'Main Source Table', SCR2.SrcField AS 'Main Source Table Field', SCR2.SrcFieldFC AS 'Source Field, Foreign Currency', SCR2.SrcFieldSC AS 'Source Field, System Currency', SCR2.Calc AS 'Calculation Expression', SCR2.CalcFC AS 'Expression for Foreign Calculation', SCR2.CalcSC AS 'Expression for System Calculation', SCR2.CalcCond AS 'Calculation Condition', SCR2.CalcCondFC AS 'Condition for Foreign Calculation', SCR2.CalcCondSC AS 'Condition for System Calculation', SCR2.CurrFld AS 'Table Field with Currency', SCR2.CallProc AS 'Recalculation Stored Procedure Name', SCR2.ExtCond AS 'Extended Special Data' FROM SCR2 AS SCR2

Related information


G/L Accounts OACT SQL Table

Distribution Rule OOCR SQL Table

Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses OSCR 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