Customer Balance Adjustment

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	cbadj_acct_info_dtl	Table contains the info about the posing for customer against each adjustments	ou_id	int	Organization Unit Id	Yes	No
			tran_no	sql_variant	Transaction Number
			tran_type		Transaction Type
			account_code		Account Code
			drcr_flag		Debit Credit Flag
			line_no	int	Line Number
			guid	sql_variant	Guid
			company_code		Company Code	No
			fb_id		Finance Book Id
			fin_post_date	datetime	Finance Posted Date
			currency_code	sql_variant	Currency Code
			cost_center		Cost Center
			tran_amount	bigint	Transaction Amount
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			basecur_erate	bigint	Base Currency Exchange Rate
			base_amount		Base Amount
			pbcur_erate		Parallel Base Currency Exchange Rate
			par_base_amt		Parallel Base Amount
			fin_post_status	sql_variant	Finance Posted Status.Values P-Posted
			transaction_date	datetime	Transaction Date
			account_type	sql_variant	Account Type
			bu_id		Business Unit Id
			ref_doc_no		Reference Document Number
			ref_tran_type		Reference Transaction Type
	cbadj_acctlnk_tmp		guid		Guid	Yes
			tran_no		Transaction Number
	cbadj_adjcrdocdtl_tmp		guid		Guid
			cr_doc_type		Credit Document Type
			cr_doc_no		Credit Document Number
			cr_doc_ou	int	Credit Document Organization Unit
			term_no	sql_variant	Term Number
			timestamp	int	Time Stamp	No
			cr_doc_date	datetime	Credit Document Date
			cr_doc_amount	bigint	Credit Document Amount
			cr_doc_unadj_amt		Other than Credit Document Adjustment Amount
			cr_doc_adj_amt		Credit Document Adjustment Amount
			cr_doc_currency	sql_variant	Credit Document Currency
			exchange_rate	bigint	Exchange Rate
			fb_id	sql_variant	Finance Book Id
			billing_point	int	Billing Point
			receipt_type	sql_variant	Receipt Type
			currentdate	datetime	Current Date
			tran_type	sql_variant	Transaction Type
			bal_unadj_amt	bigint	Other Than Balance Adjustment Amount
			proposed_flag	sql_variant	Proposed Flag
			selected_flag		Selected Flag
			comp_curadj	bigint	Computed Current Adjustment
			compute_flag	sql_variant	Compute Flag
			current_key		Current Key
			par_base_exrate	bigint	Parallel Base Exchange Rate
			Fw_cov_flag	sql_variant	Forward Cover Flag
	cbadj_adjdrdocdtl_tmp		guid		Guid	Yes
			dr_doc_type		Debit Document Type
			dr_doc_no		Debit Document Number
			dr_doc_ou	int	Debit Document Organization Unit
			term_no	sql_variant	Term Number
			timestamp	int	Time Stamp	No
			dr_doc_unadj_amt	bigint	Other than Debit Document Adjustment Amount
			dr_doc_adj_amt		Debit Document Adjustment Amount
			due_date	datetime	Due Date
			cust_code	sql_variant	Customer Code
			dr_doc_currency		Debit Document Currency
			exchange_rate	bigint	Exchange Rate
			discount		Discount
			charges		Charges
			proposed_discount		Proposed Discount
			proposed_charges		Proposed Charges
			discount_date	datetime	Discount Date
			billing_point	int	Billing Point
			dr_doc_date	datetime	Debit Document Date
			dr_doc_amt	bigint	Debit Document Amount
			fb_id	sql_variant	Finance Book Id
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			tran_date	datetime	Transaction Date
			sal_ord_ref	sql_variant	Sales Order Reference
			pur_ord_ref		Purchase Order Reference
			disc_grace_days	int	Discount Grace Days
			res_writeoff_perc	bigint	Residual Write Off Percentage
			writeoff_amount		Write Off Amount
			tran_type	sql_variant	Transaction Type
			disc_available	bigint	Discount Available
			bal_unadj_amt		Other than Balance Adjustment Amount
			bal_disc_available		Balance Discount Available
			charges_collected		Charges Collected
			due_amount		Due Amount
			penalty_percent		Penalty Percent
			vat_rate		Value Added Tax Rate
			last_term_flag	sql_variant	Last Term Flag
			proposed_flag		Proposed Flag
			disc_proportional		Discount Proportional
			selected_flag		Selected Flag
			comp_discount	bigint	Computed Discount
			comp_charges		Computed Charges
			comp_adjustment		Computed Adjustment
			compute_flag	sql_variant	Compute Flag
			current_key		Current Key
			par_base_exrate	bigint	Parallel Base Exchange Rate
			cr_doc_adjusted		Credit Document Adjusted
			cr_doc_disc		Credit Document Discount
			cr_doc_charge		Credit Document Charges
			crosscurexrate		Cross Currency Exchange Rate
			Fw_cov_flag	sql_variant	Forward Covered Flag
	cbadj_adjv_crdoc_dtl	Table contains the info about the Credit documents that are adjusted against in a transactions	ou_id	int	Organization Unit Id	Yes
			adj_voucher_no	sql_variant	Adjustment Voucher Number
			cr_doc_ou	int	Credit Document Organization Unit
			cr_doc_type	sql_variant	Credit Document Type
			cr_doc_no		Credit Document Number
			term_no		Term Number
			voucher_tran_type		Voucher Transaction Type
			cr_doc_adj_amt	bigint	Credit Document Adjustment Amount	No
			au_cr_doc_unadj_amt		Other Than Authorized Credit Document Adjustment Amount
			au_cr_doc_date	datetime	Authorized Credit Document Date
			au_cr_doc_cur	sql_variant	Authorized Credit Document Currency
			au_fb_id		Authorized Finance Book Id
			au_receipt_type		Authorized Receipt Type
			au_billing_point	int	Authorized Billing Point
			parent_key	sql_variant	Parent Key
			current_key		Current Key
			tran_type		Transaction Type
			batch_id		Batch Id
			au_base_exrate	bigint	Authorized Base Exchange Rate
			au_par_base_exrate		Authorized Parallel Base Exchange Rate
	cbadj_adjv_crdoc_ref		parent_key	sql_variant	Parent Key	Yes
			ref_cr_doc_no		Reference Credit Document Number
			cr_doc_ou	int	Credit Document Organization Unit
			cr_doc_type	sql_variant	Credit Document Type
			term_no		Term Number
			cr_doc_adj_amt	bigint	Credit Document Number Adjustment Amount	No
			cr_doc_unadj_amt		Other Than Credit Document Number Adjustment Amount
			tran_type	sql_variant	Transaction Type
	cbadj_adjv_drdoc_dtl	Table contains the info about the debit documents that are adjusted against in a transactions	ou_id	int	Organization Unit Id	Yes
			adj_voucher_no	sql_variant	Adjustment Voucher Number
			dr_doc_ou	int	Debit Document Organization Unit
			dr_doc_type	sql_variant	Debit Document Type
			dr_doc_no		Debit Document Number
			term_no		Term Number
			voucher_tran_type		Voucher Transaction Type
			dr_doc_adj_amt	bigint	Debit Document Adjust Amount	No
			discount		Discount
			proposed_discount		Proposed Discount
			charges		Charges
			proposed_charges		Proposed Charges
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			au_pur_ord_ref		Authorized Purchase Order Reference
			au_dr_doc_unadj_amt	bigint	Other Than Authorized Debit Document Adjustment Amount
			au_dr_doc_cur	sql_variant	Authorized Debit Document Currency
			au_crosscur_erate	bigint	Authorized Cross Currency Exchange
			au_discount_date	datetime	Authorized Discount Date
			au_dr_doc_date		Authorized Debit Document Date
			au_fb_id	sql_variant	Authorized Finance Book Id
			au_billing_point	int	Authorized Billing Point
			parent_key	sql_variant	Parent Key
			current_key		Current Key
			au_sale_ord_ref		Authorized Sales Order Reference
			au_due_date	datetime	Authorized Due Date
			au_disc_available	bigint	Authorized Discount Available
			au_cust_code	sql_variant	Authorized Customer Code
			batch_id		Batch Id
			au_base_exrate	bigint	Authorized Base Exchange Rate
			au_par_base_exrate		Authorized Parallel Base Exchange Rate
	cbadj_adjv_drdoc_ref		parent_key	sql_variant	Parent Key	Yes
			ref_dr_doc_no		Reference Debit Document Number
			dr_doc_ou	int	Debit Document Organization Unit
			dr_doc_type	sql_variant	Debit Document Type
			term_no		Term Number
			timestamp	int	Time Stamp	No
			sale_ord_ref	sql_variant	Sales Order Reference
			dr_doc_adj_amt	bigint	Debit Document Adjustment Amount
			au_dr_doc_unadj_amt		Other Than Authorized Debit Document Adjustment Amount
			tran_type	sql_variant	Transaction Type
			au_exrate_variance	bigint	Authorized Exchange Rate Variance
			au_dr_disc		Authorized Debit Discount
			au_dr_charge		Authorized Debit Charges
	cbadj_adjvoucher_hdr	Table that contains the adjustment doucment number and it’s status and the adjusted amount	ou_id	int	Organization Unit Id	Yes
			adj_voucher_no	sql_variant	Adjustment Voucher Number
			voucher_tran_type		Voucher Transaction Type
			timestamp	int	Time Stamp	No
			voucher_date	datetime	Voucher Date
			fb_id	sql_variant	Finance Book Id
			voucher_amount	bigint	Voucher Amount
			status	sql_variant	Status.Values AU- Authorized,D -Deleted, R -Reversed,RE- Returned,P -PAID,PP- PARTLY PAID,PADJ- PARTLY JUSTED
			cust_code		Customer Code
			cust_hierarchy		Customer Hierarchy
			adjust_seq		Adjustment Sequence
			currency_code		Currency Code
			voucher_type		Voucher Type
			rev_voucher_no		Revised Voucher Number
			reversal_date	datetime	Reversal Date
			notype_no	sql_variant	Numbering Type
			reason_code		Reason Code
			remarks		Remarks
			currentkey		Current Key
			batch_id		Batch Id
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cbadj_attach_notes	Table that containst the notes and comments details for the Document number	adj_voucher_no	sql_variant	Adjustment Voucher Number
			adj_ouid	int	Adjustment Organization Unit Id
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_ou	int	Reference Document Organization Unit
			timestamp		Time Stamp
			notes	sql_variant	Notes
			notes_level		Notes Level
			notes_for		Notes For
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	cbadj_stdnotes_tmp		std_notes_id	sql_variant	Standard Notes Id	Yes
			std_notes_desc		Standard Notes Description
			notes		Notes	No
			guid		Guid
	cbadj_vat_ref		parent_key		Parent Key	Yes
			ref_cr_doc_no		Reference Credit Document Number
			cr_doc_ou	int	Credit Document Organization Unit
			cr_doc_type	sql_variant	Credit Document Type
			term_no		Term Number
			vat_line_no	int	Value Added Tax Line Number
			vat_tran_amt	bigint	Value Added Tax Transaction Amount	No
			vat_base_amt		Value Added Tax Base Amount
			vat_ded_base_amt		Value Added Tax Deduction Base Amount
			vat_nonded_base_amt		Value Added Tax Non-Deduction Base Amount
			vat_category	sql_variant	Value Added Tax Category
			vat_rate	bigint	Value Added Tax Rate
			vat_class	sql_variant	Value Added Tax Class