biuan SAP® BUSINESS ONE SDK
API OVRW
OVRW - VAT Reposting Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
RunNameWizard Run NamenVarChar
100
RunDateWizard Run DateDate
8
StatusStatusVarChar
E) Executed
S) Saved
D) Draft
C) Canceled
1
E
UserSignUser SignatureInt
11OUSR
Users
LedgerTypeLedger TypeVarChar
S) Sales
P) Purchase
1
S
DebitAccDebit AccountnVarChar
15OACT
G/L Accounts
PostDatePosting DateDate
8
JESeriesJournal Entry SeriesnVarChar
6
0
APTISeriesA/P Tax Invoice SeriesnVarChar
6
0
DateTypeDate TypeVarChar
R) Posting Date
D) Due Date
T) Document Date
1
R
DateFromDate FromDate
8
DateToDate ToDate
8
IncCorAltInclude Corr. and Alter.VarChar
Y) Yes
N) No
1
N
BPLIdActive BranchInt
11OBPL
Business Place

Table relationship map

SELECT statement

SELECT OVRW.AbsEntry AS 'Internal Number', OVRW.RunName AS 'Wizard Run Name', OVRW.RunDate AS 'Wizard Run Date', OVRW.Status AS 'Status', OVRW.UserSign AS 'User Signature', OVRW.LedgerType AS 'Ledger Type', OVRW.DebitAcc AS 'Debit Account', OVRW.PostDate AS 'Posting Date', OVRW.JESeries AS 'Journal Entry Series', OVRW.APTISeries AS 'A/P Tax Invoice Series', OVRW.DateType AS 'Date Type', OVRW.DateFrom AS 'Date From', OVRW.DateTo AS 'Date To', OVRW.IncCorAlt AS 'Include Corr. and Alter.', OVRW.BPLId AS 'Active Branch' FROM OVRW AS OVRW

Related information


Business Place OBPL SQL Table

G/L Accounts OACT SQL Table

Users OUSR 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