|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Tax Report Saving Object
Table Name: OTRS
Table Description: Tax Report Saving Object
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| ReportType | Report Type | Int | 11 | - | Â | 1 | VAT Report (UK) |
| PeriodType | Report Period Type | VarChar | 1 | - | Â | Y | Year |
| Â | Â | Â | Â | Â | Â | Q | Quarter |
| Â | Â | Â | Â | Â | Â | B | Bi-Monthly |
| Â | Â | Â | Â | Â | Â | M | Month |
| Â | Â | Â | Â | Â | Â | P | Period |
| Â | Â | Â | Â | Â | Â | F | Fiscal Year |
| Â | Â | Â | Â | Â | Â | G | Fiscal Quarter |
| PeriodNum | Report Period Number | Int | 11 | - | Â | Â | Â |
| Year | Report Year | Int | 6 | - | Â | Â | Â |
| AdjustNum | Report Adjustment Number | Int | 6 | - | Â | Â | Â |
| ApUserSign | Approved By (User Signature) | Int | 6 | - | Â | Â | Â |
| ApDate | Approval Date | Date | 8 | - | Â | Â | Â |
| ApTime | Approval Time | Int | 6 | - | Â | Â | Â |
| DeclType | Declaration Type | VarChar | 1 | - | O | O | Original |
| Â | Â | Â | Â | Â | Â | S | Substitute |
| Â | Â | Â | Â | Â | Â | C | Complementary |
| SCDateFrom | Selection Criteria - Date From | Date | 8 | - | Â | Â | Â |
| SCDateTo | Selection Criteria - Date To | Date | 8 | - | Â | Â | Â |
| BosCode | Box Set Code | Int | 11 | OBOS | Â | Â | Â |
| BatchNum | Journal Voucher No. | Int | 11 | OBTD | Â | Â | Â |
| GstRtType | GTS Return Type | nVarChar | 10 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |