BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_OM
ORDER_NOEOEP_RULE_IDRECNAMEFIELDNAMEORD_PRCADJHD_DT(SQL View) |
Index Back |
|---|---|
Ord Line Price adjustmentsThis record holds an audit of all price adjustments made to an order line or schedule. Users may access this record to see an audit trail of discounts, surcharges or manual price changes to see how a net unit price has been derived. |
| SELECT DTL.BUSINESS_UNIT , DTL.ORDER_NO , DTL.EOEP_RULE_ID , KFL.RECNAME , KFL.FIELDNAME , DTL.ORDER_INT_LINE_NO , DTL.SCHED_LINE_NBR , DTL.EOEP_CHAR FROM PS_ORD_PRCADJ_DTL DTL , PS_EOEP_KEY_FIELD KFL WHERE KFL.EOEP_KEY_FLD_CD = DTL.EOEP_KEY_FLD_CD AND DTL.ORDER_INT_LINE_NO = 0 AND DTL.SCHED_LINE_NBR = 0 |
| # | 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 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 7 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 8 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |