📚 SAP Business One SDK Help

Table Name: OVRT

Table Description: Tax Invoice Report

Field Description Type Size Related Default Value Constraints
TxInvRptNo Tax Invoice Rpt Number nVarChar 10 -      
TxInvRptDt Tax Invoice Rpt Create Date Date 8 -      
SupBPLId Supplier BPL ID Int 11 -      
CardCode Receipt BP Code nVarChar 15 -      
BaseAmt Total Base Amount(LC) Num 19.6 -      
BlankNo Blank Before Total Base Amount Int 11 -      
TaxAmt Total Tax Amount(LC) Num 19.6 -      
Total Total Base + Total Tax Num 19.6 -      
BPAddress Customer Pay to Address nVarChar 254 -      
version Report Generation Version nVarChar 50 -      
ReportType VAT: Tax Report Type ID Int 11 OKRT      
NTSApprov NTS Approved VarChar 1 - N N No
            Y Yes
NTSWebSite E-Tax Web Site Int 6 OTWS -1    
NTSeTaxNo E-Tax Number nVarChar 50 -      
NTSApprNo NTS Approval Number nVarChar 50 -      
Remarks Remarks nVarChar 254 -      
OriNTSAppr Original NTS Approval Number nVarChar 50 -      
CardName Receipt BP Code nVarChar 200 -      
RptStatus Tax Invoice Report Status VarChar 1 - S S Saved
            C Canceled
            R Reversed
OriTaxInvN Original Tax Invoice Number nVarChar 10 -      
TxInvPrint Tax Invoice Report Print Type VarChar 1 - I A Aggregated
            I Individual
Canceled Tax Invoice Report is Canceled or Not VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes TxInvRptNo