| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: PPRC_PROMO_TBL.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
Default Value: PPRC_PROMO_TBL.PPRC_PROMO_CD
Prompt Table:
PPRC_PROMO_TBL
Set Control Field: SETID
|
| 3 |
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
Default Value: OI
|
| 4 |
PAYMENT_METHOD_PL |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned Payment Method
1=Deduction
2=Check
3=Field Draft
4=Credit Memo
6=Chargeback
Default Value: 2
|
| 5 |
RETURN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be returned
Y/N Table Edit
Default Value: TD_SETID_TBL.RETURN_FLAG
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PPRC_PROMO_TBL.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 7 |
TD_INT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Status
A=Not Applicable
C=Changed
D=Deleted
M=Complete
N=New
Default Value: N
|
| 8 |
PRICE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Price Type
P=Extended Price
Q=Quantity
V=Volume
W=Weight
Default Value: TD_SETID_TBL.PRICE_TYPE
|
| 9 |
EOEP_ACTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge
10=CRM Free Period Promotion
11=CRM Product Add
12=Pricing Base
13=Rollup Only Rule
14=Min/Max Margin
2=Price Override
3=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
Default Value: TD_SETID_TBL.EOEP_ACTION_TYPE
|
| 10 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
Default Value: TD_SETID_TBL.EOEP_ADJ_METHOD
|
| 11 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 12 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Default Value: PPRC_PROMO_TBL.DST_ID
Prompt Table:
DSTCD_DIS_OM_VW
|
| 13 |
EOEP_ONETIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
One-Time Flag
1=No
2=Per Customer
3=Per Rule
Default Value: 1
|
| 14 |
EOEP_TIERED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tiered Pricing Flag
N=No
Y=Yes
Default Value: N
|
| 15 |
EOEP_TIERED_INCRE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
Default Value: 1
|
| 16 |
EOEP_MEPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mutually Exclusive Pricing Rule
N=No
Y=Yes
Default Value: N
|
| 17 |
EOEP_MAX_QUANTITY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Max Quantity
Default Value: 0
|
| 18 |
EOEP_PTD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Period To Date flag
N=No
R=By Rule
Y=By Customer
Default Value: N
|
| 19 |
EOEP_BAUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use with buying agreement.
N=No
Y=Yes
Default Value: TD_SETID_TBL.EOEP_BAUSE_FLG
|
| 20 |
EOEP_COSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use cost.
N=No
Y=Yes
Default Value: TD_SETID_TBL.EOEP_COSTUSE_FLG
|
| 21 |
EOEP_ALTCSTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to apply to alternate cost base.
N=No
Y=Yes
Default Value: TD_SETID_TBL.EOEP_ALTCSTUSE_FLG
|
| 22 |
EOEP_LISTUSE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether to use list price.
N=No
Y=Yes
Default Value: TD_SETID_TBL.EOEP_LISTUSE_FLG
|
| 23 |
TD_RMA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicable to RMA
N=No
Y=Yes
Default Value: TD_SETID_TBL.TD_RMA_FLG
|
| 24 |
EOEP_PRC_MATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate what to use to match price break
B=Base Price
N=Net Price
Default Value: B
|