GPCN_TX_RPT_AET

(SQL Table)
Index Back

State record for GPCN_TAX_RPT

State 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