|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Tax Report Wizard for Brazil
Table Name: OTRB
Table Description: Tax Report Wizard for Brazil
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| BPLId | Branch ID | Int | 11 | OBPL | Â | Â | Â |
| GPCId | Government Payment Code | Int | 11 | OGPC | Â | Â | Â |
| GPCCode | Government Payment Code | nVarChar | 6 | - | Â | Â | Â |
| Year | Reporting Year | Int | 6 | - | Â | Â | Â |
| PrdType | Period Type | VarChar | 1 | - | Â | Q | Quarter |
| Â | Â | Â | Â | Â | Â | M | Month |
| Â | Â | Â | Â | Â | Â | H | Half Month |
| Â | Â | Â | Â | Â | Â | T | Ten Days |
| PrdNum | Period Number | Int | 11 | - | Â | Â | Â |
| PrdDate | Period Date To | Date | 8 | - | Â | Â | Â |
| RunName | Wizard Run Name | nVarChar | 100 | - | Â | Â | Â |
| RunDate | Wizard Run Date | Date | 8 | - | Â | Â | Â |
| Status | Wizard Run Status | VarChar | 1 | - | Â | S | Saved |
| Â | Â | Â | Â | Â | Â | E | Executed |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| StateTax | State Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DueDate | Due Date | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Generation Time | Int | 6 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| SECONDARY | Yes | RunName |