BUSINESS_UNITPrompt Table: SP_BU_BI_NONVW
INVOICEPrompt Table: BI_HDR
LINE_SEQ_NUMNOTES_SEQ_NUMN=No
Y=Yes
Y/N Table Edit
Default Value: N
Prompt Table: NOTE_TYPE_EF_VW
N=No
Y=Yes
Y/N Table Edit
Default Value: N
Prompt Table: BI_STD_NOTE_VW
BI_LINE_NOTE(SQL Table) |
Index Back |
|---|---|
Bill Line Notes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Prompt Table: BI_HDR |
| 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 | STD_NOTE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Standard Note Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Note Type
Prompt Table: NOTE_TYPE_EF_VW |
| 7 | INTERNAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Internal Only Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 8 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 9 | STD_NOTE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table: BI_STD_NOTE_VW |
| 10 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 11 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |