BUSINESS_UNITINVOICEBI_LINE_MIN_VW(SQL View) |
Index Back |
|---|---|
Bill Line Minimum ViewBill line minimum net extended amount view |
| SELECT L.BUSINESS_UNIT , L.INVOICE , L.BI_CURRENCY_CD , MIN(L.NET_EXTENDED_AMT) FROM PS_BI_LINE L , PS_BI_HDR H WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.INVOICE = L.INVOICE GROUP BY L.BUSINESS_UNIT, L.INVOICE, L.BI_CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 4 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |