biuan SAP® BUSINESS ONE SDK
DTW Tax Report
API Report Filter Service / Tax Report Filter
OVTR - Tax Report Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEAbs Entry (Numerator)Int
11
PRIMARYYes
ReportName KEY UNIQUEReport NamenVarChar
50
NAMEYes
RptLayoutReport LayoutVarChar
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
FirstPrintFirst Printed No.Int
11
FromDateDate FromDate
8
ToDateDate ToDate
8
TaxDateDocument DateVarChar
N) No
Y) Yes
1
N
RoundSumRound AmountsVarChar
N) No
Y) Yes
1
N
DeclrationDeclaration TypeVarChar
O) Original
S) Substitute
C) Complementary
1
O
FilterTypeSelection Criteria TypeVarChar
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
ExcludeWTExclude Withholding TaxVarChar
N) No
Y) Yes
1
N
CustomerInInclude CustomersVarChar
Y) Yes
N) No
1
Y
VendorInInclude VendorsVarChar
N) No
Y) Yes
1
Y
PeriodQuarter, Year or MonthVarChar
Q) Quarter
Y) Year
M) Month
S) .
1
Q
QuarterQuarterInt
11
YearYearInt
11
DocTypeA/P or A/RVarChar
P) Purchasing Documents
R) Sales Documents
1
P
CreditMemoCredit MemosVarChar
N) No
Y) Yes
1
N
DocTypeInInclude Document TypeVarChar
N) No
Y) Yes
1
N
FirstRegFirst Register NumberInt
11
AccountInInclude G/L AccountsVarChar
N) No
Y) Yes
1
N
DeferTaxInShow Pmts with Deferred TaxVarChar
Y) Yes
N) No
1
Y
ApndxOOrPAppendix O or P SelectionVarChar
Y) Yes
N) No
1
Y
DispOBCBOpening & Closing BalanceVarChar
N) No
Y) Yes
1
Y
FromSeriesFrom Tax Series GroupInt
11
ToSeriesTo Tax Series GroupInt
11
canceltnFor EU Sales ReportVarChar
1
N
HideNTransHide Tax Codes with no Trans.VarChar
N) No
Y) Yes
1
N
SeriesInInclude Series FilterVarChar
N) No
Y) Yes
1
N
UserCodeUser CodenVarChar
8
FromCardCoBP Code FromnVarChar
15
ToCardCoBP Code TonVarChar
15
SizeOfStruSize of StructureInt
11
PostFrDatePosting Date FromDate
8
PostToDatePosting Date ToDate
8
DocFrDateDocument Date FromDate
8
DocToDateDocument Date ToDate
8
FromDoc1NuDocument 1 - FromnVarChar
11
ToDoc1NuDocument 1 - TonVarChar
11
Serie1Invoice Numbering SeriesnVarChar
Y) Yes
N) No
6
Y
Serie1CBInv. Numbering Series FilterVarChar
Y) Yes
N) No
1
N
Doc1TypeType of Document 1Int
11
FromDoc2NuDocument 2 - FromnVarChar
11
ToDoc2NuDocument 2 - TonVarChar
11
Serie2Credit Memo Numbering SeriesnVarChar
Y) Yes
N) No
6
Y
Serie2CBCorr. Inv. Rev. No. SeriesVarChar
Y) Yes
N) No
1
N
Doc2TypeType of Document 2Int
11
FromDoc3NuDocument 3 - FromnVarChar
11
ToDoc3NuDocument 3 - TonVarChar
11
Serie3Corr. Inv. Numbering SeriesnVarChar
Y) Yes
N) No
6
Y
Serie3CBCorr. Inv. Num. Series FilterVarChar
Y) Yes
N) No
1
N
Doc3TypeType of Document 3Int
11
FromDoc4NuDocument 4 - FromnVarChar
11
ToDoc4NuDocument 4 - TonVarChar
11
Serie4Corr. Inv. Rev. No. SeriesnVarChar
Y) Yes
N) No
6
Y
Serie4CBCorr. Inv. Reversal No. SeriesVarChar
Y) Yes
N) No
1
N
Doc4TypeType of Document 4Int
11
FromDoc5NuDocument 5 - FromnVarChar
11
ToDoc5NuDocument 5 - TonVarChar
11
Serie5Down Payment Numbering SeriesnVarChar
Y) Yes
N) No
6
Y
Serie5CBDown Payment Numbering SeriesVarChar
Y) Yes
N) No
1
N
Doc5TypeType of Document 5Int
11
DateRBtnReport PeriodVarChar
I) Interval
D) Date
1
I
MarkDocsInInclude Marketing DocumentsVarChar
N) No
Y) Yes
1
Y
ExRateExchange RateVarChar
P) Posting
R) For Reports
1
P
ExRateDateExchange Rate DateVarChar
P) Posting Date
D) Document Date
V) VAT Date
1
P
TrsPerioTpReport Period TypeVarChar
Y) Year
Q) Quarter
M) Month
P) Period
1
TrsPerioNuReport Period NumberInt
11
TrsYearReport YearInt
6
TrsAdjtNumReport Adjustment NumberInt
6
DateTypeDate TypeVarChar
P) Posting Date
D) Document Date
V) VAT Date
1
P
IncServDocInclude Service DocumentsVarChar
Y) Yes
N) No
1
Y
GrpBySCodeGroup by Sales CodeVarChar
Y) Yes
N) No
1
Y
IncUnReDocInclude Unreconciled DocumentsVarChar
Y) Yes
N) No
1
Y
DoYearSumYear SummaryVarChar
Y) Yes
N) No
1
DefTaxOnlyOnly Include Deferred Tax DocsVarChar
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


Tax Report Filter TaxReportFilter Object· Table: OVTR
TaxReportFilter is a data structure related to the TaxReportsService. Source table: OVTR.
   Parent: Report Filter Service ReportFilterService Service· Table: OVTR

Tax Report Filter Params 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

Tax Report Filters Params 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

Report Filter Service 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 Tax...



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