MG_ENREV_EC1_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT EIP_CTL_ID ,BUSINESS_UNIT ,INV_ITEM_ID FROM PS_EN_REVISION_EC |
# | 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 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |