📚 SAP Business One SDK Help

Table Name: OVTR

Table Description: Tax Report

Field Description Type Size Related Default Value Constraints
AbsEntry Abs Entry (Numerator) Int 11 -      
ReportName Report Name nVarChar 50 -      
RptLayout Report Layout VarChar 1 - R 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
            F Electronic Tax Declaration 2018
            M VAT Invoice Declaration 2017
            G Electronic Tax Declaration 2019
            T One-Stop Shop Declaration
FirstPrint First Printed No. Int 11 -      
FromDate Date From Date 8 -      
ToDate Date To Date 8 -      
TaxDate Document Date VarChar 1 - N N No
            Y Yes
RoundSum Round Amounts VarChar 1 - N N No
            Y Yes
              .
Declration Declaration Type VarChar 1 - O O Original
            S Substitute
            C Complementary
FilterType Selection Criteria Type VarChar 1 - N 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
ExcludeWT Exclude Withholding Tax VarChar 1 - N N No
            Y Yes
CustomerIn Include Customers VarChar 1 - Y Y Yes
            N No
VendorIn Include Vendors VarChar 1 - Y N No
            Y Yes
Period Quarter, Year or Month VarChar 1 - Q Q Quarter
            Y Year
            M Month
            S .
Quarter Quarter Int 11 -      
Year Year Int 11 -      
DocType A/P or A/R VarChar 1 - P P Purchasing Documents
            R Sales Documents
CreditMemo Credit Memos VarChar 1 - N N No
            Y Yes
DocTypeIn Include Document Type VarChar 1 - N N No
            Y Yes
FirstReg First Register Number Int 11 -      
AccountIn Include G/L Accounts VarChar 1 - N N No
            Y Yes
DeferTaxIn Show Pmts with Deferred Tax VarChar 1 - Y Y Yes
            N No
ApndxOOrP Appendix O or P Selection VarChar 1 - Y Y Yes
            N No
DispOBCB Opening & Closing Balance VarChar 1 - Y N No
            Y Yes
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 1 - N N No
            Y Yes
SeriesIn Include Series Filter VarChar 1 - N N No
            Y Yes
UserCode User Code nVarChar 25 -      
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 11 - Y Y Yes
            N No
Serie1CB Inv. Numbering Series Filter VarChar 1 - N Y Yes
            N No
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 11 - Y Y Yes
            N No
Serie2CB Corr. Inv. Rev. No. Series VarChar 1 - N Y Yes
            N No
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 11 - Y Y Yes
            N No
Serie3CB Corr. Inv. Num. Series Filter VarChar 1 - N Y Yes
            N No
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 11 - Y Y Yes
            N No
Serie4CB Corr. Inv. Reversal No. Series VarChar 1 - N Y Yes
            N No
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 11 - Y Y Yes
            N No
Serie5CB Down Payment Numbering Series VarChar 1 - N Y Yes
            N No
Doc5Type Type of Document 5 Int 11 -      
DateRBtn Report Period VarChar 1 - I I Interval
            D Date
MarkDocsIn Include Marketing Documents VarChar 1 - Y N No
            Y Yes
ExRate Exchange Rate VarChar 1 - P P Posting
            R For Reports
ExRateDate Exchange Rate Date VarChar 1 - P P Posting Date
            D Document Date
            V VAT Date
TrsPerioTp Report Period Type VarChar 1 -   Y Year
            Q Quarter
            B Bi-Monthly
            M Month
            P Period
            F Fiscal Year
            G Fiscal Quarter
TrsPerioNu Report Period Number Int 11 -      
TrsYear Report Year Int 6 -      
TrsAdjtNum Report Adjustment Number Int 6 -      
DateType Date Type VarChar 1 - P P Posting Date
            D Document Date
            V VAT Date
            C System Date
IncServDoc Include Service Documents VarChar 1 - Y Y Yes
            N No
GrpBySCode Group by Sales Code VarChar 1 - Y Y Yes
            N No
IncUnReDoc Include Unreconciled Documents VarChar 1 - Y Y Yes
            N No
DoYearSum Year Summary VarChar 1 -   Y Yes
            N No
DefTaxOnly Only Include Deferred Tax Docs VarChar 1 - N Y Yes
            N No
ExcElDoc Exclude Electronic Documents VarChar 1 - N Y Yes
            N No
QtrByMnt Quarter by Months VarChar 1 - N Y Yes
            N No
OnlyExtnTx Only External Tax VarChar 1 - N Y Yes
            N No
IncludeWTR Include Inventory Transfers VarChar 1 - Y Y Yes
            N No
FromMark MARK From nVarChar 40 -      
ToMark MARK To nVarChar 40 -      
IsueFrDate Issue Date From Date 8 -      
IsueToDate Issue Date To Date 8 -      
FromVatNo Issuer VAT No. From nVarChar 64 -      
ToVatNo Issuer VAT No. To nVarChar 64 -      
FrInvType Invoice Type From nVarChar 50 -      
ToInvType Invoice Type To nVarChar 50 -      
IncludeDpm Include Down Payment VarChar 1 -   Y Yes
            N No
Key Unique Field
PRIMARY Yes AbsEntry
NAME Yes ReportName
    FilterType