BUSINESS_UNITINVOICELINE_SEQ_NUMNOTES_SEQ_NUMBI_LN_CNT_EC_VW(SQL View) |
Index Back |
|---|---|
Bill Line Custom Notes view |
| SELECT BUSINESS_UNIT , INVOICE , LINE_SEQ_NUM , NOTES_SEQ_NUM , NOTE_TYPE , TEXT254 FROM PS_BI_LINE_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 | LINE_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Sequence |
| 4 | NOTES_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Notes Sequence Num |
| 5 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Note Type |
| 6 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |