Main Page > Application Development Team > DB Specs > Payroll DB
Database File
PMMCITY.DBF - Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CTYCTCD
|
Character
|
03
|
|
City Code
|
| CTYDESC
|
Character
|
20
|
|
Description
|
| CTYPVCD
|
Character
|
03
|
|
Province Code
|
| CTYZPCD
|
Character
|
08
|
|
Zip Code
|
| Index Name
|
Index Key
|
| PMMCITY1.NTX
|
CTYCTCD
|
| PMMCITY2.NTX
|
CTYDESC
|
PMMLNGE.DBF - Language Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| LNGCODE
|
Character
|
02
|
|
Code
|
| LNGDESC
|
Character
|
01
|
|
Description
|
| Index Name
|
Index Key
|
| PMMLNGE1.NTX
|
PRVPVCD
|
| PMMLNGE2.NTX
|
PRVDESC
|
