|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Bill Of Exchang Transaction
Table Name: OBOT
Table Description: Bill Of Exchang Transaction
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | BOE Transaction key | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| StatusFrom | Status from | VarChar | 1 | - | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | G | Generated |
| Â | Â | Â | Â | Â | Â | D | Deposit |
| Â | Â | Â | Â | Â | Â | P | Paid |
| Â | Â | Â | Â | Â | Â | F | Failed |
| Â | Â | Â | Â | Â | Â | V | BoE to Vendor |
| StatusTo | Status To | VarChar | 1 | - | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | G | Generated |
| Â | Â | Â | Â | Â | Â | D | Deposit |
| Â | Â | Â | Â | Â | Â | P | Paid |
| Â | Â | Â | Â | Â | Â | F | Failed |
| Â | Â | Â | Â | Â | Â | L | Closed |
| Â | Â | Â | Â | Â | Â | V | BoE to Vendor |
| TranDate | Transaction Date | Date | 8 | - | Â | Â | Â |
| TranTime | Transaction Time | Int | 6 | - | Â | Â | Â |
| Reconciled | was the Boe Reconciled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TransId | Transaction Number | Int | 11 | OJDT | Â | Â | Â |
| PostDate | Posting Date | Date | 8 | - | Â | Â | Â |
| TaxDate | Document Date | Date | 8 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| 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 |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |