OM_MAX_DRN_VW(SQL View) |
Index Back |
|---|---|
Max Document Ref Num by IBUMax un-shipped Doc Reference number by IBU |
| SELECT BUSINESS_UNIT , ORDER_NO , SHIP_FROM_BU , MAX(DOC_REFNUM) FROM PS_ORD_SCHEDULE WHERE CS_STATUS NOT IN ('S') GROUP BY BUSINESS_UNIT, ORDER_NO, SHIP_FROM_BU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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 |
| 3 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 4 | DOC_REFNUM | Character(20) | VARCHAR2(20) NOT NULL | Counter sale document reference number |