TD_PRO_MRCH_TMP(SQL Table) |
Index Back |
|---|---|
Promotion Forecast Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |
| 5 | 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. |
| 6 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Merchandising Type |
| 7 | MERCH_SUB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Merchandising Subtype |
| 8 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 9 | PROMO_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Promotional Group |
| 10 | TD_ADJUST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type
AC=Bill Back GV=Giveaway LS=Lump Sum OI=Off-Invoice |
| 11 | MERCH_ACTIVITY | Character(1) | VARCHAR2(1) NOT NULL |
Merchandising Activity type
C=Consumption P=Purchasing |
| 12 | 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 |
| 13 | DISCOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 14 | LUMPSUM_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Lump Sum Cost |
| 15 | FG_PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product Add |
| 16 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 17 | REF_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Referenced Inv Item ID |
| 18 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 19 | FG_UOM | Character(3) | VARCHAR2(3) NOT NULL | Product Add Unit Of Measure |
| 20 | FG_QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity/BOGO Factor |
| 21 | UNIT_VALUE | Number(15,4) | DECIMAL(14,4) NOT NULL | Unit Value |
| 22 | 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 |
| 23 | EOEP_MAX_QUANTITY | Number(16,4) | DECIMAL(15,4) NOT NULL | Max Quantity |
| 24 | FG_DISCOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |