Item_account_map

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accounting_book_id	NUMBER		39	0	accounting_book_id	Accounting_books	Accounting Book ID
class_id	NUMBER		39	0	class_id	Classes	Class ID
date_created	TIMESTAMP						Date created
date_effective	TIMESTAMP						Date effective
date_end	TIMESTAMP						Date end
date_last_modified	TIMESTAMP						Date last modified
department_id	NUMBER		39	0	department_id	Departments	Department ID
destination_account_id	NUMBER		39	0	account_id	Accounts	Destination account ID
form_template_component_id	VARCHAR2	16					Form template component ID
form_template_id	NUMBER		39	0			Form template ID
is_class_any	VARCHAR2	3					Is class any
is_department_any	VARCHAR2	3					Is department any
is_location_any	VARCHAR2	3					Is location any
item_account_map_extid	VARCHAR2	255					Item account map Extension ID
item_account_map_id	NUMBER		39	0			Item account map ID
item_account_type	VARCHAR2	150					Item account type
location_id	NUMBER		39	0	location_id	Locations	Location ID
source_account_id	NUMBER		39	0	account_id	Accounts	Account ID in the primary book
subsidiary_id	NUMBER		39	0	subsidiary_id	Subsidiaries	Subsidiary ID

Primary key

PK Column Name
item_account_map_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
item_account_map_accounting_books_fk	accounting_book_id	Accounting_books	accounting_book_id	1
item_account_map_accounts_fk_1	destination_account_id	Accounts	account_id	1
item_account_map_accounts_fk_2	source_account_id	Accounts	account_id	1
item_account_map_classes_fk	class_id	Classes	class_id	1
item_account_map_departments_fk	department_id	Departments	department_id	1
item_account_map_locations_fk	location_id	Locations	location_id	1
item_account_map_subsidiaries_fk	subsidiary_id	Subsidiaries	subsidiary_id	1

This table is included in the following domains

Domains
Multibooks

Domain diagrams