File(s) located at R:\PAY\COM\DB2
From SPGC Document Wiki
Revision as of 15:13, 12 January 2017 by Admin (Talk | contribs) (Created page with " Main Page > Application Development Team > DB Specs > Payroll DB == Database File == ===...")
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 |
