VRW2 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Finance / VAT Reposting Wizard - Rows 2

API VRW2

VRW2 - VAT Reposting Wizard - Rows 2 Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
TaxInvID	Tax Invoice ID	Int		11	OTPI Purchase Tax Invoice
VatGroup	VAT Group Code	nVarChar		8	OVTG Tax Definition
Selected	Selected Line	VarChar	Y) Yes N) No	1		N
LineStatus	Line Status	VarChar	C) Canceled R) Regular	1		R
DebitAcc	Debit Account	nVarChar		15	OACT G/L Accounts
DocDate	Document Date	Date		8
VatAmount	VAT Amount	Num		20
NetAmount	Net Amount	Num		20
JETransID	Journal Entry Number	Int		11	OJDT Journal Entry
Ref1	Reference 1	nVarChar		100
Ref2	Reference 2	nVarChar		100
Ref3	Reference 3	nVarChar		27
Remarks	Remarks	nVarChar		50
TrnsCode	Code	nVarChar		4
BPLId	Branch	Int		11	OBPL 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

OBPL SQL Table

OACT SQL Table

OJDT SQL Table

OTPI SQL Table

OVTG SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates