TR_FOUR15_OB_VW (SQL View)	Index Back
Four-15 outbound total records

TR_FOUR15_OB_VW

(SQL View)

Four-15 outbound total records

Select ECTRANSID, ECQUEUEINSTANCE, ECTRANSINOUTSW, ECPRIEVTCD, ECACTIONCD, COUNT(*), 32767, '#TRUE#' From PS_TR_FOUR15_OB_EC Group BY ECTRANSID, ECQUEUEINSTANCE, ECTRANSINOUTSW, ECPRIEVTCD, ECACTIONCD

# 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)

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

4 ECPRIEVTCD Character(6) VARCHAR2(6) NOT NULL Electronic Commerce Primary Event Codes (or Purpose codes) - specify the status of the transaction. New, Cancellation, duplicate, etc. Every transaction has a primary code assigned to it. Used in EDI Manager.

5 ECACTIONCD Character(3) VARCHAR2(3) NOT NULL EC Action Code

6 JPM_NUM_COMPONENTS Number(12,0) DECIMAL(12) NOT NULL Represents the total number of financial components in a given set of deal transactions; the

7 JPM_MAXCOMPOSIT_ID Number(5,0) INTEGER NOT NULL Represents the largest possible number to be utilized as a composite ID for a given deal transac

8 JPM_NOM_IN_LOCAL Character(8) VARCHAR2(8) NOT NULL A value indicating whether a given deal transaction is stated in a transaction or base currency; t

#	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)
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
4	ECPRIEVTCD	Character(6)	VARCHAR2(6) NOT NULL	Electronic Commerce Primary Event Codes (or Purpose codes) - specify the status of the transaction. New, Cancellation, duplicate, etc. Every transaction has a primary code assigned to it. Used in EDI Manager.
5	ECACTIONCD	Character(3)	VARCHAR2(3) NOT NULL	EC Action Code
6	JPM_NUM_COMPONENTS	Number(12,0)	DECIMAL(12) NOT NULL	Represents the total number of financial components in a given set of deal transactions; the
7	JPM_MAXCOMPOSIT_ID	Number(5,0)	INTEGER NOT NULL	Represents the largest possible number to be utilized as a composite ID for a given deal transac
8	JPM_NOM_IN_LOCAL	Character(8)	VARCHAR2(8) NOT NULL	A value indicating whether a given deal transaction is stated in a transaction or base currency; t