Difference between revisions of "File(s) located at R:\PAY\COM\DB2"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with " Main Page > Application Development Team > DB Specs > Payroll DB == Database File == ===...")
 
Line 190: Line 190:
 
|PMMCMPY2.NTX
 
|PMMCMPY2.NTX
 
|CMPNAME
 
|CMPNAME
 +
|}
 +
=== PMMDEPT.DBF - Department Master File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMDEPT1.NTX1
 +
|DEPDPCD+DEPCPCD
 +
|-
 +
|PMMDEPT2.NTX
 +
|DEPNAME
 
|}
 
|}

Revision as of 15:21, 12 January 2017

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CCOM%5CDB2&oldid=4473"