biuan SAP® BUSINESS ONE SDK
API VRT2
VRT2 - Tax Invoice Report Grid Info Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TxInvRptNo KEY UNIQUETax Invoice Report No.nVarChar
10OVRT
Tax Invoice Report
PRIMARYYes
GridRowGrid Row NumberInt
11
BPLIdBusiness Place IDInt
11
BPCodeBP CodenVarChar
15
BPNameBP NamenVarChar
100
DocDateDoc. DateDate
8
ItemNoItem NumbernVarChar
20
ItemDesItem DescriptionnVarChar
100
TaxCodeTax CodenVarChar
8
ItemQtyItem QuantityNum
20
ItemPriceItem PriceNum
20
BaseAmtBase AmountNum
20
TaxAmtTax AmountNum
20
LineTypeRow TypeInt
11
DocEntryUnique Document IDInt
11
DocTypeDocument TypeInt
0
13) A/R Invoice
14) A/R Credit Memo
203) A/R Down Payment
11
LineNumItem Row NumberInt
11
CurrencyCurrencynVarChar
3
RemarkRemarksnVarChar
100
LegacyDataLegacy DataVarChar
Y) Yes
N) No
1
N
QuantityQuantityNum
20

SELECT statement

SELECT VRT2.TxInvRptNo AS 'Tax Invoice Report No.', VRT2.GridRow AS 'Grid Row Number', VRT2.BPLId AS 'Business Place ID', VRT2.BPCode AS 'BP Code', VRT2.BPName AS 'BP Name', VRT2.DocDate AS 'Doc. Date', VRT2.ItemNo AS 'Item Number', VRT2.ItemDes AS 'Item Description', VRT2.TaxCode AS 'Tax Code', VRT2.ItemQty AS 'Item Quantity', VRT2.ItemPrice AS 'Item Price', VRT2.BaseAmt AS 'Base Amount', VRT2.TaxAmt AS 'Tax Amount', VRT2.LineType AS 'Row Type', VRT2.DocEntry AS 'Unique Document ID', VRT2.DocType AS 'Document Type', VRT2.LineNum AS 'Item Row Number', VRT2.Currency AS 'Currency', VRT2.Remark AS 'Remarks', VRT2.LegacyData AS 'Legacy Data', VRT2.Quantity AS 'Quantity' FROM VRT2 AS VRT2

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