BUSINESS_UNITTO_DT1PL_PO_TO_DD_VW(SQL View) |
Index Back |
|---|---|
Plan/Purch To Dates ViewThis search view is used to provide the user with a list of existing To dates found in the PL_SF_OP_HEADER table. |
| SELECT DISTINCT BUSINESS_UNIT_IN , DUE_DT FROM PS_PL_PO_PLAN_ORD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TO_DT1 |
Date(10) | DATE | To Date |