Used to display line changes from current PO to last dispatched PO.

PO_SSLNCNG_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
2 FIELD_DESCR1 Character(30) VARCHAR2(30) NOT NULL Field Description
3 FIELD_VALUE_CHAR1 Character(254) VARCHAR2(254) NOT NULL Original Value
4 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
5 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b
6 CHNG_DTTM DateTime(26) TIMESTAMP Change Request Date/Time
7 ORIG_DUE_TIME Time(15) TIMESTAMP Original Time Due
8 CHNG_CHAR_VALUE Character(254) VARCHAR2(254) NOT NULL New Field Value
9 CHNG_NBR_VALUE Signed Number(30,5) DECIMAL(28,5) NOT NULL New Numeric Value
10 CHNG_DATE_VALUE Date(10) DATE New Date Value
11 CHNG_DTTM_VALUE DateTime(26) TIMESTAMP Change Date/Time Value
12 CHNG_TIME_VALUE Time(15) TIMESTAMP Change Time Value