Data Dictionary -- Finance Book Processing

Srl. No.	Table Name	Comment
1	fbp_account_balance	To store account balance information
2	fbp_acc_inq_met	To store account inquiry details
3	fbp_act_bal_prd	To store account balance product details
4	fbp_anal_account_balance	To store account balance details
5	fbp_attach_notes_dtl	To store attach notes details
6	fbp_attach_notes_his	To store history of attach notes information
7	fbp_bankcash_bal	To store bank cash balance details
8	fbp_bank_reconcile_dtl	To store bank reconcile details
9	fbp_bank_reg_dtls	To store bank registration details
10	fbp_bank_request_trn_dtl	To store bank request transaction detail
11	fbp_bfg_comp_met	To store bfg component details
12	fbp_closure_account_balance	To store closure account balance details
13	fbp_ibe_trn_dtl	To Store Posting details of legacy transactions
14	fbp_mnt_trntype_dtl	To maintain transaction type detail
15	fbp_posted_trn_dtl	To store posted transaction detail
16	fbp_posted_trn_dtl_his	To store history of posted transaction detail
17	fbp_postings_mode_sys	To store system posting mode details
18	fbp_post_to_tax_dtl	To store post to tax details
19	fbp_post_trantype_sys	To store system post transaction typr details
20	fbp_ret_earn_yr_prd	To store information about retained earning for the given period
21	fbp_ret_earn_yr_prd_his	To store information about history of retained earning for the given period
22	fbp_trn_error_log	To store transaction error log details
23	fbp_unposted_trn_dtl	To store unposted transaction details
24	fbp_unposted_trn_dtl_bk	To store all unposted transactions for BK BPC
25	fbp_unposted_trn_dtl_fam	To store all unposted transactions for FAM BPC
26	fbp_unposted_trn_dtl_gen	To store all unposted transactions for other than finance BPC
27	fbp_unposted_trn_dtl_pm	To store all unposted transactions for PM BPC
28	fbp_unposted_trn_dtl_rm	To store all unposted transactions for Rm BPC
29	fbp_unpost_account_balance	To store unposted account balance details
30	fbp_view_acc_bal_exptoxl	To view account balance details
31	fbp_voucher_dtl	To store voucher details
32	fbp_voucher_hdr	To store voucher header

Table Name :	fbp_account_balance
Comment :	To store account balance information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	No
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
timestamp	_int_0	int(0)	Yes	Timestamp	No
ob_credit	fin_amount	numeric(13)	No	Order base credit	No
ob_debit	fin_amount	numeric(13)	No	Order base debit	No
period_credit	fin_amount	numeric(13)	No	Period credit	No
period_debit	fin_amount	numeric(13)	No	Period debit	No
cb_credit	fin_amount	numeric(13)	No	cb credit	No
cb_debit	fin_amount	numeric(13)	No	cb debit	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
createdby	fin_ctxt_user	varchar(30)	Yes	created by	No
createddate	_datetime_8	datetime(8)	Yes	created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modified by	No
modifieddate	_datetime_8	datetime(8)	Yes	modified date	No

Table Name :	fbp_acc_inq_met
Comment :	To store account inquiry details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
Total	fin_int	int(4)	Yes	Total	No
minval	fin_int	int(4)	Yes	Minimum vakue	No
maxval	fin_int	int(4)	Yes	Maximum value	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_act_bal_prd
Comment :	To store account balance product details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	Yes	Company code	No
fin_year	fin_financeyear	varchar(15)	Yes	Financial year	No
fin_period	fin_financeperiod	varchar(15)	Yes	Financial period	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
finprd_startdt	fin_date	datetime(8)	Yes	Financial period start date	No
sequenceno	fin_int	int(4)	Yes	Sequence number	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_anal_account_balance
Comment :	To store account balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
analysis_code	fin_analysiscode	varchar(5)	No	Analysis code	Yes
subanalysis_code	fin_subanalysiscode	varchar(5)	No	Subanalysis code	Yes
timestamp	fin_int	int(4)	Yes	TImestamp	No
ob_credit	fin_amount	numeric(13)	Yes	Order base credit	No
ob_debit	fin_amount	numeric(13)	Yes	Order base debit	No
period_credit	fin_amount	numeric(13)	Yes	Period credit	No
period_debit	fin_amount	numeric(13)	Yes	Period debit	No
cb_credit	fin_amount	numeric(13)	Yes	cb credit	No
cb_debit	fin_amount	numeric(13)	Yes	cd debit	No
recon_status	fin_status	varchar(25)	Yes	Reconsile 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 :	fbp_attach_notes_dtl
Comment :	To store attach notes details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
status	fin_status	varchar(25)	Yes	Status	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach 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

Table Name :	fbp_attach_notes_his
Comment :	To store history of attach notes information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
serial_no	fin_integer8	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
status	fin_status	varchar(25)	Yes	Status	No
attach_notes_desc	fin_text2500	varchar(2500)	Yes	Attach 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

Table Name :	fbp_bankcash_bal
Comment :	To store bank cash balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
bankcash_code	fin_bankcashcode	varchar(32)	No	Bank cash code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
pay_type	fin_paytype	varchar(30)	No	Payment type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
request_bal	fin_amount	numeric(13)	Yes	Request balance	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 :	fbp_bank_reconcile_dtl
Comment :	To store bank reconcile details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bank_account_no	fin_bankname	varchar(40)	No	Bank account number	Yes
bank_code	fin_bankname	varchar(40)	No	Bank code	Yes
ref_no	fin_documentnumber	varchar(18)	No	Reference number	Yes
serial_no	fin_serialno	varchar(18)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
doc_no	fin_documentnumber	varchar(18)	Yes	Document number	No
prefix	fin_prefix	varchar(6)	Yes	Prefix	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_checknumber	varchar(30)	Yes	Comp reference	No
deposit_ou	fin_ouinstid	int(4)	Yes	Deposit OU	No
recon_status	fin_status	varchar(25)	Yes	Reconsile status	No
recon_remarks	fin_remarks	varchar(100)	Yes	Reconsile remarks	No
recon_by	fin_ctxt_user	varchar(30)	Yes	Reconsile by	No
recon_date	fin_datetime	datetime(8)	Yes	Reconsile 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 :	fbp_bank_reg_dtls
Comment :	To store bank registration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
serial_no	fin_int	int(4)	Yes	Serial number	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
voucher_no	fin_documentnumber	varchar(18)	Yes	Voucher number	No
trantype	fin_transactiontypeid	varchar(10)	Yes	Transaction type	No
pay_date	fin_datetime	datetime(8)	Yes	Payment date	No
check_no	fin_checknumber	varchar(30)	Yes	Check number	No
comp_reference	fin_desc40	varchar(40)	Yes	Comp reference	No
guid	fin_guid	varchar(40)	Yes	Guid	No
checkprefix	fin_checkprefix	varchar(15)	Yes	Check prefix	No
checkamount	fin_amount	numeric(13)	Yes	Check amount	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
credit_amt	fin_amount	numeric(13)	Yes	Credit amount	No
debit_amt	fin_amount	numeric(13)	Yes	Debit amount	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_bank_request_trn_dtl
Comment :	To store bank request transaction detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
document_no	fin_documentno	varchar(40)	No	Document number	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
bankcash_code	fin_bankcashcode	varchar(32)	No	Bank cash code	Yes
pay_type	fin_paytype	varchar(30)	No	Payment type	Yes
amount_type	fin_amounttype	varchar(40)	No	Amount type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
doc_date	fin_datetime	datetime(8)	Yes	Document date	No
req_amount	fin_amount	numeric(13)	Yes	Request amount	No
currency_code	fin_currency	varchar(5)	Yes	Currency code	No
doc_user_id	fin_ctxt_user	varchar(30)	Yes	Document user id	No
component_id	fin_componentshortid	varchar(20)	Yes	Component id	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 :	fbp_bfg_comp_met
Comment :	To store bfg component details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bfg_code	fin_code	varchar(6)	Yes	bfg code	No
component_id	fin_componentshortid	varchar(20)	Yes	Component id	No
component_desc	fin_desc255	varchar(255)	Yes	Component 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 :	fbp_closure_account_balance
Comment :	To store closure account balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
analysis_code	fin_analysiscode	varchar(5)	No	Analysis code	Yes
subanalysis_code	fin_subanalysiscode	varchar(5)	No	Subanalysis code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ob_credit	fin_amount	numeric(13)	Yes	Order base credit	No
ob_debit	fin_amount	numeric(13)	Yes	Order dase debit	No
period_credit	fin_amount	numeric(13)	Yes	Period credit	No
period_debit	fin_amount	numeric(13)	Yes	Period debit	No
cb_credit	fin_amount	numeric(13)	Yes	cb credit	No
cb_debit	fin_amount	numeric(13)	Yes	cb debit	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 :	fbp_ibe_trn_dtl
Comment :	To Store Posting details of legacy transactions

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
document_no	fin_documentno	varchar(40)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	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 :	fbp_mnt_trntype_dtl
Comment :	To maintain transaction type detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
bfg_code	fin_bfgid	varchar(20)	No	bfg code	Yes
component_name	fin_componentshortid	varchar(20)	No	Component name	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
serial_no	fin_int	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_desc	fin_description	varchar(100)	Yes	Transaction description	No
status	fin_status	varchar(25)	Yes	Status	No
effective_date_from	fin_datetime	datetime(8)	Yes	Effective date from	No
effective_date_to	fin_datetime	datetime(8)	Yes	Effective date to	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No

Table Name :	fbp_posted_trn_dtl
Comment :	To store posted transaction detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	No	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_componentshortid	varchar(20)	No	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	No	Transaction OU	No
fb_voucher_no	fin_documentnumber	varchar(18)	No	Finance book voucher number	No
fb_voucher_date	_datetime_8	datetime(8)	No	Finance book voucher date	No
recon_flag	fin_flag	varchar(25)	Yes	Reconsile flag	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Console reference vou	No
document_no	fin_documentnumber	varchar(18)	No	Document number	No
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	No
tran_date	_datetime_8	datetime(8)	Yes	Transaction date	No
entry_date	_datetime_8	datetime(8)	Yes	Entry date	No
auth_date	_datetime_8	datetime(8)	Yes	Author date	No
posting_date	_datetime_8	datetime(8)	No	Posting date	No
ou_id	fin_ouinstid	int(4)	No	Organization unit id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	No	Currency code	No
tran_amount	fin_amount	numeric(13)	No	Transaction amount	No
base_amount	fin_amount	numeric(13)	No	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
exchange_rate	fin_exchangerate	numeric(9)	No	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
narration	fin_text255	varchar(255)	Yes	Narration	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
tax_post_flag	fin_eflag	varchar(1)	Yes	Tax post flag	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_customer_id	varchar(18)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	Unit of Measurement	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	_datetime_8	datetime(8)	Yes	createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modifiedby	No
modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
mac_inc_flag	fin_flag	varchar(25)	Yes	mac_inc_flag	No
tran_line_no	fin_lineno	int(4)	Yes	Transaction line number	No
SRL_NO	_int_0	int(0)	No	Serial number	No
anal_inc_flag	fin_flag	varchar(25)	Yes	anal_inc_flag	No
Item_TCD_Flag	fin_flag	varchar(25)	Yes	Item tcd flag	No
TagNo	fin_seqno	int(4)	Yes	Tag number	No
RowIdentity	fin_seqno	int(4)	Yes	Row identity	No
expense_class	fin_quickcode	varchar(20)	Yes	Expense class	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	ame_no	No
swo_no	fin_documentno	varchar(40)	Yes	swo_no	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier id	No
exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No

Table Name :	fbp_posted_trn_dtl_his
Comment :	To store history of posted transaction detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_componentshortid	varchar(20)	Yes	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
fb_voucher_no	fin_documentnumber	varchar(18)	Yes	Finance book voucher number	No
fb_voucher_date	_datetime_8	datetime(8)	Yes	Finance book voucher date	No
recon_flag	fin_flag	varchar(25)	Yes	Reconsile flag	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Console reference voucher number	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	_datetime_8	datetime(8)	Yes	Transaction date	No
entry_date	_datetime_8	datetime(8)	Yes	Entry date	No
auth_date	_datetime_8	datetime(8)	Yes	Author date	No
posting_date	_datetime_8	datetime(8)	Yes	Posting date	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
narration	fin_name	varchar(60)	Yes	narration	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	quantity	No
tax_post_flag	fin_eflag	varchar(1)	Yes	Tax post flag	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_customer_id	varchar(18)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	Unit of Measurement	No
createdby	fin_ctxt_user	varchar(30)	Yes	createdby	No
createddate	_datetime_8	datetime(8)	Yes	createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	modifiedby	No
modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
mac_inc_flag	fin_flag	varchar(25)	Yes	mac inc flag	No
tran_line_no	fin_lineno	int(4)	Yes	Transaction line number	No
SRL_NO	_int_0	int(0)	Yes	Serial number	No
anal_inc_flag	fin_flag	varchar(25)	Yes	analysis inc flag	No
Item_TCD_Flag	fin_flag	varchar(25)	Yes	Item tcd flag	No
TagNo	fin_seqno	int(4)	Yes	Tag number	No
RowIdentity	fin_seqno	int(4)	Yes	RowIdentity	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Null	Yes

Table Name :	fbp_postings_mode_sys
Comment :	To store system posting mode details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
component_name	fin_componentshortid	varchar(20)	No	Component name	Yes
calling_srvc_or_view	fin_service_name	varchar(64)	No	Calling service or view	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
online_post	fin_eflag	varchar(1)	Yes	Online post	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 :	fbp_post_to_tax_dtl
Comment :	To store post to tax details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_calendarcode	varchar(10)	No	Financial year	Yes
fin_period	fin_calendarcode	varchar(10)	No	Financial period	Yes
serial_no	fin_number	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
posted_date	fin_datetime	datetime(8)	Yes	Posted date	No
posted_by	fin_ctxt_user	varchar(30)	Yes	Posted by	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 :	fbp_post_trantype_sys
Comment :	To store system post transaction typr details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bpc_id	fin_desc40	varchar(40)	Yes	bpc id	No
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_desc	fin_trandesc	varchar(60)	Yes	Transaction description	No
category	fin_eflag	varchar(1)	Yes	Category	No
language_id	fin_languageid	int(4)	Yes	Language id	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_post_flag	fin_eflag	varchar(1)	Yes	Finance book post flag	No

Table Name :	fbp_ret_earn_yr_prd
Comment :	To store information about retained earning for the given period

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
run_no	fin_documentno	varchar(40)	No	Run number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ret_earn_amount	fin_amount	numeric(13)	Yes	Return earn amount	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit credit flag	No
close_status	fin_status	varchar(25)	Yes	Close 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 :	fbp_ret_earn_yr_prd_his
Comment :	To store information about history of retained earning for the given period

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
company_code	fin_companycode	varchar(10)	No	Company code	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fin_year	fin_financeyear	varchar(15)	No	Financial year	Yes
fin_period	fin_financeperiod	varchar(15)	No	Financial period	Yes
run_no	fin_documentno	varchar(40)	No	Run number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
ret_earn_amount	fin_amount	numeric(13)	Yes	Return earn amount	No
drcr_flag	fin_flag	varchar(25)	Yes	Debit credit flag	No
close_status	fin_status	varchar(25)	Yes	Close 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 :	fbp_trn_error_log
Comment :	To store transaction error log details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
component_name	fin_componentshortid	varchar(20)	Yes	Component name	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
remarks	fin_name	varchar(60)	Yes	Remarks	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	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
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_value	numeric(9)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	UOM	No
error_desc	fin_msgtext	varchar(255)	Yes	Error description	No
log_time	fin_datetime	datetime(8)	Yes	Log time	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_unposted_trn_dtl
Comment :	To store unposted transaction details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_componentshortid	varchar(20)	Yes	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
fb_voucher_no	fin_documentnumber	varchar(18)	Yes	Finance voucher number	No
fb_voucher_date	fin_datetime	datetime(8)	Yes	Finance voucher date	No
recon_flag	fin_flag	varchar(25)	Yes	Reconsile flag	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Console reference voucher number	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
narration	fin_text255	varchar(255)	Yes	Narration	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
tax_post_flag	fin_eflag	varchar(1)	Yes	Tax post flag	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_value	numeric(9)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	UOM	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 :	fbp_unposted_trn_dtl_bk
Comment :	To store all unposted transactions for BK BPC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_componentshortid	varchar(20)	Yes	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
narration	fin_text255	varchar(255)	Yes	Narration	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	UOM	No
con_ref_voucherno	fin_docuemntno	varchar(18)	Yes	Console reference voucher number	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	No
createdby	fin_createdby	Varchar(40)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_createdby	Varchar(40)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
fb_voucher_date	fin_datetime	datetime(8)	Yes	Finance book voucher date	No
tran_line_no	fin_lineno	int(4)	Yes	Transaction line number	No
expense_class	fin_desc40	varchar(40)	Yes	Expense class	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	ame number	No
swo_no	fin_documentno	varchar(40)	Yes	swo number	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier id	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes
exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No

Table Name :	fbp_unposted_trn_dtl_fam
Comment :	To store all unposted transactions for FAM BPC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
company_code	fin_companycode	varchar(10)	Yes	Company code	No
component_name	fin_componentshortid	varchar(20)	Yes	Component name	No
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
tran_ou	fin_ouinstid	int(4)	Yes	Transaction OU	No
document_no	fin_documentnumber	varchar(18)	Yes	Document number	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
entry_date	fin_datetime	datetime(8)	Yes	Entry date	No
auth_date	fin_datetime	datetime(8)	Yes	Author date	No
posting_date	fin_datetime	datetime(8)	Yes	Posting date	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
account_code	fin_accountcode	varchar(32)	Yes	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Debit credit flag	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
par_base_amount	fin_amount	numeric(13)	Yes	Parallel base amount	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Exchange rate	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Parallel exchange rate	No
narration	fin_text255	varchar(255)	Yes	Narration	No
bank_code	fin_bankcode	varchar(32)	Yes	Bank code	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
item_code	fin_itemcode	varchar(40)	Yes	Item code	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Item variant	No
quantity	fin_quantity	numeric(17)	Yes	Quantity	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Reference transaction finance book id	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Reference transaction number	No
reftran_ou	fin_ouinstid	int(4)	Yes	Reference transaction OU	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	UOM	No
mac_post_flag	fin_eflag	varchar(1)	Yes	Mac post flag	No
createdby	fin_createdby	Varchar(40)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_createdby	Varchar(40)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
fb_voucher_date	fin_datetime	datetime(8)	Yes	Finance book voucher date	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Console reference voucher number	No
tran_line_no	fin_lineno	int(4)	Yes	Transaction line number	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document type code	No
refdoc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
custorder_no	fin_documentno	varchar(40)	Yes	Customer order number	No
ame_no	fin_documentno	varchar(40)	Yes	ame number	No
swo_no	fin_documentno	varchar(40)	Yes	swo number	No
customer_id	fin_customer_id	varchar(18)	Yes	Customer id	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Supplier id	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_unposted_trn_dtl_gen
Comment :	To store all unposted transactions for other than finance BPC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	Yes	Null	No
batch_id	fin_guid	varchar(40)	Yes	Null	No
company_code	fin_companycode	varchar(10)	Yes	Null	No
component_name	fin_componentshortid	varchar(20)	Yes	Null	No
bu_id	fin_buid	varchar(20)	Yes	Null	No
fb_id	fin_financebookid	varchar(20)	Yes	Null	No
tran_ou	fin_ouinstid	int(4)	Yes	Null	No
document_no	fin_documentnumber	varchar(18)	Yes	Null	No
tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
tran_date	_datetime_8	datetime(8)	Yes	Null	No
entry_date	_datetime_8	datetime(8)	Yes	Null	No
auth_date	_datetime_8	datetime(8)	Yes	Null	No
posting_date	_datetime_8	datetime(8)	Yes	Null	No
ou_id	fin_ouinstid	int(4)	Yes	Null	No
account_code	fin_accountcode	varchar(32)	Yes	Null	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Null	No
currency_code	fin_currencycode	varchar(5)	Yes	Null	No
tran_amount	fin_amount	numeric(13)	Yes	Null	No
base_amount	fin_amount	numeric(13)	Yes	Null	No
par_base_amount	fin_amount	numeric(13)	Yes	Null	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
narration	fin_text255	varchar(255)	Yes	Null	No
bank_code	fin_bankcode	varchar(32)	Yes	Null	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Null	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Null	No
cost_center	fin_costcentercode	varchar(10)	Yes	Null	No
item_code	fin_itemcode	varchar(40)	Yes	Null	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Null	No
quantity	fin_quantity	numeric(17)	Yes	Null	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Null	No
reftran_no	fin_desc40	varchar(40)	Yes	Null	No
reftran_ou	fin_ouinstid	int(4)	Yes	Null	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Null	No
uom	fin_uom	varchar(15)	Yes	Null	No
mac_post_flag	fin_eflag	varchar(1)	Yes	Null	No
createdby	fin_createdby	Varchar(40)	Yes	Null	No
createddate	_datetime_8	datetime(8)	Yes	Null	No
modifiedby	fin_createdby	Varchar(40)	Yes	Null	No
modifieddate	_datetime_8	datetime(8)	Yes	Null	No
fb_voucher_date	_datetime_8	datetime(8)	Yes	Null	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Null	No
tran_line_no	fin_lineno	int(4)	Yes	Null	No
Item_TCD_Flag	fin_flag	varchar(25)	Yes	Null	No
TagNo	fin_seqno	int(4)	Yes	Null	No
RowIdentity	fin_seqno	int(4)	Yes	Null	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Null	No
refdoc_no	fin_documentno	varchar(40)	Yes	Null	No
custorder_no	fin_documentno	varchar(40)	Yes	Null	No
ame_no	fin_documentno	varchar(40)	Yes	Null	No
swo_no	fin_documentno	varchar(40)	Yes	Null	No
customer_id	fin_customer_id	varchar(18)	Yes	Null	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Null	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Null	Yes
exchord_no	fin_documentno	varchar(40)	Yes	Null	No

Table Name :	fbp_unposted_trn_dtl_pm
Comment :	To store all unposted transactions for PM BPC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	Yes	Null	No
batch_id	fin_guid	varchar(40)	Yes	Null	No
company_code	fin_companycode	varchar(10)	Yes	Null	No
component_name	fin_componentshortid	varchar(20)	Yes	Null	No
bu_id	fin_buid	varchar(20)	Yes	Null	No
fb_id	fin_financebookid	varchar(20)	Yes	Null	No
tran_ou	fin_ouinstid	int(4)	Yes	Null	No
document_no	fin_documentnumber	varchar(18)	Yes	Null	No
tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
tran_date	_datetime_8	datetime(8)	Yes	Null	No
entry_date	_datetime_8	datetime(8)	Yes	Null	No
auth_date	_datetime_8	datetime(8)	Yes	Null	No
posting_date	_datetime_8	datetime(8)	Yes	Null	No
ou_id	fin_ouinstid	int(4)	Yes	Null	No
account_code	fin_accountcode	varchar(32)	Yes	Null	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Null	No
currency_code	fin_currencycode	varchar(5)	Yes	Null	No
tran_amount	fin_amount	numeric(13)	Yes	Null	No
base_amount	fin_amount	numeric(13)	Yes	Null	No
par_base_amount	fin_amount	numeric(13)	Yes	Null	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
narration	fin_text255	varchar(255)	Yes	Null	No
bank_code	fin_bankcode	varchar(32)	Yes	Null	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Null	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Null	No
cost_center	fin_costcentercode	varchar(10)	Yes	Null	No
item_code	fin_itemcode	varchar(40)	Yes	Null	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Null	No
quantity	fin_quantity	numeric(17)	Yes	Null	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Null	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Null	No
reftran_ou	fin_ouinstid	int(4)	Yes	Null	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
supcust_code	fin_suppliercode	varchar(16)	Yes	Null	No
uom	fin_uom	varchar(15)	Yes	Null	No
mac_post_flag	fin_eflag	varchar(1)	Yes	Null	No
createdby	fin_createdby	Varchar(40)	Yes	Null	No
createddate	_datetime_8	datetime(8)	Yes	Null	No
modifiedby	fin_createdby	Varchar(40)	Yes	Null	No
modifieddate	_datetime_8	datetime(8)	Yes	Null	No
fb_voucher_date	_datetime_8	datetime(8)	Yes	Null	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Null	No
tran_line_no	fin_lineno	int(4)	Yes	Null	No
expense_class	fin_quickcode	varchar(20)	Yes	Null	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Null	No
refdoc_no	fin_documentno	varchar(40)	Yes	Null	No
custorder_no	fin_documentno	varchar(40)	Yes	Null	No
ame_no	fin_documentno	varchar(40)	Yes	Null	No
swo_no	fin_documentno	varchar(40)	Yes	Null	No
customer_id	fin_customer_id	varchar(18)	Yes	Null	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Null	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Null	Yes
exchord_no	fin_documentno	varchar(40)	Yes	Null	No

Table Name :	fbp_unposted_trn_dtl_rm
Comment :	To store all unposted transactions for Rm BPC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	Yes	Null	No
batch_id	fin_guid	varchar(40)	Yes	Null	No
company_code	fin_companycode	varchar(10)	Yes	Null	No
component_name	fin_componentshortid	varchar(20)	Yes	Null	No
bu_id	fin_buid	varchar(20)	Yes	Null	No
fb_id	fin_financebookid	varchar(20)	Yes	Null	No
tran_ou	fin_ouinstid	int(4)	Yes	Null	No
document_no	fin_documentnumber	varchar(18)	Yes	Null	No
tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
tran_date	_datetime_8	datetime(8)	Yes	Null	No
entry_date	_datetime_8	datetime(8)	Yes	Null	No
auth_date	_datetime_8	datetime(8)	Yes	Null	No
posting_date	_datetime_8	datetime(8)	Yes	Null	No
ou_id	fin_ouinstid	int(4)	Yes	Null	No
account_code	fin_accountcode	varchar(32)	Yes	Null	No
drcr_flag	fin_drcridentifier	varchar(6)	Yes	Null	No
currency_code	fin_currencycode	varchar(5)	Yes	Null	No
tran_amount	fin_amount	numeric(13)	Yes	Null	No
base_amount	fin_amount	numeric(13)	Yes	Null	No
par_base_amount	fin_amount	numeric(13)	Yes	Null	No
exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
par_exchange_rate	fin_exchangerate	numeric(9)	Yes	Null	No
narration	fin_text255	varchar(255)	Yes	Null	No
bank_code	fin_bankcode	varchar(32)	Yes	Null	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Null	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Null	No
cost_center	fin_costcentercode	varchar(10)	Yes	Null	No
item_code	fin_itemcode	varchar(40)	Yes	Null	No
item_variant	fin_itemvariantdes	varchar(70)	Yes	Null	No
quantity	fin_quantity	numeric(17)	Yes	Null	No
reftran_fbid	fin_financebookid	varchar(20)	Yes	Null	No
reftran_no	fin_documentnumber	varchar(18)	Yes	Null	No
reftran_ou	fin_ouinstid	int(4)	Yes	Null	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Null	No
supcust_code	fin_customer_id	varchar(18)	Yes	Null	No
uom	fin_uom	varchar(15)	Yes	Null	No
mac_post_flag	fin_eflag	varchar(1)	Yes	Null	No
createdby	fin_createdby	Varchar(40)	Yes	Null	No
createddate	_datetime_8	datetime(8)	Yes	Null	No
modifiedby	fin_createdby	Varchar(40)	Yes	Null	No
modifieddate	_datetime_8	datetime(8)	Yes	Null	No
fb_voucher_date	_datetime_8	datetime(8)	Yes	Null	No
con_ref_voucherno	fin_documentno	varchar(40)	Yes	Null	No
tran_line_no	fin_lineno	int(4)	Yes	Null	No
expense_class	fin_quickcode	varchar(20)	Yes	Null	No
refdoctype_code	fin_desc5	varchar(5)	Yes	Null	No
refdoc_no	fin_documentno	varchar(40)	Yes	Null	No
custorder_no	fin_documentno	varchar(40)	Yes	Null	No
ame_no	fin_documentno	varchar(40)	Yes	Null	No
swo_no	fin_documentno	varchar(40)	Yes	Null	No
customer_id	fin_customer_id	varchar(18)	Yes	Null	No
supplier_Id	fin_vendorcode	varchar(45)	Yes	Null	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Null	Yes
item_tcd_flag	fin_flag	varchar(25)	Yes	Null	No
exchord_no	fin_documentno	varchar(40)	Yes	Null	No

Table Name :	fbp_unpost_account_balance
Comment :	To store unposted account balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
currency_code	fin_currencycode	varchar(5)	No	Currency code	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
dr_balance	fin_amount	numeric(13)	Yes	Debit balance	No
cr_balance	fin_amount	numeric(13)	Yes	Credit balance	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 :	fbp_view_acc_bal_exptoxl
Comment :	To view account balance details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
guid	fin_guid	varchar(40)	Yes	Guid	No
TransactionType	fin_transactiontype	varchar(40)	Yes	TransactionType	No
Transactionno	fin_documentno	varchar(40)	Yes	Transactionno	No
linenumber	fin_lineno	int(4)	Yes	Line number	No
ConfirmationDate	fin_datetime	datetime(8)	Yes	ConfirmationDate	No
PartNo	fin_partno	varchar(40)	Yes	Part number	No
SerialNo	udd_documentno	varchar(40)	Yes	Serial number	No
LotNo	fin_lotno	varchar(18)	Yes	Lot number	No
Balance_quantity	fin_quantity	numeric(17)	Yes	Balance quantity	No
BalanceAmount	fin_amount	numeric(13)	Yes	Balance amount	No
AccountCodeML	fin_accountcode	varchar(32)	Yes	Account code ML	No
Account_type	udd_autopostingaccounttype	varchar(40)	Yes	Account type	No
FinanceBookid	fin_financebookid	varchar(20)	Yes	Finance book id	No
PartStatus	fin_partstatus	varchar(40)	Yes	Part status	No
RefDocNo	fin_documentno	varchar(40)	Yes	Reference document number	No
TaskInfo	fin_description	varchar(100)	Yes	Task information	No
Tran_Type_id	fin_transactiontype	varchar(40)	Yes	Transaction type id	No
Acct_Type_id	fin_autopostingaccounttype	varchar(40)	Yes	Account type id	No
Part_Type	fin_varchar	varchar(800)	Yes	Part type	No
Part_acc_group	fin_varchar	varchar(800)	Yes	Part account group	No
Part_Desc	fin_varchar	varchar(800)	Yes	Part description	No
Part_Category	fin_varchar	varchar(800)	Yes	Part category	No
Warehouse_id	fin_varchar	varchar(800)	Yes	Warehouse id	No
Aircraft_RegnNo	fin_varchar	varchar(800)	Yes	Aircraft registration number	No
Comments	fin_varchar	varchar(800)	Yes	Comments	No
Vendor_no	fin_varchar	varchar(800)	Yes	Vendor number	No
Vendor_Name	fin_varchar	varchar(800)	Yes	Vendor name	No
Remarks	fin_varchar	varchar(800)	Yes	Remarks	No
AC_Model	fin_varchar	varchar(800)	Yes	Account model	No
ro_date	fin_datetime	datetime(8)	Yes	ro date	No
VAB_dummy1	udd_documentno	varchar(40)	Yes	VAB dummy1	No
VAB_dummy2	udd_documentno	varchar(40)	Yes	VAB dummy2	No
VAB_dummy3	udd_documentno	varchar(40)	Yes	VAB dummy3	No
VAB_dummy4	udd_txt80	varchar(80)	Yes	VAB dummy4	No
VAB_dummy5	udd_txt80	varchar(80)	Yes	VAB dummy5	No
VAB_dummy6	udd_txt80	varchar(80)	Yes	VAB dummy6	No
VAB_dummy7	udd_txt255	varchar(255)	Yes	VAB dummy7	No
VAB_dummy8	udd_txt255	varchar(255)	Yes	VAB dummy8	No
VAB_dummy9	udd_txt255	varchar(255)	Yes	VAB dummy9	No
VAB_dummy10	udd_txt2000	varchar(2000)	Yes	VAB dummy10	No
VAB_dummy11	udd_txt2000	varchar(2000)	Yes	VAB dummy11	No
VAB_dummy12	udd_txt2000	varchar(2000)	Yes	VAB dummy12	No
VAB_dummy13	udd_date	varchar(15)	Yes	VAB dummy13	No
VAB_dummy14	udd_date	varchar(15)	Yes	VAB dummy14	No
VAB_dummy15	udd_date	varchar(15)	Yes	VAB dummy15	No
VAB_dummy16	udd_count	int(4)	Yes	VAB dummy16	No
VAB_dummy17	udd_count	int(4)	Yes	VAB dummy17	No
VAB_dummy18	udd_count	int(4)	Yes	VAB dummy18	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	fbp_voucher_dtl
Comment :	To store voucher details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
current_key	fin_guid	varchar(40)	No	Current key	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fb_voucher_no	fin_documentnumber	varchar(18)	No	Finance voucher number	Yes
serial_no	fin_integer8	int(4)	No	Serial number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
account_code	fin_accountcode	varchar(32)	No	Account code	No
drcr_flag	fin_drcridentifier	varchar(6)	No	Devit credit flag	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
base_amount	fin_amount	numeric(13)	No	Base amount	No
par_base_amount	fin_amount	numeric(13)	No	Parallel base 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 :	fbp_voucher_hdr
Comment :	To store voucher header

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
current_key	fin_guid	varchar(40)	No	Current key	Yes
company_code	fin_companycode	varchar(10)	No	Company code	Yes
component_name	fin_componentshortid	varchar(20)	No	Component name	Yes
bu_id	fin_buid	varchar(20)	No	Business unit id	Yes
fb_id	fin_financebookid	varchar(20)	No	Finance book id	Yes
fb_voucher_no	fin_documentnumber	varchar(18)	No	Finance book voucher number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	fin_datetime	datetime(8)	Yes	Transaction date	No
fb_voucher_date	fin_datetime	datetime(8)	Yes	Finance book voucher date	No
con_ref_voucher_no	fin_documentno	varchar(40)	Yes	Console reference voucher number	No
createdby	fin_createdby	Varchar(40)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_createdby	Varchar(40)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No