|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bill of Exchange Transactions
Table Name: BOT1
Table Description: Bill of Exchange Transactions
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Transaction No. | Int | 11 | OBOT | Â | Â | Â |
| BOENumber | Bill of Exchange No. | Int | 11 | - | Â | Â | Â |
| BoeType | Bill of Exchange Type | VarChar | 1 | - | I | I | Incoming |
| Â | Â | Â | Â | Â | Â | O | Outgoing |
| DueDate | Bill of Exchange Due Date | Date | 8 | - | Â | Â | Â |
| BPBankCtr | BP Bank Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| BPBankCod | BP Bank Code | nVarChar | 30 | - | Â | Â | Â |
| BPBankAct | BP Bank Account | nVarChar | 50 | - | Â | Â | Â |
| BPBankBrnc | BP Bank Branch | nVarChar | 50 | - | Â | Â | Â |
| ExReconNum | Extra Reconciliation Number | Int | 11 | - | Â | Â | Â |
| BOEAbs | Bill of Exchange Key | Int | 11 | OBOE | Â | Â | Â |
| BPLId | Branch | Int | 11 | OBPL | Â | Â | Â |
| EnBPBnkAct | Encryption of BP Bank Account | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | BOENumber |
| Â | Â | BoeType |