PO_CHNG_L_WRK1

(SQL Table)
Index Back

PO Change Line Work

# 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

5 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
6 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
7 INSERT_STATUS Character(1) VARCHAR2(1) NOT NULL Insert Status
I=Inserted Record

Default Value: N

8 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
9 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
10 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
11 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
14 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
15 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
16 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
17 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
18 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
19 RFQ_LINE_NBR Number(5,0) INTEGER NOT NULL RFQ Line
20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
21 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number