BUSINESS_UNIT_INORD_INVARBU_VW(SQL View) |
Index Back |
|---|---|
AR business unit for shipfrom |
| SELECT inv.business_unit , bi.business_unit_ar , inv.business_unit_bi FROM PS_BUS_UNIT_TBL_BI bi , ps_bus_unit_tbl_in inv WHERE inv.business_unit_bi = bi.business_unit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 2 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 3 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |