ORD_PRICE_ADJST(SQL Table) |
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. Date Initials Issue Description 090601 dms 8.4 Add merch_type 101201 ept DI-MVANWINK Modularized pricing. Removed 16 price-by key fieldnames. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | SCHED_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 6 | ADJUST_TAKEN | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Applied
Y/N Table Edit |
| 7 | ADJUSTMENT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment Percent |
| 8 | BREAK_ID | Number(10,0) | DECIMAL(10) NOT NULL | Price Break ID |
| 9 | BREAK_QTY_LOW | Number(15,4) | DECIMAL(14,4) NOT NULL | Low Quantity/Amount |
| 10 | BREAK_QTY_HIGH | Number(15,4) | DECIMAL(14,4) NOT NULL | Upper Quantity/Amount |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 12 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 13 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 14 | DATE_END | Date(10) | DATE | End Date |
| 15 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Merchandising Type |
| 16 | OM_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 17 | OM_ADJST_AMT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount (Base) |
| 18 | OM_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 19 | OM_AMOUNT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 20 | ORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Total Order Flag |
| 21 | PPRC_ADJUST_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Pricing adjustment type
AC=Bill Back OI=Off-Invoice Default Value: OI |
| 22 | PPRC_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Key code |
| 23 | PPRC_PTD_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine if Period-to-date Totals should be used in Price Set Break select
Y/N Table Edit Default Value: N |
| 24 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 25 | PRICE_ADJST_REASON | Character(10) | VARCHAR2(10) NOT NULL | Price Adjustment Reason |
| 26 | PRICE_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 27 | PRICE_PROGRAM | Character(6) | VARCHAR2(6) NOT NULL | Exclusive Pricing ID |
| 28 | PRICE_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Price Rule Code |
| 29 | PRICE_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Price Set ID |
| 30 | PRICE_SET_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Price Set Type
99=Standard Discount A=Replacement Price F=Cascading S=Summed Adjustments Z=Product Giveaway |
| 31 | PRICE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price Q=Quantity V=Volume W=Weight |
| 32 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |
| 33 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 34 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 35 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 36 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 37 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |