biuan SAP® BUSINESS ONE SDK
API OVRT
OVRT - Tax Invoice Report Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TxInvRptNo KEY UNIQUETax Invoice Rpt NumbernVarChar
10
PRIMARYYes
TxInvRptDtTax Invoice Rpt Create DateDate
8
SupBPLIdSupplier BPL IDInt
11
CardCodeReceipt BP CodenVarChar
15
BaseAmtTotal Base Amount(LC)Num
20
BlankNoBlank Before Total Base AmountInt
11
TaxAmtTotal Tax Amount(LC)Num
20
TotalTotal Base + Total TaxNum
20
BPAddressCustomer Pay to AddressnVarChar
127
versionReport Generation VersionnVarChar
50
ReportTypeVAT: Tax Report Type IDInt
11OKRT
Tax Report Type
NTSApprovNTS ApprovedVarChar
N) No
Y) Yes
1
N
NTSWebSiteE-Tax Web SiteInt
6OTWS
E-Tax Web Site
-1
NTSeTaxNoE-Tax NumbernVarChar
50
NTSApprNoNTS Approval NumbernVarChar
50
RemarksRemarksnVarChar
127
OriNTSApprOriginal NTS Approval NumbernVarChar
50
CardNameReceipt BP CodenVarChar
100
RptStatusTax Invoice Report StatusVarChar
S) Saved
C) Canceled
R) Reversed
1
S
OriTaxInvNOriginal Tax Invoice NumbernVarChar
10
TxInvPrintTax Invoice Report Print TypeVarChar
A) Aggregated
I) Individual
1
I
CanceledTax Invoice Report is Canceled or NotVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OVRT.TxInvRptNo AS 'Tax Invoice Rpt Number', OVRT.TxInvRptDt AS 'Tax Invoice Rpt Create Date', OVRT.SupBPLId AS 'Supplier BPL ID', OVRT.CardCode AS 'Receipt BP Code', OVRT.BaseAmt AS 'Total Base Amount(LC)', OVRT.BlankNo AS 'Blank Before Total Base Amount', OVRT.TaxAmt AS 'Total Tax Amount(LC)', OVRT.Total AS 'Total Base + Total Tax', OVRT.BPAddress AS 'Customer Pay to Address', OVRT.version AS 'Report Generation Version', OVRT.ReportType AS 'VAT: Tax Report Type ID', OVRT.NTSApprov AS 'NTS Approved', OVRT.NTSWebSite AS 'E-Tax Web Site', OVRT.NTSeTaxNo AS 'E-Tax Number', OVRT.NTSApprNo AS 'NTS Approval Number', OVRT.Remarks AS 'Remarks', OVRT.OriNTSAppr AS 'Original NTS Approval Number', OVRT.CardName AS 'Receipt BP Code', OVRT.RptStatus AS 'Tax Invoice Report Status', OVRT.OriTaxInvN AS 'Original Tax Invoice Number', OVRT.TxInvPrint AS 'Tax Invoice Report Print Type', OVRT.Canceled AS 'Tax Invoice Report is Canceled or Not' FROM OVRT AS OVRT

Related information


OVRT SQL Table

E-Tax Web Site OTWS SQL Table

Tax Report Type OKRT SQL Table



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