NOTES_ACCT

Description:

This table contains summary information for billing system account notepad notes attached to accounts.

Primary Key

Column Name	Ordinal Position
NOTE_ID	1

Column Information

	Name	Type	Discontinued?
1	NOTE_ID	VARCHAR	No
	The unique ID of the Account Notepad note record.
2	ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the guarantor associated with the note. It is only populated for guarantor-level notes.
3	ACTIVE_STATUS	VARCHAR	No
	The status of the note: active or inactive. May contain organization-specific values: No Category Entries: Active Inactive
4	ENTRY_USER_ID	VARCHAR	No
	The ID of the user who manually created the note. If the note was automatically created by billing system, this is the person who executed the activity that triggered the note creation. This ID may be encrypted
5	ENTRY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	INVOICE_NUMBER	VARCHAR	No
	The invoice number associated with this note.
7	NOTE_ENTRY_DTTM	DATETIME (Local)	No
	The date and time the account note was created.