ECPACKAGELOG_EC

Return to Index

Table: PS_ECPACKAGELOG_EC

The Package Level is equivalent to the ISA Envelope Control Level

PeopleSoft Field NameDescription
ECQUEUEINSTANCEElectronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
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
EC_PACKAGE_CNTL_NBEC Package Control ID
EC_PACKAGE_VEREC Package Version
ECRELATEDINOUTSWEC Related In/Out Switch
EC_EXT_TP_IDElectronic Commerce External Trading Partner ID. Used in EDI Manager. The External Trading Partners are the customers, vendors, etc. that will do business with the PeopleSoft enterprise. External TPID can be found out from the external businesses directly or from the VAN.
EC_INT_TP_IDEC Internal Trading Partner ID
DTTM_STAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
STATS_STARTStart Time For Stats Gathering
STATS_STOPStop Time For Stats Gathering
ECCOMPLETIONSTATUSEC Completion Status
FAIL=Transaction Failed Process
PASS=Transaction Passed Process
ECLOADTOTALEC Inbound Load Total
ECERRORTOTALEC Inbound Error Total
EC_APP_FIELD_1EC Applicartion Defined Field
EC_APP_FIELD_2EC Applicartion Defined Field
EC_APP_FIELD_3EC Application Defined Field

Author: PeopleTools

Return to Index

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