OPRIDRUN_CNTL_IDDefault Value: PRCSRUNCNTL.LANGUAGE_CD
O=Specified Language
R=Recipient's Language
Default Value: O
Prompt Table: COMPANY_TBL
1=Employee
2=Tax Reduction
Default Value: 1
GPNL_RC_RED(SQL Table) |
Index Back |
|---|---|
Reductions Report RunThis record is used as run control for the reductions report (AFDRACHT VERMINDERINGEN). |
| # | 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
Default Value: PRCSRUNCNTL.LANGUAGE_CD |
| 4 | LANGUAGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language R=Recipient's Language Default Value: O |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 6 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 7 | END_DT | Date(10) | DATE NOT NULL | end date |
| 8 | GPNL_RED_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Print Order
1=Employee 2=Tax Reduction Default Value: 1 |