PO_HDR_STG_EML (SQL Table)	Index Back
PO Dispatch Email IDs

PO_HDR_STG_EML

(SQL Table)

PO Dispatch Email IDs

Parent record: PO_HDR_STG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: PO_HDR_STG.PROCESS_INSTANCE

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PO_HDR_STG.BUSINESS_UNIT

3 PO_STG_TYPE Character(1) VARCHAR2(1) NOT NULL Used in conjunction with PO_STG_ID to make a unique key on the stage tables.
O=Other
R=Requisition
Default Value: O

4 PO_STG_ID Character(10) VARCHAR2(10) NOT NULL Uniqye key to the PO Staging table

5 EMAIL_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
BB=Blackberry
BUS=Business
D=Dispatch
HOME=Home
N=Notification
OTH=Other
WORK=Work
Default Value: D

6 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

7 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Prompt Table: PO_HDR_VW1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: PO_HDR_STG.PROCESS_INSTANCE
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PO_HDR_STG.BUSINESS_UNIT
3	PO_STG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Used in conjunction with PO_STG_ID to make a unique key on the stage tables. O=Other R=Requisition Default Value: O
4	PO_STG_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniqye key to the PO Staging table
5	EMAIL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Email Type BB=Blackberry BUS=Business D=Dispatch HOME=Home N=Notification OTH=Other WORK=Work Default Value: D
6	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
7	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Prompt Table: PO_HDR_VW1