PL_BA_EXCEP_VW

(SQL View)
 Index Back

PL/OM date change exceptions

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

SELECT SHIP_FROM_BU , SETID , CNTRCT_ID , 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 = 'BA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
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