TBP

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	tbp_account_balance	Gives the account balance details	ou_id	int	Organization Unit Id	Yes	No
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			fin_year_code		Finance Year Code
			fin_period_code		Finance Period Code
			account_code		Account Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			period_credit		Period Credit
			period_debit		Period Debit
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			recon_status	sql_variant	Reconciliation Status.Values A Authorized, R Reversed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_attach_notes	Gives the details of the notes attached	ou_id	int	Organization Unit	Yes
			voucher_no	sql_variant	Voucher Number
			timestamp	int	Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values A Authorized, R Reversed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_attach_notes_hist	Gives the history of the notes attached	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			attach_notes_desc	sql_variant	Attach Notes Description
			voucher_status		Voucher Status.Values A Authorized, R Reversed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_attach_notes_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit
			voucher_no	sql_variant	Voucher Number
			std_notes_id		Standard Notes  Id
			std_desc		Standard Description
			attach_notes_desc		Attach Notes Description
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_compute_total_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			bu_id		Business Unit Id
			voucher_date	datetime	Voucher Date
			tran_date		Transaction Date
			posting_date		Posting Date
			component_name	sql_variant	Component Name
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			fb_type		Finance Book Type
			closure_type		Closure Type
			closure_option		Closure Option
			tax_year_range		Tax Year Range
			tax_prd_range_from		Tax Period Range From
			tax_prd_range_to		Tax Period Range To
			coa_id		Chart Of Account Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_finstmtvalues_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			company_code		Company Code
			finstmt_type		Finance Statement Type
			layout_heading		Layout Heading
			amount	bigint	Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_header_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			fin_year		Finance Year
			fin_period		Finance Period
			first_period		First Period
			fb_id		Finance Book Id
			dispoption		Display Option
			basecurrency		Base Currency
			yeartodate		Year To Date
			notes_desc		Notes Descripiton
			std_notes_desc		Standard Notes Descripiton
			std_notes_id		Standard Notes Id
			ctxt_service		Context Service
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			status		Status.Values O Open, C Closed, P Provisional Closed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ibe_trn_compute_tmp		guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			finance_year		Finance Year
			finance_period		Finance Period
			account_code		Account Code
			timestamp	int	Time Stamp
			account_desc	sql_variant	Account Description
			currency		Currency
			debit_credit		Debit Credit
			base_amt	bigint	Base Amount
			tran_amt		Transaction Amount
			account_group	sql_variant	Account Group
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ibe_trn_dtl	Gives the initial balance details	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			finance_year		Finance Year
			finance_period		Finance Period
			account_code		Account Code
			timestamp	int	Time Stamp	No
			debit_credit	sql_variant	Debit Credit
			base_amt	bigint	Base Amount
			tran_amt		Transaction Amount
			batch_id	sql_variant	Batch Id
			doc_no		Document Number
			tran_type		Transaction Type
			tran_ou	int	Transaction  Organization Unit
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ibe_trn_dtl_tmp		ou_id	int	Organixation Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			finance_year		Finance Year
			finance_period		Finance Period
			account_code		Account Code
			timestamp	int	Time Stamp	No
			debit_credit	sql_variant	Debit Credit
			base_amt	bigint	Base Amount
			tran_amt		Transaction Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ibe_trn_upload_tmp		ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			account_code		Account Code
			timestamp	int	Time Stamp	No
			debit_credit	sql_variant	Debit Credit
			base_amt	bigint	Base Amount
			tran_amt		Transaction Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_isbsbalance_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			isbs_id		Income Statement Balance Sheet Id
			account_code		Account Code
			finance_bookid		Finance Book Id
			ou_id	int	Organization
			layout_heading	sql_variant	Layout Heading
			cb_credit	bigint	Closing Balance Credit
			cb_debit		Closing Balance Debit
			ob_credit		Opening Balance Credit
			ob_debit		Opening Balance Debit
			period_debit		Period Debit
			period_credit		Period Credit
			fin_year	sql_variant	Finance Year
			fin_period		Finance Period
			account_group		Account Group
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_post_trantype_sys	Gives the tran type details	tran_type	sql_variant	Transaction Type	Yes
			timestamp	int	Time Stamp	No
			tran_desc	sql_variant	Transaction Description
			category		Category
			language_id	int	Language Id
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_postact_balance_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			account_code		Account Code
			account_desc		Account Description
			opening_balance	bigint	Opening Balance
			prd_credit		Period Credit
			prd_debit		Period Debit
			currency_code	sql_variant	Currency Code
			account_group		Account Group
			ob_credit	bigint	Opening Balance Credit
			ob_debit		Opening Balance Debit
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			closing_balance	bigint	Closing Balance
			budget_amount		Budget Amount
			utilized_amount		Utilized Amount
			variance_amount		Variance Amount
			variance_percentage		Variance Percentage
			company_code	sql_variant	Company Code
			control_action		Control Action
	tbp_posted_trn_dtl	Gives the posting details	timestamp	int	Time Stamp
			batch_id	sql_variant	Batch Id
			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 Book Voucher Number
			fb_voucher_date	datetime	Finance Book Voucher Date
			con_ref_voucherno	sql_variant	Consolidation Reference Voucher Number
			document_no		Document Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			entry_date		Entry Date
			auth_date		Authorized Date
			posting_date		Posting Date
			ou_id	int	Organization Unit Id
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			narration	sql_variant	Narration
			bank_code		Bank Code
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			item_code		Item Code
			item_variant		Item  Variant
			quantity	bigint	Quantity
			reftran_fbid	sql_variant	Reference Transaction Finance Book Id
			reftran_no	bigint	Reference Transaction  Number
			reftran_ou	int	Reference Transaction  Organization Unit
			ref_tran_type	sql_variant	Reference Transaction  Type
			supcust_code		Supplier Customer Code
			uom		Unit Of Measurement
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified  Date
	tbp_postings_mode_sys	Gives the posting mode details	component_name	sql_variant	Company Name	Yes
			calling_srvc_or_view		Calling Service Or View
			timestamp	int	Time Stamp	No
			online_post	sql_variant	On Line Posting
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ret_earn_yr_prd	Gives the retained earnings year/period closure status	company_code	sql_variant	Company Code	Yes
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			timestamp	int	Time Stamp	No
			ret_earn_amount	bigint	Return Earn Amount
			drcr_flag	sql_variant	Debit Credit Flag
			close_status		Close Status.Values O Open, C Closed, P Provisional Closed
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_ret_earn_yr_prd_his	Gives the history of the retained earnings year/period closure status	company_code	sql_variant	Company Code	Yes
			fb_id		Finance Book Id
			fin_year		Finance Year
			fin_period		Finance Period
			run_no	int	Run Number
			timestamp		Time Stamp	No
			ret_earn_amount	bigint	Return Earn Amount
			drcr_flag	sql_variant	Debit Credit Flag
			close_status		Close Status. Values O Open, C Closed, P Provisional Closed
			createdby		Created By
			createddate	datetime	Created  Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_runbal_accounts_tmp		timestamp	int	Time Stamp
			gu_id	sql_variant	Guid
			company_code		Company Code
			fb_id		Finance Book Id
			account_code		Account Code
			account_desc		Account Description
			account_group		Account Group
			account_currency		Account Currency
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_runbal_actbal_tmp		timestamp	int	Time Stamp
			gu_id	sql_variant	Guid
			serial_no	int	Serial Number
			account_code	sql_variant	Account Code
			doc_ou	int	Document Organization Unit
			doc_type	sql_variant	Document Type
			doc_no		Document  Number
			act_cb_drcr		Actual Closing Balance Debit Credit
			base_cb_drcr		Base Closing Balance Debit Credit
			base_cr_amount	bigint	Base Credit Amount
			base_dr_amount		Base Debit Amount
			act_cr_amount		Actual Credit Amount
			act_dr_amount		Actual Debit Amount
			act_amount		Actual Amount
			act_runbal		Actual Run Balance
			base_amount		Base Amount
			base_runbal		Base Run Balance
			total_sum		Total Sum
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			startdate		Start Date
			fb_id	sql_variant	Finance Book Id
			posting_date	datetime	Posting Date
			currency_code	sql_variant	Currency Code
			drcr_flag		Debit Credit Flag
			cr_amount	bigint	Credit Amount
			dr_amount		Debit Amount
			runbal_amount		Run Balance Amount
			entry_date	datetime	Entry Date
			auth_date		Authorized Date
			exchange_rate	bigint	Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			narration	sql_variant	Narration
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			item_code		Item Code
			item_variant		Item Variant
			quantity	bigint	Quantity
			reftran_fbid	sql_variant	Reference Transaction Finance Book Id
			reftran_no		Reference Transaction Number
			reftran_ou	int	Reference Transaction Organization Unit
			ref_tran_type	sql_variant	Reference Transaction Type
			supcust_code		Supplier Customer Code
			uom		Unit Of Measurement
			bank_code		Bank Code
			total_cr_sum	bigint	Total Credit Sum
			total_dr_sum		Total Debit Sum
			clo_cr_bal		Closing Credit Balance
			clo_dr_bal		Closing Debit Balance
			short_desc	varchar(75)	Short Description
	tbp_unpost_account_balance	Gives the details about unposted account balances	ou_id	int	Organization Unit Id	Yes
			fb_id	sql_variant	Finance Book Id
			account_code		Account Code
			currency_code		Currency Code
			timestamp	int	Time Stamp	No
			dr_balance	bigint	Debit Balance
			cr_balance		Credit Balance
			createdby	sql_variant	Created By
			createddate	datetime	Created  Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_unposted_trn_dtl	Gives the posting details	timestamp	int	Time Stamp
			batch_id	sql_variant	Batch Id
			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 Book Voucher Number
			fb_voucher_date	datetime	Finance Book Voucher Date
			con_ref_voucherno	sql_variant	Consolidation Ref Voucher Num
			document_no		Document Number
			tran_type		Transaction Type
			tran_date	datetime	Transaction Date
			entry_date		Entry Date
			auth_date		Authorized Date
			posting_date		Posting Date
			ou_id	int	Organization Unit Id
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			narration	sql_variant	Narration
			bank_code		Bank Code
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			item_code		Item Code
			item_variant		Item Variant
			quantity	bigint	Quantity
			reftran_fbid	sql_variant	Reference Transaction Finance Book Id
			reftran_no	bigint	Reference Transaction Number
			reftran_ou	int	Reference Transaction Organization Unit
			ref_tran_type	sql_variant	Reference Transaction  Type
			supcust_code		Supplier Customer Code
			uom		Unit Of Measurement
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_voucher_dtl	Gives the details of the vouchers generated during posting	parent_key	sql_variant	Parent Key	Yes
			current_key		Current Key
			company_code		Company Code
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			fb_voucher_no		Finance Book Voucher Number
			serial_no	int	Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			base_amount	bigint	Base Amount
			par_base_amount		Parallel Base Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_voucher_hdr	Gives the details of the header generated during posting	current_key	sql_variant	Current Key	Yes
			company_code		Company Code
			component_name		Component Name
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			fb_voucher_no		Finance Book Voucher Number
			timestamp	int	Time Stamp	No
			tran_type	sql_variant	Transaction Type
			tran_date	datetime	Transaction Date
			fb_voucher_date		Finance Book Voucher Date
			con_ref_voucher_no	sql_variant	Consolidation Reference  Voucher Number
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_voucher_report_tmp		timestamp	int	Time Stamp
			guid	sql_variant	Guid
			company_code		Company Code
			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
			ou_id	int	Organization Unit Id
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			currency_code		Currency Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			exchange_rate		Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			narration	sql_variant	Narration
			bank_code		Bank Code
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			item_code		Item Code
			item_variant		Item Variant
			quantity	bigint	Quantity
			reftran_fbid	sql_variant	Reference Tranaction Finance Book Id
			reftran_no		Reference Transaction Number
			reftran_ou	int	Reference Transaction Organization Number
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified  Date
	tbp_voucher_trn_dtl	Gives the tax journal detail information	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			voucher_serial_no	int	Voucher Serial Number
			timestamp		Time Stamp	No
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			remarks	sql_variant	Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_voucher_trn_hdr	Gives the tax journal header information	ou_id	int	Organization Unit Id	Yes
			voucher_no	sql_variant	Voucher Number
			timestamp	int	Time Stamp	No
			voucher_date	datetime	Voucher Date
			numbering_type	sql_variant	Numbering Type
			fb_id		Finance Book Id
			remarks		Remarks
			voucher_status		Voucher Status.Values A Authorized R Reversed
			ref_voucher_no		Reference Voucher Number
			ref_voucher_date	datetime	Reference Voucher Date
			rev_flag	sql_variant	Reversal Flag
			createdby		Created By
			createddate	datetime	Created  Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_yr_prd_close_hist	Gives the tax book year/period closure status history	ou_id	int	Organization Unit  Id	Yes
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			finance_year		Finance Year
			finance_period		Finance Period
			run_no		Run Number
			timestamp	int	Time Stamp	No
			close_status	sql_variant	Close Status.Values O Open C Closed P Provisional Closed
			closed_by		Closed By
			closed_date	datetime	Closed Date
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	tbp_yr_prd_close_status	Gives the tax book year/period closure status	ou_id	int	Organization Unit Id	Yes
			company_code	sql_variant	Company Code
			fb_id		Finance Book Id
			finance_year		Finance Year
			finance_period		Finance Period
			timestamp	int	Time Stamp	No
			close_status	sql_variant	Close Status.Values O Open, C Closed, P Provisional Closed
			closed_by		Closed By
			closed_date	datetime	Closed Date
			sequenceno	int	Sequence Number
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date