|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Savings Payments
Table Name: AHE7
Table Description: Savings Payments
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| empID | Employee No. | Int | 11 | OHEM | Â | Â | Â |
| line | Row | Int | 6 | - | Â | Â | Â |
| ConName | Contract Name | nVarChar | 50 | - | Â | Â | Â |
| PmntNotes | Payment Details | nVarChar | 50 | - | Â | Â | Â |
| AN | Employee | Num | 19.6 | - | Â | Â | Â |
| AG | Employer | Num | 19.6 | - | Â | Â | Â |
| BankName | Bank Name | nVarChar | 50 | - | Â | Â | Â |
| BankCode | Bank Code | nVarChar | 20 | - | Â | Â | Â |
| BankAcct | Bank Account | nVarChar | 20 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ANCurrency | Employee Currency | nVarChar | 3 | - | Â | Â | Â |
| AGCurrency | Employer Currency | nVarChar | 3 | - | Â | Â | Â |
| Sequence | Frequency | VarChar | 1 | - | M | B | Â |
| Â | Â | Â | Â | Â | Â | M | Monthly |
| Â | Â | Â | Â | Â | Â | Q | Quarterly |
| Â | Â | Â | Â | Â | Â | S | Semi-annually |
| Â | Â | Â | Â | Â | Â | Y | Yearly |
| EnBnkAcct | Encryption of Bank Account | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | empID |
| Â | Â | line |
| Â | Â | LogInstanc |