Data Dictionary -- Asset Migration

Srl. No.	Table Name	Comment
1	amig_account_balance	To store information of account balance
2	amig_asset_tag_dtl	To store information of asset tag details
3	amig_asset_tag_hdr	To store information of asset tag header
4	amig_error_log	To store information of error log
5	amig_initial_balance	To store information of initial balance
6	amig_process_parameter_sys	To store information of system process parameters

Table Name :	amig_account_balance
Comment :	To store information of account balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset class	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_desc	fin_accountdesc	varchar(60)	Yes	Account description	No
balance_gl	fin_amount	numeric(13)	Yes	balance_gl	No
balance_fa	fin_amount	numeric(13)	Yes	balance_fa	No
diff_amount	fin_amount	numeric(13)	Yes	Difference amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	amig_asset_tag_dtl
Comment :	To store information of asset tag details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
doc_type	fin_doctype	varchar(40)	Yes	Document type	No
doc_number	fin_documentnumber	varchar(18)	Yes	Document number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
supplier_name	fin_name	varchar(60)	Yes	Supplier name	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
currency	fin_currency	varchar(5)	Yes	Currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
gr_date	fin_datetime	datetime(8)	Yes	Gross date	No
cap_amount	fin_amount	numeric(13)	Yes	Capital amount	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	amig_asset_tag_hdr
Comment :	To store information of asset tag header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
legacy_asset_number	fin_assetnumber	varchar(18)	Yes	Legacy asset number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
asset_status	fin_status	varchar(25)	Yes	Asset status	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
inv_cycle	fin_invcycleallen	varchar(15)	Yes	Invoice cycle	No
inservice_date	fin_datetime	datetime(8)	Yes	Inservice date	No
cap_date	fin_datetime	datetime(8)	Yes	Capital date	No
bar_code	fin_documentnumber	varchar(18)	Yes	Bar code	No
serial_num	fin_serialno	varchar(18)	Yes	Serial number	No
warranty_no	fin_documentnumber	varchar(18)	Yes	Warranty number	No
model	fin_desc40	varchar(40)	Yes	Model	No
manufacturer	fin_name	varchar(60)	Yes	Manufacturer	No
custodian	fin_employeename	varchar(77)	Yes	custodian	No
business_use	fin_deprpercent	numeric(13)	Yes	Business use	No
salvage_val	fin_amount	numeric(13)	Yes	Salvage type	No
retire_type	fin_type	varchar(25)	Yes	Retire type	No
retire_date	fin_datetime	datetime(8)	Yes	Retire date	No
sale_value	fin_amount	numeric(13)	Yes	Sale value	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
usefullife_expdt	fin_date	datetime(8)	Yes	Useful life expiry date	No

Table Name :	amig_error_log
Comment :	To store information of error log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
error_id	fin_errorid	int(4)	Yes	Error id	No
error_desc	fin_subtitle	varchar(40)	Yes	Error description	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	amig_initial_balance
Comment :	To store information of initial balance

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
depr_book	fin_deprkey	varchar(20)	No	Depreciation book	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
asset_class	fin_assetclass	varchar(20)	No	Asset class	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
cum_depr_charge	fin_amount	numeric(13)	Yes	Cumulative depreciation charge	No
reval_type	fin_flag	varchar(25)	Yes	Revalue type	No
reval_date	fin_datetime	datetime(8)	Yes	Revalue date	No
reval_amount	fin_amount	numeric(13)	Yes	Revalue amount	No
rev_dep_cost	fin_amount	numeric(13)	Yes	Reversal depreciation cost	No
asset_book_val	fin_amount	numeric(13)	Yes	Asset book value	No
complete_status	fin_status	varchar(25)	Yes	Complete status	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	amig_process_parameter_sys
Comment :	To store information of system process parameters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter category	Yes
parameter_code	fin_param_code	varchar(6)	No	Parameter code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_param_text	varchar(255)	Yes	Parameter text	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No