EOEP_PRCLST_ERR

(SQL Table)
Index Back

Price List Detail Error

Price List Detail error table. This table will contain errors during the upgrade processing UPG_EOEP8488.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

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

Prompt Table: EOEP_PRICE_LIST

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PRICSET_PROD_VW

5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: PROD_UOM

6 START_DT Date(10) DATE Start Date
7 PW_FREQUENCY Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
00=Daily
05=Weekly
10=Monthly
15=Quarterly
20=Annually
8 RECURRING_FLG Character(1) VARCHAR2(1) NOT NULL Recurring Flag
N=No
Y=Yes
9 EFFDT Date(10) DATE Effective Date

Default Value: %date

10 END_DATE Date(10) DATE End Date
11 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

12 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
13 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected

Y/N Table Edit

Default Value: N

14 START_DT_ORIGVALUE Date(10) DATE Start date original value
15 EOEP_START_DT Date(10) DATE Start Date
16 EOEP_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
17 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID