BUSINESS_UNIT_PORECEIVER_IDCM_RC_LN_SHP_VW(SQL View) |
Index Back |
|---|---|
Prompt table for RUN_CNTL_CM.Receiver prompt table used on RUN_CNTL_CM. |
| SELECT DISTINCT a.business_unit_po , a.receiver_id , a.business_unit FROM PS_RECV_LN_SHIP a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |