Reports - Payables Management

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ard_supplier_account_rpt_tmp		company_code	sql_variant	Company Code	No	No
			supplier_group		Supplier Group
			fb_id		Finance Book Id
			currency_code		Currency Code
			account_code		Account Code
			supp_control_acct_type		Supplier Control Account Type
			supplier_type		Supplier Type
			guid		Guid
	pm_sst_rpt_tmp		address		Address
			amount	bigint	Amount
			billingamt		Billing Amount
			buid	sql_variant	Business Unit Id
			calyear		Calendar Year
			closingbalance	bigint	Closing Balance
			CM_DocId	sql_variant	Document Id
			companycode		Company Code
			contactname		Contact Name
			companycontactname		Company Contact Name
			companyaddress1		Company Address 1
			companyaddress2		Company Address 2
			companyaddress3		Company Address 3
			companyaddress4		Company Address 4
			companyaddress5		Company Address 5
			companyaddress6		Company Address 6
			companyaddress7		Company Address 7
			contactperson		Contact Person
			currency_code		Currency Code
			currency_ml		Currency Multiple Line
			dateoption		Date Option
			depositamt	bigint	Deposit Amount
			desc255	sql_variant	Description 255
			desc255ml		Description 255 Multiple Line
			docdate	datetime	Document Date
			documentno	sql_variant	Document Number
			datefrom	datetime	Date From
			dateto		Date To
			duedate		Due Date
			financialperiod	sql_variant	Financial Period
			financialyear		Financial Year
			fromsupplier		From Supplier
			finmonth		Financial Month
			grandtotal	bigint	Grand Total
			instrumentdate	datetime	Instrument Date
			instrumentnumber	sql_variant	Instrument Number
			language		Language
			mltdescription		Multiple Line Description
			narration		Narration
			openingbalance	bigint	Opening Balance
			outstandingamount		Outstanding Amount
			paymentamt		Payment Amount
			phonenumber	sql_variant	Phone Number
			purpose		Purpose
			reporttype		Report Type
			status		Status
			suppliercodeto		Supplier Code To
			supplierfrom		Supplier Code From
			suppliergroup		Supplier Group
			suppliergrpfrom		Supplier Group From
			suppliergrpto		Supplier Group To
			suppliername		Supplier Name
			tosupplier		To Supplier
			transaction1		Transaction 1
			transactiontype		Transaction Type
			transactiontypehdn		Transaction Type Hidden
			actualamount	bigint	Actual Amount
			supplieraddress1	sql_variant	Supplier Address 1
			supplieraddress2		Supplier Address 2
			supplieraddress3		Supplier Address 3
			supplieraddress4		Supplier Address 4
			supplieraddress5		Supplier Address 5
			supplieraddress6		Supplier Address 6
			supplieraddress7		Supplier Address 7
			supplieraddress8		Supplier Address 8
			advamt	bigint	Advance Amount
			companyname	sql_variant	Company Name
			dateml	datetime	Date Multiple Line
			supdocrefno	sql_variant	Supplier Document Reference Number
			totoutstandingamt	bigint	Total Outstanding Amount
			unadjppiamt		Unadjusted Pre-payment Invoice Amount
			guid	sql_variant	Guid
	rep_out_temp		ou_id	int	Organization Unit Id
			tran_type	sql_variant	Transaction Type
			age	int	Age
			guid	sql_variant	Guid
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			supplier_code	sql_variant	Supplier Code
			tran_amount	bigint	Transaction Amount
			base_amount		Base Amount
			parbase_amount		Parallel Base Amount
			tran_currency	sql_variant	Transaction Currency
			bucket		Bucket
			bucket_desc		Bucket Description
	rep_sst_process	To store supplier statement details for reporting purposes	guid		Guid
			document_grp_ou	int	Document Group Organization Unit
			document_grp_no	sql_variant	Document Group Number
			document_grp_type		Document Group Type
			document_key		Document Key
	reports_ageing_bucket_dtl	To Store information about supplier ageing bucket details for reporting purposes	ou_id	int	Organization Unit Id
			bucket_no		Bucket Number
			bucket_from		Bucket From
			bucket_to		Bucket To
			flag	sql_variant	Flag
	repspm_age_fmt_tmp		guid		Guid
			asondate	datetime	As On Date
			suppliername	sql_variant	Supplier Name
			supplier_code		Supplier Code
			daysfrom	int	Days From
			daysto		Days To
			tran_amount	bigint	Transaction Amount
			flag	sql_variant	Flag
			fb_id		Finance Book Id
			currency_code		Currency Code
	repspm_age_output_tmp		guid		Guid
			bu		Business Unit
			companycode		Company Code
			companyname		Company Name
			crtdatmlt		Credit document amount
			fb		Finance Book
			currencycodeml		Currency Code Multiple
			supplier_code		Supplier Code
			suppliername		Supplier Name
			asondate	datetime	As On Date
			cm_docid	sql_variant	Document Id
			currencyoption		Currency Option
			amount	bigint	Amount
			amount1		Amount 1
			amountconsidered		Amount Considered
			amountdue		Amount Due
			amountfrom		Amount From
			amountin		Amount Information
			amountml		Amount Multiple
			amountto		Amount To
			amountto1		Amount To 1
			desc4	sql_variant	Description 4
			desc1		Description 1
			desc2		Description 2
			desc255		Description 255
			desc3		Description 3
			description2		Description 2
			description3		Description 3
			descriptionfrom		Description From
			descriptionhdr		Description Header
			descriptionto		Description To
			includeprepayments		Include Prepayments
			language		Language
			suppliercodeto		Supplier Code
			supplierfrom		Supplier From
			suppliergroup		Supplier Group
			totalpayamount	bigint	Total Pay amount
	repspm_calendaryear_tmp		ma_guid	sql_variant	Management Account Guid
			ma_year	varchar(10)	Management Account Year
			ma_month		Management Account Month
			ma_monthno	int	Management Account Month To
	repspm_invoice_tmp		guid	sql_variant	Guid
			invoice_type		Invoice Type
			invoice_ou		Invoice Organization Unit
			invoice_no		Invoice Number
			termno		Term Number
			receipt_type		Receipt Type
			receipt_ou		Receipt Organization Unit
			receipt_no		Receipt Number
			adj_tran_type		Adjustment Transaction Type
			adj_ou		Adjustment Organization Unit
			adj_voucher_no		Adjustment Voucher Number
			adj_fb		Adjustment Finance Book
			adj_voucher_date	datetime	Adjustment Voucher Date
			adj_currency	sql_variant	Adjustment Currency
			adjust_amount	bigint	Adjustment Amount
			discount		Discount
			charges		Charges
	repspm_pno_rpt_tmp		companycode	sql_variant	Company Code
			companyname		Company Name
			companyaddress1		Company Address 1
			companyaddress2		Company Address 2
			companyaddress3		Company Address 3
			companyaddress4		Company Address 4
			companyaddress5		Company Address 5
			companyaddress6		Company Address 6
			companyaddress7		Company Address 7
			suppliercode		Supplier Code
			suppliername		Supplier Name
			supplieradd1		Supplier Address 1
			supplieradd2		Supplier Address 2
			supplieradd3		Supplier Address 3
			supplieradd4		Supplier Address 4
			supplieradd5		Supplier Address 5
			supplieradd6		Supplier Address 6
			supplieradd7		Supplier Address 7
			supplieradd8		Supplier Address 8
			supplieradd9		Supplier Address 9
			notenumber		Note Number
			supp_notenumber		Supplier Note Number
			notedate	datetime	Note Date
			supp_notedate		Supplier Note Date
			status	sql_variant	Status
			currency_code		Currency Code
			tranamount	bigint	Transaction Amount
			supp_tranamount		Supplier Transaction Amount
			comments	sql_variant	Comments
			accountcode		Account Code
			accountdesc		Account Description
			refamount	bigint	Reference Amount
			ref_tranamount		Reference Transaction Amount
			pay_term	sql_variant	Pay Term
			pay_method		Pay Method
			anchor_date	datetime	Anchor Date
			elec_pay	sql_variant	Electronic Pay
			pay_mode		Pay Mode
			pay_priority		Pay Priority
			payment_ou	int	Payment Organization
			refdocno	sql_variant	Reference Document Number
			refdocdate	datetime	Reference Document Date
			ref_doc_type	sql_variant	Reference Document Type
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			duedate		Due Date
			dueamount	bigint	Due Amount
			discountdate	datetime	Discount Date
			discountamount	bigint	Discount Amount
			penalty		Penalty
			place	sql_variant	Place
			itemcode		Item Code
			itemdesc		Item Description
			UOM		Unit Of Measurement
			quantity	bigint	Quantity
			rate		Rate
			debitcredit	sql_variant	Debit Credit
			fbid		Finance Book Id
			exchange_rate	bigint	Exchange Rate
			Notetype	sql_variant	Note Type
			ou_desc		Organization Unit Description
			flag		Flag
			guid		Guid
	repspm_pno_tran_rpt_tmp		tran_ou		Transaction Organization Unit
			tran_type		Transaction Type
			tran_no		Transaction Number
			supplier_code		Supplier Code
			Doc_type		Document Type
			Account_no		Account Number
			Account_type		Account Type
			Amount	bigint	Amount
			tra_doc_no	sql_variant	Transaction Document Number
			fb		Finance Book
			guid		Guid
			tran_date	datetime	Transaction Date
			Tot_amount	bigint	Total Amount
			drcr_flag	sql_variant	Debit Credit Flag
			status		Status
	repspm_prninv_tmp		guid		Guid
			tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			bu_id	sql_variant	Business Unit Id
			company_code		Company Code
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			tran_status	sql_variant	Transaction Status
			supp_invoice_no		Supplier Invoice Number
			supp_code		Supplier Code
			supp_invoice_date	datetime	Supplier Invoice Date
			supp_invoice_amount	bigint	Supplier Invoice Amount
			fb_id	sql_variant	Finance Book Id
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			uom		Unit Of Measurement
			item_qty	bigint	Item Quantity
			usage	sql_variant	Usage
			item_rate	bigint	Item Rate
			rate_per		Rate Per
			item_amount		Item Amount
			tcdcode	sql_variant	Tax Charge Discount Code
			tcdvar		Tax Charge Discount Variant
			ref_doc_no		Reference Document Number
			rev_doc_no		Reversal Document Number
			rev_date	datetime	Reversal Date
			rev_reason_code	sql_variant	Reversal Reason Code
			rev_remarks		Reversal Remarks
			hld_reason_code		Hold Reason Code
			hld_remarks		Hold Remarks
			proposal_no		Proposal Number
			tcddesc		Tax Charge Discount Description
			line_no	int	Line Number
			pay_term	sql_variant	Pay Term
			pay_method		Pay Method
			anchor_date	datetime	Anchor Date
			elec_pay	sql_variant	Electronic Pay
			pay_mode		Pay Mode
			pay_priority		Pay Priority
			comments		Comments
			cost_center		Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			due_date	datetime	Due Date
			due_amount	bigint	Due Amount
			disc_date	datetime	Discount Date
			disc_percent	bigint	Discount Percentage
			disc_amount		Discount Amount
			penalty_percent		Penalty Percentage
			suppliername	sql_variant	Supplier Name
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			expense	sql_variant	Expense
			tran_status_desc		Transaction Status Description
			po_no		Purchase Order Number
			po_ou	int	Purchase Order Organization Unit
			item_type	sql_variant	Item Type
			tcd_level		Tax Charge Discount Level
			CompanyName		Company Name
			company_address1		Company Address 1
			company_address2		Company Address 2
			company_address3		Company Address 3
			company_address4		Company Address 4
			company_address5		Company Address 5
			company_address6		Company Address 6
			company_address7		Company Address 7
			supplier_address1		Supplier Address 1
			supplier_address2		Supplier Address 2
			supplier_address3		Supplier Address 3
			supplier_address4		Supplier Address 4
			supplier_address5		Supplier Address 5
			supplier_address6		Supplier Address 6
			supplier_address7		Supplier Address 7
			supplier_address8		Supplier Address 8
			supplier_address9		Supplier Address 9
			ou_desc		Organization Unit Description
			sobitcd_value	bigint	Tax Charge Discount Value of supplier order based invoice
			vatamount		Value Added Tax Amount
			flag	sql_variant	Flag
			itemdesc		Item Description
			vatdesc		Value Added Tax Description
	repspm_pvo_rpt_snp_tmp		voucher_no		Voucher Number
			fb_id		Finance Book Id
			payee_name		Payee Name
			pay_date	datetime	Pay Date
			pay_currency	sql_variant	Pay Currency
			exchange_rate	bigint	Exchange Rate
			pay_amount		Pay Amount
			pay_method	sql_variant	Pay Method
			payment_route		Payment Route
			pay_mode		Pay Mode
			bank_cash_code		Bank Cash Code
			relpay_ou	int	Release Payment Organization Unit
			priority	sql_variant	Priority
			hr_reason_code		HR Reason Code
			hr_remarks		HR Remarks
			reversal_reason_code		Reversal Reason Code
			reversal_date	datetime	Reversal Date
			reversal_remarks	sql_variant	Reversal Remarks
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip_code		Zip Code
			contact		Contact
			url		Universal Resource Locator
			mail_stop		Mail Stop
			pager_no		Pager Number
			email_id		Email Id
			telex		Telex
			phone_no		Phone Number
			mobile_no		Mobile Number
			fax_no		Fax Number
			cap_charge		Capitalization Charge
			voucher_status		Voucher Status
			guid		Guid
	repspm_pvo_rpt_tmp		voucher_no		Voucher Number
			request_date	datetime	Request Date
			fb_id	sql_variant	Finance Book Id
			pay_date	datetime	Pay Date
			supp_code	sql_variant	Supplier Code
			payment_route		Payment Route
			pay_mode		Pay Mode
			pay_currency		Pay Currency
			pay_amount	bigint	Pay Amount
			doc_type	sql_variant	Document Type
			ref_doc_no		Reference Document Number
			ref_pay_amount	bigint	Reference Pay Amount
			status	sql_variant	Status
			due_date	datetime	Due Date
			due_amt	bigint	Due Amount
			pay_batch_no	sql_variant	Pay Batch Number
			supp_name		Supplier Name
			cr_doc_type		Credit Document Type
			dr_doc_type		Debit Document Type
			cr_doc_no		Credit Document Number
			dr_doc_no		Debit Document Number
			cr_unadj_amt	bigint	Credit Unadjustment Amount
			dr_unadj_amt		Debit Unadjustment Amount
			cr_doc_cur	sql_variant	Credit Document Currency
			dr_doc_cur		Debit Document Currency
			cr_erate	bigint	Credit Exchange Rate
			dr_doc_amt		Debit Document Amount
			cr_adj_amt		Credit Adjustment Amount
			dr_adj_amt		Debit Adjustment Amount
			discount		Discount
			disc_date	datetime	Discount date
			dr_doc_date		Debit Document Date
			cr_fbid	sql_variant	Credit Finance Book Id
			dr_fbid		Debit Finance Book Id
			guid		Guid
	repspm_quick_code_met	To store system defined information for reporting purposes	component_id		Component Id	Yes
			parameter_type		Parameter Type
			parameter_category		Parameter Category
			parameter_code		Parameter Code
			timestamp	int	Time Stamp	No
			parameter_text	sql_variant	Parameter Text
			language_id	int	Language Id
			extension_flag	sql_variant	Extension Flag
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	repspm_sba_rpt_result_tmp		guid	sql_variant	Guid
			tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			sequence_no	int	Sequence Number
			tran_date	datetime	Transaction Date
			component_id	sql_variant	Component Id
			lo_id		Logistics Organization Id
			company_code		Company Code
			company_name		Company Name
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supp_ou	int	Supplier Organization Unit
			supplier_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			account_code		Account Code
			account_desc		Account Description
			ctrl_acct_type		Control Account Type
			acct_currency		Account Currency
			due_date	datetime	Due Date
			tran_due_amount	bigint	Transaction Due Amount
			base_due_amount		Base Due Amount
			par_due_amount		Parallel Due Amount
			cur_opt_due_amount		Due amount
			age	int	Age
			bucket	sql_variant	Bucket
			bucket_desc		Bucket Description
	repspm_sdd_ml_temp		guid		Guid
			trans_desc		Transaction Description
			trans_type		Transaction Type
			docno_from		Document Number From
			docno_to		Document Number To
			docamt_from	bigint	Document Amount From
			docamt_to		Document Amount To
			docstat_desc	sql_variant	Document Status Description
			doc_status		Document Status
			disamt_from	bigint	Discount Amount From
			disamt_to		Discount Amount To
			penalty_from		Penalty From
			penalty_to		Penalty To
			date_criteria	sql_variant	Date Criteria
			daysfrom	int	Days From
			daysto		Days To
			date_from	datetime	Date From
			date_to		Date To
			due_date		Due Date
			ou_id	int	Organization Unit
			inc_no		Increased Number
	repspm_ssl_rpt_result_tmp		guid	sql_variant	Guid
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			component_id	sql_variant	Component Id
			lo_id		Logistics Organization Id
			company_code		Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supp_ou	int	Supplier Organization Unit
			supplier_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			supp_inv_no		Supplier Invoice Number
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			doc_status	sql_variant	Document Status
			reversed_docno		Reversed Document Number
			reversal_date	datetime	Reversal Date
			bank_code	sql_variant	Bank Code
			checkseries_no		Check Series Number
			check_no		Check Number
			paid_status		Paid Status
			vat_applicable		Value Added Tax Applicable
			discount_proportional		Discount Proportional
			discount_amount	bigint	Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			reversed_docou	int	Reversed Document Organization Unit
			bankcashcode	sql_variant	Bank Cash Code
			line_no	int	Line Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ctrl_acct_type		Control Account Type
			auto_post_acct_type		Auto Posted Account Type
			tran_currency		Transaction Currency
			acct_currency		Account Currency
			tran_amount_acc_cur	bigint	Transaction Amount Account Currency
			tran_amount_acc_cur_cr		Transaction Amount Account Currency Credit
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			base_amount_cr		Base Amount Credit
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			par_base_amount_cr		Parallel Base Amount Credit
			narration	sql_variant	Narration
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			supp_control_acct_type		Supplier Control Account Type
			supplier_type		Supplier Type
			flag_op		Flag
			debit_accnt_code		Debit Account Code
			debit_accnt_desc		Debit Account Description
			cur_option_dr_amt	bigint	Currency Option Debit Amount
			cur_option_cr_amt		Currency Option Credit Amount
			company_name	sql_variant	Company Name
			account_desc		Account Description
			short_desc		Short Description
	repspm_ssl_rpt_tmp		accountcode		Account Code
			accountdescription		Account Description
			bu		Business Unit
			calyear		Calendar Year
			closingbalance	bigint	Closing Balance
			cm_docid	sql_variant	Document Id
			companycode		Company Code
			companyname		Company Name
			controlaccounttype		Control Account Type
			credittotal	bigint	Credit Total
			crtdatmlt	sql_variant	Credit Amount
			currencyoption		Currency Option
			currency_code		Currency Code
			currency_codeml		Currency Code Multiple Line
			datefrom	datetime	Date From
			dateoption	sql_variant	Date Option
			dateto	datetime	Date To
			debittotal	bigint	Debit Total
			desc255	sql_variant	Description255
			documentdate	datetime	Document Date
			documentno	sql_variant	Document Number
			fb		Finance Book
			financialperiod		Financial Period
			financialyear		Financial Year
			finmonth		Financial Month
			opbal	bigint	Opening Balance
			reportingbasis	sql_variant	Reporting Basis
			reporttype		Report Type
			supcode		Supplier Code
			supplierfrom		Supplier From
			suppliergroup		Supplier Group
			suppliergroupmlt		Supplier Group Multiple line
			suppliername		Supplier Name
			supplierto		Supplier To
			transactiontype		Transaction Type
			guid		Guid
	repspm_sst_rpt_result_tmp
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			component_id	sql_variant	Component Id
			lo_id		Logistics Organization Id
			company_code		Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supp_ou	int	Supplier Organization Unit
			supplier_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			supp_inv_no		Supplier Invoice Number
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			doc_status	sql_variant	Document Status
			reversed_docno		Reversed Document Number
			reversal_date	datetime	Reversal Date
			bank_code	sql_variant	Bank Code
			checkseries_no		Check Series Number
			check_no		Check Number
			paid_status		Paid Status
			vat_applicable		Value Added Tax Applicable
			discount_proportional		Discount Proportional
			discount_amount	bigint	Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			reversed_docou	int	Reversed Document Organization Unit
			bankcashcode	sql_variant	Bank Cash Code
			line_no	int	Line Number
			account_code	sql_variant	Account Code
			account_desc		Account Description
			drcr_flag		Debit Credit Flag
			ctrl_acct_type		Control Account Type
			auto_post_acct_type		Auto Posted Account Type
			tran_currency		Transaction Currency
			acct_currency		Account Currency
			tran_amount_acc_cur	bigint	Transaction Amount Account Currency
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			narration	sql_variant	Narration
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
			supp_control_acct_type		Supplier Control Account Type
			supplier_type		Supplier Type
			flag_op
			sequence_no	int	Sequence Number
			flag_adj	sql_variant	Flag Adjustment
			document_grp_ou	int	Document Group Organization Unit
			document_grp_no	sql_variant	Document Group Number
			document_grp_type		Document Group Type
			doc_balance	bigint	Document Balance
			debit_accnt_code	sql_variant	Debit Account Code
			debit_accnt_desc		Debit Account Description
			cur_option_dr_amt	bigint	Currency Option Debit Amount
			cur_option_cr_amt		Currency Option Credit Amount
			company_name	sql_variant	Company Name
			short_desc		Short Description
			doc_due_date	datetime	Document Due Date
			doc_term_no	sql_variant	Document Term Number
			doc_due_amount	bigint	Document Due Amount
			contact_person	sql_variant	Contact Person
			Address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip		Zip
	repspm_sup_age_tmp		ageinganalysis		Ageing Analysis
			amount	bigint	Amount
			amount1		Amount 1
			amountconsidered		Amount Considered
			amountdue		Amount Due
			amountfrom		Amount From
			amountin		Amount Information
			amountml		Amount Multiple Line
			amountto		Amount To
			amountto1		Amount To 1
			asondate	datetime	As On Date
			bu	sql_variant	Business Unit
			cm_docid		Document Id
			companycode		Company Code
			companyname		Company Name
			crtdatmlt		Credit Amount
			currencycodeml		Currency Code Multiple Line
			currencyoption		Currency Option
			desc4		Description 4
			desc1		Description 1
			desc2		Description 2
			desc255		Description 255
			desc3		Description 3
			description2		Description 2
			description3		Description 3
			descriptionfrom		Description From
			descriptionhdr		Description Header
			descriptionto		Description To
			fb		Finance Book
			includeprepayments		Include Prepayment
			language		Language
			suppliercodeto		Supplier Code To
			supplierfrom		Supplier From
			suppliergroup		Supplier Group
			suppliername		Supplier Name
			totalpayamount	bigint	Total Pay Amount
			guid	sql_variant	Guid
			supplier_code		Supplier Code
			tran_date	datetime	Transaction Date
			tran_amount	bigint	Transaction Amount
	repspm_supp_details	To store information about Supplier details for reporting purposes	guid	sql_variant	Guid
			suppcode		Supplier Code
			suppname		Supplier Name
			suppgroupcode		Supplier Group Code
			purpose		Purpose
			status		Status
	repspm_supp_recipt_rpt	To store information about Supplier Receipts for reporting purposes	receipt_no		Receipt Number
			receipt_date	datetime	Receipt Date
			Status	sql_variant	Status
			fb		Finance Book
			supplier_code		Supplier Code
			supplier_name		Supplier Name
			amount	bigint	Amount
			currency	sql_variant	Currency
			receipt_mode		Receipt Mode
			inst_no		Instrument Number
			inst_date	datetime	Instrument Date
			inst_amt	bigint	Instrument Amount
			bank_code	sql_variant	Bank Code
			micr_no		MICR number
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			receipt_type		Receipt Type
			exch_rate	bigint	Exchange Rate
			guid	sql_variant	Guid
	si_cursor_tmp
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supplier_code		Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			account_type		Account Type
			tran_drcr_flag		Transaction Debit Credit Flag
			base_drcr_flag		Base Debit Credit Flag
			pab_drcr_flag		Parallel base amount Debit/Credit Flag
			tran_balance	bigint	Transaction Balance
			base_balance		Base Balance
			pab_balance		Parallel base Balance amount
			cb_credit		Closing Balance Credit
			cb_debit		Closing Balance Debit
			balance_type	sql_variant	Balance Type
			srno	int	Serial Number
	si_doc_acct_info_tmp		guid	sql_variant	Guid
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			tran_date	datetime	Transaction Date
			component_id	sql_variant	Component Id
			lo_id		Logistics Organization Id
			company_code		Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			supp_ou	int	Supplier Organization Unit
			supplier_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			supp_inv_no		Supplier Invoice Number
			pay_term		Pay Term
			payterm_version	int	Pay Term Version
			doc_status	sql_variant	Document Status
			reversed_docno		Reversed Document Number
			reversal_date	datetime	Reversal Date
			bank_code	sql_variant	Bank Code
			checkseries_no		Check Series Number
			check_no		Check Number
			paid_status		Paid Status
			vat_applicable		Value Added Tax Applicable
			discount_proportional		Discount Proportional
			discount_amount	bigint	Discount Amount
			discount_availed		Discount Availed
			penalty_amount		Penalty Amount
			reversed_docou	int	Reversed Document Organization Unit
			bankcashcode	sql_variant	Bank Cash Code
			line_no	int	Line Number
			account_code	sql_variant	Account Code
			drcr_flag		Debit Credit Flag
			ctrl_acct_type		Control Account Type
			auto_post_acct_type		Auto Posted Account Type
			tran_currency		Transaction Currency
			acct_currency		Account Currency
			tran_amount_acc_cur	bigint	Transaction Amount Account Currency
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			narration	sql_variant	Narration
			ref_doc_ou	int	Reference Document Organization Unit
			ref_doc_fb_id	sql_variant	Reference Document Finance Book Id
			ref_doc_type		Reference Document Type
			ref_doc_no		Reference Document Number
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			txnou_id	int	Transaction Organization Unit Id
			tran_qty	bigint	Transaction Quantity
			analysis_code	sql_variant	Analysis Code
			subanalysis_code		Subanalysis Code
			cost_center		Cost Center
	si_supp_bal_rpt_summ_tmp		guid		Guid
			start_date	datetime	Start Date
			end_date		End Date
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			ou_id	int	Organization Unit Id
			fb_id	sql_variant	Finance Book Id
			supplier_code		Supplier Code
			supp_name		Supplier Name
			account_code		Account Code
			account_type		Account Type
			acct_currency		Account Currency
			pr_cr_tran_amount	bigint	Period Credit Transaction Amount
			pr_dr_tran_amount		Period Debit Transaction Amount
			pr_cr_base_amount		Period Credit Base Amount
			pr_dr_base_amount		Period Debit Base Amount
			pr_cr_pab_amount		Period Credit Parallel Base Amount
			pr_dr_pab_amount		Period Debit Parallel Base Amount
			op_balance_tran		Opening Balance Transaction Amount
			op_balance_base		Opening Balance Base Amount
			op_balance_pab
			tran_drcr_flag	sql_variant	Transaction Debit Credit Flag
			base_drcr_flag		Base Debit Credit Flag
			pab_drcr_flag		Parallel Base Credit /
			company_name		Company Name
			account_desc		Account Description
			op_balance	bigint	Opening Balance
			pr_cr_balance
			pr_dr_balance
			tran_type	sql_variant	Transaction Type
			contact_person		Contact Person
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip		Zip
	si_supplier_balance_rpt_tmp		guid		Guid
			ou_id	int	Organization Unit Id
			company_code	sql_variant	Company Code
			bu_id		Business Unit Id
			fb_id		Finance Book Id
			as_on_date	datetime	As On Date
			supplier_code	sql_variant	Supplier Code
			account_code		Account Code
			currency_code		Currency Code
			account_type		Account Flag
			tran_drcr_flag		Transaction Debit Credit Flag
			base_drcr_flag		Base Debit Credit Flag
			pab_drcr_flag		Parallel Base Credit / Debit Flag
			tran_balance	bigint	Transaction Balance
			base_balance		Base Balance
			pab_balance		Parallel Base Balance Amount