EIP_CTL_IDPrompt Table: BCT_CTL
Prompt Table: SP_BUVM_NONVW
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Confirmed
IN_VMI_BCT_VW(SQL View) |
Index Back |
|---|---|
VMI BCT Lookup ViewVMI view that allows the user to lookup the specific EIP_CTL_ID transactions from the BCT_CTL record. |
| SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.TRANS_PROGRAM , A.BCT_STATUS FROM PS_BCT_CTL A , PS_SP_BUVM_NONVW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND BCT_STATUS IN ('0','4') |
| # | 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
Prompt Table: BCT_CTL |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUVM_NONVW |
| 3 | TRANS_PROGRAM | Character(3) | VARCHAR2(3) NOT NULL | Transaction Program |
| 4 | 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 |