PL_SO_OMDTE_VW

(SQL View)
 Index Back

pl/om sales order date chgs

06/03/99 jnw (cn#pl800-26) created record 09/29/99 cel (PL800-32.0) added fields pl_display_nm, ep_group_code, response_agent, planning_timstamp 03/01/220 JNW (PL900-1.0) release 9 field changes

SELECT BUSINESS_UNIT_OM , SHIP_FROM_BU , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , ORDER_TYPE_CD , PRODUCT_ID , PL_SCHED_SHIP_DTTM , SCHED_SHIP_DTTM , SHIP_TO_CUST_ID , QTY_SCHEDULED , ORD_SCH_STATUS , REQ_SHIP_DTTM , CONFIG_CODE , FROZEN_CD FROM PS_PL_SO_OMDTE_CHG WHERE ORDER_TYPE_CD = 'SO' OR ORDER_TYPE_CD = 'QUO'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
2 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
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 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
5 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
6 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
8 PL_SCHED_SHIP_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
9 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
10 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
11 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled
12 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
13 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
14 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
15 FROZEN_CD Character(1) VARCHAR2(1) NOT NULL Frozen code
1=Change from unfrozen to frozen
2=Change from frozen to unfrozen
3=No Change