SRT2 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Reports / Korean Summary Report - Rows2

API SRT2

SRT2 - Korean Summary Report - Rows2 Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
SumRptId ^KEY ^UNIQUE	Summary Rpt ID	nVarChar	100	PRIMARY	Yes
SeqNo	Sequence Number	Int	11
VATRegNum	VAT Reg. Number of BP	nVarChar	12
CardCode	BP Code on OCRD	nVarChar	15
CardName	BP Name	nVarChar	100
TransNo	Total Trans Number under BP	Int	11
BaseAmt	Total Base Amount under BP	Num	20
TaxAmt	Total Tax Amount under BP	Num	20
Remark	Line Item Remark, do not use	nVarChar	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

biuan SAP® BUSINESS ONE

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