|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Methods for Payment Wizard
Table Name: OPYM
Table Description: Payment Methods for Payment Wizard
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| PayMethCod | Payment Method Code | nVarChar | 15 | - | Â | Â | Â |
| Descript | Description | nVarChar | 100 | - | Â | Â | Â |
| Type | Type | VarChar | 1 | - | Â | O | Outgoing |
| Â | Â | Â | Â | Â | Â | I | Incoming |
| BankTransf | Payment Means | VarChar | 1 | - | Â | C | Check |
| Â | Â | Â | Â | Â | Â | T | Bank Transfer |
| Â | Â | Â | Â | Â | Â | B | Bill of Exchange |
| Address | Check Address | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BankDet | Check Bank Details | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CllctAutor | Check Collection Authorization | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FrgnPmntBl | Block Foreign Payment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FrgnBnkBl | Block Foreign Bank | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CurrRestr | Currency Restriction | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PostOffBnk | Post Office Bank | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| MinAmount | Minimum Amount | Num | 19.6 | - | Â | Â | Â |
| MaxAmount | Maximum Amount | Num | 19.6 | - | Â | Â | Â |
| BnkDflt | Default Bank | nVarChar | 30 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| BankCountr | Bank Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| DflAccount | Default Bank Account | nVarChar | 50 | - | Â | Â | Â |
| GLAccount | G/L Account | nVarChar | 15 | OACT | Â | Â | Â |
| Branch | Bank Branch | nVarChar | 50 | - | Â | Â | Â |
| KeyCode | Key Code | nVarChar | 6 | - | Â | Â | Â |
| TrnsType | Transaction Type | nVarChar | 2 | - | Â | Â | Â |
| Format | File Format | nVarChar | 11 | OFRM | Â | Â | Â |
| AgtCollect | Agent Collection | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SendAccept | Send for Acceptance | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| GrpByDate | Group By Date | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DepNorm | Deposit Norm | nVarChar | 8 | - | Â | Â | Â |
| DebitMemo | Debit Memo | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| GroupPmRef | Group by Payment Reference No. | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| GroupInv | Group Invoices by Pay | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ValDateSel | Due Date Selection | VarChar | 1 | - | P | P | Date of Payment Run |
| Â | Â | Â | Â | Â | Â | I | Due Date of Invoice |
| Â | Â | Â | Â | Â | Â | T | Payment Terms |
| PaymTerms | Payment Terms Code | Int | 6 | OCTG | Â | Â | Â |
| IntrimAcct | Post to G/L Interim Account | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| BnkActKey | Bank Account Key | Int | 11 | DSC1 | Â | Â | Â |
| DocType | BoE Document Type | nVarChar | 2 | - | Â | Â | Â |
| Accepted | BoE Status - Accepted | VarChar | 1 | - | Â | Â | Â |
| PtfID | BoE Internal Portfolio ID | nVarChar | 3 | - | Â | Â | Â |
| PtfCode | BoE Portfolio Code | nVarChar | 2 | - | Â | Â | Â |
| PtfNum | BoE Portfolio Number | nVarChar | 4 | - | Â | Â | Â |
| CurCode | BoE Currency Code | nVarChar | 2 | - | Â | Â | Â |
| Instruct1 | BoE Instruction 1 | nVarChar | 2 | - | Â | Â | Â |
| Instruct2 | BoE Instruction 2 | nVarChar | 2 | - | Â | Â | Â |
| PaymntPlc | BoE Payment Place | nVarChar | 128 | - | Â | Â | Â |
| BoeDll | Bar Code DLL | nVarChar | 50 | - | Â | Â | Â |
| BankCtlKey | Bank Control No. | nVarChar | 2 | - | Â | Â | Â |
| Active | Status of the Payment Method | VarChar | 1 | - | Y | Y | Active |
| Â | Â | Â | Â | Â | Â | N | Inactive |
| BcgPcnt | Bank Charge Rate (%) | Num | 19.6 | - | Â | Â | Â |
| GrpByCur | Group Invoices by Currency | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| GrpByBank | Group Invoices by Pay-To Bank | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DflIBAN | Bank IBAN | nVarChar | 50 | - | Â | Â | Â |
| DflSwift | Bank BIC/SWIFT | nVarChar | 50 | - | Â | Â | Â |
| BoeReport | BoE Report Code | nVarChar | 8 | - | Â | Â | Â |
| CancInstr | Cancellation Instruction | nVarChar | 2 | - | Â | Â | Â |
| OccurCode | Occurrence Code | nVarChar | 2 | - | Â | Â | Â |
| MovmntCode | Movement Code | nVarChar | 10 | - | Â | Â | Â |
| NegPymCode | Negative Payment Method Code | nVarChar | 15 | OPYM | Â | Â | Â |
| DirectDbt | Direct Debit | nVarChar | 5 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | CORE | Â |
| Â | Â | Â | Â | Â | Â | B2B | Â |
| Â | Â | Â | Â | Â | Â | COR1 | Â |
| IssueIndic | Issue Indicator | VarChar | 1 | - | R | 3 | Â |
| Â | Â | Â | Â | Â | Â | R | Â |
| PrintSEPA | Print SEPA Prenotification | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PmntType | Payment Type | nVarChar | 50 | - | 01 | 01 | Efectivo |
| Â | Â | Â | Â | Â | Â | 02 | Cheque nominativo |
|  |  |  |  |  |  | 03 | Transferencia electr�nica de fondos |
|  |  |  |  |  |  | 04 | Tarjeta de cr�dito |
|  |  |  |  |  |  | 05 | Monedero electr�nico |
|  |  |  |  |  |  | 06 | Dinero electr�nico |
| Â | Â | Â | Â | Â | Â | 08 | Vales de despensa |
|  |  |  |  |  |  | 12 | Daci�n en pago |
|  |  |  |  |  |  | 13 | Pago por subrogaci�n |
|  |  |  |  |  |  | 14 | Pago por consignaci�n |
|  |  |  |  |  |  | 15 | Condonaci�n |
|  |  |  |  |  |  | 17 | Compensaci�n |
|  |  |  |  |  |  | 23 | Novaci�n |
|  |  |  |  |  |  | 24 | Confusi�n |
|  |  |  |  |  |  | 25 | Remisi�n de deuda |
|  |  |  |  |  |  | 26 | Prescripci�n o caducidad |
|  |  |  |  |  |  | 27 | A satisfacci�n del acreedor |
|  |  |  |  |  |  | 28 | Tarjeta de d�bito |
| Â | Â | Â | Â | Â | Â | 29 | Tarjeta de servicios |
|  |  |  |  |  |  | 30 | Aplicaci�n de anticipos |
| Â | Â | Â | Â | Â | Â | 31 | Intermediario pagos |
| Â | Â | Â | Â | Â | Â | 99 | Por definir |
| GrpByAgrNo | Group Blanket Agreement | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SpltPmtVAT | Split Payments for VAT | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnDflAcct | Encryption of Default Bank Account | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | PayMethCod |