| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 4 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
Prompt Table:
CC_CARD_TBL_VW
|
| 5 |
BILLING_DATE |
Date(10) |
DATE NOT NULL |
Billing Date
Prompt Table:
CC_BILLDATE_VW
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
CC_BUPROMPT_VW
|
| 7 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 8 |
CC_VCHRSTG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Vouchers
1=By Business Unit
2=By Credit Card Number
Default Value: 1
|
| 9 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 10 |
MAX_VOUCHER_LINE |
Number(5,0) |
INTEGER NOT NULL |
Max Voucher Lines
Default Value: INSTALLATION_PO.MAX_VOUCHER_LINE
|
| 11 |
IGNORE_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status Criteria
N=Approved Status
Y=Any Status Except Closed
Default Value: N
|
| 12 |
IGNORE_BUDGET |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Status Criteria
N=Valid Budget Status
Y=Any Budget Status
Default Value: N
|
| 13 |
IGNORE_CHARTFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield Status Criteria
N=Valid Chartfield Status
Y=Any Chartfield Status
Default Value: N
|
| 14 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 15 |
CC_INVOICE_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date to Use
1=Billing Date
2=Enter Date
3=Today
|
| 16 |
INVOICE_DT |
Date(10) |
DATE NOT NULL |
Invoice Date
|