biuan SAP® BUSINESS ONE SDK
SQL Reports / Korean Summary Report - Rows1
API SRT1
SRT1 - Korean Summary Report - Rows1 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SumRptId KEY UNIQUESummary Rpt IDnVarChar
100
PRIMARYYes
SeqNoSequence NumberInt
11
CardNumBusiness Partner Total NumbersInt
11
TransNumTotal Trans Number Under BPInt
11
BaseAmtTotal Base Amount Under BPsNum
20
TaxAmtTotal Tax Amount Under BPsNum
20

SELECT statement

SELECT SRT1.SumRptId AS 'Summary Rpt ID', SRT1.SeqNo AS 'Sequence Number', SRT1.CardNum AS 'Business Partner Total Numbers', SRT1.TransNum AS 'Total Trans Number Under BP', SRT1.BaseAmt AS 'Total Base Amount Under BPs', SRT1.TaxAmt AS 'Total Tax Amount Under BPs' FROM SRT1 AS SRT1

Related information
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