biuan SAP® BUSINESS ONE SDK
API PWZ6
PWZ6 - Payment Wizard Rows - 6 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IdEntry KEY UNIQUEID NumberInt
11OPWZ
Payment Wizard
PRIMARYYes
CondNumCondition NumberInt
11
SelFldIDSelection Field IDnVarChar
100
FromStringFrom String ValuenVarChar
127
FromNumberFrom Number ValueInt
11
FromMoneyFrom Amount ValueNum
20
FromDateFrom Date ValueDate
8
FromMemoFrom Memo ValueText
16
ToStringTo String ValuenVarChar
127
ToNumberTo Number ValueInt
11
ToMoneyTo Amount ValueNum
20
ToDateTo Date ValueDate
8
ToMemoTo Memo ValueText
16

SELECT statement

SELECT PWZ6.IdEntry AS 'ID Number', PWZ6.CondNum AS 'Condition Number', PWZ6.SelFldID AS 'Selection Field ID', PWZ6.FromString AS 'From String Value', PWZ6.FromNumber AS 'From Number Value', PWZ6.FromMoney AS 'From Amount Value', PWZ6.FromDate AS 'From Date Value', PWZ6.FromMemo AS 'From Memo Value', PWZ6.ToString AS 'To String Value', PWZ6.ToNumber AS 'To Number Value', PWZ6.ToMoney AS 'To Amount Value', PWZ6.ToDate AS 'To Date Value', PWZ6.ToMemo AS 'To Memo Value' FROM PWZ6 AS PWZ6

Related information


Payment Wizard OPWZ 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