ECACTIONS_VW

Platform	View Text
Default	SELECT DISTINCT TP_PROFILE_ID, ECTRANSID, ECTRANSINOUTSW, ECACTIONCD, ECPRIEVTCD, ECSECEVTCD FROM PS_ECACTIONS

PeopleSoft Field Name	Description
TP_PROFILE_ID	EC Profile ID Prompt Table: ECPROTRANS
ECTRANSID	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: ECPROTRANS
ECTRANSINOUTSW	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
ECACTIONCD	EC Action Code Prompt Table: ECACTIONCDS
ECPRIEVTCD	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. Prompt Table: ECPRIEVENTCDS
ECSECEVTCD	Electronic Commerce Secondary Event Codes (or transaction codes) - specify the type of transaction in detail. Used in EDI Manager. This could indicate a rush order, catalog order, or request for a sample. Not all transaction types include secondary codes. Prompt Table: ECSECEVENTCDS

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010