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 | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | 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 |