DESTIN_BUINTERUNIT_IDINTERUN2_INV_VW(SQL View) |
Index Back |
|---|---|
Prompt Table for Interunit Id.05/10/04 PWF Change references from SHIP_INF_INV to IN_DEMAND |
| SELECT DISTINCT destin_bu , interunit_id , order_no FROM PS_IN_DEMAND WHERE interunit_flg = 'Y' AND interunit_id <> ' ' AND IN_FULFILL_STATE > '50' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL | Destination Unit |
| 2 | INTERUNIT_ID |
Character(10) | VARCHAR2(10) NOT NULL | InterUnit Order ID |
| 3 | ORDER_NO | Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |