biuan SAP® BUSINESS ONE SDK
SQL Finance / Special Ledger - Analytical Accounting Report Lines: Material
API SLM1
SLM1 - Special Ledger - Analytical Accounting Report Lines: Material Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocID KEY UNIQUEDocument Identification NumberInt
11OSLM
Special Ledger - Analytical Accounting Report: Material		PRIMARYYes
LineIDLine IdentificationInt
11
RuleIDRule Identification NumberInt
6OSCM
Special Ledger - Analytical Accounting Configuration Rules: Material
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 SLM1.DocID AS 'Document Identification Number', SLM1.LineID AS 'Line Identification', SLM1.RuleID AS 'Rule Identification Number', SLM1.GoalNum AS 'Rule Goal Number', SLM1.TransType AS 'Transaction Type Number', SLM1.PrfCntVal AS 'Distribution Rule Code', SLM1.PrfCntOrig AS 'Orig. Distribution Rule Code', SLM1.Checked AS 'Selected for Processing', SLM1.Status AS 'Status', SLM1.Enabled AS 'Enabled for Processing', SLM1.DebitAct AS 'Debit Account', SLM1.CreditAct AS 'Credit Account', SLM1.RevSides AS 'Revert Debit/Credit Sides', SLM1.Src AS 'Source Amount', SLM1.SrcFC AS 'Source Amount, Foreign Currency', SLM1.SrcSC AS 'Source Amount, System Currency', SLM1.SrcCalc AS 'Calculated Amount', SLM1.SrcCalcFC AS 'Calculated Amount - Foreign', SLM1.SrcCalcSC AS 'Calculated Amount - System', SLM1.FinalSum AS 'Final Amount', SLM1.FinalSumFC AS 'Final Amount (FC)', SLM1.FinalSumSC AS 'Final Amount (SC)', SLM1.Currency AS 'Foreign Currency', SLM1.MainTable AS 'Main Source Table', SLM1.PKField0 AS 'Primary Key Field', SLM1.PKField1 AS 'Primary Key Field', SLM1.PKField2 AS 'Primary Key Field', SLM1.PKField3 AS 'Primary Key Field', SLM1.PKField4 AS 'Primary Key Field', SLM1.PKField5 AS 'Primary Key Field', SLM1.PKField6 AS 'Primary Key Field', SLM1.PKField7 AS 'Primary Key Field', SLM1.PKField8 AS 'Primary Key Field', SLM1.PKField9 AS 'Primary Key Field' FROM SLM1 AS SLM1

Related information


G/L Accounts OACT SQL Table

Currency Codes OCRN SQL Table

Special Ledger - Analytical Accounting Report: Material OSLM SQL Table

Distribution Rule OOCR SQL Table

Special Ledger - Analytical Accounting Configuration Rules: Material OSCM 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