|
|
SAP Business One SDK 10.0 - Database Tables Reference |
E-Books - History
Table Name: AEBK
Table Description: E-Books - History
| 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 |
| Â | Â | LogInstanc |
| MARK | Yes | MARK |
| Â | Â | LogInstanc |