EMPLIDPrompt Table:
PERSONAL_DATA
Set Control Field: EMPLID
PV_CC_REQUEST_NUMPrompt Table: CC_CARD_TBL_VW
Prompt Table: GL_ACCT_ALL_VW
Prompt Table: CURRENCY_CD_TBL
C=Complete
E=Errors
N=Initialize
P=In Process
CC_RQSTHIST_VW(SQL View) |
Index Back |
|---|---|
P-Card Request TableThis Table is used to store requests for a Procurement Card |
| %SelectAll(PV_CC_REQUEST) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | PV_CC_REQUEST_NUM |
Character(3) | VARCHAR2(3) NOT NULL | Request Number |
| 4 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL |
Corporate Card Vendor
Prompt Table: CC_CARD_TBL_VW |
| 5 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_ALL_VW |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | LIMIT_PO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Limit Per PO |
| 8 | LIMIT_CYCLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Limit Per Pay Cycle |
| 9 | NBR_PO_PER_DAY | Number(5,0) | INTEGER NOT NULL | Nbr of Transactions Per Day |
| 10 | NBR_PO_PER_CYCLE | Number(5,0) | INTEGER NOT NULL | Nbr of Transactions Per Cycle |
| 11 | PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete E=Errors N=Initialize P=In Process |