biuan SAP® BUSINESS ONE SDK
API SRT2
SRT2 - Korean Summary Report - Rows2 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SumRptId KEY UNIQUESummary Rpt IDnVarChar
100
PRIMARYYes
SeqNoSequence NumberInt
11
VATRegNumVAT Reg. Number of BPnVarChar
12
CardCodeBP Code on OCRDnVarChar
15
CardNameBP NamenVarChar
100
TransNoTotal Trans Number under BPInt
11
BaseAmtTotal Base Amount under BPNum
20
TaxAmtTotal Tax Amount under BPNum
20
RemarkLine Item Remark, do not usenVarChar
100

SELECT statement

SELECT SRT2.SumRptId AS 'Summary Rpt ID', SRT2.SeqNo AS 'Sequence Number', SRT2.VATRegNum AS 'VAT Reg. Number of BP', SRT2.CardCode AS 'BP Code on OCRD', SRT2.CardName AS 'BP Name', SRT2.TransNo AS 'Total Trans Number under BP', SRT2.BaseAmt AS 'Total Base Amount under BP', SRT2.TaxAmt AS 'Total Tax Amount under BP', SRT2.Remark AS 'Line Item Remark, do not use' FROM SRT2 AS SRT2

Related information




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