EIP_PROGRAM601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync
Default Value: OM_EIP_PRD_VW.EIP_PROGRAM
EIP_CTL_IDOM_EIP_PRD2_VW(SQL View) |
Index Back |
|---|---|
Product EIP CTL prompt |
| SELECT DISTINCT EIP.EIP_PROGRAM , ERR.EIP_CTL_ID FROM PS_EO_EIP_CTL_SET EIP , PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR WHERE EO.EIP_DTA_STATUS = '1' AND EIP.EIP_PROGRAM = ERR.EIP_PROGRAM AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND EIP.EIP_PROGRAM = 'PRODUCTMST' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EIP_PROGRAM |
Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync Default Value: OM_EIP_PRD_VW.EIP_PROGRAM |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |