BUSINESS_UNITINVOICEBI_HDR_NCR_VW(SQL View) |
Index Back |
|---|---|
Non-Cr. Card BillsView used by AR to pay bills not previously paid by Credit Card. |
| SELECT business_unit , invoice FROM PS_BI_HDR WHERE bill_status = 'INV' AND payment_method <> 'CC' |
| # | 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 |