|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payroll G/L accounts Setup
Table Name: OPRA
Table Description: Payroll G/L accounts Setup
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| CateType | Category Type | VarChar | 1 | - | Â | P | Perception |
| Â | Â | Â | Â | Â | Â | D | Deduction |
| Â | Â | Â | Â | Â | Â | N | Payroll Payable |
| Â | Â | Â | Â | Â | Â | R | Rounding |
| Â | Â | Â | Â | Â | Â | O | Other Payments |
| CateCode | Category Code | nVarChar | 8 | - | Â | Â | Â |
| Category | Category of Payroll | nVarChar | 254 | - | Â | Â | Â |
| Account | G/L Account | nVarChar | 15 | OACT | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| CATE_CODE | Yes | CateType |
| Â | Â | CateCode |