ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
KEY_CHAR_30_01KEY_CHAR_30_02KEY_CHAR_30_03KEY_NUM_01KEY_NUM_02KEY_NUM_03MESSAGE_SET_NBRMESSAGE_NBRRECNAMEFIELDNAMELASTUPDDTTMECQUEUEAPPERROR(SQL Table) |
Index Back |
|---|---|
EC Application Load Error |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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) |
| 2 | 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. |
| 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 | KEY_CHAR_30_01 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 01 |
| 5 | KEY_CHAR_30_02 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 02 |
| 6 | KEY_CHAR_30_03 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 03 |
| 7 | KEY_NUM_01 |
Number(5,0) | INTEGER NOT NULL | Key Number 01 |
| 8 | KEY_NUM_02 |
Number(5,0) | INTEGER NOT NULL | Key Number 02 |
| 9 | KEY_NUM_03 |
Number(5,0) | INTEGER NOT NULL | Key Number 03 |
| 10 | MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 11 | MESSAGE_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 12 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 13 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 14 | LASTUPDDTTM |
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. |
| 15 | EDITVALUE | Character(20) | VARCHAR2(20) NOT NULL | Edit Value |
| 16 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 17 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |