Database Schema for

Data Dictionary -- Customer Balance Adjustment

Srl. No.	Table Name	Comment
1	cbadj_acct_info_dtl	To store information of account detail
2	cbadj_adjvoucher_hdr	To store information of adjacent voucher header
3	cbadj_adjv_crdoc_dtl	To store information of adjacent voucher credit document detail
4	cbadj_adjv_crdoc_ref	To store information of adjacent voucher credit document reference
5	cbadj_adjv_drdoc_dtl	To store information of adjacent voucher debo
6	cbadj_adjv_drdoc_ref	To store information of adjacent voucher debit document reference
7	cbadj_attach_notes	To store information of attach notes
8	cbadj_vat_ref	To store information of vat reference


Table Name :	cbadj_acct_info_dtl
Comment :	To store information of account detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
tran_no	fin_documentno	varchar(40)	No	Transaction number	Yes
tran_type	fin_transactiontype	varchar(40)	No	Transaction type	Yes
account_code	fin_accountcode	varchar(32)	No	Account code	Yes
drcr_flag	fin_drcridentifier	varchar(6)	No	Debit credit flag	Yes
line_no	fin_lineno	int(4)	No	Line number	Yes
company_code	fin_companycode	varchar(10)	Yes	Company code	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
fin_post_date	fin_datetime	datetime(8)	Yes	Finance post date	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
cost_center	fin_costcentercode	varchar(10)	Yes	Cost center	No
tran_amount	fin_amount	numeric(13)	Yes	Transaction amount	No
analysis_code	fin_analysiscode	varchar(5)	Yes	Analysis code	No
subanalysis_code	fin_subanalysiscode	varchar(5)	Yes	Subanalysis code	No
basecur_erate	fin_amount	numeric(13)	Yes	Base currency exchange rate	No
base_amount	fin_amount	numeric(13)	Yes	Base amount	No
pbcur_erate	fin_amount	numeric(13)	Yes	Parallel base currency exchange rate	No
par_base_amt	fin_amount	numeric(13)	Yes	Parallel base amount	No
fin_post_status	fin_status	varchar(25)	Yes	Finance post status	No
transaction_date	fin_datetime	datetime(8)	Yes	Transaction date	No
account_type	fin_accounttype	varchar(15)	Yes	Account type	No
guid	fin_guid	varchar(40)	No	Guid	Yes
bu_id	fin_buid	varchar(20)	Yes	Business unit id	No
ref_doc_no	fin_documentno	varchar(40)	Yes	Reference document number	No
ref_tran_type	fin_transactiontype	varchar(40)	Yes	Reference transaction type	No


Table Name :	cbadj_adjvoucher_hdr
Comment :	To store information of adjacent voucher header


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentnumber	varchar(18)	No	Adj voucher number	Yes
voucher_tran_type	fin_transactiontype	varchar(40)	No	Voucher transaction type	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
voucher_date	fin_datetime	datetime(8)	Yes	Voucher date	No
fb_id	fin_financebookid	varchar(20)	Yes	Finance book id	No
voucher_amount	fin_amount	numeric(13)	Yes	Voucher amount	No
status	fin_status	varchar(25)	Yes	Status	No
cust_code	fin_customercode	varchar(16)	Yes	Customer code	No
cust_hierarchy	fin_customerhierarchyen	varchar(18)	Yes	Customer hierarchy	No
adjust_seq	fin_docadjseqen	varchar(12)	Yes	Adjust sequence	No
currency_code	fin_currencycode	varchar(5)	Yes	Currency code	No
voucher_type	fin_vouchertype	varchar(20)	Yes	Voucher type	No
rev_voucher_no	fin_documentno	varchar(40)	Yes	Reversal voucher number	No
reversal_date	fin_datetime	datetime(8)	Yes	Reversal date	No
notype_no	fin_notypeno	varchar(10)	Yes	notype_no	No
reason_code	fin_reasoncode	varchar(10)	Yes	Reason code	No
remarks	fin_comments	varchar(256)	Yes	Remarks	No
currentkey	fin_guid	varchar(40)	Yes	Current key	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No


Table Name :	cbadj_adjv_crdoc_dtl
Comment :	To store information of adjacent voucher credit document detail


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentnumber	varchar(18)	No	Adj voucher number	Yes
cr_doc_ou	fin_ouinstid	int(4)	No	Credit document OU	Yes
cr_doc_type	fin_documenttype	varchar(40)	No	Credit document type	Yes
cr_doc_no	fin_documentnumber	varchar(18)	No	Credit document number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
voucher_tran_type	fin_transactiontype	varchar(40)	No	Voucher transaction type	Yes
cr_doc_adj_amt	fin_amount	numeric(13)	Yes	Credit document adj amount	No
au_cr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author credit document unadjusted amount	No
au_cr_doc_date	fin_datetime	datetime(8)	Yes	Author credit document date	No
au_cr_doc_cur	fin_currencycode	varchar(5)	Yes	Author credit document currency	No
au_fb_id	fin_financebookid	varchar(20)	Yes	Author finance book id	No
au_receipt_type	fin_receipttype	varchar(30)	Yes	Author receipt type	No
au_billing_point	fin_ouinstid	int(4)	Yes	Author billing point	No
parent_key	fin_guid	varchar(40)	Yes	Parent key	No
current_key	fin_guid	varchar(40)	Yes	Current key	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
au_base_exrate	fin_amount	numeric(13)	Yes	Author base exchange rate	No
au_par_base_exrate	fin_amount	numeric(13)	Yes	Author parallel base exchange rate	No


Table Name :	cbadj_adjv_crdoc_ref
Comment :	To store information of adjacent voucher credit document reference


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
ref_cr_doc_no	fin_documentnumber	varchar(18)	No	Reference credit document number	Yes
cr_doc_ou	fin_ouinstid	int(4)	No	Credit document OU	Yes
cr_doc_type	fin_documenttype	varchar(40)	No	Credit document type	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
cr_doc_adj_amt	fin_amount	numeric(13)	Yes	Credit doc adj amount	No
cr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Credit doc unadj amount	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No


Table Name :	cbadj_adjv_drdoc_dtl
Comment :	To store information of adjacent voucher debo


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
adj_voucher_no	fin_documentnumber	varchar(18)	No	Adj voucher number	Yes
dr_doc_ou	fin_ouinstid	int(4)	No	Debit document OU	Yes
dr_doc_type	fin_documenttype	varchar(40)	No	Debit document type	Yes
dr_doc_no	fin_documentnumber	varchar(18)	No	Debit document number	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
voucher_tran_type	fin_transactiontype	varchar(40)	No	Voucher transaction type	Yes
dr_doc_adj_amt	fin_amount	numeric(13)	Yes	Debit document adj amount	No
discount	fin_amount	numeric(13)	Yes	Discount	No
proposed_discount	fin_amount	numeric(13)	Yes	Proposed discount	No
charges	fin_amount	numeric(13)	Yes	Charges	No
proposed_charges	fin_amount	numeric(13)	Yes	Proposed charges	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
au_pur_ord_ref	fin_documentnumber	varchar(18)	Yes	Author purchase order reference	No
au_dr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author debit document unadjusted amount	No
au_dr_doc_cur	fin_currencycode	varchar(5)	Yes	Author debit document currency	No
au_crosscur_erate	fin_amount	numeric(13)	Yes	Author cross currency exchange rate	No
au_discount_date	fin_datetime	datetime(8)	Yes	Author discount date	No
au_dr_doc_date	fin_datetime	datetime(8)	Yes	Author debit document date	No
au_fb_id	fin_financebookid	varchar(20)	Yes	Author finance book id	No
au_billing_point	fin_ouinstid	int(4)	Yes	Author billing point	No
parent_key	fin_guid	varchar(40)	Yes	Parent key	No
current_key	fin_guid	varchar(40)	Yes	Current key	No
au_sale_ord_ref	fin_documentnumber	varchar(18)	Yes	Author sale order reference	No
au_due_date	fin_datetime	datetime(8)	Yes	Author due date	No
au_disc_available	fin_amount	numeric(13)	Yes	Author discount available	No
au_cust_code	fin_customercode	varchar(16)	Yes	Author customer code	No
batch_id	fin_guid	varchar(40)	Yes	Batch id	No
au_base_exrate	fin_amount	numeric(13)	Yes	Author base exchange rate	No
au_par_base_exrate	fin_amount	numeric(13)	Yes	Author parallel base exchange rate	No


Table Name :	cbadj_adjv_drdoc_ref
Comment :	To store information of adjacent voucher debit document reference


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
ref_dr_doc_no	fin_documentnumber	varchar(18)	No	Reference debit document number	Yes
dr_doc_ou	fin_ouinstid	int(4)	No	Debit document OU	Yes
dr_doc_type	fin_documenttype	varchar(40)	No	Debit document type	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
sale_ord_ref	fin_documentnumber	varchar(18)	Yes	Sale order reference	No
dr_doc_adj_amt	fin_amount	numeric(13)	Yes	Debit document adj amount	No
au_dr_doc_unadj_amt	fin_amount	numeric(13)	Yes	Author debit document unadjusted amount	No
tran_type	fin_transactiontype	varchar(40)	Yes	Transaction type	No
au_exrate_variance	fin_amount	numeric(13)	Yes	Author exchange rate variance	No
au_dr_disc	fin_amount	numeric(13)	Yes	Author debit discount	No
au_dr_charge	fin_amount	numeric(13)	Yes	Author debit charge	No


Table Name :	cbadj_attach_notes
Comment :	To store information of attach notes


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
adj_voucher_no	fin_docuemntno	varchar(18)	No	Adjustment voucher number	No
adj_ouid	fin_ouinstid	int(4)	No	Adjustment ou id	No
ref_doc_no	fin_docuemntno	varchar(18)	Yes	Reference document number	No
ref_doc_ou	fin_ouinstid	int(4)	Yes	Reference document OU	No
timestamp	fin_int	int(4)	Yes	Timestamp	No
notes	fin_notes	varchar(2000)	Yes	Notes	No
notes_level	fin_notes_level	varchar(10)	Yes	Notes level	No
notes_for	fin_notesfor	varchar(30)	Yes	Notes for	No
createdby	fin_ctxt_user	varchar(30)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes


Table Name :	cbadj_vat_ref
Comment :	To store information of vat reference


Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
parent_key	fin_guid	varchar(40)	No	Parent key	Yes
ref_cr_doc_no	fin_docuemntno	varchar(18)	No	Reference credit document number	Yes
cr_doc_ou	fin_ouinstid	int(4)	No	Credit document OU	Yes
cr_doc_type	fin_documenttype	varchar(40)	No	Credit document type	Yes
term_no	fin_termnumber	varchar(20)	No	Term number	Yes
vat_line_no	fin_lineno	int(4)	No	Vat line number	Yes
vat_tran_amt	fin_amount	numeric(13)	Yes	Vat transaction amount	No
vat_base_amt	fin_amount	numeric(13)	Yes	Vat base amount	No
vat_ded_base_amt	fin_amount	numeric(13)	Yes	Vat ded base amount	No
vat_nonded_base_amt	fin_amount	numeric(13)	Yes	Vat nonded base amount	No
vat_category	fin_vatcategory	varchar(40)	Yes	Vat category	No
vat_rate	fin_amount	numeric(13)	Yes	Vat rate	No
vat_class	fin_vatclass	varchar(40)	Yes	Vat class	No