SHIP_FROM_BUDATE1PL_SO_BUSD_VW(SQL View) |
Index Back |
|---|---|
Order Management Schedule DateDate Initials Reference # Description 05/06/10 TH ICE 1965526000 Change Date lookups to run off Views - New View of Order Management Schedule dates |
| SELECT DISTINCT SHIP_FROM_BU , %DatePart(SCHED_SHIP_DTTM) FROM PS_PL_SO_DATE_CHG WHERE ORDER_TYPE_CD = 'SO' OR ORDER_TYPE_CD = 'QUO' OR ORDER_TYPE_CD = 'BA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHIP_FROM_BU |
Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 2 | DATE1 |
Date(10) | DATE | Date |