BUSINESS_UNITINVOICENOTES_SEQ_NUMBI_CU_CNT_EC_VW(SQL View) |
Index Back |
|---|---|
BI Cust Standard Notes EC VW |
| SELECT H.BUSINESS_UNIT , H.INVOICE , CNOTE.SEQ_NUM , CNOTE.NOTE_TYPE , CNOTE.TEXT254 , CNOTE.STD_NOTE_CD FROM PS_CUST_NOTE CNOTE , PS_CUST_NOTE_DOC DOC , PS_BI_HDR H WHERE H.BILL_STATUS = 'INV' AND H.BILL_TO_MEDIA = 'E' AND CNOTE.SETID = DOC.SETID AND CNOTE.CUST_ID = DOC.CUST_ID AND CNOTE.SEQ_NUM = DOC.SEQ_NUM AND DOC.DOCUMENT_CD = 'INVC' AND CNOTE.STD_NOTE_CD = ' ' AND CNOTE.CUST_ID = H.BILL_TO_CUST_ID |
| # | 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 | NOTES_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Notes Sequence Num |
| 4 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Note Type |
| 5 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 6 | STD_NOTE_CD | Character(10) | VARCHAR2(10) NOT NULL | Standard Note Code |