PO_ER_SHIP_COM (SQL Table)	Index Back
PO Expected Rct Sch Comments

PO_ER_SHIP_COM

(SQL Table)

PO Expected Rct Sch Comments

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

6 CMMT_NBR Number(4,0) SMALLINT NOT NULL Comment Number

7 COMMENTS_2000 Long Character CLOB Comment Text

8 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

9 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
6	CMMT_NBR	Number(4,0)	SMALLINT NOT NULL	Comment Number
7	COMMENTS_2000	Long Character	CLOB	Comment Text
8	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
9	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values