BUSINESS_UNITFINT_MSTR_BR_VW(SQL View) |
Index Back |
|---|---|
Demand History Master BranchView of Demand History Master Branch - All Inventory and Order Management Business Units Date Initials Reference # Description 03/15/12 KAJ Bug 13697381 New View used for Master Branch lookup on Field Mappings |
| SELECT DISTINCT (BUSINESS_UNIT_IN) FROM PS_DP_DMDHISTORY WHERE BUSINESS_UNIT_IN <> ' ' UNION SELECT DISTINCT (BUSINESS_UNIT_OM) FROM PS_DP_DMDHISTORY WHERE BUSINESS_UNIT_OM <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |