BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_OM
ORDER_NOORDER_INT_LINE_NOORD_PRC_GIVE_VW(SQL View) |
Index Back |
|---|---|
Price Adjst for GiveawaysThis view holds the order price adjustments for giveaway type price rules ids. |
| SELECT DISTINCT L.BUSINESS_UNIT , L.ORDER_NO , L.ORDER_INT_LINE_NO , L.ORD_LINE_TAG , A.EOEP_RULE_ID , A.EOEP_FORMULA_ID , A.QTY_ORDERED FROM PS_ORD_LINE L , PS_ORD_PRICE_ADJST A WHERE L.BUSINESS_UNIT = A.BUSINESS_UNIT AND L.ORDER_NO = A.ORDER_NO AND L.ORDER_INT_LINE_NO = A.ORDER_INT_LINE_NO AND L.ORD_LINE_TAG > 0 AND A.EOEP_ACTION_TYPE = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_OM |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | ORD_LINE_TAG | Number(5,0) | INTEGER NOT NULL | Order Line tag line nbr |
| 5 | EOEP_RULE_ID | Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 6 | EOEP_FORMULA_ID | Number(10,0) | DECIMAL(10) NOT NULL | Pricing Formula ID |
| 7 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |