SRM_DB_FTR_FLDS(SQL Table) |
Index Back |
---|---|
Filter 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 | RECFIELDNAME | Character(34) | VARCHAR2(34) NOT NULL | Field Name |
3 | SRM_DB_FLD_LOGIC | Character(1) | VARCHAR2(1) NOT NULL |
Field Logic Flag
Y/N Table Edit Default Value: N |