Sundry Receipt

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	sur_accinfo_tmp		ou_id	int	Organization Unit Id	No	No
			guid	nvarchar(40)	Guid
			timestamp	int	Time Stamp
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			receipt_date	datetime	Receipt Date
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
			totvatexclamtintran	bigint	Total Value Added Tax Excluding Amount In Transaction Currency
			totvatexclamtinbase		Total Value Added Tax Excluding Amount In Base Currency
			totvatamtintran		Total Value Added Tax Amount In Transaction
			totvatamtinbase		Total Value Added Tax Amount In Base Currency
			totvatinclamtintran		Total Value Added Tax Inclusive Amount In Transaction Currency
			totvatinclamtinbase		Total Value Added Tax Inclusive Amount In Base Currency
			totcorrvatamtinbase		Total Corrected Value Added Tax Amount in Base Currency
			totcorrvatamtintran		Total Corrected Value Added Tax Amount in Transaction Currency
			totcompvatamtinbase		Total Computed Value Added Tax Amount In Base Currency
			totcompvatamtintran		Total Computed Value Added Tax Amount In Transaction Currency
	sur_account_tmp		ou_id	int	Organization Unit Id	Yes
			guid	nvarchar(40)	Guid
			account_line	int	Account Line
			timestamp		Time Stamp	No
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			exchange_rate	bigint	Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			base_currency	nvarchar(5)	Base Currency
			par_base_currency		Parallel Base Currency
			usage	nvarchar(20)	Usage
			account_code	nvarchar(32)	Account Code
			currency_code	nvarchar(5)	Currency Code
			account_amount	bigint	Account Amount
			drcr_flag	nvarchar(4)	Debit Credit Flag
			base_amount	bigint	Base Amount
			par_base_amount		Parallel Base Amount
			remarks	nvarchar(255)	Remarks
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			subanalysis_code		Subanalysis Code
			acct_type	nvarchar(40)	Account Type
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_fbpostings_dtl	Table that maintains the posting level info and Amounts for each Transaction numbers	ou_id	int	Organization Unit Id	Yes
			tran_type	nvarchar(10)	Transaction Type
			fb_id	nvarchar(20)	Finance Book Id
			tran_no	nvarchar(18)	Transaction Number
			account_code	nvarchar(32)	Account Code
			drcr_flag	nvarchar(4)	Debit Credit Flag
			acct_lineno	int	Account Line Number
			timestamp		Time Stamp	No
			acct_type	nvarchar(15)	Account Type
			currency_code	nvarchar(5)	Currency Code
			declnyr_code	nvarchar(10)	Declaration Year Code
			declnprd_code	nvarchar(15)	Declaration Period Code
			tran_date	datetime	Transaction Date
			tran_qty	bigint	Transaction Quantity
			tran_amount		Transaction Amount
			base_amount		Base Amount
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			subanalysis_code		Subanalysis Code
			bank_code	nvarchar(20)	Bank Code
			ref_doc_no	nvarchar(18)	Reference Document Number
			vendor_code	nvarchar(45)	Vendor Code
			origin_ou	int	Originating Organization Unit
			item_code	nvarchar(40)	Item Code
			vrnt_code	nvarchar(8)	Variant Code
			uom	nvarchar(10)	Unit Of Measurement
			exchange_rate	bigint	Exchange Rate
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			ref_tran_type	nvarchar(40)	Reference Transaction Type
			ref_fbid	nvarchar(20)	Reference Finance Book Id
			auth_date	datetime	Authorized Date
			post_date		Posted Date
			bu_id	nvarchar(20)	Business Date
			company_code	nvarchar(10)	Company Code
			component_name	nvarchar(16)	Component Name
			vat_category	nvarchar(40)	Value Added Tax Category
			vat_class		Value Added Tax Class
			vat_code		Value Added Tax Code
			vat_rate	bigint	Value Added Tax Rate
			vat_inclusive	nvarchar(4)	Value Added Tax Inclusive
			flag		Flag
			batch_id	nvarchar(40)	Batch Id
			receipt_type	nvarchar(4)	Receipt Type
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
			vat_line_no	int	Value Added Tax Line Number
			doc_line_no		Document Line Number
	sur_is_notes_tmp		guid	nvarchar(40)	Guid	Yes
			timestamp	int	Time Stamp	No
			st_notes_id	nvarchar(6)	Standard Notes Id
			st_notes_desc	nvarchar(2000)	Standard Notes Description
			notes	nvarchar(255)	Notes
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_notes_dtl	Table that contains the notes and comments details for the Document number	ou_id	int	Organization Unit Id	Yes
			receipt_no	nvarchar(18)	Receipt Number
			receipt_category	nvarchar(4)	Receipt Category
			tran_type	nvarchar(40)	Transaction Type
			notes_for	nvarchar(255)	Notes For
			notes_level		Notes Level
			line_no	int	Line Number
			receipt_type	nvarchar(4)	Receipt Type
			timestamp	int	Time Stamp	No
			notes	nvarchar(2000)	Notes
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_receipt_dtl	Table contains the usage id and account codes for sundry receipts	ou_id	int	Organization Unit Id	Yes
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			refdoc_lineno	int	Reference Document Number
			tran_type	nvarchar(40)	Transaction Type
			timestamp	int	Time Stamp	No
			usage	nvarchar(20)	Usage
			account_code	nvarchar(32)	Account Code
			currency_code	nvarchar(5)	Currency Code
			account_amount	bigint	Account Amount
			drcr_flag	nvarchar(4)	Debit Credit Flag
			base_amount	bigint	Base Amount
			remarks	nvarchar(255)	Remarks
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id	nvarchar(40)	Batch Id
			acct_type	nvarchar(15)	Account Type
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_receipt_hdr	Table contains the document number and status and bankcodes for each sundry receipts	ou_id	int	Organization Unit Id	Yes
			receipt_no	nvarchar(18)	Receipt Number
			receipt_type	nvarchar(4)	Receipt Type
			tran_type	nvarchar(40)	Transaction Type
			timestamp	int	Time Stamp	No
			receipt_date	datetime	Receipt Date
			receipt_category	nvarchar(4)	Receipt Category
			fb_id	nvarchar(20)	Finance Book Id
			notype_no	nvarchar(10)	Numbering Type
			remitter_name	nvarchar(60)	Remitter Name
			receipt_method	nvarchar(30)	Receipt Method
			receipt_mode	nvarchar(4)	Receipt Mode
			receipt_route		Receipt Route
			bank_cash_code	nvarchar(32)	Bank Cash Code
			currency_code	nvarchar(5)	Currency Code
			exchange_rate	bigint	Exchange Rate
			receipt_amount		Receipt Amount
			origin_no	nvarchar(18)	Origin Number
			reason_code	nvarchar(10)	Reason Code
			remarks	nvarchar(255)	Remarks
			instr_no	nvarchar(30)	Instrument Number
			micr_no		Micro Number
			instr_amount	bigint	Instrument Amount
			instr_date	datetime	Instrument Date
			instr_status	nvarchar(4)	Instrument Status. Values HO -Realized, BU -Bounced, RT -Returned
			bank_code	nvarchar(32)	Bank Code
			card_no	nvarchar(30)	Card Number
			card_auth_no	nvarchar(18)	Card Authorized Number
			issuer	nvarchar(40)	Issuer
			valid_till_month	nvarchar(10)	Valid Till Month
			valid_till_year	int	Valid Till Year
			address1	nvarchar(40)	Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip_code	nvarchar(20)	Zip Code
			contact	nvarchar(40)	Contact
			url	nvarchar(50)	Universal Resource Locator
			mail_stop	nvarchar(20)	Mail Stop
			pager_no		Pager Number
			telex		Telex
			email_id	nvarchar(60)	Email Id
			phone_no	nvarchar(20)	Phone Number
			mobile_no		Mobile Number
			fax_no		Fax Number
			receipt_status	nvarchar(2)	Receipt Status. Values DR Draft, FR -Fresh,AU -Authorized, RT -Returned, RV -Reversed, TR -To Be Reversed, DT -Deleted
			rr_flag	nvarchar(4)	Receipt Route Flag
			batch_id	nvarchar(40)	Batch Id
			refdoc_no	nvarchar(18)	Reference Document Number
			refdoc_type	nvarchar(40)	Reference Document Type
			parbaseexrate	bigint	Parallel Base Exchange Rate
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_revreceipt_tmp		ou_id	int	Organization Unit Id	Yes
			receipt_no	nvarchar(18)	Receipt Number
			receipt_type	nvarchar(4)	Receipt Type
			tran_type	nvarchar(40)	Transaction Type
			timestamp	int	Time Stamp	No
			receipt_date	datetime	Receipt Date
			receipt_category	nvarchar(4)	Receipt Category
			fb_id	nvarchar(20)	Finance Book Id
			notype_no	nvarchar(10)	Numbering Type
			remitter_name	nvarchar(60)	Remitter Name
			receipt_method	nvarchar(30)	Receipt Method
			receipt_mode	nvarchar(4)	Receipt Mode
			receipt_route		Receipt Route
			bank_cash_code	nvarchar(32)	Bank Cash Code
			currency_code	nvarchar(5)	Currency Code
			exchange_rate	bigint	Exchange Rate
			receipt_amount		Receipt Amount
			origin_no	nvarchar(18)	Origin Number
			reason_code	nvarchar(10)	Reason Code
			remarks	nvarchar(255)	Remarks
			instr_no	nvarchar(30)	Instrument Number
			micr_no		Micro Number
			instr_amount	bigint	Instrument Amount
			instr_date	datetime	Instrument Date
			instr_status	nvarchar(4)	Instrument Status
			bank_code	nvarchar(32)	Bank Code
			card_no	nvarchar(30)	Card Number
			card_auth_no	nvarchar(18)	Card Authorized Number
			issuer	nvarchar(40)	Issuer
			valid_till_month	nvarchar(10)	Valid Till Month
			valid_till_year	int	Valid Till Year
			address1	nvarchar(40)	Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip_code	nvarchar(20)	Zip Code
			contact	nvarchar(40)	Contact
			url	nvarchar(50)	Universal Resource Locator
			mail_stop	nvarchar(20)	Mail Stop
			pager_no		Pager Number
			telex		Telex
			email_id	nvarchar(60)	Email Id
			phone_no	nvarchar(20)	Phone Number
			mobile_no		Mobile Number
			fax_no		Fax Number
			receipt_status	nvarchar(2)	Receipt Status
			rr_flag	nvarchar(4)	Receipt Rout Flag
			batch_id	nvarchar(40)	Batch Id
			refdoc_no	nvarchar(18)	Reference Document Number
			refdoc_type	nvarchar(40)	Reference Document Type
			revreceipt_no	nvarchar(18)	Reversal Receipt Number
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_vataccount_dtl		ou_id	int	Organization Unit Id	Yes
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			tran_type	nvarchar(40)	Transaction Type
			refdoc_lineno	int	Reference Document Line Number
			vat_lineno		Value Added Tax Line Number
			vataccount_lineno		Value Added Tax Account Line Number
			timestamp		Time Stamp	No
			account_type	nvarchar(40)	Account Type
			account_code	nvarchar(32)	Account Code
			drcr_flag	nvarchar(4)	Debit Credit Flag
			tranvat_amount	bigint	Transaction Value Added Tax
			corrtranvat_amount		Corrected Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			corrbasevat_amount		Corrected Base Value Added Tax Amount
			cost_center	nvarchar(10)	Cost Center
			analysis_code	nvarchar(5)	Analysis Code
			subanalysis_code		Subanalysis Code
			batch_id	nvarchar(40)	Batch Id
			receipt_currency	nvarchar(5)	Receipt Currency
			account_currency		Amount Currency
			vataccount_currency		Value Added Tax Account Currency
			vatexchange_rate	bigint	Value Added Tax Exchange Rate
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_vatitem_dtl	Table contains the VAT details for each document number	ou_id	int	Organization Unit Id	Yes
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			refdoc_lineno	int	Reference Document Line Number
			vat_lineno		Value Added Tax Line Number
			tran_type	nvarchar(40)	Transaction Type
			timestamp	int	Time Stamp	No
			itemtcd_code	nvarchar(40)	Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			vat_code	nvarchar(10)	Value Added Tax Code
			vat_rate	bigint	Value Added Tax Rate
			vat_inclusive	nvarchar(4)	Value Added Tax Inclusive
			item_amount	bigint	Item Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			batch_id	nvarchar(40)	Batch Id
			receipt_currency	nvarchar(5)	Receipt Currency
			account_currency		Account Currency
			vatexchange_rate	bigint	Value Added Tax Exchange Rate
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date
	sur_vatreceipt_tmp		ou_id	int	Organization Unit Id	Yes
			guid	nvarchar(40)	Guid
			vat_lineno	int	Value Added Tax Line Number
			timestamp		Time Stamp	No
			receipt_type	nvarchar(4)	Receipt Type
			receipt_no	nvarchar(18)	Receipt Number
			account_code	nvarchar(32)	Account Code
			itemtcd_code	nvarchar(40)	Item Tax Charge Discount Code
			itemtcd_vrnt		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_vrnt	nvarchar(10)	Tax Charge Discount Variant
			vat_rate	bigint	Value Added Tax Rate
			vat_inclusive	nvarchar(4)	Value Added Tax Inclusive
			item_amount	bigint	Item Amount
			tranvat_amount		Transaction Value Added Tax Amount
			basevat_amount		Base Value Added Tax Amount
			corrbasevat_amount		Corrected Base Value Added Tax Amount
			corrtranvat_amount		Corrected Transaction Value Added Tax Amount
			createdby	nvarchar(15)	Created By
			createddate	datetime	Created Date
			modifiedby	nvarchar(15)	Modified By
			modifieddate	datetime	Modified Date