ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
KEY_CHAR_30_01KEY_CHAR_30_02KEY_CHAR_30_03KEY_NUM_01KEY_NUM_02KEY_NUM_03MESSAGE_SET_NBRMESSAGE_NBRRECNAMEFIELDNAMELASTUPDDTTMECQUEUEAPPERROR |
index back |
|---|---|
EC Application Load Error |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| 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) |
| 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. |
| 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 |
| KEY_CHAR_30_01 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 01 |
| KEY_CHAR_30_02 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 02 |
| KEY_CHAR_30_03 |
Character(30) | VARCHAR2(30) NOT NULL | Key Char(30) 03 |
| KEY_NUM_01 |
Number(5,0) | INTEGER NOT NULL | Key Number 01 |
| KEY_NUM_02 |
Number(5,0) | INTEGER NOT NULL | Key Number 02 |
| KEY_NUM_03 |
Number(5,0) | INTEGER NOT NULL | Key Number 03 |
| MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| MESSAGE_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 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. |
| EDITVALUE | Character(20) | VARCHAR2(20) NOT NULL | Edit Value |
| EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |