IN_FRT_HDR_VW

(SQL View)
Index Back

SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.DELIVERY_ID , A.BCT_DET_STATUS FROM %Table(BCT_DTL) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
4 BCT_DET_STATUS Character(1) VARCHAR2(1) NOT NULL BCTP Detail Status
0=Open
1=Error
2=Complete
3=Cancel