|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Unreported VAT Transactions - Grouped Rows
Table Name: UTX2
Table Description: Unreported VAT Transactions - Grouped Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal ID | Int | 11 | OUTX | Â | Â | Â |
| LineSeq | Row Sequence | Int | 11 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | - | Â | Â | Â |
| VatPercent | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| CrditDebit | Credit or Debit Transaction | VarChar | 1 | - | Â | C | Credit |
| Â | Â | Â | Â | Â | Â | D | Debit |
| BaseSum | Base Sum | Num | 19.6 | - | Â | Â | Â |
| BaseSumSc | Base Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| BaseSumFc | Base Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| VatSum | VAT Sum | Num | 19.6 | - | Â | Â | Â |
| VatSumSc | VAT Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| VatSumFc | VAT Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| TODedBaseS | Tax Only Deducted Base Sum | Num | 19.6 | - | Â | Â | Â |
| TODedBaSSC | Tax Only Deducted Base Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| TODedBaSFC | Tax Only Deducted Base Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| LnDataNum | Row Number in Tax Data | Int | 11 | - | -1 | Â | Â |
| DeductSum | Deduct VAT Sum | Num | 19.6 | - | Â | Â | Â |
| DedctSumSC | Deduct VAT Sum (SC) | Num | 19.6 | - | Â | Â | Â |
| DedctSumFC | Deduct VAT Sum (FC) | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineSeq |