BUSINESS_UNITINVOICEBI_EIVC_INV_VW(SQL View) |
Index Back |
|---|---|
Electronic Invoice Num VWInvoice number view of printing Electronic Invoice File. |
| SELECT DISTINCT BUSINESS_UNIT , INVOICE FROM PS_BI_HDR WHERE BILL_STATUS = 'INV' AND BILL_TO_MEDIA = 'X' AND EIVC_COPY_IND <> 'O' |
| # | 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 |