Main Page > Application Development Team > DB Specs > Payroll DB
Database File
PMMCMPY.DBF - Company Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| CMPCOCD
|
Character
|
01
|
|
Company Code
|
| CMPNAME
|
Character
|
35
|
|
Company Name
|
| CMPSSSN
|
Character
|
12
|
|
SSS Number
|
| CMPTINO
|
Character
|
12
|
|
TIN Number
|
| CMPCADD
|
Character
|
10
|
|
Address
|
| CMPSLAC
|
Character
|
10
|
|
Salaries, Wages
|
| CMPSMEC
|
Character
|
10
|
|
SSS/MED/EC
|
| CMPBKAL
|
Character
|
10
|
|
Kalookan Bank
|
| CMPOTHR
|
Character
|
10
|
|
Other Income
|
| CMPHOLD
|
Character
|
10
|
|
Hold Amount
|
| CMPPIBE
|
Character
|
10
|
|
Pag-ibig Acct
|
| CMPTELE
|
Character
|
10
|
|
Telegraphic
|
| CMPBMAK
|
Character
|
10
|
|
Makati Bank
|
| CMPCASH
|
Character
|
10
|
|
Cash Account
|
| CMPTAXC
|
Character
|
10
|
|
Tax Acct Code
|
| CMPSMEP
|
Character
|
10
|
|
SSS/MED/EC/PIB
|
| CMPABBR
|
Character
|
05
|
|
Company Abbr.
|
| CMPMEDP
|
Character
|
10
|
|
MED/EC Payable
|
| CMPHACC
|
Character
|
03
|
|
|
| CMPWACC
|
Character
|
03
|
|
|
| CMPTACC
|
Character
|
03
|
|
|
| CMPHLAC
|
Character
|
03
|
|
|
| CMPSACC
|
Character
|
03
|
|
|
| CMPBACC
|
Character
|
03
|
|
|
| CMPOIAC
|
Character
|
03
|
|
|
| CMPSMAC
|
Character
|
03
|
|
|
| CMPSPAC
|
Character
|
03
|
|
|
| CMPOSLA
|
Character
|
03
|
|
|
| Index Name
|
Index Key
|
| PMMCMPY1.NTX
|
CMPCOCD
|
| PMMCMPY2.NTX
|
CMPNAME
|
PMMDEPT.DBF - Department Master File
| Field Name
|
Type
|
Width
|
Dec
|
Description
|
| DEPPDPC
|
Character
|
10
|
|
Department Code
|
| DEPCPCD
|
Character
|
01
|
|
Company Code
|
| DEPNAME
|
Character
|
35
|
|
Department Name
|
| DEPINCO
|
Character
|
02
|
|
Internal Comp.
|
| DEPSLWG
|
Character
|
08
|
|
Salaries, Wages
|
| DEPSSSM
|
Character
|
08
|
|
SSS/MED/EC
|
| DEPABBR
|
Character
|
05
|
|
Abbreviation
|
| DEPCOCD
|
Character
|
01
|
|
Company Code
|
| DEPFLAG
|
Character
|
01
|
|
Flag for Remit
|
| DEPBONS
|
Character
|
08
|
|
Bonus Account
|
| DEPBENE
|
Character
|
08
|
|
Benefits Acct.
|
| DEPOCDE
|
Character
|
03
|
|
Old Department
|
| Index Name
|
Index Key
|
| PMMDEPT1.NTX1
|
DEPDPCD+DEPCPCD
|
| PMMDEPT2.NTX
|
DEPNAME
|
