File(s) located at R:\PAY\COM\DBF
From SPGC Document Wiki
Revision as of 10:51, 12 January 2017 by Admin (Talk | contribs) (Created page with "==File(s) located at R:\PAY\COM\DBF== ===PMHATMP.DBF - ATM File (Separted)=== {| class="wikitable" \ |- ! style="text-align:left;" | Field Name ! Type ! Width ! Dec ! Descript...")
Contents
File(s) located at R:\PAY\COM\DBF
PMHATMP.DBF - ATM File (Separted)
| Field Name | Type | Width | Dec | Description |
|---|---|---|---|---|
| ATMNUMB | Character | 08 | Employee No. | |
| ATMBKCD | Character | 05 | Bank Code | |
| ATMACCT | Character | 12 | Account No. |
| Index Name | Index Key |
|---|---|
| PMHATMP1.NTX | ATMNUMB+ATMBKCD |
PMTVIP2.DBF - VIP Second Salary File
| Field Name | Type | Width | Dec | Description |
|---|---|---|---|---|
| VIPNUMB | Character | 08 | Employee No. | |
| VIPEDTE | Date | 08 | Effectively date | |
| VIPBPAY | Numeric | 10 | 02 | Basic Pay |
| VIPALLO | Numeric | 08 | 02 | Allowance |
| Index Name | Index Key |
|---|---|
| PMTVIP21.NTX | VIPNUMB+DTOS(VIPEDTE) |
PMTTELE.DBF - Tellphone File
| Field Name | Type | Width | Dec | Description |
|---|---|---|---|---|
| TELNUMB | Character | 08 | Employee No. | |
| TELTELN | Character | 12 | Telephone No. |
| Index Name | Index Key |
|---|---|
| PMTTELE.NTX | TELNUMB |
