biuan SAP® BUSINESS ONE SDK
SQL Finance / Special Ledger - Analytical Accounting Report: Revenues & Expenses
API OSLR
OSLR - Special Ledger - Analytical Accounting Report: Revenues & Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocID KEY UNIQUEDocument Identification NumberInt
11
PRIMARYYes
DocDateDate of Report GenerationDate
8
Ref1Journal Entry NumberInt
11OJDT
Journal Entry
Ref2Original JE ReferenceInt
11OJDT
Journal Entry
StatusDocument StatusVarChar
1
DateFromDocument Start DateDate
8
DateToDocument End DateDate
8
TotDebitTotal Debit AmountNum
20
TotCreditTotal Credit AmountNum
20
RateTypeType of Exchange RateVarChar
O) Original document
E) Execution date
V) Other value
1
O
CommentRemarksnVarChar
127
UserSignUser SignatureInt
6OUSR
Users
CanceledCanceledVarChar
Y) Yes
N) No
1
N
CancelDateCancelation DateDate
8
CancelUserDocument Cancelled byInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OSLR.DocID AS 'Document Identification Number', OSLR.DocDate AS 'Date of Report Generation', OSLR.Ref1 AS 'Journal Entry Number', OSLR.Ref2 AS 'Original JE Reference', OSLR.Status AS 'Document Status', OSLR.DateFrom AS 'Document Start Date', OSLR.DateTo AS 'Document End Date', OSLR.TotDebit AS 'Total Debit Amount', OSLR.TotCredit AS 'Total Credit Amount', OSLR.RateType AS 'Type of Exchange Rate', OSLR.Comment AS 'Remarks', OSLR.UserSign AS 'User Signature', OSLR.Canceled AS 'Canceled', OSLR.CancelDate AS 'Cancelation Date', OSLR.CancelUser AS 'Document Cancelled by' FROM OSLR AS OSLR

Related information


OSLR SQL Table

Users OUSR SQL Table

Journal Entry OJDT 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