|
|
API PWZ2
PWZ2 - Payment Wizard - Rows 2 Table
G/L Accounts OACT SQL Table
Payment Wizard OPWZ SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | IdEntry KEY UNIQUE | ID Entry | Int | 11 | OPWZ Payment Wizard | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PymCode | Payment Method Code | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| BnkAccount | Bank Account | nVarChar | 15 | OACT G/L Accounts | ||||
| MaxIncom | Max. Incoming Amount | Num | 20 | |||||
| MaxOutgo | Max. Outgoing Amount | Num | 20 | |||||
| Balance | G/L Balance | Num | 20 | |||||
| ExpectBal | Expected G/L Balance | Num | 20 | |||||
| Checked | Checked | VarChar | 1 | |||||
| PymDisc | Payment discription | nVarChar | 100 | |||||
| PymType | Payment Type | VarChar | 1 | |||||
| IntBalance | G/L Interim Balance | Num | 20 | |||||
| ExpIntBal | Expected G/L Interim Balance | Num | 20 | |||||
| InterimAct | Interim Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BnkCountry | Bank Country | nVarChar | 3 | |||||
| BnkCode | Bank Code | nVarChar | 30 | |||||
| BnkAccNo | Bank Account Number | nVarChar | 50 | |||||
| FatherLn | Parent Line | VarChar | Y) Yes N) No | 1 | N | |||
| NegativPym | Negative Payment Method Code | nVarChar | 15 | |||||
| NegPymBnk | Negative Payment Bank Code | nVarChar | 30 | |||||
| NegCountry | Negative Payment Bank Country | nVarChar | 3 | |||||
| NegPymAcct | Negative Payment Bank Account | nVarChar | 50 | |||||
| PaymenMean | Payment Means | VarChar | 1 | |||||
| IBAN | IBAN | nVarChar | 50 | |||||
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 |
Table relationship map
SELECT statement
SELECT
PWZ2.IdEntry AS 'ID Entry',
PWZ2.PymCode AS 'Payment Method Code',
PWZ2.BnkAccount AS 'Bank Account',
PWZ2.MaxIncom AS 'Max. Incoming Amount',
PWZ2.MaxOutgo AS 'Max. Outgoing Amount',
PWZ2.Balance AS 'G/L Balance',
PWZ2.ExpectBal AS 'Expected G/L Balance',
PWZ2.Checked AS 'Checked',
PWZ2.PymDisc AS 'Payment discription',
PWZ2.PymType AS 'Payment Type',
PWZ2.IntBalance AS 'G/L Interim Balance',
PWZ2.ExpIntBal AS 'Expected G/L Interim Balance',
PWZ2.InterimAct AS 'Interim Account',
PWZ2.BnkCountry AS 'Bank Country',
PWZ2.BnkCode AS 'Bank Code',
PWZ2.BnkAccNo AS 'Bank Account Number',
PWZ2.FatherLn AS 'Parent Line',
PWZ2.NegativPym AS 'Negative Payment Method Code',
PWZ2.NegPymBnk AS 'Negative Payment Bank Code',
PWZ2.NegCountry AS 'Negative Payment Bank Country',
PWZ2.NegPymAcct AS 'Negative Payment Bank Account',
PWZ2.PaymenMean AS 'Payment Means',
PWZ2.IBAN AS 'IBAN',
PWZ2.SwiftNum AS 'BIC/SWIFT Code'
FROM PWZ2 AS PWZ2
Related information
G/L Accounts OACT SQL Table
Payment Wizard OPWZ SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
