Customer Receipt

Table Owner	Table Name	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	rpt_acct_info_dtl	ou_id	int	Organization Unit Id	Yes	No
		tran_no	sql_variant	Transaction Number
		fb_id		Finance Book Id
		account_code		Account Code
		tran_type		Transaction Type
		drcr_flag		Debit Credit Flag
		posting_line_no	int	Posting Line Number
		fin_post_date	datetime	Finance Posting Date	No
		currency	sql_variant	Currency
		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 Posting Status
		batch_id		Bath Id
		account_type		Account Type
		flag		Flag
		company_id		Company Id
		component_id		Component Id
		bu_id		Business Unit Id
		tran_date	datetime	Transaction Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	rpt_elec_receipt_info	ou_id	sql_variant	Organization Unit Id	Yes
		receipt_no		Receipt Number
		esr_part_id		ESR Part Id	No
		esr_ref_no		ESR Reference Number
		lsv_contract_id		LSV Contract Id
		lsv_contract_ref		LSV Contract Reference
		cust_bank_acct		Customer Bank Account
		cust_bank_id		Customer Bank Id
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	rpt_notes_dtl	ou_id	sql_variant	Organization Unit Id	Yes
		receipt_no		Receipt Number
		notes_for		Notes For
		timestamp	int	Time Stamp	No
		note_level	sql_variant	Note Level
		std_notesid		Standard Notes Id
		std_notesid_desc		Standard Notes Id Description
		notes		Notes
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	rpt_notes_tmp	guid	sql_variant	Guid	Yes
		timestamp	int	Time Stamp	No
		notes	sql_variant	Notes
		stdnotesid		Standard Notes Id
		stdnotesiddesc		Standard Notes Id Description
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
	rpt_receipt_dtl	ou_id	sql_variant	Organization Unit Id	Yes
		receipt_no		Receipt Number
		dr_doc_no		Debit Document Number
		dr_doc_ou		Debit Document Organization Unit
		term_no		Term Number
		dr_tran_type		Debit Transaction Type
		dr_doc_type		Debit Document Type	No
		au_due_date	datetime	Authorized Due Date
		au_dr_doc_cur	sql_variant	Authorized Debit Document Currency
		au_dr_doc_date	datetime	Authorized Debit Document Date
		au_dr_doc_amount	bigint	Authorized Debit Document Amount
		au_exchange_rate		Authorized Exchange Rate
		au_outstanding_amt		Authorized Outstanding
		recd_amount		Received Amount
		batch_id	sql_variant	Batch Id
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
		ftk_invoice_no	sql_variant	Invoice Number
	rpt_receipt_hdr	ou_id		Organization Unit Id	Yes
		receipt_no		Receipt Number
		timestamp	int	Time Stamp	No
		receipt_date	datetime	Receipt Date
		receipt_category	sql_variant	Receipt Category
		receipt_status		Receipt Status
		fb_id		Finance Book Id
		notype_no		Numbering Type
		cust_area		Customer Area
		cust_code		Customer Code
		receipt_route		Receipt Route
		receipt_mode		Receipt Mode
		adjustment_type		Adjustment Type
		currency		Currency
		exchange_rate	bigint	Exchange Rate
		receipt_amount		Receipt Amount
		bank_cash_code	sql_variant	Bank Cash Code
		collector		Collector
		remitter		Remitter
		comments		Comments
		instr_no		Instrument Number
		micr_no		Micro Number
		instr_amount	bigint	Instrument Amount
		instr_date	datetime	Instrument Date
		remitting_bank	sql_variant	Remitting Bank
		charges	bigint	Charges
		cost_center	sql_variant	Cost Center
		analysis_code		Analysis Code
		subanalysis_code		Subanalysis Code
		card_no		Card Number
		card_auth_no		Card Authorized Number
		issuer		Issuer
		card_val_month		Card Valid Month
		card_val_year		Card Valid Year
		unapplied_amount	bigint	Unapplied Amount
		reason_code	sql_variant	Reason Code
		reversal_date	datetime	Reversal Date
		remarks	sql_variant	Remarks
		createdby		Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date
		flag	sql_variant	Flag
		par_base_amount	bigint	Parallel Base Amount
		par_exchange_rate		Parallel Exchange Rate
		tran_type	sql_variant	Transaction Type
		ref_doc_no		Reference Document Number
		batch_id		Batch Id
		forward_cover		Forward Cover
		Fw_cov_flag		Forward Cover Flag
		Fw_cov_rate	bigint	Forward Cover Rate
	rpt_receipt_tottmp	ou_id	sql_variant	Organization Unit Id
		documentno		Document Number
		termno		Term Number
		docamount	bigint	Document Amount
		outstandingamt		Outstanding Amount
		curcode	sql_variant	Currency Code
		doctype		Document Type
		docdate	datetime	Document Date
		duedate		Due Date
		exchange_rate	bigint	Exchange Rate
		recdamt		Received Amount
		flag	sql_variant	Flag
		guid		Guid
	rpt_tranno_tmp				Yes
		tran_no		Transaction Number
		timestamp	int	Time Stamp	No
		lastmoddate	datetime	Last Modified Date
		createdby	sql_variant	Created By
		createddate	datetime	Created Date
		modifiedby	sql_variant	Modified By
		modifieddate	datetime	Modified Date