BUSINESS_UNITDESTIN_BUPRICE_EFFECTIVE_DTCM_TRN_CEDT_VW(SQL View) |
Index Back |
|---|---|
Transfer Copy Price Eff Date |
| SELECT DISTINCT A.BUSINESS_UNIT , A.DESTIN_BU , A.PRICE_EFFECTIVE_DT FROM PS_CM_TRAN_PRC_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 3 | PRICE_EFFECTIVE_DT |
Date(10) | DATE | Price Effective Date |