biuan SAP® BUSINESS ONE SDK
API SLR1
SLR1 - Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocID KEY UNIQUEDocument Identification NumberInt
11OSLR
Special Ledger - Analytical Accounting Report: Revenues & Expenses
PRIMARYYes
LineIDLine IdentificationInt
11
RuleIDRule Identification NumberInt
6OSCR
Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses
GoalNumRule Goal NumberInt
6
TransTypeTransaction Type NumberInt
6
PrfCntValDistribution Rule CodenVarChar
8OOCR
Distribution Rule
PrfCntOrigOrig. Distribution Rule CodenVarChar
8OOCR
Distribution Rule
CheckedSelected for ProcessingVarChar
N) No
Y) Yes
1
Y
StatusStatusVarChar
1
EnabledEnabled for ProcessingVarChar
N) No
Y) Yes
1
Y
DebitActDebit AccountnVarChar
15OACT
G/L Accounts
CreditActCredit AccountnVarChar
15OACT
G/L Accounts
RevSidesRevert Debit/Credit SidesVarChar
N) No
Y) Yes
1
N
SrcSource AmountNum
20
SrcFCSource Amount, Foreign CurrencyNum
20
SrcSCSource Amount, System CurrencyNum
20
SrcCalcCalculated AmountNum
20
SrcCalcFCCalculated Amount - ForeignNum
20
SrcCalcSCCalculated Amount - SystemNum
20
FinalSumFinal AmountNum
20
FinalSumFCFinal Amount (FC)Num
20
FinalSumSCFinal Amount (SC)Num
20
CurrencyForeign CurrencynVarChar
3OCRN
Currency Codes
MainTableMain Source TablenVarChar
20
PKField0Primary Key FieldnVarChar
50
PKField1Primary Key FieldnVarChar
50
PKField2Primary Key FieldnVarChar
50
PKField3Primary Key FieldnVarChar
50
PKField4Primary Key FieldnVarChar
50
PKField5Primary Key FieldnVarChar
50
PKField6Primary Key FieldnVarChar
50
PKField7Primary Key FieldnVarChar
50
PKField8Primary Key FieldnVarChar
50
PKField9Primary Key FieldnVarChar
50

Table relationship map

SELECT statement

SELECT SLR1.DocID AS 'Document Identification Number', SLR1.LineID AS 'Line Identification', SLR1.RuleID AS 'Rule Identification Number', SLR1.GoalNum AS 'Rule Goal Number', SLR1.TransType AS 'Transaction Type Number', SLR1.PrfCntVal AS 'Distribution Rule Code', SLR1.PrfCntOrig AS 'Orig. Distribution Rule Code', SLR1.Checked AS 'Selected for Processing', SLR1.Status AS 'Status', SLR1.Enabled AS 'Enabled for Processing', SLR1.DebitAct AS 'Debit Account', SLR1.CreditAct AS 'Credit Account', SLR1.RevSides AS 'Revert Debit/Credit Sides', SLR1.Src AS 'Source Amount', SLR1.SrcFC AS 'Source Amount, Foreign Currency', SLR1.SrcSC AS 'Source Amount, System Currency', SLR1.SrcCalc AS 'Calculated Amount', SLR1.SrcCalcFC AS 'Calculated Amount - Foreign', SLR1.SrcCalcSC AS 'Calculated Amount - System', SLR1.FinalSum AS 'Final Amount', SLR1.FinalSumFC AS 'Final Amount (FC)', SLR1.FinalSumSC AS 'Final Amount (SC)', SLR1.Currency AS 'Foreign Currency', SLR1.MainTable AS 'Main Source Table', SLR1.PKField0 AS 'Primary Key Field', SLR1.PKField1 AS 'Primary Key Field', SLR1.PKField2 AS 'Primary Key Field', SLR1.PKField3 AS 'Primary Key Field', SLR1.PKField4 AS 'Primary Key Field', SLR1.PKField5 AS 'Primary Key Field', SLR1.PKField6 AS 'Primary Key Field', SLR1.PKField7 AS 'Primary Key Field', SLR1.PKField8 AS 'Primary Key Field', SLR1.PKField9 AS 'Primary Key Field' FROM SLR1 AS SLR1

Related information


G/L Accounts OACT SQL Table

Currency Codes OCRN SQL Table

Special Ledger - Analytical Accounting Report: Revenues & Expenses OSLR 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates