|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Wizard - Rows 4
Table Name: PWZ4
Table Description: Payment Wizard - Rows 4
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| IdEntry | ID Entry | Int | 11 | OPWZ | Â | Â | Â |
| PymNum | Payment Number | Int | 11 | - | Â | Â | Â |
| CardCode | Vendor's Card code | nVarChar | 15 | OCRD | Â | Â | Â |
| CardName | Vendor's Card Name | nVarChar | 200 | - | Â | Â | Â |
| PymMeth | Payment Method | nVarChar | 15 | OPYM | Â | Â | Â |
| GLAccCode | G/L Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| PymAmount | Sum of payment amount | Num | 19.6 | - | Â | Â | Â |
| PymAmntFC | Total Payment Amount (FC) | Num | 19.6 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payment |
| RctId | Document ID | Int | 11 | - | Â | Â | Â |
| DocCurr | Document Currency | nVarChar | 3 | - | Â | Â | Â |
| BankAccou | Acct No. | nVarChar | 50 | OACT | Â | Â | Â |
| BnkDflt | Default Bank | nVarChar | 30 | - | Â | Â | Â |
| BankCountr | Bank Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| BankActKey | Bank Account Internal ID | Int | 11 | DSC1 | Â | Â | Â |
| 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/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| TargetBran | Target Bank Branch | nVarChar | 50 | - | Â | Â | Â |
| BcgPmnt | Payment Amount (BCG) | Num | 19.6 | - | Â | Â | Â |
| BcgPmntFc | Payment Amount FC (BCG) | Num | 19.6 | - | Â | Â | Â |
| RecipStatu | Recipient Status | nVarChar | 2 | - | Â | Â | Â |
| BudgetId | VAT Budget Classification Code | 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 | - | Â | Â | Â |
| UIPCode | UIP Code | nVarChar | 25 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| EnBankAcco | Encryption of Acct No. | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | IdEntry |
| Â | Â | RctId |
| Â | Â | ObjType |