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