OM_PRCSPADJ_TAO(SQL Table) |
Index Back |
|---|---|
Ord Line Price adjustments tmpThis is the order line price adjustment temp table used on AE OM_BACKGRND4 program. This 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. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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 |
| 4 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 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 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 12 | CARRIER_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Carrier ID |
| 13 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 16 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 17 | 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. |
| 18 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 19 | DATE_END | Date(10) | DATE | End Date |
| 20 | EOEP_ADJUST_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back AMT=Amount OI=Off-Invoice OVR=Price Override PCT=Percent |
| 21 | EOEP_ARB_ID | Character(10) | VARCHAR2(10) NOT NULL | Arbitration Plan |
| 22 | EOEP_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Price Rule Key Code |
| 23 | EOEP_RULE_ID | Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 24 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 25 | FREIGHT_TERMS_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Freight Terms Code |
| 26 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 27 | OM_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Order Adjustment Amount |
| 28 | OM_ADJST_AMT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount (Base) |
| 29 | OM_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 30 | OM_AMOUNT_BSE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Amount |
| 31 | ORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Total Order Flag |
| 32 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 33 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 34 | PRICE_ADJST_REASON | Character(10) | VARCHAR2(10) NOT NULL | Price Adjustment Reason |
| 35 | PRICE_BASE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Net Unit Price (base) |
| 36 | PRICE_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL | Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL |
| 37 | PRICE_SET_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Price Set Type
99=Standard Discount A=Price Override F=Cascading S=Summed Adjustments Z=Giveaway |
| 38 | PRICE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Price Type
P=Extended Price Q=Quantity V=Volume W=Weight |
| 39 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 40 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 41 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |
| 42 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 43 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 44 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 45 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 46 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 47 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship Via Code |
| 48 | SHIP_TYPE_ID_EXP | Character(10) | VARCHAR2(10) NOT NULL | Export Shipping Method |
| 49 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 50 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 51 | 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. |
| 52 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |