BUSINESS_UNITORDER_NOORDER_INT_LINE_NOSCHED_LINE_NBRINV_ITEM_IDDEMAND_LINE_NOORD_SCH_BI_VW(SQL View) |
Index Back |
|---|---|
Invoiced Order SchedulesDate Init. Issue # Description 01/26/01 JJM R-LBENNE-FZ7BB Added field INV_ITEM_ID and changed SQL by adding S.DEMAND_SOURCE = 'OM' and S.CANCEL_FLAG = 'N' restrictions to match ORD_SHIPMENT_VW 05/19/01 dms 7423901 Use s.sched_line_no instead of l.sched_line_nbr in select list in SQL 08/26/02 dms DI-DSCANTLA-2 Join bi_line to ship_inf_inv by invoice 05/25/04 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND |
| SELECT L.BUSINESS_UNIT_OM , L.ORDER_NO , L.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , S.INV_ITEM_ID , S.DEMAND_LINE_NO , L.BUSINESS_UNIT , L.INVOICE , L.LINE_SEQ_NUM , L.INVOICE_LINE , L.ORIGINAL_INVOICE , L.ORIGINAL_LINE_SEQ , H.INVOICE_DT FROM PS_IN_DEMAND_BI S , PS_BI_LINE L , PS_BI_HDR H , PS_ORD_SCHEDULE O WHERE S.SOURCE_BUS_UNIT = L.BUSINESS_UNIT_OM AND S.ORDER_NO = L.ORDER_NO AND S.ORDER_INT_LINE_NO = L.ORDER_INT_LINE_NO AND S.SCHED_LINE_NBR = L.SCHED_LINE_NBR AND S.INVOICE = L.INVOICE AND S.DEMAND_SOURCE = 'OM' AND S.BUSINESS_UNIT_BI = L.BUSINESS_UNIT AND O.BUSINESS_UNIT = L.BUSINESS_UNIT_OM AND O.ORDER_NO = L.ORDER_NO AND O.ORDER_INT_LINE_NO = L.ORDER_INT_LINE_NO AND O.SCHED_LINE_NBR = L.SCHED_LINE_NBR AND S.BUSINESS_UNIT = O.SHIP_FROM_BU AND %Join(COMMON_KEYS, BI_LINE L, BI_HDR H) |
| # | 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 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | DEMAND_LINE_NO |
Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 7 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 8 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 9 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 10 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 11 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 12 | ORIGINAL_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Original Line Sequence 5 |
| 13 | INVOICE_DT | Date(10) | DATE | Invoice Date |