BUSINESS_UNITADJ_INVOICE1BI_DIST_ADJ1_VW(SQL View) |
Index Back |
|---|---|
Distinct Adj1 Ivc Vw |
| select business_unit, adj_invoice1, max(invoice) from PS_BI_ADJ_GRP_LINE group by business_unit, adj_invoice1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ADJ_INVOICE1 |
Character(22) | VARCHAR2(22) NOT NULL | Credit Bill |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |