Notes_system
Important: As of NetSuite 2017.1, the notes_system view is obsolete. To avoid errors, query the
System_notes view instead.
Note: The following columns have not been ported to the [Xref:system_notes
view as they all contain identical data for each record:
- note_type_extid
- note_type
- note_type_description
- isinactive
- system_use
- date_last_modified
If you need to query these columns, join the notetype view using the note_type_id column from the system_notes view. Additionally, in the system_notes view the note_id and direction columns are not present, and the time_entered column is named date_created.]
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| author_id |
NUMBER |
|
39 |
0 |
entity_id
|
Entity
|
Author ID |
| company_id |
NUMBER |
|
39 |
0 |
entity_id
|
Entity
|
Company ID |
| custom_field |
VARCHAR2 |
40 |
|
|
|
|
The exact field that has been changed on the line item. For example, an item's description, account, etc. |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified (GMT) |
| direction |
VARCHAR2 |
|
|
|
|
|
Direction |
| event_id |
NUMBER |
|
39 |
0 |
|
|
Event ID |
| isinactive |
VARCHAR2 |
3 |
|
|
|
|
Is inactive |
| item_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Item ID |
| line_id |
NUMBER |
|
39 |
0 |
transaction_line_id
|
Transaction_lines
|
ID of the line on the transaction |
| line_transaction_id |
NUMBER |
|
39 |
0 |
transaction_id
|
Transaction_lines
|
ID of the transaction whose line has been changedUsed when line-level changes are being tracked |
| name |
VARCHAR2 |
283 |
|
|
|
|
Name |
| note_id |
VARCHAR2 |
|
|
|
|
|
Note ID |
| note_type |
VARCHAR2 |
40 |
|
|
|
|
Note type |
| note_type_description |
VARCHAR2 |
75 |
|
|
|
|
Note type description |
| note_type_extid |
VARCHAR2 |
255 |
|
|
|
|
Note type external ID |
| note_type_id |
NUMBER |
|
39 |
0 |
note_type_id
|
Notetype
|
Note type ID |
| record_id |
NUMBER |
|
39 |
0 |
|
|
Record ID |
| record_type_id |
NUMBER |
|
39 |
0 |
|
|
Record type ID |
| role_id |
NUMBER |
|
39 |
0 |
|
|
Role ID |
| standard_field |
VARCHAR2 |
40 |
|
|
|
|
The exact field that has been changed on the line item. For example, an item's description, account, etc. |
| system_use |
VARCHAR2 |
3 |
|
|
|
|
System use |
| time_entered |
TIMESTAMP |
|
|
|
|
|
Time entered |
| transaction_id |
NUMBER |
|
39 |
0 |
transaction_id
|
Transactions
|
Transaction ID |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| notes_system_entity_fk |
company_id |
Entity |
entity_id |
1 |
| notes_system_entity_fk_2 |
author_id |
Entity |
entity_id |
1 |
| notes_system_items_fk |
item_id |
Items |
item_id |
1 |
| notes_system_notetype_fk |
note_type_id |
Notetype |
note_type_id |
1 |
| notes_system_transaction_lines_fk |
line_transaction_id |
Transaction_lines |
transaction_id |
1 |
| notes_system_transaction_lines_fk |
line_id |
Transaction_lines |
transaction_line_id |
2 |
| notes_system_transactions_fk |
transaction_id |
Transactions |
transaction_id |
1 |