| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
TILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Tile Id
Prompt Table:
PO_TILES
|
| 3 |
REPORT_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Reporting Entity ID
Default Value: OPR_DEF_RPT.REPORT_ENTITY
|
| 4 |
PO_ITEM_CAT_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Items / Categories
C=Specify Categories
I=Specify Items
N=Show All
Default Value: N
|
| 5 |
BUYER_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Buyers
E=Show All
N=Show All
S=Specify Buyer
Y=Specify Buyers
Default Value: N
|
| 6 |
BU_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Units
E=Show All
N=Show All
S=Specify Business Unit
Y=Specify Business Units
Default Value: N
|
| 7 |
SHIPTO_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship To Locations
N=Show All
Y=Specify Ship To Locations
Default Value: N
|
| 8 |
SUPPLIER_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppliers
N=Show All
Y=Specify Suppliers
Default Value: N
|
| 9 |
AMT_NONCNTSPD_OVR |
Number(15,3) |
DECIMAL(14,3) NOT NULL |
Non Contract Spend Over
|
| 10 |
AMT_NONEDIPO_OVER |
Number(15,3) |
DECIMAL(14,3) NOT NULL |
Non EDI POs Over
|
| 11 |
DAYS_CNTRCT_EXP |
Number(5,0) |
INTEGER NOT NULL |
Days Contracts Due to Expire
|
| 12 |
DAYS_POAPPR_CYC |
Number(5,0) |
INTEGER NOT NULL |
PO Approval Cycle Time Over
|
| 13 |
DAYS_POBACKORD |
Number(5,0) |
INTEGER NOT NULL |
POs Backordered Days Over
|
| 14 |
DAYS_PODISP_CYC |
Number(5,0) |
INTEGER NOT NULL |
PO Dispatch Cycle Time Over
|
| 15 |
DAYS_REQAPPR_CYC |
Number(5,0) |
INTEGER NOT NULL |
Req Approval Cycle Time Over
|
| 16 |
DAYS_REQPO_CYC |
Number(5,0) |
INTEGER NOT NULL |
Req to PO Cycle Time Days Over
|
| 17 |
SEL_CNTRCT_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Contracts Due to Expire Soon
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 18 |
SEL_CNTRCT_SPND |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Spend on PO
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 19 |
SEL_NBR_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Contracts
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 20 |
SEL_NBR_PO_PERDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of POs Period to Date
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 21 |
SEL_NONCNTSPD_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Contract Spend Over Amount
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 22 |
SEL_NONEDIPO_OVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Non EDI POs Over Amount
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 23 |
SEL_PERDT_POSPND |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Period to Date PO Spend
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 24 |
SEL_POAPPR_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Approval Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 25 |
NUM_BID_INVI |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Bidder Invitations
Default Value: Y
|
| 26 |
NUM_BID_PARTICI |
Character(1) |
VARCHAR2(1) NOT NULL |
Participant Percentage
Default Value: Y
|
| 27 |
AWARD_PERCENTAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Percentage
Default Value: Y
|
| 28 |
SEL_POBACK_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
POs Backordered Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 29 |
SEL_PODISP_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Dispatch Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 30 |
SEL_REQPO_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
Req to PO Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 31 |
SEL_VOL_EDI_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Volume of EDI POs
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: Y
|