GPAR_RC_F649(SQL Table) |
Index Back |
---|---|
Form 649 Run ControlForm 649 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 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
4 | GPAR_MIN_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Amount for Form 649 |
5 | DATE_FROM | Date(10) | DATE NOT NULL | Date From |
6 | DATE_TO | Date(10) | DATE NOT NULL | Previous Period Date To |
7 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPAR_CAL_FIN_VW |
8 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GPAR_CALRUN_VW |
9 | 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 |
10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
11 | GPAR_INC_TAX_DDESC | Character(30) | VARCHAR2(30) NOT NULL | Income tax deduction description. |