Global_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 (GMT)
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
global_account_map_extid VARCHAR2 255 Global account map Ext ID
global_account_map_id NUMBER 39 0 Global account map ID
is_class_any VARCHAR2 3 Any class
is_department_any VARCHAR2 3 Any department
is_location_any VARCHAR2 3 Any location
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
global_account_map_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
global_account_map_accounting_books_fk accounting_book_id Accounting_books accounting_book_id 1
global_account_map_accounts_fk_1 destination_account_id Accounts account_id 1
global_account_map_accounts_fk_2 source_account_id Accounts account_id 1
global_account_map_classes_fk class_id Classes class_id 1
global_account_map_departments_fk department_id Departments department_id 1
global_account_map_locations_fk location_id Locations location_id 1
global_account_map_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1

This table is included in the following domains

Domains
Multibooks

Domain diagrams

Multibooks