BUSINESS_UNITINVOICENOTES_SEQ_NUMBI_HD_CNT_EC_VW(SQL View) |
Index Back |
|---|---|
Bill Header Custom Notes view |
| SELECT BUSINESS_UNIT , INVOICE , NOTES_SEQ_NUM , NOTE_TYPE , TEXT254 FROM PS_BI_HDR_NOTE WHERE INTERNAL_FLAG = 'N' AND TEXT254 <> ' ' |
| # | 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 |