|
|
SAP Business One SDK 10.0 - Database Tables Reference |
VAT Exemptions for Business Partners Row - History
Table Name: AEB1
Table Description: VAT Exemptions for Business Partners Row - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ExmpDoc | Exemption Doc. No. | nVarChar | 40 | - | Â | Â | Â |
| IssueDate | Date of Issue | Date | 8 | - | Â | Â | Â |
| IssueTime | Time of Issue | Int | 11 | - | Â | Â | Â |
| ExmpType | Exemption Type | Int | 6 | OVET | Â | Â | Â |
| AllItems | Apply to All Items | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| ItemCode | Item No. | nVarChar | 50 | OITM | Â | Â | Â |
| ItemDesc | Item Description | nVarChar | 200 | - | Â | Â | Â |
| Rate | Rate % | Num | 19.6 | - | Â | Â | Â |
| TaxCode | Exemption Tax Code | nVarChar | 8 | OSTC | Â | Â | Â |
| AuthName | Name of Authorities | nVarChar | 160 | - | Â | Â | Â |
| ValidFrom | Valid From | Date | 8 | - | Â | Â | Â |
| ValidTo | Valid To | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineNum |
| Â | Â | LogInstanc |