|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Wizard - Rows 2
Table Name: PWZ2
Table Description: Payment Wizard - Rows 2
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| IdEntry | ID Entry | Int | 11 | OPWZ | Â | Â | Â |
| PymCode | Payment Method Code | nVarChar | 15 | OPYM | Â | Â | Â |
| BnkAccount | Bank Account | nVarChar | 15 | OACT | Â | Â | Â |
| MaxIncom | Max. Incoming Amount | Num | 19.6 | - | Â | Â | Â |
| MaxOutgo | Max. Outgoing Amount | Num | 19.6 | - | Â | Â | Â |
| Balance | G/L Balance | Num | 19.6 | - | Â | Â | Â |
| ExpectBal | Expected G/L Balance | Num | 19.6 | - | Â | Â | Â |
| Checked | Checked | VarChar | 1 | - | Â | Â | Â |
| PymDisc | Payment Description | nVarChar | 100 | - | Â | Â | Â |
| PymType | Payment Type | VarChar | 1 | - | Â | Â | Â |
| IntBalance | G/L Interim Balance | Num | 19.6 | - | Â | Â | Â |
| ExpIntBal | Expected G/L Interim Balance | Num | 19.6 | - | Â | Â | Â |
| InterimAct | Interim Account | nVarChar | 15 | OACT | Â | Â | Â |
| BnkCountry | Bank Country/Region | nVarChar | 3 | - | Â | Â | Â |
| BnkCode | Bank Code | nVarChar | 30 | - | Â | Â | Â |
| BnkAccNo | Bank Account Number | nVarChar | 50 | - | Â | Â | Â |
| FatherLn | Parent Line | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| 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 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| EnBnkAccNo | Encryption of Bank Account No. | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | IdEntry |
| Â | Â | PymCode |