| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 3 |
PRINT_LISTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Listing
Y/N Table Edit
Default Value: N
|
| 4 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 5 |
OUTDESTTYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
Default Value: 3
|
| 6 |
OUTPUTDEST |
Character(127) |
VARCHAR2(127) NOT NULL |
Output Destination
|
| 7 |
SETID_FAX |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 8 |
FAX_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Fax Location
Prompt Table:
FAX_LOCATION
Set Control Field: SETID_FAX
|
| 9 |
BI_JOB_RUN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Job Run Option
1=Print/Load
2=No Load
Default Value: 1
|
| 10 |
PYMNT_METHOD_SS |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment method for self-service.
CC=Credit Card
DD=Direct Debit
EC=Electronic Check
PL=PayPal
Default Value: CC
|
| 11 |
MAX_IVC_ROWS_SS |
Number(3,0) |
SMALLINT NOT NULL |
Show me my latest
Default Value: 5
|
| 12 |
ORDER_FOCUS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Information
Y/N Table Edit
Default Value: N
|
| 13 |
CONTRACT_FOCUS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Information
Y/N Table Edit
Default Value: N
|
| 14 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 15 |
DFLT_BILL_TO_CUST |
Character(15) |
VARCHAR2(15) NOT NULL |
.
|
| 16 |
IVC_NUM_OF_DAYS |
Number(5,0) |
INTEGER NOT NULL |
Bills in Last (Days)
Default Value: 365
|
| 17 |
EB_PAID_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Paid Status
1=Not Yet Paid/Applied
2=Paid/Applied
|