ECQUEUEAPPERROR

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19