RO_PRC_PROD_HST(SQL Table) |
Index Back |
|---|---|
Product Adds on orderList the product add rules that were applieds to an order from pricing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Field use to store the capture ID in order capture. |
| 4 | UID20 |
Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 5 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 6 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | This field represents the integer Order Line Number. |
| 7 | EOEP_FORMULA_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pricing Formula ID |
| 8 | EOEP_ACTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Action Type
1=Discount/Surcharge 10=Free Period Promotion 11=Product Add 12=Price Base 13=Rollup Only Rule 14=Min/Max Margin 15=Recurring Discount/Surcharge 2=Price Override 3=Giveaway / 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 |
| 9 | PRODUCT_ID_PROMO | Character(18) | VARCHAR2(18) NOT NULL | Product ID Promotion |
| 10 | UOM_PROMO | Character(4) | VARCHAR2(4) NOT NULL | Unit of Measure (promo prod) |
| 11 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |