Notes_system

Columns

Name	Type	Length	Precision	Scale	References	In	Description
author_id	NUMBER		22	0	entity_id	Entity	Author ID
comments	VARCHAR2	4000					Comments
company_id	NUMBER		22	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		22	0			Event ID
isinactive	VARCHAR2	3					Is inactive
item_id	NUMBER		22	0	item_id	Items	Item ID
line_id	NUMBER		22	0	transaction_line_id	Transaction_lines	ID of the line on the transaction
line_transaction_id	NUMBER		22	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		22	0	note_type_id	Notetype	Note type ID
record_id	NUMBER		22	0			Record ID
record_type_id	NUMBER		22	0			Record type 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		22	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