SRM_DB_PGT_PERS

(SQL Table)
Index Back

Pagelet Personalization

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
2 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
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 MAX_ROWS Number(3,0) SMALLINT NOT NULL Maximum Rows retrieved