ECPACKAGELOG_EC | |
Table: PS_ECPACKAGELOG_EC |
| PeopleSoft Field Name | Description |
|---|---|
ECQUEUEINSTANCE | 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. |
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) |
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 |
| EC_PACKAGE_CNTL_NB | EC Package Control ID |
| EC_PACKAGE_VER | EC Package Version |
| ECRELATEDINOUTSW | EC Related In/Out Switch |
| EC_EXT_TP_ID | Electronic 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_ID | EC Internal Trading Partner ID |
| DTTM_STAMP | Specifies 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_START | Start Time For Stats Gathering |
| STATS_STOP | Stop Time For Stats Gathering |
| ECCOMPLETIONSTATUS | EC Completion Status FAIL=Transaction Failed Process PASS=Transaction Passed Process |
| ECLOADTOTAL | EC Inbound Load Total |
| ECERRORTOTAL | EC Inbound Error Total |
| EC_APP_FIELD_1 | EC Applicartion Defined Field |
| EC_APP_FIELD_2 | EC Applicartion Defined Field |
| EC_APP_FIELD_3 | EC Application Defined Field |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |