SRM_DB_SCH_FLDS(SQL Table) |
Index Back |
---|---|
Filter search fields |
# | 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 | SEARCH_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Search Field |