biuan SAP® BUSINESS ONE SDK
API OTPW
OTPW - Tax Payment Wizard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
WizNumberWizard NumberInt
11
WizName KEY UNIQUEWizard NamenVarChar
50
NAMEYes
WizStatusWizard StatusVarChar
S) Saved
E) Executed
1
S
CreateDateWizard Creation DateDate
8
SaveDateWizard Save DateDate
8
ExecDateWizard Execution DateDate
8
UserSignUser SignatureInt
6
SeriesWizard SeriesInt
6
JETransIdJournal Entry NumberInt
11OJDT
Journal Entry
WizDateWizard DateDate
8
RG23APart2RG23A Part 2Int
11
RG23CPart2RG23C Part 2Int
11
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3

Table relationship map

SELECT statement

SELECT OTPW.AbsEntry AS 'Internal Key', OTPW.WizNumber AS 'Wizard Number', OTPW.WizName AS 'Wizard Name', OTPW.WizStatus AS 'Wizard Status', OTPW.CreateDate AS 'Wizard Creation Date', OTPW.SaveDate AS 'Wizard Save Date', OTPW.ExecDate AS 'Wizard Execution Date', OTPW.UserSign AS 'User Signature', OTPW.Series AS 'Wizard Series', OTPW.JETransId AS 'Journal Entry Number', OTPW.WizDate AS 'Wizard Date', OTPW.RG23APart2 AS 'RG23A Part 2', OTPW.RG23CPart2 AS 'RG23C Part 2', OTPW.SeqCode AS 'Sequence Code', OTPW.Serial AS 'Serial Number', OTPW.SeriesStr AS 'Series String', OTPW.SubStr AS 'Subseries String' FROM OTPW AS OTPW

Related information


OTPW SQL Table

Journal Entry OJDT 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