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.]


Name Type Length Precision Scale References In Description
author_id NUMBER 39 0 entity_id
Author ID
comments VARCHAR2 4000 Comments
company_id NUMBER 39 0 entity_id
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
Item ID
line_id NUMBER 39 0 transaction_line_id
ID of the line on the transaction
line_transaction_id NUMBER 39 0 transaction_id
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
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
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