EIP_CTL_IDGRP_SEQ_NBRBUSINESS_UNITDELIVERY_ID0=Open
1=Error
2=Complete
3=Cancel
INV_FRT_GRP_VW(SQL View) |
Index Back |
|---|
| SELECT a.eip_ctl_id , 0 , 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 | GRP_SEQ_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence used to uniquely identify a row in the Fulfillment Group stage table. |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 5 | BCT_DET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
BCTP Detail Status
0=Open 1=Error 2=Complete 3=Cancel |
| 6 | ERROR_CODE | Character(10) | VARCHAR2(10) NOT NULL | Error Code |
| 7 | ERRORMSG | Character(254) | VARCHAR2(254) NOT NULL | Error Message field |