| # |
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 |
DISPLAY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 3 |
DSP_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 4 |
RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Rate index
|
| 5 |
BU_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Units
A=All
S=Specific
Default Value: A
|
| 6 |
CUST_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Select Flag
A=All
G=Customer Groups
S=Specific
Default Value: A
|
| 7 |
CUST_LEVEL_QRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Level
C=Corporate
N=No Relationship
P=Correspondence
R=Remit From
Default Value: N
|
| 8 |
BLK_CUST_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Blank Customer Group
N=NO
Y=YES
Default Value: N
|
| 9 |
RESP_PART_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
RESP_PART_OPT
A=AR Specialist
B=Broker
C=Collector
R=Credit Analyst
S=Sales Person
Default Value: C
|
| 10 |
RESP_TOP5_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
RESP_TOP5_FLG
A=All
S=Specific
T=Top Five
Default Value: T
|
| 11 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 12 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETCU_NONVW
|
| 13 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|