ECPRODFLTS_VW

Return to Index

View: PS_ECPRODFLTS_VW

Assign Defaults to a specific TP profile by transaction

PlatformView Text
DefaultSELECT DISTINCT TP_PROFILE_ID, ECTRANSID, ECTRANSINOUTSW, ECTRANSOPTIONCD, ECTRANSOPTIONVAL FROM PS_ECPRODFLTS

  • Parent record: ECPROTRANS_VW
  • PeopleSoft Field NameDescription
    TP_PROFILE_IDEC Profile ID
    ECTRANSIDElectronic 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)
    ECTRANSINOUTSWElectronic 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
    ECTRANSOPTIONCDEC Transaction Option Code

    Prompt Table: ECTRANSOPTION

    ECTRANSOPTIONVALEC Transaction Option Value

    Prompt Table: ECTRANSOPVAL

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010