PRODUCT_OE0=Prior x Days
1=Specify Date Range
OPI_SYSCFG_TBL1(SQL Table) |
Index Back |
|---|---|
OE MV Data length Config TableOE MV Data length Config Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRODUCT_OE |
Character(6) | VARCHAR2(6) NOT NULL | Product |
| 2 | GLOP_DTSEL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Date Selection
0=Prior x Days 1=Specify Date Range |
| 3 | FROM_DT | Date(10) | DATE | From Date |
| 4 | TO_DT | Date(10) | DATE | To Date |
| 5 | NUM_OF_DAYS | Number(5,0) | INTEGER NOT NULL | Payments in Last (Days) |
| 6 | CURRENT_DATE1 | Date(10) | DATE | 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label |