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

From SPGC Document Wiki
Jump to: navigation, search
Line 536: Line 536:
 
|PMMLOCA2.NTX
 
|PMMLOCA2.NTX
 
|LOCDESC
 
|LOCDESC
 +
|}
 +
=== PMMSECT.DBF - Section Master File ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | Field Name
 +
! Type
 +
! Width
 +
! Dec
 +
! Description
 +
|-
 +
|SECSCCD
 +
|Character
 +
|02
 +
|
 +
|Section Code
 +
|-
 +
|SECNAME
 +
|Character
 +
|25
 +
|
 +
|Section Name
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMSECT1.NTX
 +
|SECSCCD
 +
|-
 +
|PMMSECT2.NTX
 +
|SECNAME
 
|}
 
|}

Revision as of 15:53, 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
PMMDEPT3.NTX DEPOCDE

PMMPOSN.DBF - Position Master File

Field Name Type Width Dec Description
POSPSCD Character 03 Position Code
POSDESC Character 20 Drescription
POSJLCD Character 03 Job Level Code
POSJOSC Memo 10 Job Section
OCODE Character 03 Old Posn. Code
Index Name Index Key
PMMPOSN1.NTX POSPSCD
PMMPOSN2.NTX POSDESC

PYMPCLS.DBF - Length of Service Table

Field Name Type Width Dec Description
PCLPRBY Numeric 02 Probationary
PCLCON1 Numeric 02 Cont. 1 months
PCLCON2 Numeric 02 Cont. 2 months
PCLCON3 Numeric 02 Cont. 3 months

PYMACCT.DBF - Account Master File

Field Name Type Width Dec Description\
ACCOACD Character 10 Account Code
ACCDESC Character 35 Description
ACCNAME Character 35 Account Name
ACCACDE Character 03 Old Acct. Code
Index Name Index Key
PYMACCT1.NTX ACCOACD
PYMACCT2.NTX ICLDESC

PYMCOAC.DBF - Company Account Allocation File

Field Name Type Width Dec Description
CACCOCD Character 01 Company Code
CACBKCD Character 05 Bank Code
CACACCT Character 12 Account Code
Index Name Index Key
PYMCOAC1.NTX PYMCOAC+CACBKCD

PMMICLS.DBF - Infraction Classification File

Field Name Type Width Dec Description
ICLICCD Character 02 Infraction Code
ICLDESC Character 158 Description
Index Name Index Key
PMMICLS1.NTX ICLICCD
PMMICLS2.NTX ICLDESC

PMMJBLV.DBF - Job Level File

Field Name Type Width Dec Description
JBLJLCD Character 02 Job Level Code
JBLDESC Character 20 Description
Index Name Index Key
PMMJBLV1.NTX JBLJLCD
PMMJBLV2.NTX JBLDESC

PMMLOCA.DBF - Location Master File

Field Name Type Width Dec Description
LOCCODE Character 03 Location Code
LOCDESC Character 20 Description
Index Name Index Key
PMMLOCA1.NTX LOCCODE
PMMLOCA2.NTX LOCDESC

PMMSECT.DBF - Section Master File

Field Name Type Width Dec Description
SECSCCD Character 02 Section Code
SECNAME Character 25 Section Name
Index Name Index Key
PMMSECT1.NTX SECSCCD
PMMSECT2.NTX SECNAME
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=File(s)_located_at_R:%5CPAY%5CCOM%5CDB2&oldid=4477"