Database Schema for

Data Dictionary -- Asset Inquiry

Srl. No.	Table Name	Comment
1	ainq_accounting_info_dtl	To store information of accounting information detail
2	ainq_account_balance	To store information of account balance
3	ainq_asset_hdr	To store information of asset header
4	ainq_asset_tag_balance	To store information of asset tag balance
5	ainq_asset_tag_dtl	To store information of asset tag detail
6	ainq_asset_tag_his	To store history of asset tag
7	ainq_asset_tag_summ	To store summary of asset tag
8	ainq_clsgrpsumm_rpt	To store information of group summary report
9	ainq_registerastdtl_rpt	To store information of register asset detail
10	ainq_registertrndtl_rpt	To store information of register transaction detail
11	ainq_tag_doc_dtl	To store information of tag document detail
12	ainq_transummdtl_rpt	To store information of transaction summary detail
13	ainq_transumm_rpt	To store information of transaction summary report


Table Name :	ainq_accounting_info_dtl
Comment :	To store information of accounting information detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_number	fin_transactionnumber	varchar(18)	Yes	Transaction number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
sub_analysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
bc_erate	fin_exchangerate	numeric(9)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbc_erate	fin_exchangerate	numeric(9)	Yes	Parallel base currency exchange rate	No
pbase_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
cap_date	fin_datetime	datetime(8)	Yes	Capitalized date	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
account_type	fin_type	varchar(25)	Yes	Account type	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
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


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


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
company_code	fin_companycode	varchar(10)	Yes	Company name	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_financeyear	varchar(15)	Yes	Financial year	No
fin_period	fin_financeperiod	varchar(15)	Yes	Financial period	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
account_code	fin_accountcode	varchar(32)	Yes	Accoun code	No
ob_credit	fin_amount	numeric(13)	Yes	Order base credit	No
ob_debit	fin_amount	numeric(13)	Yes	Order base debit	No
period_credit	fin_amount	numeric(13)	Yes	Period credit	No
period_debit	fin_amount	numeric(13)	Yes	Period debit	No
cb_credit	fin_amount	numeric(13)	Yes	Case base credit	No
cb_debit	fin_amount	numeric(13)	Yes	Case base debit	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
currency_type	fin_type	varchar(25)	Yes	Currrency type	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_asset_hdr
Comment :	To store information of asset header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance id	No
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	No
asset_number	fin_assetnumber	varchar(18)	No	Asset number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
cap_date	fin_datetime	datetime(8)	Yes	Capital date	No
cap_status	fin_status	varchar(25)	Yes	Capital status	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Number type	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
seq_no	fin_sequence	int(4)	Yes	Sequence number	No
as_on_date	fin_datetime	datetime(8)	Yes	As on date	No
asset_type	fin_typecode	varchar(10)	Yes	Asset type	No
asset_status	fin_statuscode	varchar(2)	Yes	Asset status	No
transaction_date	fin_datetime	datetime(8)	Yes	Transaction date	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_asset_tag_balance
Comment :	To store information of asset tag balance


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_book_value	fin_amount	numeric(13)	Yes	Asset book value	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
cum_total	fin_amount	numeric(13)	Yes	Cumulative toatl	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation charge	No
cum_depr_charge	fin_amount	numeric(13)	Yes	Cumulative depreciation charge	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
reval_depr_charge	fin_amount	numeric(13)	Yes	Revalued depreciation charge	No
reval_cum_depr_charge	fin_amount	numeric(13)	Yes	Revalued cumulative depreciation charge	No
tran_number	fin_documentnumber	varchar(18)	Yes	Transaction number	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit credit flag	No
srno	fin_lineno	int(4)	Yes	Serial number	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
tag_status	fin_status	varchar(25)	Yes	Tag status	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_asset_tag_dtl
Comment :	To store information of asset tag detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance id	No
asset_number	fin_assetnumber	varchar(18)	No	Asset number	No
tag_number	fin_assettagno	int(4)	No	Tag number	No
cap_number	fin_documentnumber	varchar(18)	No	Capital number	No
fb_id	fin_financebookid	varchar(20)	No	Finance book id	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset locaion	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
inservice_date	fin_datetime	datetime(8)	Yes	Insevice date	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
tag_status	fin_statuscode	varchar(2)	Yes	Tag status	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
inv_cycle	fin_inventorycycle	varchar(15)	Yes	Invoice cycle	No
salvage_value	fin_amount	numeric(13)	Yes	Salvage value	No
manufacturer	fin_name	varchar(60)	Yes	Manufacturer	No
bar_code	fin_documentnumber	varchar(18)	Yes	Bar code	No
serial_no	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
custodian	fin_employeename	varchar(77)	Yes	custodian	No
business_use	fin_deprpercent	numeric(13)	Yes	Business use	No
reverse_remarks	fin_remarks	varchar(100)	Yes	Reverse remarks	No
book_value	fin_amount	numeric(13)	Yes	Book value	No
revalued_cost	fin_amount	numeric(13)	Yes	Revalued cost	No
inv_date	fin_datetime	datetime(8)	Yes	Invoice date	No
inv_due_date	fin_datetime	datetime(8)	Yes	Invoice due date	No
inv_status	fin_status	varchar(25)	Yes	Invoice status	No
softrev_run_no	fin_arevkeys	varchar(20)	Yes	Soft reversal run number	No
insurable_value	fin_amount	numeric(13)	Yes	Insurable value	No
policy_count	fin_count	int(4)	Yes	Policy count	No
dest_fbid	fin_financebookid	varchar(20)	Yes	Destination finance book id	No
transfer_date	fin_datetime	datetime(8)	Yes	Transfer date	No
legacy_asset_no	fin_assetnumber	varchar(18)	Yes	Legacy asset number	No
migration_status	fin_status	varchar(25)	Yes	Migration 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
tran_type	fin_trantype	varchar(40)	Yes	Transaction type	No
propos_numbr	fin_documentnumber	varchar(18)	Yes	Proposal number	No
insp_date	fin_datetime	datetime(8)	Yes	insp_date	No
Rev_doc_no	fin_documentnumber	varchar(18)	Yes	Reversal document number	No
usefullife_expdt	fin_date	datetime(8)	Yes	Useful life expiry date	No
salvage_value_orig	fin_amount	numeric(13)	Yes	Salvage value original	No
srno	fin_lineno	int(4)	Yes	srno	No
expdt_eff_from	fin_date	datetime(8)	Yes	Expiry date effective from	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_asset_tag_his
Comment :	To store history of asset tag


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
cap_number	fin_documentnumber	varchar(18)	Yes	Capital number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
inservice_date	fin_datetime	datetime(8)	Yes	Inservice date	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
tag_status	fin_statuscode	varchar(2)	Yes	Tag status	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
inv_cycle	fin_inventorycycle	varchar(15)	Yes	Invoice cycle	No
salvage_value	fin_amount	numeric(13)	Yes	Salvage value	No
manufacturer	fin_name	varchar(60)	Yes	Manufacturer	No
bar_code	fin_documentnumber	varchar(18)	Yes	Bar code	No
serial_no	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
custodian	fin_employeename	varchar(77)	Yes	custodian	No
business_use	fin_deprpercent	numeric(13)	Yes	Business use	No
reverse_remarks	fin_remarks	varchar(100)	Yes	Reverse remarks	No
book_value	fin_amount	numeric(13)	Yes	Book value	No
revalued_cost	fin_amount	numeric(13)	Yes	Revalued cost	No
inv_date	fin_datetime	datetime(8)	Yes	Invoice date	No
inv_due_date	fin_datetime	datetime(8)	Yes	Invoice due date	No
inv_status	fin_status	varchar(25)	Yes	Invoice status	No
softrev_run_no	fin_arevkeys	varchar(20)	Yes	Soft reversal run number	No
insurable_value	fin_amount	numeric(13)	Yes	Insurable vlue	No
action_time	fin_datetime	datetime(8)	Yes	Action time	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_asset_tag_summ
Comment :	To store summary of asset tag


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
cum_book_value	fin_amount	numeric(13)	Yes	Cumulative book value	No
cum_tag_cost	fin_amount	numeric(13)	Yes	Cumulative tag cost	No
cum_depr_charge	fin_amount	numeric(13)	Yes	Cumulative depreciation charge	No
tag_Status	fin_status	varchar(25)	Yes	Tag status	No
Latest_cap_date	fin_datetime	datetime(8)	Yes	Latest capital date	No
Latest_Depp_date	fin_datetime	datetime(8)	Yes	Latest depreciation date	No
latest_cap_number	fin_documentnumber	varchar(18)	Yes	Latest capital number	No
min_cap_number	fin_documentnumber	varchar(18)	Yes	Minimum capital number	No
min_cap_date	fin_date	datetime(8)	Yes	Minimum capital date	No
min_inservice_date	fin_date	datetime(8)	Yes	Minimum inservice date	No
salvage_value	fin_amount	numeric(13)	Yes	Savage value	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_clsgrpsumm_rpt
Comment :	To store information of group summary report


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
as_on_date	fin_datetime	datetime(8)	Yes	As on date	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
group_desc	fin_desc40	varchar(40)	Yes	Group description	No
original_cost	fin_amount	numeric(13)	Yes	Original cose	No
cumm_depr_cost	fin_amount	numeric(13)	Yes	Cumulative depraciation cost	No
net_book_value	fin_amount	numeric(13)	Yes	Net book value	No
cap_wip_cost	fin_amount	numeric(13)	Yes	Capital wip cost	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_registerastdtl_rpt
Comment :	To store information of register asset detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
asset_no_from	fin_assetnumber	varchar(18)	Yes	Asset number from	No
asset_no_to	fin_assetnumber	varchar(18)	Yes	Asset number to	No
cost_center_from	fin_costcentercode	varchar(10)	Yes	Cost center from	No
cost_center_to	fin_costcentercode	varchar(10)	Yes	Cost center to	No
fin_period_from	fin_financeperiod	varchar(15)	Yes	Financial period from	No
fin_period_to	fin_financeperiod	varchar(15)	Yes	Financial period to	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
ob_credit	fin_amount	numeric(13)	Yes	Order base credit	No
ob_debit	fin_amount	numeric(13)	Yes	Order base debit	No
tran_debit	fin_amount	numeric(13)	Yes	Transaction credit	No
tran_credit	fin_amount	numeric(13)	Yes	Transaction debit	No
cl_debit	fin_amount	numeric(13)	Yes	cl_debit	No
cl_credit	fin_amount	numeric(13)	Yes	cl_credit	No
date_from	fin_datetime	datetime(8)	Yes	Date from	No
date_to	fin_datetime	datetime(8)	Yes	Date to	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_registertrndtl_rpt
Comment :	To store information of register transaction detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
tran_number	fin_documentnumber	varchar(18)	Yes	Transaction number	No
tran_type	fin_type	varchar(25)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transatcion date	No
dr_amt	fin_amount	numeric(13)	Yes	Debit amount	No
cr_amt	fin_amount	numeric(13)	Yes	Credit 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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_tag_doc_dtl
Comment :	To store information of tag document detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Ouinstance	No
fb_id	fin_financebookid	varchar(20)	No	Finance book id	No
cap_number	fin_documentnumber	varchar(18)	No	Capital number	No
asset_number	fin_assetnumber	varchar(18)	No	Asset number	No
tag_number	fin_assettagno	int(4)	No	Tag number	No
doc_number	fin_documentnumber	varchar(18)	No	Document number	No
line_no	fin_lineno	int(4)	No	Line number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
doc_type	fin_documenttype	varchar(40)	Yes	Document type	No
cap_amount	fin_amount	numeric(13)	Yes	Capital amount	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal number	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_transummdtl_rpt
Comment :	To store information of transaction summary detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
as_on_date	fin_datetime	datetime(8)	Yes	As on date	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
group_desc	fin_desc40	varchar(40)	Yes	Group description	No
original_cost	fin_amount	numeric(13)	Yes	Original cost	No
cumm_depr_cost	fin_amount	numeric(13)	Yes	Cumulative depreciation cost	No
net_book_value	fin_amount	numeric(13)	Yes	Net book value	No
op_original_cost	fin_amount	numeric(13)	Yes	op original cost	No
op_depr_cost	fin_amount	numeric(13)	Yes	op depreciation cost	No
op_book_cost	fin_amount	numeric(13)	Yes	op book cost	No
op_wip_cost	fin_amount	numeric(13)	Yes	op wip cost	No
cl_original_cost	fin_amount	numeric(13)	Yes	cl original cost	No
cl_depr_cost	fin_amount	numeric(13)	Yes	cl depreciation cost	No
cl_book_cost	fin_amount	numeric(13)	Yes	cl book cost	No
cl_wip_cost	fin_amount	numeric(13)	Yes	cl wip cost	No
op_rev_cost	fin_amount	numeric(13)	Yes	op reversal cost	No
ad_tran_amt	fin_amount	numeric(13)	Yes	ad transaction amount	No
dl_rev_amt	fin_amount	numeric(13)	Yes	dl reversal amount	No
ad_rev_amt	fin_amount	numeric(13)	Yes	ad reversal amount	No
dl_tran_amt	fin_amount	numeric(13)	Yes	dl transaction amount	No
dl_ret_amt	fin_amount	numeric(13)	Yes	dl_ret_amt	No
cl_rev_amt	fin_amount	numeric(13)	Yes	cl reversal amount	No
op_rev_depr_cost	fin_amount	numeric(13)	Yes	op reversal depreciation cost	No
cl_rev_depr_cost	fin_amount	numeric(13)	Yes	cl reversal depreciation cost	No
ad_cap_dep_amt	fin_amount	numeric(13)	Yes	ad capital depraciation cost	No
ad_tran_dep_amt	fin_amount	numeric(13)	Yes	ad transaction depreciation amount	No
dl_rev_dep_amt	fin_amount	numeric(13)	Yes	dl reversal depreciation amount	No
dl_tran_dep_amt	fin_amount	numeric(13)	Yes	dl transaction depreciation amount	No
dl_ret_dep_amt	fin_amount	numeric(13)	Yes	dl_ret_dep_amt	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	ainq_transumm_rpt
Comment :	To store information of transaction summary report


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
guid	fin_guid	varchar(40)	Yes	Guid	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Ouinstance id	No
company_name	fin_companyname	varchar(60)	Yes	Company name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_year	fin_calendarcode	varchar(10)	Yes	Financial year	No
fin_period	fin_calendarcode	varchar(10)	Yes	Financial period	No
as_on_date	fin_datetime	datetime(8)	Yes	As on date	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
group_desc	fin_desc40	varchar(40)	Yes	Group description	No
original_cost	fin_amount	numeric(13)	Yes	Original cost	No
cumm_depr_cost	fin_amount	numeric(13)	Yes	Cumulative depreciation cost	No
net_book_value	fin_amount	numeric(13)	Yes	Net book value	No
cap_wip_cost	fin_amount	numeric(13)	Yes	Capital wip cost	No
op_original_cost	fin_amount	numeric(13)	Yes	op original cost	No
op_depr_cost	fin_amount	numeric(13)	Yes	op depreciation cost	No
op_book_cost	fin_amount	numeric(13)	Yes	op book cost	No
op_wip_cost	fin_amount	numeric(13)	Yes	op wip cost	No
cl_original_cost	fin_amount	numeric(13)	Yes	cl original cost	No
cl_depr_cost	fin_amount	numeric(13)	Yes	cl depreciation cost	No
cl_book_cost	fin_amount	numeric(13)	Yes	cl book cost	No
cl_wip_cost	fin_amount	numeric(13)	Yes	cl wip cost	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_num_desc	fin_desc40	varchar(40)	Yes	Asset number description	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
del_org_cost	fin_amount	numeric(13)	Yes	del original cost	No
del_dep_cost	fin_amount	numeric(13)	Yes	del depreciation cost	No
del_book_cost	fin_amount	numeric(13)	Yes	del book cost	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes