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

SQL Finance / Tax Report / Tax Report

DTW Tax Report

API Report Filter Service / Tax Report Filter

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Abs Entry (Numerator)	Int		11		PRIMARY	Yes
ReportName ^KEY ^UNIQUE	Report Name	nVarChar		50		NAME	Yes
RptLayout	Report Layout	VarChar	R) Tax Register Book D) Tax Declaration B) Black List Country - Tax Declaration L) Black List Country - Tax Declaration 2013 A) VAT Annual List I) Annual Invoice Declaration 2011 N) Annual Invoice Declaration 2013 P) Declaration of Purchases from San Marino E) Electronic Tax Declaration	1	R
FirstPrint	First Printed No.	Int		11
FromDate	Date From	Date		8
ToDate	Date To	Date		8
TaxDate	Document Date	VarChar	N) No Y) Yes	1	N
RoundSum	Round Amounts	VarChar	N) No Y) Yes	1	N
Declration	Declaration Type	VarChar	O) Original S) Substitute C) Complementary	1	O
FilterType	Selection Criteria Type	VarChar	V) Tax Report W) Withholding Tax Report T) Report 347 E) 349 Report R) Reconciliation Report S) Stamp Tax U) Sales Report N) None B) Box Report O) Appendix O or P Selection A) Annual Sales Report F) VAT Refund Report C) Input/Output VAT Report	1	N
ExcludeWT	Exclude Withholding Tax	VarChar	N) No Y) Yes	1	N
CustomerIn	Include Customers	VarChar	Y) Yes N) No	1	Y
VendorIn	Include Vendors	VarChar	N) No Y) Yes	1	Y
Period	Quarter, Year or Month	VarChar	Q) Quarter Y) Year M) Month S) .	1	Q
Quarter	Quarter	Int		11
Year	Year	Int		11
DocType	A/P or A/R	VarChar	P) Purchasing Documents R) Sales Documents	1	P
CreditMemo	Credit Memos	VarChar	N) No Y) Yes	1	N
DocTypeIn	Include Document Type	VarChar	N) No Y) Yes	1	N
FirstReg	First Register Number	Int		11
AccountIn	Include G/L Accounts	VarChar	N) No Y) Yes	1	N
DeferTaxIn	Show Pmts with Deferred Tax	VarChar	Y) Yes N) No	1	Y
ApndxOOrP	Appendix O or P Selection	VarChar	Y) Yes N) No	1	Y
DispOBCB	Opening & Closing Balance	VarChar	N) No Y) Yes	1	Y
FromSeries	From Tax Series Group	Int		11
ToSeries	To Tax Series Group	Int		11
canceltn	For EU Sales Report	VarChar		1	N
HideNTrans	Hide Tax Codes with no Trans.	VarChar	N) No Y) Yes	1	N
SeriesIn	Include Series Filter	VarChar	N) No Y) Yes	1	N
UserCode	User Code	nVarChar		8
FromCardCo	BP Code From	nVarChar		15
ToCardCo	BP Code To	nVarChar		15
SizeOfStru	Size of Structure	Int		11
PostFrDate	Posting Date From	Date		8
PostToDate	Posting Date To	Date		8
DocFrDate	Document Date From	Date		8
DocToDate	Document Date To	Date		8
FromDoc1Nu	Document 1 - From	nVarChar		11
ToDoc1Nu	Document 1 - To	nVarChar		11
Serie1	Invoice Numbering Series	nVarChar	Y) Yes N) No	6	Y
Serie1CB	Inv. Numbering Series Filter	VarChar	Y) Yes N) No	1	N
Doc1Type	Type of Document 1	Int		11
FromDoc2Nu	Document 2 - From	nVarChar		11
ToDoc2Nu	Document 2 - To	nVarChar		11
Serie2	Credit Memo Numbering Series	nVarChar	Y) Yes N) No	6	Y
Serie2CB	Corr. Inv. Rev. No. Series	VarChar	Y) Yes N) No	1	N
Doc2Type	Type of Document 2	Int		11
FromDoc3Nu	Document 3 - From	nVarChar		11
ToDoc3Nu	Document 3 - To	nVarChar		11
Serie3	Corr. Inv. Numbering Series	nVarChar	Y) Yes N) No	6	Y
Serie3CB	Corr. Inv. Num. Series Filter	VarChar	Y) Yes N) No	1	N
Doc3Type	Type of Document 3	Int		11
FromDoc4Nu	Document 4 - From	nVarChar		11
ToDoc4Nu	Document 4 - To	nVarChar		11
Serie4	Corr. Inv. Rev. No. Series	nVarChar	Y) Yes N) No	6	Y
Serie4CB	Corr. Inv. Reversal No. Series	VarChar	Y) Yes N) No	1	N
Doc4Type	Type of Document 4	Int		11
FromDoc5Nu	Document 5 - From	nVarChar		11
ToDoc5Nu	Document 5 - To	nVarChar		11
Serie5	Down Payment Numbering Series	nVarChar	Y) Yes N) No	6	Y
Serie5CB	Down Payment Numbering Series	VarChar	Y) Yes N) No	1	N
Doc5Type	Type of Document 5	Int		11
DateRBtn	Report Period	VarChar	I) Interval D) Date	1	I
MarkDocsIn	Include Marketing Documents	VarChar	N) No Y) Yes	1	Y
ExRate	Exchange Rate	VarChar	P) Posting R) For Reports	1	P
ExRateDate	Exchange Rate Date	VarChar	P) Posting Date D) Document Date V) VAT Date	1	P
TrsPerioTp	Report Period Type	VarChar	Y) Year Q) Quarter M) Month P) Period	1
TrsPerioNu	Report Period Number	Int		11
TrsYear	Report Year	Int		6
TrsAdjtNum	Report Adjustment Number	Int		6
DateType	Date Type	VarChar	P) Posting Date D) Document Date V) VAT Date	1	P
IncServDoc	Include Service Documents	VarChar	Y) Yes N) No	1	Y
GrpBySCode	Group by Sales Code	VarChar	Y) Yes N) No	1	Y
IncUnReDoc	Include Unreconciled Documents	VarChar	Y) Yes N) No	1	Y
DoYearSum	Year Summary	VarChar	Y) Yes N) No	1
DefTaxOnly	Only Include Deferred Tax Docs	VarChar	Y) Yes N) No	1	N

SELECT statement

SELECT
   OVTR.AbsEntry AS 'Abs Entry (Numerator)', 
   OVTR.ReportName AS 'Report Name', 
   OVTR.RptLayout AS 'Report Layout', 
   OVTR.FirstPrint AS 'First Printed No.', 
   OVTR.FromDate AS 'Date From', 
   OVTR.ToDate AS 'Date To', 
   OVTR.TaxDate AS 'Document Date', 
   OVTR.RoundSum AS 'Round Amounts', 
   OVTR.Declration AS 'Declaration Type', 
   OVTR.FilterType AS 'Selection Criteria Type', 
   OVTR.ExcludeWT AS 'Exclude Withholding Tax', 
   OVTR.CustomerIn AS 'Include Customers', 
   OVTR.VendorIn AS 'Include Vendors', 
   OVTR.Period AS 'Quarter, Year or Month', 
   OVTR.Quarter AS 'Quarter', 
   OVTR.Year AS 'Year', 
   OVTR.DocType AS 'A/P or A/R', 
   OVTR.CreditMemo AS 'Credit Memos', 
   OVTR.DocTypeIn AS 'Include Document Type', 
   OVTR.FirstReg AS 'First Register Number', 
   OVTR.AccountIn AS 'Include G/L Accounts', 
   OVTR.DeferTaxIn AS 'Show Pmts with Deferred Tax', 
   OVTR.ApndxOOrP AS 'Appendix O or P Selection', 
   OVTR.DispOBCB AS 'Opening & Closing Balance', 
   OVTR.FromSeries AS 'From Tax Series Group', 
   OVTR.ToSeries AS 'To Tax Series Group', 
   OVTR.canceltn AS 'For EU Sales Report', 
   OVTR.HideNTrans AS 'Hide Tax Codes with no Trans.', 
   OVTR.SeriesIn AS 'Include Series Filter', 
   OVTR.UserCode AS 'User Code', 
   OVTR.FromCardCo AS 'BP Code From', 
   OVTR.ToCardCo AS 'BP Code To', 
   OVTR.SizeOfStru AS 'Size of Structure', 
   OVTR.PostFrDate AS 'Posting Date From', 
   OVTR.PostToDate AS 'Posting Date To', 
   OVTR.DocFrDate AS 'Document Date From', 
   OVTR.DocToDate AS 'Document Date To', 
   OVTR.FromDoc1Nu AS 'Document 1 - From', 
   OVTR.ToDoc1Nu AS 'Document 1 - To', 
   OVTR.Serie1 AS 'Invoice Numbering Series', 
   OVTR.Serie1CB AS 'Inv. Numbering Series Filter', 
   OVTR.Doc1Type AS 'Type of Document 1', 
   OVTR.FromDoc2Nu AS 'Document 2 - From', 
   OVTR.ToDoc2Nu AS 'Document 2 - To', 
   OVTR.Serie2 AS 'Credit Memo Numbering Series', 
   OVTR.Serie2CB AS 'Corr. Inv. Rev. No. Series', 
   OVTR.Doc2Type AS 'Type of Document 2', 
   OVTR.FromDoc3Nu AS 'Document 3 - From', 
   OVTR.ToDoc3Nu AS 'Document 3 - To', 
   OVTR.Serie3 AS 'Corr. Inv. Numbering Series', 
   OVTR.Serie3CB AS 'Corr. Inv. Num. Series Filter', 
   OVTR.Doc3Type AS 'Type of Document 3', 
   OVTR.FromDoc4Nu AS 'Document 4 - From', 
   OVTR.ToDoc4Nu AS 'Document 4 - To', 
   OVTR.Serie4 AS 'Corr. Inv. Rev. No. Series', 
   OVTR.Serie4CB AS 'Corr. Inv. Reversal No. Series', 
   OVTR.Doc4Type AS 'Type of Document 4', 
   OVTR.FromDoc5Nu AS 'Document 5 - From', 
   OVTR.ToDoc5Nu AS 'Document 5 - To', 
   OVTR.Serie5 AS 'Down Payment Numbering Series', 
   OVTR.Serie5CB AS 'Down Payment Numbering Series', 
   OVTR.Doc5Type AS 'Type of Document 5', 
   OVTR.DateRBtn AS 'Report Period', 
   OVTR.MarkDocsIn AS 'Include Marketing Documents', 
   OVTR.ExRate AS 'Exchange Rate', 
   OVTR.ExRateDate AS 'Exchange Rate Date', 
   OVTR.TrsPerioTp AS 'Report Period Type', 
   OVTR.TrsPerioNu AS 'Report Period Number', 
   OVTR.TrsYear AS 'Report Year', 
   OVTR.TrsAdjtNum AS 'Report Adjustment Number', 
   OVTR.DateType AS 'Date Type', 
   OVTR.IncServDoc AS 'Include Service Documents', 
   OVTR.GrpBySCode AS 'Group by Sales Code', 
   OVTR.IncUnReDoc AS 'Include Unreconciled Documents', 
   OVTR.DoYearSum AS 'Year Summary', 
   OVTR.DefTaxOnly AS 'Only Include Deferred Tax Docs'
FROM OVTR AS OVTR

Related information

TaxReportFilter Object· Table: OVTR

TaxReportFilter is a data structure related to the TaxReportsService. Source table: OVTR.

Parent: Report Filter Service ReportFilterService Service· Table: OVTR

TaxReportFilterParams Object· Table: OVTR

The TaxReportFilterParams specifies the identification key combination(Code, Filter-Type and Name) for which the TaxReportsService is related. Source table: OVTR.

Parent: Report Filter Service ReportFilterService Service· Table: OVTR

TaxReportFiltersParams Collection· Table: OVTR

TaxReportFiltersParams is a Data Collection of TaxReportFilterParams Identification key combination. Source table: OVTR.

Parent: Report Filter Service ReportFilterService Service· Table: OVTR

ReportFilterService Service· Table: OVTR

The Report Filter Service is a business object that manages the information displaied by tax report. This object enables user to: Add new Tax report filter to the service. Delete a Tax report filter from the service. Get a list of all...

biuan SAP® BUSINESS ONE

Service
ReportFilterService

Object
TaxReportFilter

Collection

TaxReportAccounts VTR5

TaxReportBusinessPartners VTR4

TaxReportDocuments VTR2

TaxReportGroups VTR1

TaxReportSeriesCollection VTR3

Enumeration

TaxReportFilterApArDocumentType

TaxReportFilterDeclarationType

TaxReportFilterPeriod

TaxReportFilterQuarterOrDates

TaxReportFilterReportLayoutType

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

AppendixOorPSelection

Cancellation

Code

DeclarationType

DiplayCreditMemosInSeparateColumn

HideTaxWithoutTransaction

Name

OpeningAndClosingBalance

Period

Quarter

QuarterOrDates

ReportLayout

RoundAmount

ShowPaymentsWithDeferredTax

TaxDate

TaxReportAccounts

TaxReportBusinessPartners

TaxReportDocuments

TaxReportGroups

TaxReportSeriesCollection

ToDate

ToSeries

Year

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