Data Dictionary -- Asset Capitalization

Srl. No.	Table Name	Comment
1	acap_accounting_info_dtl	To store information of accounting information detail
2	acap_amend_hdr	To store information of amendment header
3	acap_amend_tag_dtl	To store information of amendment tag detail
4	acap_asset_doc_dtl	To store information of asset document detail
5	acap_asset_doc_line_dtl	To store information of asset document line detail
6	acap_asset_hdr	To store information of asset header
7	acap_asset_listing_rpt	To store information of asset listing report
8	acap_asset_tag_dtl	To store information of asset tag detail
9	acap_document_dtl	To store information of document detail
10	acap_journal_accounting_dtl	To store information of journal accounting detail
11	acap_journal_dtl	To store information of journal detail
12	acap_journal_hdr	To store information of journal header
13	acap_notes_dtl	To store information of notes detail
14	acap_open_tran_rpt	To store information of open transaction report
15	acap_reverse_asset_dtl	To store information of reverse asset detail
16	acap_reverse_asset_hdr	To store information of reverse asset header
17	acap_reverse_wip_dtl	To store information of reverse wip detail
18	acap_reverse_wip_hdr	To store information of reverse wip header
19	acap_split_asset_dtl	To store information of split asset detail
20	acap_split_asset_hdr	To store information of split asset header
21	acap_tag_balance_dtl	To store information of tag balance detail
22	acap_tag_doc_dtl	To store information of tag document detail
23	acap_wip_accounting_dtl	To store information of wip accounting detail
24	acap_wip_dtl	To store information of wip detail
25	acap_wip_hdr	To store information of wip header
26	acap_wip_line_dtl	To store information of wip line detail

Table Name :	acap_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
doc_number	fin_documentnumber	varchar(18)	Yes	Document 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	Organization unit 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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_amend_hdr
Comment :	To store information of amendment header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
document_number	fin_documentnumber	varchar(18)	No	Document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag 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
new_tag	fin_flag	varchar(25)	Yes	New tag	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 :	acap_amend_tag_dtl
Comment :	To store information of amendment tag detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
document_number	fin_documentnumber	varchar(18)	No	Document number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
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 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
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal number	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
tag_cost_orig	fin_amount	numeric(13)	Yes	Tag cost original	No
tag_cost_diff	fin_amount	numeric(13)	Yes	Tag cost difference	No
new_tag	fin_flag	varchar(25)	Yes	New tag	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
expdt_eff_from	fin_date	datetime(8)	Yes	Expiry date effective from	No

Table Name :	acap_asset_doc_dtl
Comment :	To store information of asset document detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
doc_type	fin_doctype	varchar(40)	No	Document type	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
supplier_name	fin_name	varchar(60)	Yes	Supplier name	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
pending_cap_amt	fin_amount	numeric(13)	Yes	Pending capitalized amount	No
proposal_number	fin_documentnumber	varchar(18)	No	Proposal number	Yes
gr_date	fin_datetime	datetime(8)	Yes	Group date	No
currency	fin_currencycode	varchar(5)	Yes	Currency	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
cap_amount	fin_amount	numeric(13)	Yes	Capitalized amount	No
finance_bookid	fin_financebookid	varchar(20)	Yes	Finance book id	No
doc_status	fin_status	varchar(25)	Yes	Document 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 :	acap_asset_doc_line_dtl
Comment :	To store information of asset document line detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
doc_type	fin_doctype	varchar(40)	No	Document type	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal number	No
doc_amount	fin_amount	numeric(13)	Yes	Document	No
pending_cap_amt	fin_amount	numeric(13)	Yes	Pending capitalized amount	No
cap_amount	fin_amount	numeric(13)	Yes	Capitalized amount	No
tag_group	fin_code	varchar(6)	Yes	Tag group	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	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 :	acap_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	Organization unit id	Yes
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
cap_date	fin_datetime	datetime(8)	Yes	Capitalized date	No
cap_status	fin_status	varchar(25)	Yes	Capitalized status	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering 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
asset_cost_befround	fin_amount	numeric(13)	Yes	Asset cost before round	No
asset_cost_diff	fin_amount	numeric(13)	Yes	Asset cost difference	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 :	acap_asset_listing_rpt
Comment :	To store information of asset listing 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
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_group	fin_group	varchar(25)	Yes	Asset group	No
asset_cost	fin_amount	numeric(13)	Yes	Asset cost	No
asset_book_value	fin_amount	numeric(13)	Yes	Asset book value	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
asset_status	fin_status	varchar(25)	Yes	Asset status	No
ou_desc	fin_organizationunit	varchar(40)	Yes	Organization unit description	No
loc_desc	fin_desc40	varchar(40)	Yes	Location description	No
cost_center_desc	fin_desc40	varchar(40)	Yes	Cost center 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
tag_no	fin_assettagno	int(4)	Yes	Tag number	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit id	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_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	Organization unit id	Yes
asset_number	fin_assetnumber	varchar(18)	No	Asset number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
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 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
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal number	No
tag_status	fin_statuscode	varchar(2)	Yes	Tag statu	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 count	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
tag_cost_orig	fin_amount	numeric(13)	Yes	Tag cost original	No
tag_cost_diff	fin_amount	numeric(13)	Yes	Tag cost difference	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 :	acap_document_dtl
Comment :	To store information of document detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
doc_type	fin_doctype	varchar(40)	No	Document type	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_desc	fin_desc40	varchar(40)	Yes	Document description	No
proposal_number	fin_documentnumber	varchar(18)	Yes	Proposal number	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
pending_cap_amt_	fin_amount	numeric(13)	Yes	Pending capitalized amount	No
cap_amount	fin_amount	numeric(13)	Yes	Capitalized amount	No
tag_group	fin_code	varchar(6)	Yes	Tag group	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
cap_number	fin_documentnumber	varchar(18)	Yes	Capitalized number	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	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

Table Name :	acap_journal_accounting_dtl
Comment :	To store information of journal accounting 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	Organization unit 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	Sub analysis 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_accounttype	varchar(15)	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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_journal_dtl
Comment :	To store information of journal detail

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	Organization unit id	No
voucher_number	fin_documentnumber	varchar(18)	Yes	Voucher number	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_drcren	varchar(6)	Yes	Debit credit flag	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
proposal_no	fin_documentnumber	varchar(18)	Yes	Proposal number	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis 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
inservice_date	fin_datetime	datetime(8)	Yes	Inservice date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_journal_hdr
Comment :	To store information of journal header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
voucher_number	fin_documentnumber	varchar(18)	No	Voucher number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
transaction_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
reversal_period	fin_financeperiod	varchar(15)	Yes	Reversal period	No
journal_status	fin_statuscode	varchar(2)	Yes	Journal status	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
voucher_type	fin_documenttype	varchar(40)	Yes	Voucher type	No
tran_amount_befround	fin_amount	numeric(13)	Yes	Transaction amount before round	No
tran_amount_diff	fin_amount	numeric(13)	Yes	Transaction amount difference	No
createdby	fin_ctxt_user	varchar(30)	Yes	Createdby	No
createddate	fin_datetime	datetime(8)	Yes	Createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modifiedby	No
modifieddate	fin_datetime	datetime(8)	Yes	Modifieddate	No

Table Name :	acap_notes_dtl
Comment :	To store information of notes detail

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	Organization unit id	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
notes_desc	fin_notes	varchar(2000)	Yes	Notes 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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_open_tran_rpt
Comment :	To store information of open transaction 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	Organization unit id	No
doc_number	fin_documentnumber	varchar(18)	Yes	Document number	No
doc_type	fin_documenttype	varchar(40)	Yes	Document type	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
asset_number	fin_assetnumber	varchar(18)	Yes	Asset number	No
tag_number	fin_assettagno	int(4)	Yes	Tag number	No
asset_desc	fin_desc40	varchar(40)	Yes	Asset description	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
doc_status	fin_status	varchar(25)	Yes	Document 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
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_reverse_asset_dtl
Comment :	To store information of reverse asset detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	No
document_number	fin_documentnumber	varchar(18)	No	Document number	No
tag_number	fin_assettagno	int(4)	No	Tag number	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
depr_category	fin_deprcategory	varchar(40)	Yes	Depreciation category	No
business_use	fin_deprpercent	numeric(13)	Yes	Business use	No
inservice_date	fin_datetime	datetime(8)	Yes	Inservice date	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
tag_status	fin_statuscode	varchar(2)	Yes	Tag status	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
book_value	fin_amount	numeric(13)	Yes	Book 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
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
asset_class_code	fin_assetclass	varchar(20)	Yes	Asset class code	No
capital_number	fin_documentnumber	varchar(18)	Yes	Capital number	No
capital_date	fin_datetime	datetime(8)	Yes	Capital date	No
asset_no	fin_assetnumber	varchar(18)	Yes	Asset number	No
asset_description	fin_desc40	varchar(40)	Yes	Asset description	No
userid	fin_ctxt_user	varchar(30)	Yes	User id	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_reverse_asset_hdr
Comment :	To store information of reverse asset header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
document_number	fin_documentnumber	varchar(18)	No	Document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
status	fin_status	varchar(25)	Yes	Status	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
remarks	fin_remarks	varchar(100)	Yes	Remarks	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 :	acap_reverse_wip_dtl
Comment :	To store information of reverse wip detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
doc_number	fin_documentnumber	varchar(18)	No	Docement number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_type	fin_documenttype	varchar(40)	Yes	Document type	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
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 :	acap_reverse_wip_hdr
Comment :	To store information of reverse wip header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
status	fin_status	varchar(25)	Yes	Status	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
cap_wo_number	fin_documentnumber	varchar(18)	Yes	Capital work order number	No
cap_wo_desc	fin_desc40	varchar(40)	Yes	Capital work order 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 :	acap_split_asset_dtl
Comment :	To store information of split asset detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
document_number	fin_documentnumber	varchar(18)	No	Document number	Yes
tag_number	fin_assettagno	int(4)	No	Tag number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag description	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
tag_book_value	fin_amount	numeric(13)	Yes	Tag book value	No
net_revalued_cost	fin_amount	numeric(13)	Yes	Net revalued 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

Table Name :	acap_split_asset_hdr
Comment :	To store information of split asset header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
document_number	fin_documentnumber	varchar(18)	No	Document number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
status	fin_status	varchar(25)	Yes	Status	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	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
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
tag_book_value	fin_amount	numeric(13)	Yes	Tag book value	No
net_revalued_cost	fin_amount	numeric(13)	Yes	Net revalued 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

Table Name :	acap_tag_balance_dtl
Comment :	To store information of tag balance detail

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
cap_number	fin_documentnumber	varchar(18)	No	Capitalized number	Yes
as_on_date	fin_datetime	datetime(8)	No	As on date	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
depr_book	fin_deprkey	varchar(20)	Yes	Depreciation book	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tag_cost	fin_amount	numeric(13)	Yes	Tag cost	No
cumulative_total	fin_amount	numeric(13)	Yes	Cumulative total	No
depr_charge	fin_amount	numeric(13)	Yes	Depreciation cahrge	No
cumulative_depr	fin_amount	numeric(13)	Yes	Cumulative depreciation	No
tag_book_value	fin_amount	numeric(13)	Yes	Tag book value	No
tag_status	fin_status	varchar(25)	Yes	Tag status	No
tag_desc	fin_desc40	varchar(40)	Yes	Tag 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 :	acap_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	Organization unit id	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
account_code	fin_accountcode	varchar(32)	No	Account code	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
inv_account_code	fin_accountcode	varchar(32)	Yes	Invoice account code	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	acap_wip_accounting_dtl
Comment :	To store information of wip accounting detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tran_number	fin_transactionnumber	varchar(18)	No	Transaction number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ou_id	fin_ctxt_ouinstance	int(4)	Yes	Organization unit 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	Sub analysis 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
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 :	acap_wip_dtl
Comment :	To store information of wip detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
cap_wo_number	fin_documentno	varchar(40)	No	Capital work order number	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
doc_type	fin_documenttype	varchar(40)	No	Document type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
supplier	fin_name	varchar(60)	Yes	Supplier	No
wip_cost	fin_amount	numeric(13)	Yes	wip cost	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
pen_cap_amount	fin_amount	numeric(13)	Yes	Pending capitalized 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 :	acap_wip_hdr
Comment :	To store information of wip header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
cap_wo_number	fin_documentno	varchar(40)	No	Capitalized work order number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_number	fin_documentnumber	varchar(18)	Yes	Document number	No
transaction_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
num_type	fin_notypeno	varchar(10)	Yes	Numbering type	No
wip_status	fin_statuscode	varchar(2)	Yes	wip status	No
cap_wo_desc	fin_name	varchar(60)	Yes	Capitalized wor order description	No
asset_location	fin_assetlocation	varchar(20)	Yes	Asset location	No
wip_cost	fin_amount	numeric(13)	Yes	wip cost	No
wip_cost_befround	fin_amount	numeric(13)	Yes	wip cost before round	No
wip_cost_diff	fin_amount	numeric(13)	Yes	wip cost difference	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 :	acap_wip_line_dtl
Comment :	To store information of wip line detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ctxt_ouinstance	int(4)	No	Organization unit id	Yes
cap_wo_number	fin_documentno	varchar(40)	No	Capitalized work order number	Yes
doc_type	fin_documenttype	varchar(40)	No	Document type	Yes
doc_number	fin_documentnumber	varchar(18)	No	Document number	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
line_desc	fin_desc40	varchar(40)	Yes	Line description	No
doc_amount	fin_amount	numeric(13)	Yes	Document amount	No
pen_cap_amount	fin_amount	numeric(13)	Yes	Pending capitalized amount	No
asset_class	fin_assetclass	varchar(20)	Yes	Asset class	No
wip_cost	fin_amount	numeric(13)	Yes	wip cost	No
cap_line_no	fin_lineno	int(4)	Yes	Capitalized line number	No
cap_amount	fin_amount	numeric(13)	Yes	Capitalized 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