SRM_DB_PGT_PERS(SQL Table) |
Index Back |
---|---|
Pagelet Personalization |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Buyer | |
2 | 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 |