|
|
SQL Banking / PWZ - Bank Account
API OPWB
OPWB - PWZ - Bank Account Table
Bank Codes ODSC SQL Table
Business Partner OCRD SQL Table
Countries OCRY SQL Table
Payment Wizard OPWZ SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode | BP Code | nVarChar | 15 | OCRD Business Partner | ||||
| BankCode | Bank Code | nVarChar | 30 | |||||
| Country KEY UNIQUE | Country | nVarChar | 3 | OCRY Countries | COUNTRY | Yes | ||
| Account | Account No. | nVarChar | 50 | |||||
| Branch | Branch | nVarChar | 50 | |||||
| Street | Street | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| City | City | nVarChar | 100 | |||||
| County | County | nVarChar | 100 | |||||
| State | State | nVarChar | 3 | |||||
| ControlKey | Ctrl Internal ID | nVarChar | 2 | |||||
| UsrNumber1 | User No. 1 | nVarChar | 25 | |||||
| UsrNumber2 | User No. 2 | nVarChar | 25 | |||||
| UsrNumber3 | User No. 3 | nVarChar | 25 | |||||
| UsrNumber4 | User No. 4 | nVarChar | 25 | |||||
| IBAN | IBAN | nVarChar | 50 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| Building | Building/Floor/Room | Text | 16 | |||||
| AliasName | Alias Name | nVarChar | 50 | |||||
| AcctType | Account Type | VarChar | 1 | |||||
| BankKey | Bank Internal ID | Int | 11 | ODSC Bank Codes | ||||
| BIK | BIK | nVarChar | 15 | |||||
| AcctName | Bank Account Name | nVarChar | 127 | |||||
| CorresAcct | Correspondent Account | nVarChar | 30 | |||||
| Phone | Phone | nVarChar | 25 | |||||
| Fax | Fax | nVarChar | 25 | |||||
| ISRType | ISR Type | Int | 1) ISR 2) BISR 3) ISR+ 4) BISR+ | 6 | 2 | |||
| ISRBillerI | ISR Biller ID | nVarChar | 9 | |||||
| CustIdNum | Customer ID Number | nVarChar | 6 | 0 | ||||
| AddrType | Address Type | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| SwiftNum | BIC/SWIFT Code | nVarChar | 50 | |||||
| ABARoutNum | ABA Routing Number | nVarChar | 25 | |||||
| MandateID | Mandate ID | nVarChar | 35 | |||||
| SignDate | Date of Signature | Date | 8 | |||||
| PWZAbsEntr | PWZ ABS Entry | Int | 11 | OPWZ Payment Wizard | ||||
| BranchChk | Branch Check Digit | nVarChar | 5 | |||||
| MandatDate | Date Of Mandate Expiration | Date | 8 | |||||
| SeqType | SEPA Seq. Type | nVarChar | OOFF) OOFF FRST) FRST RCUR) RCUR FNAL) FNAL | 4 | ||||
| ActType | Account Type | VarChar | C) Checking Account S) Savings Account | 1 | ||||
| IsPrenot | Is Prenotification | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OPWB.AbsEntry AS 'Internal Key',
OPWB.CardCode AS 'BP Code',
OPWB.BankCode AS 'Bank Code',
OPWB.Country AS 'Country',
OPWB.Account AS 'Account No.',
OPWB.Branch AS 'Branch',
OPWB.Street AS 'Street',
OPWB.Block AS 'Block',
OPWB.ZipCode AS 'Zip Code',
OPWB.City AS 'City',
OPWB.County AS 'County',
OPWB.State AS 'State',
OPWB.ControlKey AS 'Ctrl Internal ID',
OPWB.UsrNumber1 AS 'User No. 1',
OPWB.UsrNumber2 AS 'User No. 2',
OPWB.UsrNumber3 AS 'User No. 3',
OPWB.UsrNumber4 AS 'User No. 4',
OPWB.IBAN AS 'IBAN',
OPWB.LogInstanc AS 'Log Instance',
OPWB.Building AS 'Building/Floor/Room',
OPWB.AliasName AS 'Alias Name',
OPWB.AcctType AS 'Account Type',
OPWB.BankKey AS 'Bank Internal ID',
OPWB.BIK AS 'BIK',
OPWB.AcctName AS 'Bank Account Name',
OPWB.CorresAcct AS 'Correspondent Account',
OPWB.Phone AS 'Phone',
OPWB.Fax AS 'Fax',
OPWB.ISRType AS 'ISR Type',
OPWB.ISRBillerI AS 'ISR Biller ID',
OPWB.CustIdNum AS 'Customer ID Number',
OPWB.AddrType AS 'Address Type',
OPWB.StreetNo AS 'Street No.',
OPWB.SwiftNum AS 'BIC/SWIFT Code',
OPWB.ABARoutNum AS 'ABA Routing Number',
OPWB.MandateID AS 'Mandate ID',
OPWB.SignDate AS 'Date of Signature',
OPWB.PWZAbsEntr AS 'PWZ ABS Entry',
OPWB.BranchChk AS 'Branch Check Digit',
OPWB.MandatDate AS 'Date Of Mandate Expiration',
OPWB.SeqType AS 'SEPA Seq. Type',
OPWB.ActType AS 'Account Type',
OPWB.IsPrenot AS 'Is Prenotification'
FROM OPWB AS OPWB
Related information
Bank Codes ODSC SQL Table
Business Partner OCRD SQL Table
Countries OCRY 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
