|
|
API PWZ4
PWZ4 - Payment Wizard - Rows 4 Table
G/L Accounts OACT SQL Table
House Bank Accounts DSC1 SQL Table
Countries OCRY SQL Table
Business Partner OCRD 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 |
|---|---|---|---|---|---|---|---|---|
| PymNum | Payment Number | Int | 11 | |||||
| CardCode | Vendor's Card code | nVarChar | 15 | OCRD Business Partner | ||||
| CardName | Vendor's Card Name | nVarChar | 100 | |||||
| PymMeth | Payment Method | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| GLAccCode | G/L Account Code | nVarChar | 15 | OACT G/L Accounts | ||||
| PymAmount | Sum of payment amount | Num | 20 | |||||
| PymAmntFC | Total Payment Amount (FC) | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 24) Incoming Payment 46) Outgoing Payment | 20 | ||||
| RctId | Document ID | Int | 11 | |||||
| DocCurr | Document Currency | nVarChar | 3 | |||||
| BankAccou | Acct No. | nVarChar | 50 | OACT G/L Accounts | ||||
| BnkDflt | Default Bank | nVarChar | 30 | |||||
| BankCountr | Bank Country | nVarChar | 3 | OCRY Countries | ||||
| BankActKey | Bank Account Internal ID | Int | 11 | DSC1 House Bank Accounts | ||||
| LineType | Line Type | VarChar | 1 | G | ||||
| ManualNum | Manual Entry No. | Int | 11 | 0 | ||||
| TBankCode | Target Default Bank | nVarChar | 30 | -1 | ||||
| TDflAccoun | Target Default Account | nVarChar | 50 | |||||
| TBankCount | Target Bank Country | nVarChar | 3 | OCRY Countries | ||||
| TargetBran | Target Bank Branch | nVarChar | 50 | |||||
| BcgPmnt | Payment Amount (BCG) | Num | 20 | |||||
| BcgPmntFc | Payment Amount FC (BCG) | Num | 20 | |||||
| RecipStatu | Recipient Status | nVarChar | 2 | |||||
| BudgetId | Budget ID | nVarChar | 100 | |||||
| OKATO | OKATO | nVarChar | 11 | |||||
| PymReason | Payment Reason | nVarChar | 2 | |||||
| PostPeriod | Posting Period Code | nVarChar | 10 | |||||
| BaseDocTyp | Base Document Type | nVarChar | 2 | |||||
| BaseDocDat | Base Docoument Date | Date | 8 | |||||
| TaxPymType | Tax Payment Type | nVarChar | 2 | |||||
| OKTMO | OKTMO | nVarChar | 12 | |||||
| IBAN | IBAN | nVarChar | 50 | |||||
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 |
Table relationship map
SELECT statement
SELECT
PWZ4.IdEntry AS 'ID Entry',
PWZ4.PymNum AS 'Payment Number',
PWZ4.CardCode AS 'Vendor's Card code',
PWZ4.CardName AS 'Vendor's Card Name',
PWZ4.PymMeth AS 'Payment Method',
PWZ4.GLAccCode AS 'G/L Account Code',
PWZ4.PymAmount AS 'Sum of payment amount',
PWZ4.PymAmntFC AS 'Total Payment Amount (FC)',
PWZ4.ObjType AS 'Object Type',
PWZ4.RctId AS 'Document ID',
PWZ4.DocCurr AS 'Document Currency',
PWZ4.BankAccou AS 'Acct No.',
PWZ4.BnkDflt AS 'Default Bank',
PWZ4.BankCountr AS 'Bank Country',
PWZ4.BankActKey AS 'Bank Account Internal ID',
PWZ4.LineType AS 'Line Type',
PWZ4.ManualNum AS 'Manual Entry No.',
PWZ4.TBankCode AS 'Target Default Bank',
PWZ4.TDflAccoun AS 'Target Default Account',
PWZ4.TBankCount AS 'Target Bank Country',
PWZ4.TargetBran AS 'Target Bank Branch',
PWZ4.BcgPmnt AS 'Payment Amount (BCG)',
PWZ4.BcgPmntFc AS 'Payment Amount FC (BCG)',
PWZ4.RecipStatu AS 'Recipient Status',
PWZ4.BudgetId AS 'Budget ID',
PWZ4.OKATO AS 'OKATO',
PWZ4.PymReason AS 'Payment Reason',
PWZ4.PostPeriod AS 'Posting Period Code',
PWZ4.BaseDocTyp AS 'Base Document Type',
PWZ4.BaseDocDat AS 'Base Docoument Date',
PWZ4.TaxPymType AS 'Tax Payment Type',
PWZ4.OKTMO AS 'OKTMO',
PWZ4.IBAN AS 'IBAN',
PWZ4.SwiftNum AS 'BIC/SWIFT Code'
FROM PWZ4 AS PWZ4
Related information
G/L Accounts OACT SQL Table
House Bank Accounts DSC1 SQL Table
Countries OCRY SQL Table
Business Partner OCRD 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
