OPRIDPrompt Table: SP_BU_AP_NONVW
Prompt Table: SP_BU_AP_NONVW
Default Value: 0
Prompt Table: CURR_TXN_VW
B=Bar Chart
HB=Horizontal Bar
HS=Horizontal Stacked Bar
P=Percentage Stacked Bar
SB=Stacked Bar
Default Value: B
AP_DB_PDUE_PERS(SQL Table) |
Index Back |
|---|---|
AP Metrics Inquiry Work Table |
| # | 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 | FROM_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
From Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 3 | TO_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: SP_BU_AP_NONVW |
| 4 | DAYS_FROM3 | Number(3,0) | SMALLINT NOT NULL |
Over 60 Days Calculation Limit
Default Value: 0 |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURR_TXN_VW |
| 6 | CHART_TYPE_AP | Character(2) | VARCHAR2(2) NOT NULL |
Chart Type
B=Bar Chart HB=Horizontal Bar HS=Horizontal Stacked Bar P=Percentage Stacked Bar SB=Stacked Bar Default Value: B |