ACCT_NOTEPAD

Description: |
This table contains information about the account notes.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
NOTE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | NOTE_ID | VARCHAR | No |
The unique identifier for the note record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | ACCT_NOTE_TEXT | VARCHAR | No |
The text of the account note. This contains the first 4000 characters of the text line.
4 | ACCT_NOTE_TEXT_2 | VARCHAR | No |
The text of the account note. This contains characters 4001 to 8000.
5 | ACCT_NOTE_TEXT_3 | VARCHAR | No |
The text of the account note. This contains characters 8001 to 12000.
6 | ACCT_NOTE_TEXT_4 | VARCHAR | No |
The text of the account note. This contains characters 12001 to 16000.
7 | ACCT_NOTE_TEXT_5 | VARCHAR | No |
The text of the account note. This contains characters 16001 to 20000.
8 | ACCT_NOTE_TEXT_6 | VARCHAR | No |
The text of the account note. This contains characters 20001 to 24000.
9 | ACCT_NOTE_TEXT_7 | VARCHAR | No |
The text of the account note. This contains characters 24001 to 28000.
10 | ACCT_NOTE_TEXT_8 | VARCHAR | No |
The text of the account note. This contains characters 28001 to 32000.