GPCN_TX_RPT_AET(SQL Table) |
Index Back |
---|---|
State record for GPCN_TAX_RPTState record for GPCN_TAX_RPT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
6 | GPCN_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month Code (along with translate values)
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
7 | GPCN_YEARCD | Character(4) | VARCHAR2(4) NOT NULL | Year Code (along with translate values) |
8 | GPCN_RECREATE | Character(1) | VARCHAR2(1) NOT NULL |
Recreate
Y/N Table Edit |
9 | BGN_DT | Date(10) | DATE | Begin Date |
10 | END_DT | Date(10) | DATE | end date |
11 | GPCN_TAX_AREA | Character(30) | VARCHAR2(30) NOT NULL |
Tax Area
Prompt Table: GPCN_TAX_AR_VW |
12 | GPCN_CATGRY_INCOME | Character(1) | VARCHAR2(1) NOT NULL |
Category of Income
1=Salary/Wage 2=Annual Bonus 3=Severance |
13 | GPCN_INC_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL | Income category |
14 | GPCN_EMP_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Employee Type
1=Local Employee Only 2=Expatriate Only 3=Intern Employee Only 4=All |
15 | GPCN_OUTPUT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Output Option.
1=Summary 2=Detail 3=Both |
16 | GPCN_FILING_DT | Date(10) | DATE | This field will give the date on filling the reports. |
17 | GPCN_FILLING_DAY | Character(2) | VARCHAR2(2) NOT NULL | Day of the filling date of tax. |
18 | GPCN_FILLING_MONTH | Character(2) | VARCHAR2(2) NOT NULL | Month of the filling date of tax. |
19 | GPCN_FILLING_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Year of the filling date of tax. |
20 | GPCN_PAYMNT_DT | Date(10) | DATE | Payment date |
21 | GPCN_PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
GP China Pay Entity
Prompt Table: GPCN_PYENT_VW |
22 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
23 | GPCN_TAXSORT_KEY1 | Character(1) | VARCHAR2(1) NOT NULL |
Tax Sort Key 1
0=Not Applicable 1=Pay Group 2=Employee Number 3=Employee Name Default Value: 0 |
24 | GPCN_TAXSORT_KEY2 | Character(1) | VARCHAR2(1) NOT NULL |
Tax Sort Key 2
0=Not Applicable 1=Pay Group 2=Employee Number 3=Employee Name Default Value: 0 |
25 | GPCN_TAXSORT_KEY3 | Character(1) | VARCHAR2(1) NOT NULL |
Tax Sort Key 3
0=Not Applicable 1=Pay Group 2=Employee Number 3=Employee Name Default Value: 0 |
26 | DYNAMIC_SQL | Character(100) | VARCHAR2(100) NOT NULL | Dynamic SQL |
27 | DYNAMIC_SQL_IMP | Character(200) | VARCHAR2(200) NOT NULL | Dynamic SQL |
28 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |