SAP Business One SDK 10.0 - Database Tables Reference
-
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 |