PL_SO_EXCEP_VW

(SQL View)
 Index Back

PL/OM date change exceptions

06/03/99 jnw (cn#pl800-26) created record

SELECT BUSINESS_UNIT_OM , SHIP_FROM_BU , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , KIT_LINE_NBR , MESSAGE_SET_NBR , MESSAGE_NBR , ORDER_TYPE_CD , PL_SCHED_SHIP_DTTM , SCHED_SHIP_DTTM , PRODUCT_ID , INV_ITEM_ID , PEG_STATUS , CONFIG_CODE FROM PS_PL_SO_EXCEP 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

Prompt Table: SP_BU_OM_NONVW

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 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
9 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
10 PL_SCHED_SHIP_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
11 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
12 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
15 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator