ECAUDIT_02_VW

index back

EC Audit Staging Area View

Associative table between ECQUEUE, ECTRANSGROUPLOG, and ECPACKAGELOG
SELECT DISTINCT B.EC_TRANS_GROUP_NBR, B.EC_TRANS_GROUP_VER, B.ECQUEUEINSTANCE, B.ECTRANSID, B.ECTRANSINOUTSW, B.ECBUSDOCID, G.EC_EXT_TP_ID, G.EC_INT_TP_ID, G.DTTM_STAMP, G.STATS_START, G.STATS_STO P, G.ECCOMPLETIONSTATUS, G.ECLOADTOTAL, G.ECERRORTOTAL, G.EC_APP_FIELD_1, G.EC_APP_FIELD_2, G.EC_APP_FIELD_3 FROM PS_ECTRANSGROUPLOG G, PS_ECBUSDOCLINK B WHERE G.EC_TRANS_GROUP_NBR = B.EC_TRANS_GROUP_NBR AND G.EC_TRANS_GROUP_VER = B.EC_TRANS_GROUP_VER

PeopleSoft Field NameField TypeColumn TypeDescription
EC_TRANS_GROUP_NBRCharacter(18)VARCHAR2(18) NOT NULLEC Transaction Group Cntl Nbr
EC_TRANS_GROUP_VERCharacter(6)VARCHAR2(6) NOT NULLEC Transaction Group Version
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.
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)
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
ECBUSDOCIDNumber(9,0)DECIMAL(9) NOT NULLEC Business Document ID
EC_EXT_TP_IDCharacter(16)VARCHAR2(16) NOT NULLElectronic 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.
EC_INT_TP_IDCharacter(16)VARCHAR2(16) NOT NULLEC Internal Trading Partner ID
DTTM_STAMPDateTime(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.
STATS_STARTDateTime(26)TIMESTAMPStart Time For Stats Gathering
STATS_STOPDateTime(26)TIMESTAMPStop Time For Stats Gathering
ECCOMPLETIONSTATUSCharacter(4)VARCHAR2(4) NOT NULLEC Completion Status
FAIL=Transaction Failed Process
PASS=Transaction Passed Process
ECLOADTOTALNumber(9,0)DECIMAL(9) NOT NULLEC Inbound Load Total
ECERRORTOTALNumber(9,0)DECIMAL(9) NOT NULLEC Inbound Error Total
EC_APP_FIELD_1Character(40)VARCHAR2(40) NOT NULLEC Applicartion Defined Field
EC_APP_FIELD_2Character(40)VARCHAR2(40) NOT NULLEC Applicartion Defined Field
EC_APP_FIELD_3Character(40)VARCHAR2(40) NOT NULLEC Application Defined Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19