TD_MERCH_TYPE

(SQL Table)
 Index Back

Merchandising types

  • Related Language Record: TD_MRCH_TYP_LNG

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

    Default Value: OPR_DEF_FS_VW.SETID

    Prompt Table: SP_SETID_NONVW

    2 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 MERCH_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Merchandising Activity type
    C=Consumption
    P=Purchasing

    Default Value: P

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 MERCH_TYPE_SYN Character(2) VARCHAR2(2) NOT NULL Syndicated Merch Type
    DP=Display
    FD=Feature & Display
    FE=Feature
    FS=Frequent Shopper
    TP=Temporary Price Reduction
    9 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

    Prompt Table: DSTCD_DIS_OM_VW

    10 RETURN_FLAG Character(1) VARCHAR2(1) NOT NULL Can be returned

    Y/N Table Edit

    Default Value: TD_SETID_TBL.RETURN_FLAG

    11 INSERT_COST Number(15,4) DECIMAL(14,4) NOT NULL Insertion Costs
    12 REDEMPTION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Redemption Percent
    13 COUPON_CD Character(10) VARCHAR2(10) NOT NULL Coupon Code
    14 UNIT_VALUE Number(15,4) DECIMAL(14,4) NOT NULL Unit Value
    15 UNIT_HANDLING Number(15,4) DECIMAL(14,4) NOT NULL Unit Handling Cost
    16 LUMPSUM_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Lump Sum Cost
    17 OVERHEAD_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Overhead Cost
    18 TD_ADJUST_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Type
    AC=Bill Back
    GV=Giveaway
    LS=Lump Sum
    OI=Off-Invoice
    19 EOEP_MAX_QUANTITY Number(16,4) DECIMAL(15,4) NOT NULL Max Quantity
    20 EOEP_MEPR_FLG Character(1) VARCHAR2(1) NOT NULL Mutually Exclusive Pricing Rule
    N=No
    Y=Yes
    21 EOEP_ADJ_METHOD Character(1) VARCHAR2(1) NOT NULL Adjustment Method
    1=Cascading
    2=Summed
    22 PAYMENT_METHOD_PL Character(1) VARCHAR2(1) NOT NULL Planned Payment Method
    1=Deduction
    2=Check
    3=Field Draft
    4=Credit Memo
    6=Chargeback
    23 PRICE_TYPE Character(2) VARCHAR2(2) NOT NULL Price Type
    P=Extended Price
    Q=Quantity
    V=Volume
    W=Weight
    24 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
    25 EOEP_ONETIME_FLG Character(1) VARCHAR2(1) NOT NULL One-Time Flag
    1=No
    2=Per Customer
    3=Per Rule
    26 EOEP_TIERED_FLG Character(1) VARCHAR2(1) NOT NULL Tiered Pricing Flag
    N=No
    Y=Yes
    27 EOEP_TIERED_INCRE Signed Number(19,4) DECIMAL(17,4) NOT NULL Numeric Value
    28 EOEP_PTD_FLG Character(1) VARCHAR2(1) NOT NULL Period To Date flag
    N=No
    R=By Rule
    Y=By Customer
    29 EOEP_BAUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use with buying agreement.
    N=No
    Y=Yes
    30 EOEP_COSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use cost.
    N=No
    Y=Yes
    31 EOEP_ALTCSTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply to alternate cost base.
    N=No
    Y=Yes
    32 EOEP_LISTUSE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether to use list price.
    N=No
    Y=Yes
    33 FG_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity/BOGO Factor
    34 TD_FG_PCT_AMT_TYPE Character(1) VARCHAR2(1) NOT NULL Product Add Percent/Amount
    A=Amount
    P=Percent
    35 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
    36 TD_RMA_FLG Character(1) VARCHAR2(1) NOT NULL Applicable to RMA
    N=No
    Y=Yes
    37 EOEP_PRC_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Indicate what to use to match price break
    B=Base Price
    N=Net Price
    38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: TD_SETID_TBL.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    39 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.

    Default Value: TD_SETID_TBL.RT_TYPE

    Prompt Table: RT_TYPE_TBL

    40 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_SETID_TBL.UNIT_OF_MEASURE

    Prompt Table: UNITS_TBL