|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payroll
Table Name: OPMX
Table Description: Payroll
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| Total | Total | Num | 19.6 | - | Â | Â | Â |
| Currency | Currency | nVarChar | 3 | OCRN | Â | Â | Â |
| Rate | Exchange Rate | Num | 19.6 | - | Â | Â | Â |
| Uid | UUID of payroll | nVarChar | 100 | - | Â | Â | Â |
| RFC | RFC | nVarChar | 20 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| FileDate | File Date | Date | 8 | - | Â | Â | Â |
| FileName | Imported File Name | nVarChar | 254 | - | Â | Â | Â |
| JVBatchNum | Journal Voucher Batch Number | Int | 11 | OBTF | Â | Â | Â |
| JVTransId | Journal Voucher Trans Number | Int | 11 | OBTF | Â | Â | Â |
| JETransId | Journal Entry Trans Number | Int | 11 | OJDT | Â | Â | Â |
| Type | Type | VarChar | 1 | - | P | P | Payroll |
| Â | Â | Â | Â | Â | Â | E | Expenses |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| UID | Yes | Uid |