|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Journal Entry Codes
Table Name: OTRC
Table Description: Journal Entry Codes
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TrnsCode | Code | nVarChar | 4 | - | Â | Â | Â |
| TrnsCodDsc | Description | nVarChar | 20 | - | Â | Â | Â |
| Locked | Locked | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Pcn874Ctg | Trans. Category for PCN874 | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | I | Import Log |
| Â | Â | Â | Â | Â | Â | E | Export Log |
| Â | Â | Â | Â | Â | Â | O | Other |
| Â | Â | Â | Â | Â | Â | R | A/R Invoice - Palestinian Territory |
| Â | Â | Â | Â | Â | Â | P | A/P Invoice - Palestinian Territory |
| Â | Â | Â | Â | Â | Â | M | Self-Employed - Sales |
| Â | Â | Â | Â | Â | Â | C | Self-Employed - Purchase |
| Key | Unique | Field |
| PRIMARY | Yes | TrnsCode |
| DESCRIP | No | TrnsCodDsc |