GPAR_RC_TAX(SQL Table) |
Index Back |
---|---|
Tax Run ControlTax Run Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
5 | GP_ELN_APP_CNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Application Country
Default Value: ARG |
6 | GP_ELN_APP | Character(15) | VARCHAR2(15) NOT NULL |
ELN Application
Prompt Table: GP_ELN_APP_VW |
7 | DATE_FROM | Date(10) | DATE NOT NULL | Date From |
8 | DATE_TO | Date(10) | DATE NOT NULL | Previous Period Date To |
9 | PRINT_DATE | Date(10) | DATE NOT NULL |
Print Date
Default Value: %DATE |
10 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAR_CAL_FIN_VW |
11 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GPAR_CALRUN_VW |
12 | GPAR_LIST_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Selection type for Form 649 Argentina
1=All Establishments & Payees 2=Select Establishment ID 3=Select Employees 4=Select Group ID 5=Select Pay Group 6=Select Department Default Value: 1 |
13 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL |
Flag1
Y/N Table Edit Default Value: Y |
14 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL |
Flag2
Y/N Table Edit Default Value: N |
15 | RP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Responsible Person Name |
16 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL |
Flag3
Y/N Table Edit |
17 | GPAR_FILE_SEQ | Number(4,0) | SMALLINT NOT NULL |
File Sequence
Default Value: 0 |
18 | GPAR_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Type
1=Annual 2=Final 3=Informative |
19 | GPAR_RECTIF_SEQ | Number(2,0) | SMALLINT NOT NULL |
Rectification Sequence
Default Value: 0 |
20 | GP_GENRPT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Code of the generic report
Prompt Table: GPAR_GENRPT_TBL |