OMEC_PROG_VW

(SQL View)
Index Back

OM EC Avail Transactions VW

OM EC Avail Transactions VW

SELECT DISTINCT S.EIP_PROGRAM , S.DESCR FROM PS_EO_EIP_CTL_SET S WHERE S.EIP_PROGRAM IN ('PO','POCHG','RFQ')

# 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
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description