GPCN_PSLP_LANG(SQL Table) |
Index Back |
---|---|
GP CHN - Payslip DefinitionGP China - Payslip definition related language record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPCN_PAYSLIP_ID | Character(18) | VARCHAR2(18) NOT NULL | This field is used to uniquely identify a payslip template. |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | GPCN_LBL_ACUM1 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 1 that will be used for on-line and hard-copy payslips. |
7 | GPCN_LBL_ACUM2 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 2 that will be used for on-line and hard-copy payslips. |
8 | GPCN_LBL_ACUM3 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 3 that will be used for on-line and hard-copy payslips. |
9 | GPCN_LBL_ACUM4 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 4 that will be used for on-line and hard-copy payslips. |
10 | GPCN_LBL_ACUM5 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 5 that will be used for on-line and hard-copy payslips. |
11 | GPCN_LBL_ACUM6 | Character(10) | VARCHAR2(10) NOT NULL | This field will be used to store the label for accumulator 6 that will be used for on-line and hard-copy payslips. |