ECPACKAGEDETAIL |
index back |
|---|---|
EC Audit Information - Package |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 EC_PACKAGE_CNTL_NB |
Character(10) | VARCHAR2(10) NOT NULL | EC Package Control ID |
| EC_PACKAGE_VER |
Character(6) | VARCHAR2(6) NOT NULL | EC Package Version |
| 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 |
| SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| ECAUDITCD | Character(4) | VARCHAR2(4) NOT NULL |
EC Audit Code
FA=Functional Acknowledgement TPTR=Trading Partner Transmission TRNS=EDI Translator Reported VAN=Reported from VAN |
| STATS_START | DateTime(26) | TIMESTAMP | Start Time For Stats Gathering |
| STATS_STOP | DateTime(26) | TIMESTAMP | Stop Time For Stats Gathering |
| ECCOMPLETIONSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
EC Completion Status
FAIL=Transaction Failed Process PASS=Transaction Passed Process |
| ECLOADTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Load Total |
| ECERRORTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Error Total |
| EC_APP_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| EC_APP_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| EC_APP_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | EC Application Defined Field |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |