SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OEBK
Table Description: E-Books
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
E-Books Abs. Entry |
Int |
11 |
- |
|
|
|
| MARK |
MARK |
nVarChar |
40 |
- |
|
|
|
| CancelMARK |
Cancel MARK |
nVarChar |
40 |
- |
|
|
|
| UID |
UID |
nVarChar |
50 |
- |
|
|
|
| IssueVATID |
Issuer VAT Number |
nVarChar |
64 |
- |
|
|
|
| CPVATID |
Counterpart VAT Number |
nVarChar |
64 |
- |
|
|
|
| Series |
Series |
nVarChar |
16 |
- |
|
|
|
| AA |
AA |
nVarChar |
200 |
- |
|
|
|
| IssueDate |
Issue Date |
Date |
8 |
- |
|
|
|
| InvoiceTyp |
Invoice Type |
nVarChar |
100 |
- |
|
|
|
| Currency |
Currency |
nVarChar |
200 |
- |
|
|
|
| TlNetVal |
Total Net Value |
Num |
19.6 |
- |
|
|
|
| TlVatAmn |
Total VAT Amount |
Num |
19.6 |
- |
|
|
|
| TlWheldAmn |
Total Withheld Amount |
Num |
19.6 |
- |
|
|
|
| TlGrossVal |
Total Gross Value |
Num |
19.6 |
- |
|
|
|
| LinkDocTyp |
Linked Doc. Type |
Int |
11 |
- |
|
18 |
A/P Invoices |
| |
|
|
|
|
|
19 |
A/P Credit Memos |
| |
|
|
|
|
|
30 |
Journal Entries |
| |
|
|
|
|
|
0 |
|
| |
|
|
|
|
|
-1 |
|
| LinkDocEnt |
Linked Doc. Entry |
Int |
11 |
- |
|
|
|
| IsNegMark |
Is Negative MARK |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Create Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| SourceECM8 |
LogNum of Source ECM8 |
Int |
11 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
234003013 |
234003013 |
E-Books Expense |
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| Key |
Unique |
Field |
| PRIMARY |
Yes |
AbsEntry |
| UID |
Yes |
UID |
| MARK |
Yes |
MARK |