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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TxInvRptNo KEY UNIQUETax Invoice Report No.nVarChar
10OVRT
Tax Invoice Report
PRIMARYYes
SeqNoSequence No.Int
11
MDOriginal Date of Line ItemDate
8
ItemDescDescription of Line ItemnVarChar
100
UnitUnit of Line ItemnVarChar
100
QuantityQuantityNum
20
UnitPriceUnit PriceNum
20
BaseAmtBase AmountNum
20
TaxAmtTax AmountNum
20
RemarkRemarksnVarChar
100

SELECT statement

SELECT VRT1.TxInvRptNo AS 'Tax Invoice Report No.', VRT1.SeqNo AS 'Sequence No.', VRT1.MD AS 'Original Date of Line Item', VRT1.ItemDesc AS 'Description of Line Item', VRT1.Unit AS 'Unit of Line Item', VRT1.Quantity AS 'Quantity', VRT1.UnitPrice AS 'Unit Price', VRT1.BaseAmt AS 'Base Amount', VRT1.TaxAmt AS 'Tax Amount', VRT1.Remark AS 'Remarks' FROM VRT1 AS VRT1

Related information


Tax Invoice Report OVRT 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