SRM_DB_FTR_SYS(SQL Table) |
Index Back |
|---|---|
Filter System Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SRM_DB_PGLT_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Paglet Id
CATG=Spend by Category CPCT=Contract Spend By Period DSPO=Dispatched Purchase Orders MCAT=Manger Spend by Category MPCT=Manger Percent Contract Spend MPOD=Manager Spend By PO Date MTTL=Manger Spend by Sched MVSP=Manger Spend By Supplier ODPO=Overdue Purchase Orders POAS=PO Acknowledgement Status PODT=Spend By PO Date RASN=Review ASN RTBS=Requisitions to be Sourced SPCT=Spend By Percent STTL=Spend By Schedule VSPD=Spend by Supplier |
| 2 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 3 | ORDERBY | Character(254) | VARCHAR2(254) NOT NULL | ORDER BY |
| 4 | MAX_ROWS | Number(3,0) | SMALLINT NOT NULL | Maximum Rows retrieved |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | SRM_DB_LST_LBL | Character(50) | VARCHAR2(50) NOT NULL | Pagelet List Lable |