Asset Capitalization

Asset Capitalization

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	acap_accounting_info_dtl	This table will store all asset account details will be stored.	timestamp	int	Time Stamp	No	No
			tran_number	sql_variant	Transaction Number
			tran_type		Transaction Type
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_number	sql_variant	Document Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			ou_id	int	Organization Unit Id
			tran_date	datetime	Transaction Date
			posting_date		Posting Number
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis code
			sub_analysis_code		Subanalysis code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			cap_date	datetime	Capitalization Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			account_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_amend_hdr	This table will store all asset ament details will be stored.	ou_id	int	Organization Unit Id	Yes
			document_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_location		Asset Location
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			tag_status	sql_variant	Tag Status.Values FR-Fresh,AC-Active,AM-Amended,RE-Reversed,CL-Marked for Insur. Claim,TR-Marked for Transfer,RT-Retired,IT-InTransfer,RC-Retired-Claimable.T-Transfered,FZ-Frozen.
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			new_tag	sql_variant	New Tag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_amend_tag_dtl	This table will store all asset ament tag details will be stored.	ou_id	int	Organization Unit Id	Yes
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			document_number	sql_variant	Document Number
			fb_id		Finance Book Id
			timestamp	int	Time Stamp	No
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_location		Asset Location
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			proposal_number	sql_variant	Proposal Number
			tag_status		Tag Status.Values FR-Fresh,AC-Active,AM-Amended.
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			revalued_cost		Revalued Cost
			inv_date	datetime	Invoice Date
			inv_due_date		Invoice Due Date
			inv_status	sql_variant	Invoice Status.Value AC-Active.
			softrev_run_no		Soft Reverse Run Number
			insurable_value	bigint	Insurable Value
			tag_cost_orig		Tag Cost Originate
			tag_cost_diff		Tag Cost Difference
			new_tag	sql_variant	New Tag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			usefullife_expdt	fin_date	Usefull life expiry date
			expdt_eff_from	datetime	expiry date effective from
	acap_asset_bulk_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			cap_amount	bigint	Capitalization Amount
			tag_group	sql_variant	Tag Group
			asset_number		Asset Number
			tag_number	int	Tag Number
			location_code	sql_variant	Location Code
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			new_tag	sql_variant	New Tag
	acap_asset_doc_dtl	This table will store all asset document details will be stored.	ou_id	int	Organization Unit Id	Yes
			cap_number	sql_variant	Capitalization Number
			asset_number		Asset Number
			doc_type		Document Type
			doc_number		Document Number
			proposal_number		Proposal Number
			supplier_name		Supplier Name	No
			timestamp	int	Time Stamp
			doc_date	datetime	Document Date
			doc_amount	bigint	Document Amount
			pending_cap_amt		Pending Capitalization Amount
			gr_date	datetime	Good Receipt Date
			currency	sql_variant	Currency
			exchange_rate	bigint	Exchange Rate
			cap_amount		Capitalization Amount
			finance_bookid	sql_variant	Finance Book Id
			doc_status		Document Status.Values FR-Fresh
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_asset_doc_line_dtl	This table will store all asset document line details will be stored.	ou_id	int	Organization Unit Id	Yes
			cap_number	sql_variant	Capitalization Number
			asset_number		Asset Number
			doc_type		Document Type
			doc_number		Document Number
			line_no	int	Line Number
			timestamp		Time Stamp	No
			proposal_number	sql_variant	Proposal Number
			doc_amount	bigint	Document Amount
			pending_cap_amt		Pending Capitalization Amount
			cap_amount		Capitalization Amount
			tag_group	sql_variant	Tag Group
			doc_date	datetime	Document Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_asset_doc_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			doc_number	sql_variant	Document Number
			asset_number		Asset Number
			doc_type		Document Type
			cap_number		Capitalization Number
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			doc_amount	bigint	Document Amount
			pending_cap_amt		Pending Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			gr_date	datetime	Goods Receipt Date
			currency	sql_variant	Currency
			exchange_rate	bigint	Exchange Rate
			cap_amount		Capitalization Amount
			tag_group	sql_variant	Tag Group
			fb_id		Finance Book Id
			asset_class		Asset Class
			capital_flag		Capital Flag
			new_tag		New Tag
			tag_no	int	Tag Number
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			labour_cap_flag	sql_variant	Labour Capitalization Flag
			line_no	int	Line Number
	acap_asset_edit_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			timestamp	int	Time Stamp
			asset_desc	sql_variant	Asset Description
			asset_class_code		Asset Class Code
			asset_cost	bigint	Asset Cost
			asset_group	sql_variant	Asset Group
			cost_center		Cost Center
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_asset_hdr	This table will store all asset details will be stored.	ou_id	int	Organization Unit	Yes
			cap_number	sql_variant	Capitalization Number
			asset_number		Asset Number
			timestamp	int	Time Stamp	No
			cap_date	datetime	Capitalization Date
			cap_status	sql_variant	Capitalization Status.Values FR-Fresh,AC-Active,AM-Amended,RE-Reversed,CL-Marked for Insur. Claim,TR-Marked for Transfer,RT-Retired,IT-InTransfer,RC-Retired-Claimable.T-Transfered,FZ-Frozen.
			fb_id		Finance Book Id
			num_type		Numbering Type
			asset_class		Asset Class
			asset_group		Asset Group
			cost_center		Cost Center
			asset_desc		Asset Description
			asset_cost	bigint	Asset Cost
			asset_location	sql_variant	Asset Location
			seq_no	int	Sequence Number
			as_on_date	datetime	As On Date
			asset_type	sql_variant	Asset Type
			asset_status		Asset Status.Values FR-Fresh,AC-Active,AM-Amended,RE-Reversed,CL-Marked for Insur. Claim,TR-Marked for Transfer,RT-Retired,IT-InTransfer,RC-Retired-Claimable.T-Transfered,FZ-Frozen.
			transaction_date	datetime	Transaction Date
			account_code	sql_variant	Account Code
			asset_cost_befround	bigint	Asset Code Before Round
			asset_cost_diff		Asset Cost Difference
			createdby	sql_variant	Created By
			createddate	datetime	Created By Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_asset_info_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			cap_number	sql_variant	Capitalization Number
			asset_number		Asset Number
			cap_date	datetime	Capitalization Date
			cap_status	sql_variant	Capitalization Status
			fb_id		Finance Book Id
			num_type		Numbering Type
			asset_class		Asset Class
			asset_group		Asset Group
			cost_center		Cost Center
			asset_desc		Asset Description
			asset_cost	bigint	Asset Cost
			asset_location	sql_variant	Asset Location
			seq_no	int	Sequence Number
			as_on_date	datetime	As On Date
			asset_type	sql_variant	Asset Type
			asset_status		Asset Status
			transaction_date	datetime	Transaction Date
			account_code	sql_variant	Account Code
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			proposal_number	sql_variant	Proposal Number
			tag_status		Tag Status
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			revalued_cost		Revalued Cost
			inv_date	datetime	Invoice Date
			inv_due_date		Invoice Due Date
			inv_status	sql_variant	Invoice Status
			softrev_run_no		Soft Reverse Run Number
			insurable_value	bigint	Insurable Value
			policy_count	int	Policy Count
			dest_fbid	sql_variant	Destination Finance Book Id
			transfer_date	datetime	Transfer Date
			legacy_asset_no	sql_variant	Legacy Asset Number
			migration_status		Migration Status
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tran_type	sql_variant	Transaction Type
			expdt_eff_from	datetime	expiry date effective from
	acap_asset_line_tmp		guid		Guid	Yes
			doc_type		Document Type
			doc_number		Document Number
			ou_id	int	Organization Unit Id
			line_no		Line Number
			account_code	sql_variant	Account Code
			timestamp	int	Time Stamp	No
			proposal_number	sql_variant	Proposal Number
			cap_number		Capitalization Number
			doc_amount	bigint	Document Amount
			pending_cap_amt		Pending Capitalization Amount
			cap_amount		Capitalization Amount
			tag_group	sql_variant	Tag Group
			doc_date	datetime	Document Date
			tag_no	int	Tag Number
			new_tag	sql_variant	New Flag
			fb_id		Finance Book Id
			supplier_name		Supplier Name
			asset_class		Asset Class
			line_amount	bigint	Line Amount
			doc_desc	sql_variant	Document Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_asset_listing_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			asset_number		Asset Number
			asset_desc		Asset Description
			asset_class		Asset Class
			asset_group		Asset Group
			asset_cost	bigint	Asset Cost
			asset_book_value		Asset Book Value
			cost_center	sql_variant	Cost Center
			asset_location		Asst Location
			fb_id		Finance Book Id
			asset_status		Asset Status.Value AC-Active.
			ou_desc		Organization Unit Description
			loc_desc		Location Description
			cost_center_desc		Cost Center Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tag_no	int	Tag Number
			ou_id		Organization Unit
	acap_asset_tag_dtl	This table will store all asset tag details will be stored.			Organization Unit Id	Yes
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			cap_number	sql_variant	Capitalization Number
			fb_id		Finance Book Id
			timestamp	int	Time Stamp	No
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			asset_location		Asset Location
			cost_center		Cost Center
			inservice_date	datetime	Inservice Date
			tag_cost	bigint	Tag Cost
			proposal_number	sql_variant	Proposal Number
			tag_status		Tag Status.Values FR-Fresh,AC-Active,AM-Amended,RE-Reversed,CL-Marked for Insur. Claim,TR-Marked for Transfer,RT-Retired,IT-InTransfer,RC-Retired-Claimable.T-Transfered,FZ-Frozen.
			depr_category		Depreciation Category
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			business_use	bigint	Business Use
			reverse_remarks	sql_variant	Reverse Remarks
			book_value	bigint	Book Value
			revalued_cost		Revalued Cost
			inv_date	datetime	Invoice Date
			inv_due_date		Invoice Due Date
			inv_status	sql_variant	Invoice Status.Values FZ-Frozen,IT-InTransfer, MR-To retire,T-Transfered.
			softrev_run_no		Soft Reverse Run Number
			insurable_value	bigint	Insurable Value
			policy_count	int	Policy Count
			dest_fbid	sql_variant	Destination Finance Book Id
			transfer_date	datetime	Transfer Date
			legacy_asset_no	sql_variant	Legacy Asset Number
			migration_status		Migration Status.Value AC-Active.
			tag_cost_orig	bigint	Tag Cost Origination
			tag_cost_diff		Tag Cost Difference
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			usefullife_expdt	fin_date	Useful life expiry date
	acap_asset_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			asset_number		Asset Number
			cap_number		Capitalization Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_assetclass_ui_tmp		asset_class	sql_variant	Asset Class
			asset_location		Asset Location
			bar_code		Bar Code
			business_use	bigint	Business Use
			custodian	sql_variant	Custodian
			depr_category		Depreciation Category
			guid		Guid
			inservicedate	datetime	Inservice Date
			inventory_cycle	sql_variant	Inventory Cycle
			manufacturer		Manufacturer
			model		Model
			proposal_number		Proposal Number
			salvage_value	bigint	Salvage Value
			serial_number	sql_variant	Serial Number
			tag_cost	bigint	Tag Cost
			tag_description	sql_variant	Tag Description
			tag_number	int	Tag Number
			warrenty_number	sql_variant	Warranty Number
	acap_doc_dtl_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			cap_number		Capitalization Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_number	sql_variant	Document Number
			line_no	int	Line Number
			doc_amount	bigint	Document Amount
			doc_type	sql_variant	Document Type
			cap_amount	bigint	Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_doc_tmp		cap_no	sql_variant	Capitalization Number
			asset_no		Asset Number
			doc_no		Document Number
			line_no	int	Line Number
			tag_no		Tag Number
			line_amount	bigint	Line Amount
			guid	sql_variant	Guid
			split_no		Split Number
	acap_document_dtl	This table will store all asset document &nbspdetails will be stored.	ou_id	int	Organization Unit Id	Yes
			doc_type	sql_variant	Document Type
			doc_number		Document Number
			line_no	int	Line Number
			timestamp		Time Stamp	No
			doc_desc	sql_variant	Document Description
			proposal_number		Proposal Number
			asset_class		Asset Class
			doc_amount	bigint	Document Amount
			pending_cap_amt_		Pending Capitalization Amount
			cap_amount		Capitalization Amount
			tag_group	sql_variant	Tag Group
			doc_date	datetime	Document Date
			cap_number	sql_variant	Capitalization Number
			fb_id		Finance Book Id
			account_code		Account Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_fbpostings_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			company_code		Company Code
			component_name		Component Name
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			tran_ou	int	Transaction Organization Unit
			fb_voucher_no	sql_variant	Finance Voucher Number
			fb_voucher_date	datetime	Finance Voucher Date
			document_no	sql_variant	Document Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			account_code	sql_variant	Account Code
			drcr_flag		Credit Debit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			exchange_rate		Exchange Rate
			ou_id	int	Organization Unit Id
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			par_base_amount	bigint	Parallel Base Amount
			par_exchange_rate		Parallel Exchange Rate
			mac_flag	sql_variant	Management Account Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_journal_accounting_dtl	This table will store all asset journal accounting details &nbspwill be stored.	timestamp	int	Time Stamp
			tran_number	sql_variant	Transaction Number
			tran_type		Transaction Type
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ou_id	int	Organization Unit Id
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis code
			sub_analysis_code		Subanalysis code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			cap_date	datetime	Capitalization Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			account_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_journal_accounting_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			tran_number		Transaction Number
			tran_type		Transaction Type
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ou_id	int	Organization Unit Id
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			cap_date	datetime	Capitalization Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			account_type		Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_journal_dtl	This table will store all asset journal &nbspdetails &nbspwill be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			voucher_number	sql_variant	Voucher Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_amount	bigint	Transaction Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			inservice_date	datetime	Inservice Date
	acap_journal_hdr		ou_id	int	Organization Unit Id	Yes
			voucher_number	sql_variant	Voucher Number
			timestamp	int	Time Stamp	No
			transaction_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			reversal_period		Reversal Period
			journal_status		Journal Status.Values FR-Fresh,AC-Active,IA-Inactive.
			remarks		Remarks
			tran_amount	bigint	Transaction Amount
			voucher_type	sql_variant	Voucher Type
			tran_amount_befround	bigint	Transaction Amount Before Round
			tran_amount_diff		Transaction Amount Difference
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_journal_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			voucher_number	sql_variant	Voucher Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tag_number	int	Tag Number
			asset_number	sql_variant	Asset Number
			tran_amount	bigint	Transaction Amount
			proposal_no	sql_variant	Proposal Number
			remarks		Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			asset_flag		Asset Flag
			currency_code		Currency Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_notes_dtl	This table will store all asset note details &nbspwill be stored.	timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			asset_number	sql_variant	Asset Number
			tag_number	int	Tag Number
			notes_desc	sql_variant	Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_notes_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			notes_id		Notes Id
			notes_desc		Notes Description
			notes		Note
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_open_tran_rpt		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			doc_number	sql_variant	Document Number
			doc_type		Document Type
			doc_date	datetime	Document Date
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			asset_desc	sql_variant	Asset Description
			tag_desc		Tag Description
			doc_status		Document Status.Value AC-Active.
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_prop_dtl_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			cap_number		Capitalization Number
			asset_class		Asset Class
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_number	sql_variant	Document Number
			line_no	int	Line Number
			doc_amount	bigint	Document Amount
			doc_type	sql_variant	Document Type
			cap_amount	bigint	Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			status		Status
			cap_date	datetime	Capitalization Date
	acap_reverse_asset_dtl	This table will store all reverse asset details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			document_number	sql_variant	Document Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			tag_desc	sql_variant	Tag Description
			depr_category		Depreciation Category
			business_use	bigint	Business Use
			inservice_date	datetime	Inservice Date
			asset_location	sql_variant	Asset Location
			cost_center		Cost Center
			tag_cost	bigint	Tag Cost
			tag_status	sql_variant	Tag Status.Values RE-Reverse.
			inv_cycle		Invoice Cycle
			salvage_value	bigint	Salvage Value
			manufacturer	sql_variant	Manufacturer
			bar_code		Bar Code
			serial_no		Serial Number
			warranty_no		Warranty Number
			model		Model
			custodian		Custodian
			book_value	bigint	Book Value
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			fb_id	sql_variant	Finance Book Id
			asset_class_code		Asset Class Code
			capital_number		Capital Number
			capital_date	datetime	Capital Date
			asset_no	sql_variant	Asset Number
			asset_description		Asset Description
			userid		Use Id
	acap_reverse_asset_hdr		ou_id	int	Organization Unit Id	Yes
			document_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			status		Status.Values AC-Active,RE-Reversed.
			num_type		Numbering Type
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_reverse_wip_dtl	This table will store all reverse wip asset details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			doc_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			doc_type	sql_variant	Document Type
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			doc_amount	bigint	Document Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_reverse_wip_hdr		ou_id	int	Organization Unit Id	Yes
			doc_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			status		Status.Values FR-Fresh,AC-Active,DE-Delete.
			num_type		Numbering Type
			asset_class		Asset Class
			asset_location		Asset Location
			cap_wo_number		Capitalization Work Order Number
			cap_wo_desc		Capitalization Work Order Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_split_asset_dtl	This table will store all splict asset details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			document_number	sql_variant	Document Number
			tag_number	int	Tag Number
			timestamp		Time Stamp	No
			tag_desc	sql_variant	Tag Description
			tag_cost	bigint	Tag Cost
			tag_book_value		Tag Book Value
			net_revalued_cost		Net Revalued Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_split_asset_hdr		ou_id	int	Organization Unit Id	Yes
			document_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			status		Status.Value AC-Active.
			num_type		Numbering Type
			asset_number		Asset Number
			asset_desc		Asset Description
			tag_number	int	Tag Number
			tag_desc	sql_variant	Tag Description
			tag_cost	bigint	Tag Cost
			tag_book_value		Tag Book Value
			net_revalued_cost		Net Revalued Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_tag_balance_dtl	This table will store all asset tag balance details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			asset_number		Asset Number
			tag_number	int	Tag Number
			cap_number	sql_variant	Capitalization Number
			as_on_date	datetime	As On Date
			timestamp	int	Time Stamp	No
			depr_book	sql_variant	Depreciation Book
			tran_type		Transaction Type
			tag_cost	bigint	Tag Cost
			cumulative_total		Cumulative Total
			depr_charge		Depreciation Charge
			cumulative_depr		Cumulative Depreciation
			tag_book_value		Tag Book Value
			tag_status	sql_variant	Tag Status.Value AC-Active.
			tag_desc		Tag Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_tag_doc_dtl	This table will store all asset document details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			cap_number		Capitalization Number
			asset_number		Asset Number
			tag_number	int	Tag Number
			doc_number	sql_variant	Document Number
			line_no	int	Line Number
			account_code	sql_variant	Account Code
			timestamp	int	Time Stamp	No
			doc_amount	bigint	Document Amount
			doc_type	sql_variant	Document Type
			cap_amount	bigint	Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tran_type	sql_variant	Transaction Type
			cost_center	sql_variant	Cost Center
			analysis_code	sql_variant	analysis code
			subanalysis_code	sql_variant	subanalysis code
	acap_tag_input_tmp		asset_no	sql_variant	Asset Number
			tag_no_hdr	int	Tag Number Header
			tag_no_dtl		Tag Number Detail
			tag_amount	bigint	Tag Amount
			guid	sql_variant	Guid
			tag_desc	varchar(256)	Tag Description
	acap_tag_split_tmp		cap_no	sql_variant	Capitalization Number
			asset_no		Asset Number
			doc_no		Document Number
			line_no	int	Line Number
			tag_no		Tag Number
			line_amount	bigint	Line Amount
			tag_amount		Tag Amount
			guid	sql_variant	Guid
	acap_updinvoice_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			tran_ou		Transaction Organization Unit
			trans_type	sql_variant	Transactions Type
			tran_type		Transaction Type
			doc_type		Document Type
			doc_number		Document Number
			account_code		Account Code
			doc_date	datetime	Document Date
			line_no	int	Line Number
			cap_amount	bigint	Capitalization Amount
			tran_number	sql_variant	Transaction Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_updproposal_tmp		guid	sql_variant	Guid
			fb_id		Finance Book Id
			asset_class		Asset Class
			SrcOu	int	Source Organization Unit
			SrcComponent	sql_variant	Source Component
			Document_OU	int	Document Organization Unit
			Document_Type	sql_variant	Document Organization Type
			Document_No		Document Number
			Document_Task		Document Task
			Document_Flag		Document Flag
			Document_Date	datetime	Document Date
			Document_Curr	sql_variant	Document Currency
			Document_ProposalNo		Document Proposal Number
			Document_Stage		Document Stage
			Document_Status		Document Status
			Document_LineNo	int	Document Line Number
			Document_Amount	bigint	Document Amount
			RefDoc_Ou	int	Reference Document Organization Unit
			RefDoc_Type	sql_variant	Reference Document Type
			RefDoc_Number		Reference Document Number
			RefDoc_CompID		Reference Document Component Id
			RefDoc_Task		Reference Document Task
			RefDoc_Flag		Reference Document Flag
			RefDoc_ProposalNo		Reference Document Proposal Number
			RefDoc_Stage		Reference Document Stage
			RefDoc_Curr		Reference Document Currency
			Refoct_LineNo	int	Reference Document Line Number
			RefDoc_Amount	bigint	Reference Document Amount
			RefDoc_Status	sql_variant	Reference Document Status
	acap_wip_accounting_dtl	This table will store all wip asset account details &nbspwill be stored.	tran_number		Transaction Number	Yes
			tran_type		Transaction Type
			doc_number		Document Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			timestamp	int	Time Stamp	No
			ou_id		Organization Unit Id
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			cap_date	datetime	Capitalization Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_accounting_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			tran_number		Transaction Number
			tran_type		Transaction Type
			doc_number		Document Number
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			ou_id	int	Organization Unit Id
			tran_date	datetime	Transaction Date
			posting_date		Posting Date
			currency	sql_variant	Currency
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			bc_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbc_erate		Parallel Base Currency Exchange Rate
			pbase_amount		Parallel Base Amount
			cap_date	datetime	Capitalization Date
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_dtl	This table will store all wip asset details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			cap_wo_number	sql_variant	Capitalization Work Order Number
			doc_number		Document Number
			doc_type		Document Type
			timestamp	int	Time Stamp	No
			doc_date	datetime	Document Date
			supplier	sql_variant	Supplier
			wip_cost	bigint	Work In Progress Cost
			asset_class	sql_variant	Asset Class
			doc_amount	bigint	Document Amount
			pen_cap_amount		Penalty Capitalization Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_hdr		ou_id	int	Organization Unit Id	Yes
			cap_wo_number	sql_variant	Capitalization Work Order Number
			timestamp	int	Time Stamp	No
			doc_number	sql_variant	Document Number
			transaction_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			wip_status		Work In Progress Status.Values FR-Fresh,AC-Active,DE-Delete.
			cap_wo_desc		Capitalization Work Order Description
			asset_location		Asset Location
			wip_cost	bigint	Work In Progress Cost
			wip_cost_befround		Work In Progress Cost Before Round
			wip_cost_diff		Work In Progress Cost Difference
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_hdr_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			cap_wo_number	sql_variant	Capitalization Work Order Number
			timestamp	int	Time Stamp	No
			doc_number	sql_variant	Document Number
			transaction_date	datetime	Transaction Date
			fb_id	sql_variant	Finance Book Id
			num_type		Numbering Type
			wip_status		Work In Progress Status
			cap_wo_desc		Capitalization Work Order Description
			asset_class		Asset Class
			asset_location		Asset Location
			wip_cost	bigint	Work In Progress Cost
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_line_dtl	This table will store all wip asset line details &nbspwill be stored.	ou_id	int	Organization Unit Id	Yes
			cap_wo_number	sql_variant	Capitalization Work Order Number
			doc_type		Document Type
			doc_number		Document Number
			line_no	int	Line Number
			timestamp		Time Stamp	No
			line_desc	sql_variant	Line Description
			doc_amount	bigint	Document Amount
			pen_cap_amount		Penalty Capitalization Amount
			asset_class	sql_variant	Asset Class
			wip_cost	bigint	Work In Progress Cost
			cap_line_no	int	Capitalization Line Number
			cap_amount	bigint	Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_line_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			line_no		Line Number
			doc_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			cap_wo_number	sql_variant	Capitalization Work Order Number
			doc_type		Document Type
			line_desc		Line Description
			doc_amount	bigint	Document Amount
			pen_cap_amount		Penalty Capitalization Amount
			asset_class	sql_variant	Asset Class
			wip_cost	bigint	Work In Progress Cost
			cap_amount		Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			doc_date	datetime	Document Date
			supplier_name	sql_variant	Supplier Name
			lineitem_amount	bigint	Line Item Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	acap_wip_tmp		guid	sql_variant	Guid	Yes
			ou_id	int	Organization Unit Id
			doc_number	sql_variant	Document Number
			timestamp	int	Time Stamp	No
			cap_wo_number	sql_variant	Capitalization Work Order Number
			doc_type		Document Type
			doc_date	datetime	Document Date
			supplier	sql_variant	Supplier
			wip_cost	bigint	Work In Progress Cost
			doc_amount		Document Amount
			pen_cap_amount		Penalty Capitalization Amount
			proposal_number	sql_variant	Proposal Number
			cap_line_no	int	Capitalization Line Number
			asset_class	sql_variant	Asset Class
			fb_id		Finance Book Id
			noncapital_doc		Other Than Capital Document
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	FinLJServtmp		Finance_Book	sql_variant	Finance Book
			Document_Type		Document Type
			WorkOrder_No		Work Order Number
			WorkOrder_Date	datetime	Work Order Date
			WorkOrder_Amt	bigint	Work Order Amount
			Capitalized_Amt		Capitalized Amount
			Line_No	int	Line Number
			Proposal_No	sql_variant	Proposal Number
			Line_Amt	bigint	Line Amount
			Line_Desc	sql_variant	Line Description
			Acc_Code		Account Code
			Cost_Center		Cost Center
			Analysis_Code		Analysis Code
			Sub_Analysis_Code		Subanalysis Code
			guid		Guid
			seqno	int	Sequence Number
			Asset_No	sql_variant	Asset Number
			Asset_Tag	int	Asset Tag
	finserwoamt_tmp		Finance_Book	sql_variant	Finance Book
			Document_Type		Document Type
			WorkOrder_No		Work Order Number
			WorkOrder_Date	datetime	Work Order Date
			WorkOrder_Amt	bigint	Work Order Amount
			Capitalized_Amt		Capitalized Amount
			Line_No	int	Line Number
			Proposal_No	sql_variant	Proposal Number
			Line_Amt	bigint	Line Amount
			Line_Desc	sql_variant	Line Description
			Acc_Code		Account Code
			Cost_Center		Cost Center
			Analysis_Code		Analysis Code
			Sub_Analysis_Code		Subanalysis Code
			guid		Guid
			seqno	int	Sequence Number
			Labour_Capitalized_Amt	bigint	Labour Capitalized Amount