|
|
API PWZ1
PWZ1 - Payment Wizard - Rows 1 Table
Business Partner OCRD SQL Table
Payment Wizard OPWZ 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 |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | BP Name | nVarChar | 100 | |||||
| CardType | BP Type | VarChar | 1 | |||||
| Checked | Checked | VarChar | 1 | |||||
| BPCurrency | BP Currency | nVarChar | 3 | |||||
| BPSingleP | BP Single Payment | VarChar | N) No Y) Yes | 1 | N |
Table relationship map
SELECT statement
SELECT
PWZ1.IdEntry AS 'ID Entry',
PWZ1.CardCode AS 'BP Code',
PWZ1.CardName AS 'BP Name',
PWZ1.CardType AS 'BP Type',
PWZ1.Checked AS 'Checked',
PWZ1.BPCurrency AS 'BP Currency',
PWZ1.BPSingleP AS 'BP Single Payment'
FROM PWZ1 AS PWZ1
Related information
Business Partner OCRD SQL Table
Payment Wizard OPWZ SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
