EOEP_LIST_RCNTL

(SQL Table)
Index Back

Price List Extract

The record is used to request the price list to download to Excel.

# 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 This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_NONVW

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

5 DATE_SEL_DT Date(10) DATE 03/23/2004 SFC Added PROD_COST_EFF_DT label

Default Value: %date

6 DATE_IN_EFFECT Date(10) DATE NOT NULL 01/27/2000 RML Added "As of date" label

Default Value: %date

7 PRICE_LIST_ID_FLG Character(1) VARCHAR2(1) NOT NULL Price List ID flag for the pricing engine.
N=All Price Lists
Y=Single Price List

Y/N Table Edit

Default Value: N

8 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

Prompt Table: EOEP_PRLSTID_VW

9 CURRENCY_PLST_FLG Character(1) VARCHAR2(1) NOT NULL 03/23/2004 SFC Deleted SELECTCURRENCYCODE Modified XLAT
N=All Currencies
Y=Single Currency Code

Y/N Table Edit

Default Value: N

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

Prompt Table: %EDITTABLE

11 CURRENCY_CD_PLST Character(3) VARCHAR2(3) NOT NULL Convert Currency To

Prompt Table: CURRENCY_CD_TBL

12 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL

13 CUR_EFFDT Date(10) DATE NOT NULL Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

Default Value: %date