|
|
SAP Business One SDK 10.0 - Database Tables Reference |
VAT Transactions
Table Name: OTAX
Table Description: VAT Transactions
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| SrcObjType | Source Object Type | nVarChar | 20 | - | -1 | -1 | Â |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 165 | Correction A/R Invoice |
| Â | Â | Â | Â | Â | Â | 166 | Correction A/R Invoice Reversals |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| Â | Â | Â | Â | Â | Â | 19 | A/P Credit Memo |
| Â | Â | Â | Â | Â | Â | 163 | Correction A/P Invoice |
| Â | Â | Â | Â | Â | Â | 164 | Correction A/P Invoice Reversals |
| Â | Â | Â | Â | Â | Â | 46 | Outgoing Payment |
| Â | Â | Â | Â | Â | Â | 24 | Incoming Payment |
| Â | Â | Â | Â | Â | Â | 57 | Check for Payment |
| Â | Â | Â | Â | Â | Â | 30 | Journal Transaction |
| Â | Â | Â | Â | Â | Â | 67 | Warehouse Transfer |
| Â | Â | Â | Â | Â | Â | 25 | Deposit |
| Â | Â | Â | Â | Â | Â | 321 | Internal Reconciliation |
| Â | Â | Â | Â | Â | Â | 76 | Deposit Temporary |
| Â | Â | Â | Â | Â | Â | 140000010 | Incoming Excise Invoice |
| Â | Â | Â | Â | Â | Â | 140000009 | Outgoing Excise Invoice |
| Â | Â | Â | Â | Â | Â | 69 | Import file |
| SrcObjAbs | Source Object Internal ID | Int | 11 | - | -1 | Â | Â |
| OrdinLNum | Ordial Num (BTF & Canceled) | Int | 11 | - | -1 | Â | Â |
| Cancelled | Canceled | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| SECONDARY | Yes | SrcObjType |
| Â | Â | SrcObjAbs |
| Â | Â | OrdinLNum |