PELL_MRR_SRCH (SQL View)	Index Back
99-00 Pell In Srch Rec Pell Inbound Search record for 99-00

PELL_MRR_SRCH

(SQL View)

99-00 Pell In Srch Rec

Pell Inbound Search record for 99-00

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , PG_BATCH_ID_00 , OPRID , PELL_TRANS_DTTM FROM PS_PG_HDR_00_EC WHERE ECTRANSID='PGMR00OP' OR ECTRANSID='PGMR01OP' OR ECTRANSID='PGMR02OP' OR ECTRANSID='PGMR03OP' OR ECTRANSID='PGMR04OP' OR ECTRANSID='PGMR05OP' OR ECTRANSID='PGMR06OP' OR ECTRANSID='PGMR07OP' OR ECTRANSID='PGMR08OP' OR ECTRANSID='PGMR09OP' OR ECTRANSID='PGMR10OP' OR ECTRANSID='PGMR11OP' OR ECTRANSID='PGMR12OP' OR ECTRANSID='PGMR13OP' OR ECTRANSID='PGMR14OP' OR ECTRANSID='PGMR15OP' OR ECTRANSID='PGMR16OP' OR ECTRANSID='PGMR17OP' OR ECTRANSID='PGMR18OP' OR ECTRANSID='PGMR19OP' OR ECTRANSID='PGMR20OP' OR ECTRANSID='PGMR21OP' OR ECTRANSID='PGMR22OP' OR ECTRANSID='PGMR23OP' OR ECTRANSID='PGMR24OP' OR ECTRANSID='PGMR25OP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
Prompt Table: PG_HDR_IN_VW

2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.

3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I

4 PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID
Prompt Table: PG_BATID_IN_VW

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 PELL_TRANS_DTTM DateTime(26) TIMESTAMP Pell Trans Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) Prompt Table: PG_HDR_IN_VW
2	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound Default Value: I
4	PG_BATCH_ID_00	Character(26)	VARCHAR2(26) NOT NULL	Pell Batch ID Prompt Table: PG_BATID_IN_VW
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time