INV_TMS_EIP_VW

(SQL View)
 Index Back

SELECT DISTINCT ctl.business_unit , ctl.eip_ctl_id , ctl.bct_status , ctl.bct_status , dtl.load_id , ctl.eip_trans_src , ctl.eip_trans_src_ref , ctl.dt_timestamp FROM ps_bct_ctl ctl , PS_BCT_DTL dtl WHERE ctl.trans_program = '150' AND ctl.bct_status IN ('0','1','4') AND ctl.business_unit = dtl.business_unit AND ctl.eip_ctl_id = dtl.eip_ctl_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 BCT_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction status in the stage table
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed
4 TRANS_PROGRAM Character(3) VARCHAR2(3) NOT NULL Transaction Program
5 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
6 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
7 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
8 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp