Data Dictionary -- Formula Builder

Srl. No.	Table Name	Comment
1	fbp_account_balance	fbp_account_balance
2	fbp_acc_inq_met	fbp_acc_inq_met
3	fbp_act_bal_prd	fbp_act_bal_prd
4	fbp_anal_account_balance	fbp_anal_account_balance
5	fbp_attach_notes_dtl	fbp_attach_notes_dtl
6	fbp_attach_notes_his	fbp_attach_notes_his
7	fbp_bankcash_bal	fbp_bankcash_bal
8	fbp_bank_reconcile_dtl	fbp_bank_reconcile_dtl
9	fbp_bank_reg_dtls	fbp_bank_reg_dtls
10	fbp_bank_request_trn_dtl	fbp_bank_request_trn_dtl
11	fbp_bfg_comp_met	fbp_bfg_comp_met
12	fbp_closure_account_balance	fbp_closure_account_balance
13	fbp_ibe_trn_dtl	fbp_ibe_trn_dtl
14	fbp_mnt_trntype_dtl	fbp_mnt_trntype_dtl
15	fbp_posted_trn_dtl	fbp_posted_trn_dtl
16	fbp_posted_trn_dtl_his	fbp_posted_trn_dtl_his
17	fbp_postings_mode_sys	fbp_postings_mode_sys
18	fbp_post_to_tax_dtl	fbp_post_to_tax_dtl
19	fbp_post_trantype_sys	fbp_post_trantype_sys
20	fbp_ret_earn_yr_prd	fbp_ret_earn_yr_prd
21	fbp_ret_earn_yr_prd_his	fbp_ret_earn_yr_prd_his
22	fbp_trn_error_log	fbp_trn_error_log
23	fbp_unposted_trn_dtl	fbp_unposted_trn_dtl
24	fbp_unposted_trn_dtl_fam	fbp_unposted_trn_dtl_fam
25	fbp_unposted_trn_dtl_gen	fbp_unposted_trn_dtl_gen
26	fbp_unposted_trn_dtl_pm	fbp_unposted_trn_dtl_pm
27	fbp_unposted_trn_dtl_rm	fbp_unposted_trn_dtl_rm
28	fbp_unpost_account_balance	fbp_unpost_account_balance
29	fbp_view_acc_bal_exptoxl	fbp_view_acc_bal_exptoxl
30	fbp_voucher_dtl	fbp_voucher_dtl
31	fbp_voucher_hdr	fbp_voucher_hdr
32	FB_FBCNTKN_CONTENT_TOKENS	This table contains the list of participating tokens for a given formula
33	FB_FBMST_FORMULA_MASTER	This table contains the list of all formula defined in the system either thru BASFB component or thru any other component
34	FB_FBPRM_PARAMETER_DETAILS	Stores Parameter detail information. In this component, this table needs to store only search criteria message
35	FB_TKNLST_VALID_TOKEN_LIST	This table contains the list of valid set of Tokens that can participate in a formula defined for a component. Data gets inserted into this table from components which needs to avail the formula builder service.

Table Name :	fbp_account_balance
Comment :	fbp_account_balance

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	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

Table Name :	fbp_acc_inq_met
Comment :	fbp_acc_inq_met

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

Table Name :	fbp_act_bal_prd
Comment :	fbp_act_bal_prd

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

Table Name :	fbp_anal_account_balance
Comment :	fbp_anal_account_balance

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	_int_0	int(0)	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	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

Table Name :	fbp_attach_notes_dtl
Comment :	fbp_attach_notes_dtl

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	_int_0	int(0)	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	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

Table Name :	fbp_attach_notes_his
Comment :	fbp_attach_notes_his

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	_int_0	int(0)	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	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

Table Name :	fbp_bankcash_bal
Comment :	fbp_bankcash_bal

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	_int_0	int(0)	Yes	timestamp	No
request_bal	fin_amount	numeric(13)	Yes	Request balance	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

Table Name :	fbp_bank_reconcile_dtl
Comment :	fbp_bank_reconcile_dtl

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	_int_0	int(0)	Yes	Timestamp	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	_datetime_8	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	_datetime_8	datetime(8)	Yes	Reconsile date	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

Table Name :	fbp_bank_reg_dtls
Comment :	fbp_bank_reg_dtls

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	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	_datetime_8	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	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
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

Table Name :	fbp_bank_request_trn_dtl
Comment :	fbp_bank_request_trn_dtl

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	_int_0	int(0)	Yes	Timestamp	No
doc_date	_datetime_8	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	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

Table Name :	fbp_bfg_comp_met
Comment :	fbp_bfg_comp_met

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	_int_0	int(0)	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	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

Table Name :	fbp_closure_account_balance
Comment :	fbp_closure_account_balance

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	_int_0	int(0)	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	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

Table Name :	fbp_ibe_trn_dtl
Comment :	fbp_ibe_trn_dtl

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	_int_0	int(0)	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	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

Table Name :	fbp_mnt_trntype_dtl
Comment :	fbp_mnt_trntype_dtl

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	_int_0	int(0)	Yes	Timestamp	No
tran_desc	fin_description	varchar(100)	Yes	Transaction description	No
status	fin_status	varchar(25)	Yes	Status	No
effective_date_from	_datetime_8	datetime(8)	Yes	Effective date from	No
effective_date_to	_datetime_8	datetime(8)	Yes	Effective date to	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

Table Name :	fbp_posted_trn_dtl
Comment :	fbp_posted_trn_dtl

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 :	fbp_posted_trn_dtl_his

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

Table Name :	fbp_postings_mode_sys
Comment :	fbp_postings_mode_sys

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	_int_0	int(0)	Yes	Timestamp	No
online_post	fin_eflag	varchar(1)	Yes	Online post	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

Table Name :	fbp_post_to_tax_dtl
Comment :	fbp_post_to_tax_dtl

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	_int_0	int(0)	Yes	Timestamp	No
posted_date	_datetime_8	datetime(8)	Yes	Posted date	No
posted_by	fin_ctxt_user	varchar(30)	Yes	Posted by	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

Table Name :	fbp_post_trantype_sys
Comment :	fbp_post_trantype_sys

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	_int_0	int(0)	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	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
fb_post_flag	fin_eflag	varchar(1)	Yes	Finance book post flag	No

Table Name :	fbp_ret_earn_yr_prd
Comment :	fbp_ret_earn_yr_prd

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	_int_0	int(0)	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	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

Table Name :	fbp_ret_earn_yr_prd_his
Comment :	fbp_ret_earn_yr_prd_his

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	_int_0	int(0)	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	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

Table Name :	fbp_trn_error_log
Comment :	fbp_trn_error_log

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
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	_datetime_8	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	_datetime_8	datetime(8)	Yes	Entry date	No
auth_date	_datetime_8	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	_datetime_8	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	Unit of Measurement	No
error_desc	fin_msgtext	varchar(255)	Yes	Error description	No
log_time	_datetime_8	datetime(8)	Yes	Log time	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

Table Name :	fbp_unposted_trn_dtl
Comment :	fbp_unposted_trn_dtl

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 voucher number	No
fb_voucher_date	_datetime_8	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	_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_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	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

Table Name :	fbp_unposted_trn_dtl_fam
Comment :	fbp_unposted_trn_dtl_fam

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
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_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	Unit of Measurement	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	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
fb_voucher_date	_datetime_8	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_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

Table Name :	fbp_unposted_trn_dtl_gen
Comment :	fbp_unposted_trn_dtl_gen

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
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_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	Unit of measurement	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	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
fb_voucher_date	_datetime_8	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
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
refdoctype_code	fin_desc5	varchar(5)	Yes	Reference document 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	Null	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Null	Yes

Table Name :	fbp_unposted_trn_dtl_pm
Comment :	fbp_unposted_trn_dtl_pm

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
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_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_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
fb_voucher_date	_datetime_8	datetime(8)	Yes	Finance 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
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
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
exchord_no	fin_documentno	varchar(40)	Yes	Exchange number	No

Table Name :	fbp_unposted_trn_dtl_rm
Comment :	fbp_unposted_trn_dtl_rm

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
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_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_customer_id	varchar(18)	Yes	Supplier customer code	No
uom	fin_uom	varchar(15)	Yes	Unit of measurement	No
mac_post_flag	fin_eflag	varchar(1)	Yes	mac post flag	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
fb_voucher_date	_datetime_8	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
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
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes
item_tcd_flag	fin_flag	varchar(25)	Yes	Item tcd flag	No
exchord_no	fin_documentno	varchar(40)	Yes	Exchange order number	No

Table Name :	fbp_unpost_account_balance
Comment :	fbp_unpost_account_balance

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	_int_0	int(0)	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	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

Table Name :	fbp_view_acc_bal_exptoxl
Comment :	fbp_view_acc_bal_exptoxl

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	linenumber	No
ConfirmationDate	fin_datetime	datetime(8)	Yes	ConfirmationDate	No
PartNo	fin_partno	varchar(40)	Yes	PartNo	No
SerialNo	udd_documentno	varchar(40)	Yes	SerialNo	No
LotNo	fin_lotno	varchar(18)	Yes	LotNo	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	_varchar_60	varchar(60)	Yes	Part type	No
Part_acc_group	_varchar_60	varchar(60)	Yes	Part account group	No
Part_Desc	_varchar_255	varchar(255)	Yes	Part description	No
Part_Category	_varchar_60	varchar(60)	Yes	Part category	No
Warehouse_id	_varchar_60	varchar(60)	Yes	Warehouse id	No
Aircraft_RegnNo	_varchar_40	varchar(40)	Yes	Aircraft registration number	No
Comments	_varchar_255	varchar(255)	Yes	Comments	No
Vendor_no	_varchar_255	varchar(255)	Yes	Vendor number	No
Vendor_Name	_varchar_255	varchar(255)	Yes	Vendor name	No
Remarks	_varchar_255	varchar(255)	Yes	Remarks	No
AC_Model	_varchar_255	varchar(255)	Yes	account model	No
ro_date	_datetime_8	datetime(8)	Yes	ro_date	No

Table Name :	fbp_voucher_dtl
Comment :	fbp_voucher_dtl

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	_int_0	int(0)	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	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

Table Name :	fbp_voucher_hdr
Comment :	fbp_voucher_hdr

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	_int_0	int(0)	Yes	Timestamp	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
tran_date	_datetime_8	datetime(8)	Yes	Transaction date	No
fb_voucher_date	_datetime_8	datetime(8)	Yes	Finance book voucher date	No
con_ref_voucher_no	fin_documentno	varchar(40)	Yes	Console reference voucher number	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

Table Name :	FB_FBCNTKN_CONTENT_TOKENS
Comment :	This table contains the list of participating tokens for a given formula

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FBTKN_FB_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
FBTKN_FORMULA_ID	_varchar_20	varchar(20)	No	Formula id	Yes
FBTKN_COMPONENT_OU	_decimal_10_0	decimal(10)	No	This is the OU of the "other" component from where the formula is defined. If Formula is created thru "BasFb", then this OUInstance is nothing but the BasFb components Login OU.	Yes
FBTKN_COMPONENT	_varchar_20	varchar(20)	No	The Component which owns the formula. If the formula is defined thru BASFB component, then the componentname will be "BasFb" itself.	Yes
FBTKN_TOKEN_CODE	_varchar_40	varchar(40)	No	The participating Token code of the formula.	Yes
FBTKN_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by the user	No
FBTKN_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
FBTKN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modiffied by	No
FBTKN_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No

Table Name :	FB_FBMST_FORMULA_MASTER
Comment :	This table contains the list of all formula defined in the system either thru BASFB component or thru any other component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FBMST_FB_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance of BasFb Component	Yes
FBMST_FORMULA_ID	_varchar_20	varchar(20)	No	Formula id	Yes
FBMST_COMPONENT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This is the OU of the "other" component from where the formula is defined. If Formula is created thru "BasFb", then this OUInstance is nothing but the BasFb components Login OU.	Yes
FBMST_COMPONENT	_varchar_20	varchar(20)	No	The Component which owns the formula. If the formula is defined thru BASFB component, then the componentname will be "BasFb" itself.	Yes
FBMST_FORMULA_STATUS	_varchar_5	varchar(5)	Yes	Status can be "Active" ["A"] or "InActive" [I].	No
FBMST_FORMULA_DESC	_varchar_80	varchar(80)	Yes	Description of the formula	No
FBMST_FORMULA_DESC_UP	_varchar_80	varchar(80)	Yes	Formula description	No
FBMST_FORMULA_CONTENT	_varchar_150	varchar(150)	Yes	Formula content is nothing but a mathematical expression with numbers and tokens where tokens starts with an alphabet. Tokens should be purely alpha-numeric. Only one special character "_" is allowed	No
FBMST_USAGE_FLAG	_varchar_5	varchar(5)	Yes	This flag will have the value "Y" if the formula is used by Entity-Parameter screens else "N"	No
FBMST_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by the user	No
FBMST_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
FBMST_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
FBMST_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No
FBMST_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	FB_FBPRM_PARAMETER_DETAILS
Comment :	Stores Parameter detail information. In this component, this table needs to store only search criteria message

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_80	varchar(80)	No	Component name	Yes
PARAMCATEGORY	_varchar_25	Varchar(25)	No	Parameter catergory	Yes
PARAMTYPE	_varchar_25	Varchar(25)	No	Parameter type	Yes
PARAMCODE	_varchar_5	varchar(5)	No	Parameter code	Yes
LANGID	_decimal_10_0	decimal(10)	No	Landuage id	Yes
PARAMDESC	_varchar_80	varchar(80)	Yes	Parameter description	No
CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No

Table Name :	FB_TKNLST_VALID_TOKEN_LIST
Comment :	This table contains the list of valid set of Tokens that can participate in a formula defined for a component. Data gets inserted into this table from components which needs to avail the formula builder service.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TKNLST_FB_OUINSTANCE	_decimal_10_0	decimal(10)	No	BasFbs OU	Yes
TKNLST_COMPONENT_OUINSTANCE	_decimal_10_0	decimal(10)	No	This the OU of the component which populates the list of permissible tokens for a formula	Yes
TKNLST_COMPONENT	_varchar_20	varchar(20)	No	This is the Code of the Component which populates is availing the Formula Builder service	Yes
TKNLST_TOKEN_CODE	_varchar_40	varchar(40)	No	This column contains the valid token list permissible for formulae defined for a component.	Yes
TKNLST_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by the user	No
TKNLST_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
TKNLST_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
TKNLST_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No