|
SELECT SETID , PPRC_PROMO_CD , CUST_ID , MERCH_TYPE , SEQNO , METRICS , CURRENCY_CD , BREAK_QTY_LOW , BREAK_QTY_HIGH , UNIT_OF_MEASURE , TD_PCT_AMT_TYPE , DISCOUNT , FG_PRODUCT_ID , FG_UOM , FG_QUANTITY , TD_FG_PCT_AMT_TYPE , FG_DISCOUNT , FG_PRICE , EOEP_ADJST_FLG , EOEP_VAR_TYPE FROM PS_TD_PRO_MERBRK_C
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: TD_PRO_MERC_CUS.SETID
Prompt Table:
SP_SETTD_NONVW
|
| 2 |
TO_PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
To Promotion Code
Default Value: TD_PRO_MERC_CUS.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_PRO_MERC_CUS.CUST_ID
Prompt Table:
%EDITTABLE
|
| 4 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
Default Value: TD_PRO_MERC_CUS.MERCH_TYPE
Prompt Table:
TD_MERCH_TYP_VW
Set Control Field: SETID
|
| 5 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 6 |
METRICS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use For Metrics
Y/N Table Edit
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: TD_PRO_MERC_CUS.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
BREAK_QTY_LOW |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Low Quantity/Amount
Default Value: 1
|
| 9 |
BREAK_QTY_HIGH |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Upper Quantity/Amount
Default Value: 9999999999
|
| 10 |
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_PRO_MERC_CUS.UNIT_OF_MEASURE
Prompt Table:
UNITS_TBL
|
| 11 |
TD_PCT_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent/Amount Type
A=Amount
P=Percent
Default Value: A
|
| 12 |
DISCOUNT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 13 |
FG_PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Add
Prompt Table:
%EDITTABLE7
Set Control Field: SETID
|
| 14 |
FG_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Product Add Unit Of Measure
Prompt Table:
TD_PROD_UOM
Set Control Field: SETID
|
| 15 |
FG_QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity/BOGO Factor
|
| 16 |
TD_FG_PCT_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Add Percent/Amount
A=Amount
P=Percent
Default Value: P
|
| 17 |
FG_DISCOUNT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
Default Value: 100
|
| 18 |
FG_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Product Add Price/Cost
|
| 19 |
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
|
| 20 |
EOEP_VAR_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Pricing Variable Type
01=Base Price
02=Rollup Quantity
03=Rollup Amount
04=Rollup Weight
05=Rollup Volume
06=Net Price
07=List Price
08=Product Cost
09=Index Start Amount
10=Index Start Value
11=Index End Value
12=Trans Extended Base Price
13=Trans Extended List Price
14=Trans Extended Net Price
15=Trans Extended Product Cost
16=Alternate Product Cost
99=User Variable
|