EIP_CTL_IDDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
PO_POA_CTLID_VW(SQL View) |
Index Back |
|---|---|
POA HDR EIP CTL ID ViewSELECT DISTINCT EIP_CTL_ID FROM PS_EO_EIP_CTL |
| SELECT A.EIP_CTL_ID , B.BUSINESS_UNIT , B.PO_ID FROM PS_EO_EIP_CTL A , PS_PO_HDR_EC B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.EIP_PROGRAM = 'POACK' |
| # | 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |