biuan SAP® BUSINESS ONE SDK
API VRW2
VRW2 - VAT Reposting Wizard - Rows 2 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TaxInvIDTax Invoice IDInt
11OTPI
Purchase Tax Invoice
VatGroupVAT Group CodenVarChar
8OVTG
Tax Definition
SelectedSelected LineVarChar
Y) Yes
N) No
1
N
LineStatusLine StatusVarChar
C) Canceled
R) Regular
1
R
DebitAccDebit AccountnVarChar
15OACT
G/L Accounts
DocDateDocument DateDate
8
VatAmountVAT AmountNum
20
NetAmountNet AmountNum
20
JETransIDJournal Entry NumberInt
11OJDT
Journal Entry
Ref1Reference 1nVarChar
100
Ref2Reference 2nVarChar
100
Ref3Reference 3nVarChar
27
RemarksRemarksnVarChar
50
TrnsCodeCodenVarChar
4
BPLIdBranchInt
11OBPL
Business Place

Table relationship map

SELECT statement

SELECT VRW2.AbsEntry AS 'Internal Number', VRW2.TaxInvID AS 'Tax Invoice ID', VRW2.VatGroup AS 'VAT Group Code', VRW2.Selected AS 'Selected Line', VRW2.LineStatus AS 'Line Status', VRW2.DebitAcc AS 'Debit Account', VRW2.DocDate AS 'Document Date', VRW2.VatAmount AS 'VAT Amount', VRW2.NetAmount AS 'Net Amount', VRW2.JETransID AS 'Journal Entry Number', VRW2.Ref1 AS 'Reference 1', VRW2.Ref2 AS 'Reference 2', VRW2.Ref3 AS 'Reference 3', VRW2.Remarks AS 'Remarks', VRW2.TrnsCode AS 'Code', VRW2.BPLId AS 'Branch' FROM VRW2 AS VRW2

Related information


Business Place OBPL SQL Table

G/L Accounts OACT SQL Table

Journal Entry OJDT SQL Table

Purchase Tax Invoice OTPI SQL Table

Tax Definition OVTG 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