| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
EOEP_APP_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table:
EOEP_APPCD_VW
|
| 3 |
EOEP_TEST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Price Test ID
|
| 4 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 0
|
| 5 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 6 |
EOEP_FORMULA_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pricing Formula ID
|
| 7 |
BREAK_QTY_LOW |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Low Quantity/Amount
|
| 8 |
BREAK_QTY_HIGH |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Upper Quantity/Amount
|
| 9 |
DATE_BEGIN |
Date(10) |
DATE |
Start Date
|
| 10 |
DATE_END |
Date(10) |
DATE |
End Date
|
| 11 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 12 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 13 |
PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
|
| 14 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 15 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=Free Period Promotion
11=Product Add
12=Price Base
13=Rollup Only Rule
14=Min/Max Margin
15=Recurring Discount/Surcharge
2=Price Override
3=Giveaway / Product Add
4=Total Order Discount/Surcharge
5=Min/Max Target Price
6=Min/Max Target Discount
7=Min/Max Target Surcharge
8=Related Busines Objects
9=Price List Only Condition
99=Standard Discount
|
| 16 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
|
| 17 |
EOEP_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back
AMT=Amount
OI=Off-Invoice
OVR=Price Override
PCT=Percent
|
| 18 |
EOEP_ADJUSTMENT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment
|
| 19 |
EOEP_ADJ_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type
AMT=Amount
OVR=Price Override
PCT=Percent
|
| 20 |
EOEP_CHAR |
Character(254) |
VARCHAR2(254) NOT NULL |
Long field
|
| 21 |
EOEP_ADJST_AMT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|
| 22 |
EOEP_DATE_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Date Break
|
| 23 |
EOEP_FORM_BREAK |
Character(30) |
VARCHAR2(30) NOT NULL |
Formula Break
|
| 24 |
EOEP_ADJST_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjustment Flag
01=Amount
02=Percentage
03=Price
04=External Class
05=Math Expression
06=Quantity
07=BOGO Factor
08=Quantity with Price
09=BOGO with Price
10=Quantity Expression
11=Amount And Math Expression
12=Percentage And Math Expression
13=Price And Math Expression
|
| 25 |
EOEP_NUM_VALUE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
|
| 26 |
EOEP_TEXT_VALUE |
Character(254) |
VARCHAR2(254) NOT NULL |
Text Value
|
| 27 |
EOEP_SELSMLG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Small or Large
1=Smaller
2=Larger
|
| 28 |
EOEP_LONG |
Long Character |
CLOB |
Price Rule Definition
|