|
|
API AHE7
AHE7 - Savings Payments Table
Employees OHEM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | empID KEY UNIQUE | Employee No. | Int | 11 | OHEM Employees | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| line | Row | Int | 6 | |||||
| ConName | Contract Name | nVarChar | 50 | |||||
| PmntNotes | Payment Details | nVarChar | 50 | |||||
| AN | Employee | Num | 20 | |||||
| AG | Employer | Num | 20 | |||||
| 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 | B) M) Monthly Q) Quarterly S) Semi-annually Y) Yearly | 1 | M |
SELECT statement
SELECT
AHE7.empID AS 'Employee No.',
AHE7.line AS 'Row',
AHE7.ConName AS 'Contract Name',
AHE7.PmntNotes AS 'Payment Details',
AHE7.AN AS 'Employee',
AHE7.AG AS 'Employer',
AHE7.BankName AS 'Bank Name',
AHE7.BankCode AS 'Bank Code',
AHE7.BankAcct AS 'Bank Account',
AHE7.LogInstanc AS 'Log Instance',
AHE7.ANCurrency AS 'Employee Currency',
AHE7.AGCurrency AS 'Employer Currency',
AHE7.Sequence AS 'Frequency'
FROM AHE7 AS AHE7
Related information
Employees OHEM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
