Notes_system_custom

Important: As of NetSuite 2017.1, the notes_system_custom view is obsolete. To avoid errors, query the System_notes_custom view instead.

Note: The following columns have not been ported to the [Xref:system_notes_custom
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_custom view. Additionally, the note_id and direction columns are not present in the system_notes_custom view, and the following columns have been renamed:
- time_entered is now date_created
- customfield_created_date is now date_customfield_created
- customfield_modified_date is now date_customfield_modified
- customfield_created_by is now customfield_created_by_id
- customfield_modified_by is now customfield_modified_by_id]

Columns

Name Type Length Precision Scale References In Description
author_id NUMBER 39 0 entity_id
Entity
Author ID
comments VARCHAR2 4000 Comments
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.
customfield_created_by NUMBER 39 0 Custom field — created by
customfield_created_date TIMESTAMP Custom field — created date
customfield_modified_by NUMBER 39 0 Custom field — modified by
customfield_modified_date TIMESTAMP Custom field — modified date
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 227 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_custom_entity_fk company_id Entity entity_id 1
notes_system_custom_entity_fk_2 author_id Entity entity_id 1
notes_system_custom_items_fk item_id Items item_id 1
notes_system_custom_notetype_fk note_type_id Notetype note_type_id 1
notes_system_custom_transaction_lines_fk line_transaction_id Transaction_lines transaction_id 1
notes_system_custom_transaction_lines_fk line_id Transaction_lines transaction_line_id 2
notes_system_custom_transactions_fk transaction_id Transactions transaction_id 1