CTRN

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	ctrn_acct_info	Stores accounting information	ou_id	int	Organization Unit Id	Yes	No
			tran_type	nvarchar(40)	Transaction Type
			tran_no	nvarchar(18)	Transaction Number
			transfer_doc_no		Transfer Document Number
			acc_code	nvarchar(32)	Account Code
			drcr_flag	nvarchar(6)	Debit Credit Flag
			acc_type	nvarchar(40)	Account Type
			timestamp	int	Time Stamp	No
			fb_id	nvarchar(20)	Finacne Book Id
			fin_post_date	datetime	Finance Posted  Date
			currency	nvarchar(5)	Currency
			customer_code	nvarchar(18)	Customer Code
			cost_center	nvarchar(10)	Cost Center
			tran_amt	bigint	Transaction Amount
			analysis_code	nvarchar(5)	Analysis Code
			sub_analysis_code		Subanalysis Code
			base_cur_exrate	bigint	Base Currency Exchange Rate
			base_amt		Base Amount
			par_base_cur_exrate		Parallel Base Currency Exchange Rate
			par_base_amt		Parallel Base Amount
			status	nvarchar(25)	Status.Values P-Posted
			batch_id	nvarchar(40)	Batch Id
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_attach_notes	Stores Information about the Notes that get attached in the system	voucher_no	nvarchar(18)	Voucher Number
			ref_doc_no		Reference Document Number
			ref_doc_ou	int	Reference Document Organization Unit
			std_notes_id	nvarchar(18)	Standard Notes Id
			std_notes_desc	nvarchar(100)	Standard Notes Description
			paybatch_no	nvarchar(18)	Pay Batch Number
			notes	nvarchar(2000)	Notes
			notes_level	nvarchar(10)	Notes Level
			notes_for	nvarchar(30)	Notes For
			vouch_ouid	int	Voucher Organization Unit Id
	ctrn_ci_transfer_tmp		ou_id		Organization Unit Id
			transfer_doc_no	nvarchar(18)	Transfer Document Number
			timestamp	int	Time Stamp
			tran_date	datetime	Transaction Date
			tran_bal_in	nvarchar(15)	Transaction Balance Information
			transferor	nvarchar(18)	Transferor
			transferor_fb	nvarchar(20)	Transferor Finance Book
			transferee_fb		Transferee Finance Book
			transferor_currency	nvarchar(5)	Transferor Currency
			transferee_currency		Transferee Currency
			auto_adjust	nvarchar(10)	Automatic Adjust
			transferee	nvarchar(18)	Transferee
			transferor_docno		Transferor Document Number
			transferor_doctype	nvarchar(40)	Transferor Document Type
			transferee_docno	nvarchar(18)	Transferee Document Number
			transferee_doctype	nvarchar(40)	Transferee Document Type
			status	nvarchar(25)	Status
			trasfer_type		Transfer Type
			trasferee_acc_code	nvarchar(32)	Transferee Account Code
			trasfer_acc_code		Transfer Account Code
			accbalance	bigint	Account Balance
			batch_id	nvarchar(40)	Batch Id
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_comptot_tmp		timestamp	int	Time Stamp
			guid	nvarchar(40)	Guid
			total_amt	bigint	Total Amount
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_credit_note_dtl	Stores Information about the Credit notes	ou_id	int	Organization Unit Id	Yes
			tcn_no	nvarchar(18)	Transaction Number
			timestamp	int	Time Stamp	No
			transfer_doc_no	nvarchar(18)	Transfer Document Number
			tran_date	datetime	Transaction Date
			customer_code	nvarchar(18)	Customer Code
			currency_code	nvarchar(5)	Currency Code
			account_code	nvarchar(32)	Account Code
			bu_id	nvarchar(20)	Business Unit Id
			tran_amount	bigint	Transaction Amount
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			subanalysis_code		Subanalysis Code
			exchange_rate	bigint	Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			transferee_amt		Transferee Amount
			reason_code	nvarchar(10)	Reason Code
			comments	nvarchar(256)	Comments
			ref_doc_no	nvarchar(18)	Reference Document Number
			status	nvarchar(25)	Status.Values P-Posted
			batch_id	nvarchar(40)	Batch Id
			tran_type		Transaction Type
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_debit_note_dtl	Stores Information about the Debit notes	ou_id	int	Organization Unit Id	Yes
			tdn_no	nvarchar(18)	Number
			timestamp	int	Time Stamp	No
			transfer_doc_no	nvarchar(18)	Transfer Document Number
			tran_date	datetime	Transaction Date
			customer_code	nvarchar(18)	Customer Code
			currency_code	nvarchar(5)	Currency Code
			account_code	nvarchar(32)	Account Code
			bu_id	nvarchar(20)	Business Unit Id
			tran_amount	bigint	Transaction Amount
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			par_exchange_rate	bigint	Parallel Exchange Rate
			subanalysis_code	nvarchar(5)	Subanalysis Code
			exchange_rate	bigint	Exchange Rate
			transferee_amt		Transferee Amount
			reason_code	nvarchar(10)	Reason Code
			comments	nvarchar(256)	Comments
			ref_doc_no	nvarchar(18)	Reference Document Number
			status	nvarchar(25)	Status.Values P-Posted
			batch_id	nvarchar(40)	Batch Id
			tran_type		Transaction Type
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_doc_dtl	Stores Information about all the documents	doc_no	nvarchar(18)	Document Number	Yes
			guid	nvarchar(40)	Guid
			ou_id	int	Organization Unit Id
			tcn_no	nvarchar(18)	Number
			timestamp	int	Time Stamp	No
			doc_type	nvarchar(40)	Document Type
			doc_date	datetime	Document Date
			cust_area	int	Customer Area
			doc_amt	bigint	Document Amount
			doc_status	nvarchar(25)	Document Status.Values F -Fresh,D -Draft,A -Authorised
			transfer_status		Transfer Status.Values F -Fresh,D -Draft,A -Authorised
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_doc_dtl_tmp		timestamp	int	Time Stamp
			ou_id		Organization Unit Id
			tcn_no	nvarchar(18)	Number
			doc_no		Document Number
			guid	nvarchar(40)	Guid
			doc_type		Document Type
			doc_date	datetime	Document Status
			cust_area	int	Customer Area
			doc_amt	bigint	Document Amount
			doc_status	nvarchar(25)	Document Status
			transfer_status		Transfer Status
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_pay_dtl	Stores Information about all the payments	ou_id	int	Organization Unit Id	Yes
			tdn_no	nvarchar(18)	Number
			term_no	nvarchar(15)	Term Number
			pay_term		Pay Term
			flag	nvarchar(25)	Flag
			timestamp	int	Time Stamp	No
			due_date	datetime	Due Date
			due_amt_type	nvarchar(15)	Due Amount
			due_per	bigint	Due Percentage
			due_amt		Due Amount
			dis_type	nvarchar(30)	Discount Type
			dis_comp_amt	bigint	Discount Computed Amount
			dis_date	datetime	Discount Date
			dis_per	bigint	Discount Per
			dis_amt		Discount Amount
			penalty_per		Penalty Percentage
			esr_ref_no	nvarchar(27)	ESR Reference Number
			esr_line	nvarchar(128)	ESR Line
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_pay_dtl_tmp		ou_id	int	Organization Unit Id	Yes
			tdn_no	nvarchar(18)	Number
			term_no	nvarchar(15)	Term Number
			guid	nvarchar(40)	Guid
			pay_term	nvarchar(15)	Pay Term
			flag	nvarchar(25)	Flag
			timestamp	int	Time Stamp	No
			due_date	datetime	Due Date
			due_amt_type	nvarchar(15)	Due Amount Type
			due_per	bigint	Due Percentage
			due_amt		Due Amount
			dis_type	nvarchar(30)	Discount Type
			dis_comp_amt	bigint	Discount Computed Amount
			dis_date	datetime	Discount Date
			dis_per	bigint	Discount Per
			dis_amt		Discount Amount
			penalty_per		Penalty Percentage
			esr_ref_no	nvarchar(18)	ESR Reference Number
			esr_line	nvarchar(40)	ESR Line
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_pay_hdr	Stores Information about all the payments	ou_id	int	Organization Unit Id	Yes
			tdn_no	nvarchar(18)	Number
			flag	nvarchar(25)	Flag
			pay_term	nvarchar(15)	Pay Term
			timestamp	int	Time Stamp	No
			disc_type	nvarchar(30)	Discount Type
			rpt_method	nvarchar(25)	Report Method
			esr_bank_code	nvarchar(32)	ESR Bank Code
			esr_id		ESR Id
			lsv_bank_code		LSV Bank Code
			lsv_id		LSV Id
			lsv_ref	nvarchar(18)	LSV Reference
			cust_bank_acc	nvarchar(32)	Custome Bank Account
			cust_bank_id		Custome Bank Id
			acc_in	nvarchar(15)	Account Information
			ptt_ref	nvarchar(18)	PTT Reference
			ptt_acc_no	nvarchar(32)	PTT Account Number
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_tranno_tmp		guid	nvarchar(40)	Guid	Yes
			tran_no	nvarchar(18)	Transaction Number
			timestamp	int	Time Stamp	No
			tran_type	nvarchar(40)	Transaction Type
			createdby	nvarchar(15)	Created By
			newguid	nvarchar(40)	New Guid
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	ctrn_transfer_bal_hdr	Stores Information about all the balances	ou_id	int	Organization Unit Id	Yes
			transfer_doc_no	nvarchar(18)	Transfer Document Number
			timestamp	int	Time Stamp	No
			tran_date	datetime	Transaction Date
			tran_bal_in	nvarchar(15)	Transaction Balance Information
			transferor	nvarchar(18)	Transferor
			auto_adjust	nvarchar(10)	Automatic  Adjustment
			transferee	nvarchar(18)	Transferee
			transferor_docno		Transferor Document Number
			transferor_doctype	nvarchar(40)	Transferor Document Type
			transferee_docno	nvarchar(18)	Transferee Document Number
			transferee_doctype	nvarchar(40)	Transferee Document Type
			status	nvarchar(25)	Status.Values F -Fresh,D -Draft,A -Authorised
			batch_id	nvarchar(40)	Batch Id
			trasferee_acc_code	nvarchar(32)	Transferee Account Code
			trasfer_acc_code		Transfer Account Code
			accbalance	bigint	Account Balance
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date