Supplier 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	sad_acct_info_dtl	Table contains the info about the posing for supplier 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
			acct_line_no	int	Account Line Number
			fin_post_date	datetime	Finance Posted Date	No
			currency_code	sql_variant	Currency Code
			cost_center		Cost Center
			tran_amount	bigint	Transaction Amount
			fb_id	sql_variant	Finance Book Id
			analysis_code		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 Posting Status.
			transaction_date	datetime	Transaction Date
			account_type	sql_variant	Account Type
			guid		Guid
			company_code		Company Code
			bu_id		Business Unit Id
			ref_doc_no		Reference Document Number
			ref_tran_type		Reference Transaction Type
	sad_acctlnk_tmp		guid		Guid	Yes
			tran_no		Transaction Number
	sad_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
			cr_doc_unadj_amt	bigint	Other than Credit Document Adjustment Amount	No
			cr_doc_adj_amt		Credit Document Adjustment Amount
			due_date	datetime	Due Date
			cust_code	sql_variant	Customer Code
			cr_doc_currency		Credit 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
			cr_doc_date	datetime	Credit Document Date
			cr_doc_amt	bigint	Credit 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
			tran_type	sql_variant	Transaction Type
			disc_available	bigint	Discount Available
			timestamp	int	Time Stamp
			total_adjusted_amt	bigint	Total Adjusted Amount
			bal_unadj_amt		Other than Balance Adjusted Amount
			proposed_flag	sql_variant	Proposed Flag
			selected_flag		Selected Flag
			comp_adjustment	bigint	Computation Adjustment
			compute_flag	sql_variant	Compute Flag
			current_key		Current Key
			bal_disc_available	bigint	Balance Discount Available
			due_amount		Due Amount
			last_term_flag	sql_variant	Last Term Flag
			disc_proportional		Discount Proportional
			comp_discount	bigint	Computed Discount
			vat_amount		Value Added Tax Amount
			vat_rate		Value Added Tax Rate
			dr_doc_adjusted		Debit Document Adjusted
			dr_doc_cur_disc		Debit Document Currency Discount
			par_base_exrate		Parallel Base Exchange Rate
			Fw_cov_flag	sql_variant	Forward Cover Flag
	sad_adjdrdocdtl_tmp		guid		Guid	Yes
			dr_doc_no		Debit Document Number
			dr_doc_ou	int	Debit Document Organization Unit
			term_no	sql_variant	Term Number
			dr_doc_type		Debit Document T ype
			dr_doc_date	datetime	Debit Document Date	No
			dr_doc_amount	bigint	Debit Document Amount
			dr_doc_unadj_amt		Other than Debit Document Adjustment Amount
			dr_doc_adj_amt		Debit Document Adjustment Amount
			dr_doc_currency	sql_variant	Debit 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
			timestamp	int	Time Stamp
			bal_unadj_amt	bigint	Other than Balance Adjustment Amount
			proposed_flag	sql_variant	Proposed Flag
			selected_flag		Selected Flag
			comp_curadj	bigint	Company Currency 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
	sad_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_no	sql_variant	Credit Document Number
			term_no		Term Number
			cr_doc_type		Credit Document Type
			cr_doc_adj_amt	bigint	Credit Document Adjustment Amount	No
			discount		Discount
			proposed_discount		Proposed Discount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			au_pur_ord_ref		Authorized Purchase Order Reference
			au_cr_doc_unadj_amt	bigint	Other Than Authorized Credit Document Adjustment Amount
			au_cr_doc_cur	sql_variant	Authorized Credit Document Currency
			au_crosscur_erate	bigint	Authorized Cross Currency Exchange Rate
			au_discount_date	datetime	Authorized Discount Date
			au_cr_doc_date		Authorized Credit Document Date
			au_fb_id	sql_variant	Authorized Finance Book Id
			parent_key		Parent Key
			current_key		Current Key
			au_disc_available	bigint	Authorized Discount Available
			au_due_date	datetime	Authorized Due Date
			au_billing_point	int	Authorized Billing Point
			vat_amount	bigint	Value Added Tax Amount
			vat_rate		Value Added Tax Rate
			tran_type	sql_variant	Transaction Type
			au_sale_ord_ref		Authorized Sales Order Reference
			voucher_tran_type		Voucher Transaction Type
			batch_id		Batch Id
	sad_adjv_crdoc_ref	Reference table that contains the Credit documents that are adjusted	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
			sale_ord_ref		Sales Order Reference	No
			cr_doc_adj_amt	bigint	Credit Document Adjustment Amount
			au_cr_doc_unadj_amt		Other than Authorized Credit Document Adjustment Amount
			tran_type	sql_variant	Transaction Type
			cr_discount	bigint	Credit Discount
			cross_cur_erate		Cross Currency Exchange Rate
	sad_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
			dr_doc_adj_amt	bigint	Debit Document Adjustment Amount	No
			au_dr_doc_unadj_amt		Authorized Debit Document Adjustment Amount
			au_dr_doc_amount		Authorized Debit Document Amount
			au_dr_doc_date	datetime	Authorized Debit Document Date
			au_dr_doc_cur	sql_variant	Authorized Debit Document Currency
			au_fb_id		Authorized Finance Book Id
			parent_key		Parent Key
			current_key		Current Key
			timestamp	int	Time Stamp
			au_billing_point		Authorized Billing Point
			tran_type	sql_variant	Transaction Type
			voucher_tran_type		Voucher Transaction Type
			batch_id		Batch Id
	sad_adjv_drdoc_ref	Reference table that contains the Debit documents that are adjusted	parent_key		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
			dr_doc_adj_amt	bigint	Debit Document Adjustment Amount	No
			dr_doc_unadj_amt		Other than Debit Document Adjustment Amount
			tran_type	sql_variant	Transaction Type
			discount	bigint	Discount
	sad_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
			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 - Aurthorized ,F -> Fresh,R - Reversed
			supp_code		Supplier Code
			adjust_seq		Adjustment Sequence
			currency_code		Currency Code
			voucher_type		Voucher Type
			rev_voucher_no		Reversal Voucher Number
			reversal_date	datetime	Reversal Date
			notype_no	sql_variant	Numbering Type Number
			reason_code		Reason Code
			remarks		Remarks
			currentkey		Current Key
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			voucher_tran_type	sql_variant	Voucher Transaction Type
			batch_id		Batch Id
	sad_attach_notes	Table that containst the notes and comments details for the Document number	adj_voucher_no		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
			notes	sql_variant	Notes
			notes_level		Notes Level
			notes_for		Notes For
			std_notes_id		Standard Notes Id
			std_notes_desc		Standard Notes Description
	sad_stdnotes_tmp		guid		Guid
			voucher_no		Voucher Number
			ref_doc_no		Reference Document Number
			ref_doc_ou	int	Reference Document Organization Unit
			std_notes_id	sql_variant	Standard Notes Id
			std_notes_desc		Standard Notes Description
			notes		Notes
	sad_vat_ref	Table contains the VAT info for the debit document’s	parent_key		Parent Key
			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
			vat_line_no	int	Value Added Tax Line Number
			vat_tran_amt	bigint	Value Added Tax Transaction Amount
			vat_base_amt		Value Added Tax Base Amount
			vat_ded_base_amt		Value Added Tax Deducted Base Amount
			vat_nonded_base_amt		Other than Value Added Tax Deducted 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