Finance Book Processing

Finance Book Processing

Table Name fbp_account_balance

Table Comment To Store the Account Code wise balance for a financial period
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
ob_credit	numeric(28,8)	NOT NULL	Opening Balance Credit	No	No
ob_debit	numeric(28,8)	NOT NULL	Opening Balance Debit	No	No
period_credit	numeric(28,8)	NOT NULL	Period Credit	No	No
period_debit	numeric(28,8)	NOT NULL	Period Debit	No	No
cb_credit	numeric(28,8)	NOT NULL	Closing Balance Credit	No	No
cb_debit	numeric(28,8)	NOT NULL	Closing Balance Debit	No	No
recon_status	varchar(25)	NULL	Status. Values Status - U-Unreconciled ,R-Reconciled	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_anal_account_balance

Table Comment to Store the Analysis code wise Account balance for a financial period
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
analysis_code	varchar(5)	NOT NULL	Analysis Code	Yes	No
subanalysis_code	varchar(5)	NOT NULL	Subanalysis Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
ob_credit	numeric(28,8)	NULL	Opening Balance Credit	No	No
ob_debit	numeric(28,8)	NULL	Opening Balance Debit	No	No
period_credit	numeric(28,8)	NULL	Period Credit	No	No
period_debit	numeric(28,8)	NULL	Period Debit	No	No
cb_credit	numeric(28,8)	NULL	Closing Balance Credit	No	No
cb_debit	numeric(28,8)	NULL	Closing Balance Debit	No	No
recon_status	varchar(25)	NULL	Status. Values Status - U-Unreconciled ,R-Reconciled	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_attach_notes_dtl

Table Comment To Store the notes for the specific transaction
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
tran_type	varchar(40)	NOT NULL	Transaction Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
status	varchar(25)	NULL	Status. Values A-Active,I-Inactive	No	No
attach_notes_desc	varchar(2500)	NULL	Attach Notes Description	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_attach_notes_his

Table Comment To Store the notes for the specific transaction - History table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
tran_type	varchar(40)	NOT NULL	Transaction Type	Yes	No
serial_no	int	NOT NULL	Serial Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
status	varchar(25)	NULL	Status. Values A-Active,I-Inactive	No	No
attach_notes_desc	varchar(2500)	NULL	Attach Notes Description	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_bank_reconcile_dtl

Table Comment To Store Bank reconciliation details for the all bank codes
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
bank_account_no	varchar(40)	NOT NULL	Bank Account number	Yes	No
bank_code	varchar(40)	NOT NULL	Bank Code	Yes	No
ref_no	varchar(18)	NOT NULL	Reference Number	Yes	No
serial_no	varchar(18)	NOT NULL	Serial Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
tran_amount	numeric(28,8)	NULL	Transaction Amount	No	No
doc_no	varchar(18)	NULL	Document Number	No	No
prefix	varchar(6)	NULL	Prefix	No	No
check_no	varchar(30)	NULL	Check Number	No	No
comp_reference	varchar(30)	NULL	Component Reference	No	No
deposit_ou	int	NULL	Deposit Organization Unit	No	No
recon_status	varchar(25)	NULL	Status. Values Status - U-Unreconciled ,R-Reconciled	No	No
recon_remarks	varchar(100)	NULL	Remarks	No	No
recon_by	varchar(30)	NULL	Reconciliation By	No	No
recon_date	datetime	NULL	Date	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_bank_reg_dtls

Table Comment To Store Document wise deposited amount for the bank
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
serial_no	int	NULL	Serial Number	No	No
ou_id	int	NULL	Organization Unit Id	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
voucher_no	varchar(18)	NULL	Voucher Number	No	No
trantype	varchar(10)	NULL	Transaction Type	No	No
pay_date	datetime	NULL	Pay Date	No	No
check_no	varchar(30)	NULL	Check Number	No	No
comp_reference	varchar(40)	NULL	Component Reference	No	No
guid	varchar(40)	NULL	Guid	No	No
checkprefix	varchar(15)	NULL	Check Prefix	No	No
checkamount	numeric(28,8)	NULL	Check Amount	No	No
remarks	varchar(100)	NULL	Remarks	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
credit_amt	numeric(28,8)	NULL	Credit Amount	No	No
debit_amt	numeric(28,8)	NULL	Debit Amount	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No

Table Name fbp_bank_request_trn_dtl

Table Comment To Store requested ,paid and void transaction amount for all banks
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Id	Yes	No
document_no	varchar(40)	NOT NULL	Document Number	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
tran_type	varchar(40)	NOT NULL	Transaction Type	Yes	No
bankcash_code	varchar(32)	NOT NULL	Bank Cash Code	Yes	No
pay_type	varchar(30)	NOT NULL	Pay Type	Yes	No
amount_type	varchar(40)	NOT NULL	Amount Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
doc_date	datetime	NULL	Document Date	No	No
req_amount	numeric(28,8)	NULL	Required Amount	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
doc_user_id	varchar(15)	NULL	Document User Id	No	No
component_id	varchar(20)	NULL	Component Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_bankcash_bal

Table Comment To show the requested balance for the bank codes
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
bankcash_code	varchar(32)	NOT NULL	Bank Cash Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
pay_type	varchar(30)	NOT NULL	Pay Type	Yes	No
timestamp	int	NULL	Time Stamp	No	No
request_bal	numeric(28,8)	NULL	Requested Balance	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_bfg_comp_met

Table Comment To Store the meta data that contains the bfg code mapped to the component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
bfg_code	varchar(6)	NULL	Business Function Group	No	No
component_id	varchar(20)	NULL	Component Id	No	No
component_desc	varchar(255)	NULL	Component Description	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_closure_account_balance

Table Comment To store financial year Closure account balance
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
currency_code	varchar(5)	NOT NULL	Currency Code	Yes	No
analysis_code	varchar(5)	NOT NULL	Analysis Code	Yes	No
subanalysis_code	varchar(5)	NOT NULL	Subanalysis Code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
ob_credit	numeric(28,8)	NULL	Opening Balance Credit	No	No
ob_debit	numeric(28,8)	NULL	Opening Balance Debit	No	No
period_credit	numeric(28,8)	NULL	Period Credit	No	No
period_debit	numeric(28,8)	NULL	Period Debit	No	No
cb_credit	numeric(28,8)	NULL	Closing Balance Credit	No	No
cb_debit	numeric(28,8)	NULL	Closing Balance Debit	No	No
createdby	varchar(15)	NULL	Crated By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_ibe_trn_dtl

Table Comment To Store Posting details of legacy transactions
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(10)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(10)	NOT NULL	Finance Period	Yes	No
account_code	varchar(32)	NOT NULL	Account Code	Yes	No
currency_code	varchar(5)	NOT NULL	Currency code	Yes	No
timestamp	int	NULL	Time Stamp	No	No
drcr_flag	varchar(6)	NULL	Debit Credit Flag	No	No
base_amount	numeric(28,8)	NULL	Base Amount	No	No
tran_amount	numeric(28,8)	NULL	Transaction Amount	No	No
batch_id	varchar(40)	NULL	Batch id	No	No
document_no	varchar(40)	NULL	Document Number	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_ou	int	NULL	Transaction Organization Unit	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_post_to_tax_dtl

Table Comment To store the tax posting details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(10)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(10)	NOT NULL	Finance Period	Yes	No
serial_no	int	NOT NULL	Serial Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
posted_date	datetime	NULL	Posted Date	No	No
posted_by	varchar(15)	NULL	Posted By	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_post_trantype_sys

Table Comment To Store the meta date for the transaction type for all component across the BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
tran_type	varchar(40)	NOT NULL	Transaction Type	Yes	No
bpc_id	varchar(40_	NULL	Business Processing Id	No	No
timestamp	int	NULL	Time Stamp	No	No
tran_desc	varchar(60)	NULL	Transaction Description	No	No
category	varchar(1)	NULL	Category	No	No
language_id	int	NULL	Language Id	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_post_flag	varchar(1)	NULL	Finance Book Posting Flag	No	No

Table Name fbp_posted_trn_dtl

Table Comment To Store all the transaction posting amount for all component mapped to the FB
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	varchar(40)	NOT NULL	Batch Id	No	No
company_code	varchar(10)	NULL	Company Code	No	No
component_name	varchar(20)	NOT NULL	Component Name	No	No
bu_id	varchar(20)	NULL	Business Unit Id	No	No
fb_id	varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NOT NULL	Transaction Organization Unit	No	No
fb_voucher_no	varchar(18	NOT NULL	Finance Book Voucher Number	No	No
fb_voucher_date	datetime	NOT NULL	Finance Book Voucher Date	No	No
recon_flag	varchar(25)	NULL	Reconcile Flag	No	No
con_ref_voucherno	varchar(40)	NULL	Reference Voucher Number	No	No
document_no	varchar(18)	NOT NULL	Document Number	No	No
tran_type	varchar(40)	NOT NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NOT NULL	Posting Date	No	No
ou_id	int	NOT NULL	Organization Unit Id	No	No
account_code	varchar(32)	NULL	Account Code	No	No
drcr_flag	varchar(6)	NOT NULL	Debit Credit Flag	No	No
currency_code	varchar(5)	NOT NULL	Currency Code	No	No
tran_amount	numeric(28,8)	NOT NULL	Transaction Amount	No	No
base_amount	numeric(28,8)	NOT NULL	Base Amount	No	No
par_base_amount	numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	numeric(28,8)	NOT NULL	Exchange Rate	No	No
par_exchange_rate	numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	varchar(60)	NULL	Narration	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
item_code	varchar(40)	NULL	Item Code	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
quantity	numeric(29,8)	NULL	Quantity	No	No
tax_post_flag	varchar(1)	NULL	Tax Post Flag	No	No
mac_post_flag	varchar(1)	NULL	Post Flag	No	No
reftran_fbid	varchar(20)	NULL	Reference Transaction Finance Book Id	No	No
reftran_no	varchar(18)	NULL	Reference Transaction Number	No	No
reftran_ou	int	NULL	Reference Transaction Organization Id	No	No
ref_tran_type	varchar(40)	NULL	Reference Transaction Type	No	No
supcust_code	varchar(18)	NULL	Supplier Customer Code	No	No
uom	varchar(15)	NULL	Unit Of Measurement	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
mac_inc_flag	varchar(25)	NULL	Increment Flag	No	No
anal_inc_flag	varchar(25)	NULL	Increment Flag	No	No
Item_TCD_Flag	varchar(25)	NULL	Item or TCD Flag	No	No
TagNo	int	NULL	Debit & Credit Tag No	No	No
RowIdentity	int	NULL	Row identity No	No	No
expense_class	varchar(20)	NULL	Expense classification	No	No

Table Name fbp_posted_trn_dtl_his

Table Comment To Store all the transaction posting amount for all component mapped to the FB - History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	varchar(40)	NULL	Batch Id	No	No
company_code	varchar(10)	NULL	Company Code	No	No
component_name	varchar(20)	NULL	Component Name	No	No
bu_id	varchar(20)	NULL	Business Unit Id	No	No
fb_id	varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Transaction Organization Unit	No	No
fb_voucher_no	varchar(18)	NULL	Voucher Number	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
recon_flag	varchar(25)	NULL	Reconcile Flag	No	No
con_ref_voucherno	varchar(40)	NULL	Voucher Number	No	No
document_no	varchar(18)	NULL	Document Number	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	varchar(8)	NULL	Entry Date	No	No
auth_date	varchar(8)	NULL	Authorized Date	No	No
posting_date	varchar(8)	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	varchar(32)	NULL	Account Flag	No	No
drcr_flag	varchar(6)	NULL	Debit Credit Flag	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
tran_amount	numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	varchar(60)	NULL	Narration	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
item_code	varchar(40)	NULL	Item Code	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
quantity	varchar(17)	NULL	Quantity	No	No
tax_post_flag	varchar(1)	NULL	Tax Posting Flag	No	No
mac_post_flag	varchar(1)	NULL	Post Flag	No	No
reftran_fbid	varchar(20)	NULL	Reference Transaction Finance Book Id	No	No
reftran_no	varchar(18)	NULL	Reference Transaction Number	No	No
reftran_ou	int	NULL	Reference Transaction Organization Unit	No	No
ref_tran_type	varchar(40)	NULL	Reference Transaction Type	No	No
supcust_code	varchar(18)	NULL	Supplier Customer Code	No	No
uom	varchar(15)	NULL	Unit Of Measurement	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
mac_inc_flag	varchar(25)	NULL	Increment Flag	No	No
anal_inc_flag	varchar(25)	NULL	Increment Flag	No	No
Item_TCD_Flag	varchar(25)	NULL	Item or TCD Flag	No	No
TagNo	int	NULL	Debit & Credit Tag No	No	No
RowIdentity	int	NULL	Row identity No	No	No

Table Name fbp_postings_mode_sys

Table Comment To Store Metadata for the Integration Service Mapped to the particular component from where account posting will happen
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
component_name	varchar(20)	NOT NULL	Component Name	Yes	No
calling_srvc_or_view	varchar(64)	NOT NULL	Serial Voucher / View	Yes	No
timestamp	int	NULL	Time Stamp	No	No
online_post	varchar(1)	NULL	On Line Posting	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_ret_earn_yr_prd

Table Comment To store information about retained earning for the given period
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
run_no	varchar(40)	NOT NULL	Run Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
ret_earn_amount	numeric(28,8)	NULL	Return Earned Amount	No	No
drcr_flag	varchar(25)	NULL	Debit /Credit Flag	No	No
close_status	varchar(25)	NULL	Close Status.Values EXC-Exclude, INC-Include,	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_ret_earn_yr_prd_his

Table Comment To store History information about retained earning for the given period
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
company_code	varchar(10	NOT NULL	Company Code	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fin_year	varchar(15)	NOT NULL	Finance Year	Yes	No
fin_period	varchar(15)	NOT NULL	Finance Period	Yes	No
run_no	varchar(40)	NOT NULL	Run Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
ret_earn_amount	numeric(28,8)	NULL	Return Earn Amount	No	No
drcr_flag	varchar(25)	NULL	Debit / Credit Flag	No	No
close_status	varchar(25)	NULL	Close Status	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Create Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_trn_error_log

Table Comment To store transaction error logs
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	varchar(40)	NULL	Batch Id	No	No
account_code	varchar(32)	NULL	Account Code	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
document_no	varchar(18)	NULL	Document Number	No	No
fb_id	varchar(20)	NULL	Finance Book Id	No	No
ou_id	int	NULL	Organization Unit Id	No	No
component_name	varchar(20)	NULL	Component Name	No	No
drcr_flag	varchar(6)	NULL	Debit Credit Flag	No	No
tran_date	datetime	NULL	Transaction Date	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
currency_code	varchar(5)	NULL	Currency Codew	No	No
tran_amount	numeric(28,8)	NULL	Transaction Amount	No	No
exchange_rate	numeric(15,5)	NULL	Exchange Rate	No	No
par_exchange_rate	numeric(15,5)	NULL	Parallel Exchange Rate	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
item_code	varchar(40)	NULL	Item Code	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
remarks	varchar(60)	NULL	Remarks	No	No
base_amount	numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	numeric(28,8)	NULL	Parallel Base Amount	No	No
posting_date	datetime	NULL	Posting Date	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
quantity	numeric(29,8)	NULL	Quantity	No	No
reftran_fbid	varchar(20)	NULL	Finance Book Id	No	No
reftran_no	numeric(10,8)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	varchar(40)	NULL	Transaction Type	No	No
supcust_code	varchar(16)	NULL	Supplier Customer Code	No	No
uom	varchar(15)	NULL	Unit Of Measurement	No	No
error_desc	varchar(255)	NULL	Error Description	No	No
log_time	datetime	NULL	Log Time	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_unposted_trn_dtl

Table Comment To store the unposted transactions
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	varchar(40)	NULL	Batch Id	No	No
company_code	varchar(10)	NULL	Company Code	No	No
component_name	varchar(20)	NULL	Component Name	No	No
bu_id	varchar(20)	NULL	Business Unit Id	No	No
fb_id	varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Transaction Organization Unit	No	No
fb_voucher_no	varchar(18)	NULL	Voucher Number	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
recon_flag	varchar(25)	NULL	Reconcile Status	No	No
con_ref_voucherno	varchar(40)	NULL	Voucher Number	No	No
document_no	varchar(18)	NULL	Document Number	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	varchar(32)	NULL	Account Code	No	No
drcr_flag	varchar(6)	NULL	Debit Credit Flag	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
tran_amount	numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	numeric(15,5)	NULL	Exchange Rate	No	No
par_exchange_rate	numeric(15,5)	NULL	Parallel Exchange Rate	No	No
narration	varchar(255)	NULL	Narration	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
cost_center	varchar(5)	NULL	Cost Center	No	No
item_code	varchar(40)	NULL	Item Code	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
quantity	numeric(29,8)	NULL	Quantity	No	No
tax_post_flag	varchar(1)	NULL	Tax Post flag	No	No
mac_post_flag	varchar(1)	NULL	Post flag	No	No
reftran_fbid	varchar(20)	NULL	Finance Book Id	No	No
reftran_no	numeric(10,8)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	varchar(20)	NULL	Transaction Type	No	No
supcust_code	varchar(16)	NULL	Supplier Customer Code	No	No
uom	varchar(15)	NULL	Unit Of Measurement	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_unposted_trn_dtl_bk

Table Comment To store all unposted transactions for BK BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	varchar(40)	NULL	Batch Id	No	No
company_code	varchar(10)	NULL	Company Code	No	No
component_name	varchar(20)	NULL	Component Name	No	No
bu_id	varchar(20)	NULL	Business Unit Id	No	No
fb_id	varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Organization Unit	No	No
document_no	varchar(18)	NULL	Document Number	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	varchar(32)	NULL	Account Code	No	No
drcr_flag	varchar(6)	NULL	Debit / Credit Flag	No	No
currency_code	varchar(5)	NULL	Currency Code	No	No
tran_amount	Numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	Numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	Numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	Numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	varchar(255)	NULL	Narration	No	No
bank_code	varchar(32)	NULL	Bank Code	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
item_code	varchar(40)	NULL	Item Code	No	No
item_variant	varchar(70)	NULL	Item Variant	No	No
quantity	Numeric(28,8)	NULL	Quantity	No	No
reftran_fbid	varchar(20)	NULL	Finance Book Id	No	No
reftran_no	varchar(18)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	varchar(40)	NULL	Transaction Type	No	No
supcust_code	varchar(16)	NULL	Supplier Customer Code	No	No
uom	varchar(15)	NULL	Unit Of Measurement	No	No
con_ref_voucherno	varchar(18)	NULL	Voucher Number	No	No
mac_post_flag	Varchar(1)	NULL	Posting Flag	No	No
createdby	Varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	Varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No

Table Name fbp_unposted_trn_dtl_fam

Table Comment To store all unposted transactions for FAM BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	Varchar(40)	NULL	Batch Id	No	No
company_code	Varchar(10)	NULL	Company Code	No	No
component_name	Varchar(20)	NULL	Component Name	No	No
bu_id	Varchar(20)	NULL	Business Unit Id	No	No
fb_id	Varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Transaciton Number	No	No
document_no	Varchar(18)	NULL	Document Number	No	No
tran_type	Varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	Varchar(32)	NULL	Account Code	No	No
drcr_flag	Varchar(6)	NULL	Debit / Credit Flag	No	No
currency_code	Varchar(5)	NULL	Currency Code	No	No
tran_amount	Numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	Numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	Numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	Numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	Varchar(255)	NULL	Narration	No	No
bank_code	Varchar(32)	NULL	Bank Code	No	No
analysis_code	Varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	Varchar(5)	NULL	Subanalysis Code	No	No
cost_center	Varchar(10)	NULL	Cost Center	No	No
item_code	Varchar(40)	NULL	Item Code	No	No
item_variant	Varchar(70)	NULL	Item Variant	No	No
quantity	Numeric(29,8)	NULL	Quantity	No	No
reftran_fbid	Varchar(20)	NULL	Finance Book Id	No	No
reftran_no	Varchar(18)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	Varchar(40)	NULL	Transaction Type	No	No
supcust_code	Varchar(16)	NULL	Supplier customer code	No	No
uom	Varchar(15)	NULL	Unit Of Measurement	No	No
mac_post_flag	Varchar(1)	NULL	Posting Flag	No	No
createdby	Varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	Varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
con_ref_voucherno	Varchar(40)	NULL	Voucher Number	No	No

Table Name fbp_unposted_trn_dtl_gen

Table Comment To store all unposted transactions for other than finance BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	Varchar(40)	NULL	Batch Id	No	No
company_code	Varchar(10)	NULL	Company Code	No	No
component_name	Varchar(20)	NULL	Component Name	No	No
bu_id	Varchar(20)	NULL	Business Unit Id	No	No
fb_id	Varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Transaction Number	No	No
document_no	Varchar(18)	NULL	Document Number	No	No
tran_type	Varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	Varchar(32)	NULL	Account Code	No	No
drcr_flag	Varchar(6)	NULL	Debit / Credit Flag	No	No
currency_code	Varchar(5)	NULL	Currency Code	No	No
tran_amount	Numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	Numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	Numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	Numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	Varchar(255)	NULL	Narration	No	No
bank_code	Varchar(32)	NULL	Bank Code	No	No
analysis_code	Varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	Varchar(5)	NULL	Subanalysis Code	No	No
cost_center	Varchar(10)	NULL	Cost Center	No	No
item_code	Varchar(40)	NULL	Item Code	No	No
item_variant	Varchar(70)	NULL	Item Variant	No	No
quantity	Numeric(29,8)	NULL	Quantity	No	No
reftran_fbid	Varchar(20)	NULL	Finance Book Id	No	No
reftran_no	Varchar(18)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	Varchar(40)	NULL	Transaction Type	No	No
supcust_code	Varchar(16)	NULL	Supplier Customer Code	No	No
uom	Varchar(15)	NULL	Unit Of Measurement	No	No
mac_post_flag	Varchar(1)	NULL	Posting Flag	No	No
createdby	Varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	Varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
con_ref_voucherno	Varchar(40)	NULL	Reference Voucher Number	No	No
Item_TCD_Flag	varchar(25)	NULL	Item or TCD Flag	No	No
TagNo	int	NULL	Debit & Credit Tag No	No	No
RowIdentity	int	NULL	Row identity No	No	No

Table Name fbp_unposted_trn_dtl_pm

Table Comment To store all unposted transactions for PM BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	Varchar(40)	NULL	Batch Id	No	No
company_code	Varchar(10)	NULL	Company Code	No	No
component_name	Varchar(20)	NULL	Component Name	No	No
bu_id	Varchar(20)	NULL	Business Unit Id	No	No
fb_id	Varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Transaction Organization Unit	No	No
document_no	Varchar(18)	NULL	Document Number	No	No
tran_type	Varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit	No	No
account_code	Varchar(32)	NULL	Account Code	No	No
drcr_flag	Varchar(6)	NULL	Debit / Credit Flag	No	No
currency_code	Varchar(5)	NULL	Currency Code	No	No
tran_amount	Numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	Numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	Numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	Numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	Varchar(255)	NULL	Narration	No	No
bank_code	Varchar(32)	NULL	Bank Code	No	No
analysis_code	Varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	Varchar(5)	NULL	Subanalysis Code	No	No
cost_center	Varchar(10)	NULL	Cost Center	No	No
item_code	Varchar(40)	NULL	Item Code	No	No
item_variant	Varchar(70)	NULL	Item Variant	No	No
quantity	Numeric(29,8)	NULL	Quantity	No	No
reftran_fbid	Varchar(20)	NULL	Finance Book Id	No	No
reftran_no	Varchar(18)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	Varchar(40)	NULL	Transaction Type	No	No
supcust_code	Varchar(16)	NULL	Supplier Customer Code	No	No
uom	Varchar(15)	NULL	Unit Of Measurement	No	No
mac_post_flag	Varchar(1)	NULL	Posting Flag	No	No
createdby	Varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	Varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
con_ref_voucherno	Varchar(40)	NULL	Voucher Number	No	No

Table Name fbp_unposted_trn_dtl_rm

Table Comment To store all unposted transactions for Rm BPC
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
batch_id	Varchar(40)	NULL	Batch Id	No	No
company_code	Varchar(10)	NULL	Company Code	No	No
component_name	Varchar(20)	NULL	Component Name	No	No
bu_id	Varchar(20)	NULL	Business Unit Id	No	No
fb_id	Varchar(20)	NULL	Finance Book Id	No	No
tran_ou	int	NULL	Ogranization Unit	No	No
document_no	Varchar(18)	NULL	Document Number	No	No
tran_type	Varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
entry_date	datetime	NULL	Entry Date	No	No
auth_date	datetime	NULL	Authorized Date	No	No
posting_date	datetime	NULL	Posting Date	No	No
ou_id	int	NULL	Organization Unit Id	No	No
account_code	Varchar(32)	NULL	Account Code	No	No
drcr_flag	Varchar(6)	NULL	Debit / Credit Flag	No	No
currency_code	Varchar(5)	NULL	Currency Code	No	No
tran_amount	Numeric(28,8)	NULL	Transaction Amount	No	No
base_amount	Numeric(28,8)	NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NULL	Parallel Base Amount	No	No
exchange_rate	Numeric(28,8)	NULL	Exchange Rate	No	No
par_exchange_rate	Numeric(28,8)	NULL	Parallel Exchange Rate	No	No
narration	Varchar(255)	NULL	Narration	No	No
bank_code	Varchar(32)	NULL	Bank Code	No	No
analysis_code	Varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	Varchar(5)	NULL	Subanalysis Code	No	No
cost_center	Varchar(10)	NULL	Cost Center	No	No
item_code	Varchar(40)	NULL	Item Code	No	No
item_variant	Varchar(70)	NULL	Item Variant	No	No
quantity	Numeric(29,8)	NULL	Quantity	No	No
reftran_fbid	Varchar(20)	NULL	Finance Book Id	No	No
reftran_no	Varchar(18)	NULL	Transaction Number	No	No
reftran_ou	int	NULL	Organization Unit	No	No
ref_tran_type	Varchar(40)	NULL	Transaction Type	No	No
supcust_code	Varchar(16)	NULL	Supplier Customer Code	No	No
uom	Varchar(15)	NULL	Unit Of Measurement	No	No
mac_post_flag	Varchar(1)	NULL	Posting Flag	No	No
createdby	Varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	Varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
con_ref_voucherno	Varchar(40)	NULL	Reference Voucher Number	No	No

Table Name fbp_voucher_dtl

Table Comment To store account balance for the GL voucher details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
parent_key	varchar(40)	NOT NULL	Parent Key	Yes	No
current_key	varchar(40)	NOT NULL	Current Key	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
ou_id	int	NOT NULL	Organization Unit Id	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fb_voucher_no	varchar(18)	NOT NULL	Voucher Number	Yes	No
serial_no	int	NOT NULL	Serial Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
account_code	varchar(32)	NOT NULL	Account Code	No	No
drcr_flag	varchar(6)	NOT NULL	Debit / Credit Flag	No	No
cost_center	varchar(10)	NULL	Cost Center	No	No
analysis_code	varchar(5)	NULL	Analysis Code	No	No
subanalysis_code	varchar(5)	NULL	Subanalysis Code	No	No
base_amount	Numeric(28,8)	NOT NULL	Base Amount	No	No
par_base_amount	Numeric(28,8)	NOT NULL	Parallel Base Amount	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fbp_voucher_hdr

Table Comment To store account balance for the GL voucher details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
current_key	varchar(40)	NOT NULL	Current Key	Yes	No
company_code	varchar(10)	NOT NULL	Company Code	Yes	No
component_name	varchar(20)	NOT NULL	Component Name	Yes	No
bu_id	varchar(20)	NOT NULL	Business Unit Id	Yes	No
fb_id	varchar(20)	NOT NULL	Finance Book Id	Yes	No
fb_voucher_no	varchar(18)	NOT NULL	Voucher Number	Yes	No
timestamp	int	NULL	Time Stamp	No	No
tran_type	varchar(40)	NULL	Transaction Type	No	No
tran_date	datetime	NULL	Transaction Date	No	No
fb_voucher_date	datetime	NULL	Voucher Date	No	No
con_ref_voucher_no	varchar(40)	NULL	Reference Voucher Number	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name fin_query_trace

Table Comment To Store Metadata table contains the IS service name from where the posting data is transferred to FBP transactions
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
timestamp	int	NULL	Time Stamp	No	No
calling_sp_or_service	varchar(255)	NULL	Calling SP / Service	No	No
calling_context	varchar(255)	NULL	Calling Context	No	No
query_buffer	varchar(4000)	NULL	Query Buffer	No	No
createdby	varchar(15)	NULL	Created By	No	No
createddate	datetime	NULL	Created Date	No	No
modifiedby	varchar(15)	NULL	Modified By	No	No
modifieddate	datetime	NULL	Modified Date	No	No

Table Name Fin_user_rights_map

Table Comment To Store user level rights
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Ouid	int	NULL	Organization Unit Id	No	No
ComponentName	varchar(80)	NULL	Component Name	No	No
ActivityName	varchar(40)	NULL	Activity Name	No	No
TaskName	varchar(200)	NOT NULL	Task Name	No	No
ServiceName	varchar(20)	NOT NULL	Service Name	No	No
Flag	varchar(25)	NULL	Flag	No	No
Createdby	varchar(30)	NULL	Created By	No	No
CreatedDate	datetime	NOT NULL	Created Date	No	No

Table Name fin_sin_inv_postings_met

Table Comment To Store account postings metadata for Supplier Order Based Invoice
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
component	varchar(16)	NULL	name of the component	No	No
entity	varchar(25)	NULL	invamt,ratevar,qtyvar	No	No
row_type	varchar(25)	NULL	on item line,tax,charge,discount line.	No	No
ord_exp_type	varchar(5)	NULL	po_expense_type(revenue or capital)	No	No
match_type	varchar(25)	NULL	for PO alone it can hold 2w or 4w, for other invoice category this column hold null	No	No
drcr_flag	varchar(25)	NULL	Debit / Credit Flag	No	No
tcd_on	varchar(15)	NULL	tcd variant rule (expense off or tcd rule)	No	No
usg_flag	varchar(25)	NULL	a flag that determines whether rate variance postings should happen for rate variance account or the account code of the GR	No	No
dr_Acc	varchar(15)	NULL	debit account control account type	No	No
cr_acc	varchar(15)	NULL	credit account control account type	No	No
ref_doc_type	varchar(25)	NULL	reference document type	No	No
inv_cat	varchar(15)	NULL	invoice category	No	No