BI_EXT_SUM_LNNT (SQL Table)	Index Back
Summarize Bill Ln Note Extract Summarize Invoice Extract bill line notes Extract. This table contains all bill line notes for those the invoice lines with summarization template. This is used for printing summarize invoice.

BI_EXT_SUM_LNNT

(SQL Table)

Summarize Bill Ln Note Extract

Summarize Invoice Extract bill line notes Extract. This table contains all bill line notes for those the invoice lines with summarization template. This is used for printing summarize invoice.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

4 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence

5 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num

6 NOTE_LEVEL_TYPE Character(1) VARCHAR2(1) NOT NULL Note Level Type.
B=Bill Note
C=Customer Note

7 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.

8 SUM_TEMPLATE_ID Character(16) VARCHAR2(16) NOT NULL Summarization Template ID

9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

10 NOTE_CATEGORY Character(1) VARCHAR2(1) NOT NULL Note Category.
O=Other
P=Primary
S=Secondary
V=VAT Messages

11 STD_NOTE_FLAG Character(1) VARCHAR2(1) NOT NULL Standard Note Flag
N=No
Y=Yes

12 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

13 INTERNAL_FLAG Character(1) VARCHAR2(1) NOT NULL Internal Only Flag
N=No
Y=Yes

14 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

15 INVOICE_DT Date(10) DATE Invoice Date

16 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

17 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

18 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
5	NOTES_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Notes Sequence Num
6	NOTE_LEVEL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Note Level Type. B=Bill Note C=Customer Note
7	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
8	SUM_TEMPLATE_ID	Character(16)	VARCHAR2(16) NOT NULL	Summarization Template ID
9	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
10	NOTE_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Note Category. O=Other P=Primary S=Secondary V=VAT Messages
11	STD_NOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Standard Note Flag N=No Y=Yes
12	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code
13	INTERNAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Internal Only Flag N=No Y=Yes
14	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type
15	INVOICE_DT	Date(10)	DATE	Invoice Date
16	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
17	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
18	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID