ECQUEUEAPPERROR

index back

EC Application Load Error


PeopleSoft Field NameField TypeColumn TypeDescription
ECTRANSIDCharacter(15)VARCHAR2(15) NOT NULLElectronic 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)
ECQUEUEINSTANCENumber(9,0)DECIMAL(9) NOT NULLElectronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
ECTRANSINOUTSWCharacter(1)VARCHAR2(1) NOT NULLElectronic 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_01Character(30)VARCHAR2(30) NOT NULLKey Char(30) 01
KEY_CHAR_30_02Character(30)VARCHAR2(30) NOT NULLKey Char(30) 02
KEY_CHAR_30_03Character(30)VARCHAR2(30) NOT NULLKey Char(30) 03
KEY_NUM_01Number(5,0)INTEGER NOT NULLKey Number 01
KEY_NUM_02Number(5,0)INTEGER NOT NULLKey Number 02
KEY_NUM_03Number(5,0)INTEGER NOT NULLKey Number 03
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
EDITVALUECharacter(20)VARCHAR2(20) NOT NULLEdit Value
EDITTABLECharacter(15)VARCHAR2(15) NOT NULLEdit Table
DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19