| # |
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 |
BU_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Units
A=All
S=Specific
Default Value: A
|
| 3 |
ARFO_DT_RANGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Range Option
D=Prior 'x' Days
F=Specific Date Range
Default Value: D
|
| 4 |
PRIOR_RANGE |
Number(4,0) |
SMALLINT NOT NULL |
Prior Range
Default Value: 90
|
| 5 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 6 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 7 |
DISPLAY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
DSP_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 9 |
RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Rate index
|
| 10 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETCU_NONVW
|
| 11 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
AR_CUSTSCHC_VW
|
| 12 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 13 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 14 |
CUST_SELECT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Select Flag
A=All
G=Customer Groups
S=Specific
Default Value: A
|
| 15 |
CUST_LEVEL_QRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Level
C=Corporate
N=No Relationship
P=Correspondence
R=Remit From
Default Value: N
|
| 16 |
BLK_CUST_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Blank Customer Group
N=NO
Y=YES
Default Value: N
|
| 17 |
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
|
| 18 |
RESP_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Flag
A=All
S=Specific
Default Value: A
|