ECQUEUEINSTANCEECTRANSIDECTRANSINOUTSWI=Inbound
O=Outbound
EC_PACKAGE_CNTL_NBEC_TRANS_GROUP_NBRFAIL=Transaction Failed Process
PASS=Transaction Passed Process
ECTRANSGROUP_EC(SQL Table) |
Index Back |
|---|---|
EC Group Audit StagingThe Group Level is equivalent to the GS Group Control Level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | 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. |
| 2 | ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | 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) |
| 3 | 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 |
| 4 | EC_PACKAGE_CNTL_NB |
Character(10) | VARCHAR2(10) NOT NULL | EC Package Control ID |
| 5 | EC_TRANS_GROUP_NBR |
Character(18) | VARCHAR2(18) NOT NULL | EC Transaction Group Cntl Nbr |
| 6 | EC_TRANS_GROUP_VER | Character(6) | VARCHAR2(6) NOT NULL | EC Transaction Group Version |
| 7 | ECRELATEDINOUTSW | Character(1) | VARCHAR2(1) NOT NULL | EC Related In/Out Switch |
| 8 | EC_EXT_TP_ID | Character(16) | VARCHAR2(16) NOT NULL | 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. |
| 9 | EC_INT_TP_ID | Character(16) | VARCHAR2(16) NOT NULL | EC Internal Trading Partner ID |
| 10 | DTTM_STAMP | DateTime(26) | TIMESTAMP | 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. |
| 11 | STATS_START | DateTime(26) | TIMESTAMP | Start Time For Stats Gathering |
| 12 | STATS_STOP | DateTime(26) | TIMESTAMP | Stop Time For Stats Gathering |
| 13 | ECCOMPLETIONSTATUS | Character(4) | VARCHAR2(4) NOT NULL |
EC Completion Status
FAIL=Transaction Failed Process PASS=Transaction Passed Process |
| 14 | ECLOADTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Load Total |
| 15 | ECERRORTOTAL | Number(9,0) | DECIMAL(9) NOT NULL | EC Inbound Error Total |
| 16 | EC_APP_FIELD_1 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 17 | EC_APP_FIELD_2 | Character(40) | VARCHAR2(40) NOT NULL | EC Applicartion Defined Field |
| 18 | EC_APP_FIELD_3 | Character(40) | VARCHAR2(40) NOT NULL | EC Application Defined Field |