| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: TD_PROMO_CUST.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
Default Value: TD_PROMO_CUST.PPRC_PROMO_CD
Prompt Table:
PPRC_PROMO_TBL
|
| 3 |
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.
Default Value: TD_PROMO_CUST.CUST_ID
Prompt Table:
%EDITTABLE
|
| 4 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
Default Value: TD_PROMO_MERCH.MERCH_TYPE
Prompt Table:
TD_MERCH_ACT_VW
Set Control Field: SETID
|
| 5 |
MERCH_SUB_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Subtype
Default Value: TD_PROMO_MERCH.MERCH_SUB_TYPE
Prompt Table:
TD_MRCH_SACT_VW
Set Control Field: SETID
|
| 6 |
PROMO_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Promotional Group
Default Value: TD_PROMO_CUST.PROMO_GROUP
|
| 7 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Default Value: TD_PROMO_CUST.PRODUCT_ID
Prompt Table:
PROD_ITEM
Set Control Field: SETID
|
| 8 |
TD_ADJUST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Type
AC=Bill Back
GV=Giveaway
LS=Lump Sum
OI=Off-Invoice
Default Value: OI
|
| 9 |
RETURN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be returned
Y/N Table Edit
Default Value: TD_SETID_TBL.RETURN_FLAG
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: TD_PROMO_CUST.CURRENCY_CD
|
| 11 |
MERCH_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Merchandising Cost
|
| 12 |
LUMPSUM_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Lump Sum Cost
|
| 13 |
OVERHEAD_COST |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Overhead Cost
|
| 14 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: TD_PROMO_CUST.UNIT_OF_MEASURE
Prompt Table:
UNITS_TBL
|
| 15 |
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
|
| 16 |
UNIT_VALUE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Unit Value
|
| 17 |
UNITS_REDEEMED |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Units Redeemed
|
| 18 |
UNIT_OF_MEASURE_SL |
Character(3) |
VARCHAR2(3) NOT NULL |
Selling Unit of Measure
Default Value: TD_SETID_TBL.UOM_PER
Prompt Table:
UNITS_TBL
|
| 19 |
UNIT_HANDLING |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Unit Handling Cost
|
| 20 |
REDEMPTION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Redemption Percent
Default Value: 100
|
| 21 |
COUPON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Coupon Code
|
| 22 |
INSERT_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Insertion Costs
|
| 23 |
START_DT |
Date(10) |
DATE |
Start Date
Default Value: TD_PROMO_CUST.FIRST_PERFORM_DT
|
| 24 |
PERFORM_WEEKS |
Number(3,0) |
SMALLINT NOT NULL |
Performance weeks
Default Value: TD_PROMO_CUST.PERFORM_WEEKS
|
| 25 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Default Value: TD_PROMO_CUST.DST_ID
Prompt Table:
DSTCD_DIS_OM_VW
|
| 26 |
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
|
| 27 |
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
|
| 28 |
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
|
| 29 |
EOEP_ADJ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Method
1=Cascading
2=Summed
Default Value: TD_SETID_TBL.EOEP_ADJ_METHOD
|
| 30 |
EOEP_RULE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Price Rule ID
|
| 31 |
CUST_ID2 |
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:
TD_CUST_OPRVW
|
| 32 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 33 |
EOEP_ONETIME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
One-Time Flag
1=No
2=Per Customer
3=Per Rule
Default Value: 1
|
| 34 |
EOEP_TIERED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tiered Pricing Flag
N=No
Y=Yes
Default Value: N
|
| 35 |
EOEP_TIERED_INCRE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Numeric Value
Default Value: 1
|
| 36 |
EOEP_MEPR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mutually Exclusive Pricing Rule
N=No
Y=Yes
Default Value: N
|
| 37 |
EOEP_MAX_QUANTITY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Max Quantity
Default Value: 0
|
| 38 |
EOEP_PTD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Period To Date flag
N=No
R=By Rule
Y=By Customer
Default Value: N
|
| 39 |
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
|
| 40 |
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
|
| 41 |
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
|
| 42 |
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
|
| 43 |
NUM_OF_ORDERS |
Number(7,0) |
INTEGER NOT NULL |
Number of Orders
Default Value: 1
|
| 44 |
TD_RMA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicable to RMA
N=No
Y=Yes
Default Value: TD_SETID_TBL.TD_RMA_FLG
|
| 45 |
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
|