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

From SPGC Document Wiki
Jump to: navigation, search
Line 281: Line 281:
 
|PMMDEPT2.NTX
 
|PMMDEPT2.NTX
 
|DEPNAME
 
|DEPNAME
 +
|-
 +
|PMMDEPT3.NTX
 +
|DEPOCDE
 +
|}
 +
=== PMMPOSN.DBF - Position Master File===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PMMPOSN1.NTX
 +
|POSPSCD
 +
|-
 +
|PMMPOSN2.NTX
 +
|POSDESC
 +
|}
 +
=== PYMPCLS.DBF - Length of Service Table ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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 ===
 +
{| class="wikitable" \
 +
|-
 +
! style="text-align:left;" | 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
 +
|}
 +
{| class="wikitable" \
 +
!style="text-align:left;"|Index Name
 +
!Index Key
 +
|-
 +
|PYMACCT1.NTX
 +
|ACCOACD
 +
|-
 +
|PYMACCT2.NTX
 +
|ICLDESC
 
|}
 
|}

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