Table Name/Column Name

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	sppi_ap_postings_dtl		tran_type	sql_variant	Transction Type	Yes	No
			tran_ou	int	Transction Organization Unit
			tran_no	sql_variant	Transction Number
			posting_line_no	int	Posting Line Number
			timestamp		Time Stamp	No
			line_no		Line Number
			company_code	sql_variant	Company Code
			posting_status		Posting Status
			posting_date	datetime	Posting Date
			fb_id	sql_variant	Finance Book Id
			tran_date	datetime	Transaction Date
			account_type	sql_variant	Account Type
			account_code		Account Code
			drcr_id		Debit Credit Id
			tran_currency		Transaction Currency
			tran_amount	bigint	Transaction Amount
			exchange_rate		Exchange Rate
			base_amount		Base Amount
			par_exchange_rate		Parallel Exchange Rate
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			guid		Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			org_vat_base_amt	bigint	Orginal Value Added Tax Base Amount
			entry_date	datetime	Entry Date
			auth_date		Authorized Date
			item_code	sql_variant	Item Code
			item_variant		Item Variant
			quantity	bigint	Quantity
			reftran_fbid	sql_variant	Refence Transaction Finance Book Id
			reftran_no		Refence Transaction Number
			reftran_ou	int	Refence Transaction Organization Unit
			supp_code	sql_variant	Supplier Code
			ref_tran_type		Refence Transaction Type
			uom		Unit Of Measurement
			mac_post_flag		Management Accounting Posting Flag
			vat_line_no	int	Value Added Tax
			source_comp	sql_variant	Source Component
	sppi_apportioned_tcd_dtl		tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			line_no	int	Line Number
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			tcd_version	int	Tax Charge Discount Version
			timestamp		Time Stamp
			item_type	sql_variant	Item Type
			tcd_rate	bigint	Tax Charge Discount Rate
			taxable_amt		Taxable Amount
			tcd_amount		Tax Charge Discount Amount
			tcd_currency	sql_variant	Tax Charge Discount Currency
			base_amount	bigint	Base Amount
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	sppi_cim_intxn_ou_tmp		guid	sql_variant	Guid
			subouinstid	int	Subscribed Organization Unit Instance Id
			subouinstname	varchar(1)	Subscribed Organization Unit Instance Name
			subcompname		Subscribed Component Name
			pubouinstid	int	Published Organization Unit Instance Id
			pubouinstname	varchar(1)	Published Organization Unit Instance Name
			pubcompname		Published Component Name
	sppi_emod_intxn_curr_tmp		guid	sql_variant	Guid
			companycode		Company Code
			currencycode		Currency Code
	sppi_emod_intxn_fb_tmp		guid		Guid
			company_code		Company Code
			finance_bookid		Finance Book Id
			fb_type		Finance Book Type
			fb_desc		Finance Book description
			fb_status		Finance Book Status
	sppi_inv_dtl_tcal_tmp		tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			timestamp	int	Time Stamp
			tran_status	sql_variant	Transaction Status
			invoce_cat		Invoice Category
			num_type		Numbering Type
			invoice_gen_type		Invoice Generic Type
			tran_date	datetime	Transaction Type
			anchor_date		Anchor Date
			fb_id	sql_variant	Finance Book Id
			auto_adjust		Auto Adjust
			tran_currency		Transaction Currency
			exchange_rate	bigint	Exchange Rate
			pay_term	sql_variant	Pay Term
			payterm_version	int	Pay Term Version
			receipt_method	sql_variant	Receipt Method
			comments		Comments
			tran_amount	bigint	Transaction Amount
			par_exchange_rate		Parallel Exchange Rate
			item_amount		Item Amount
			tax_amount		Tax Amount
			disc_amount		Discount Amount
			gross_frt_amount		Gross Freight Amount
			net_frt_amount		Net Freight Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			rev_doc_no	sql_variant	Reverse Document Number
			rev_doc_ou	int	Reverse Document Organization Unit
			rev_date	datetime	Reverse Date
			ref_doc_no	sql_variant	Reverse Document Number
			ref_doc_ou	int	Reverse Document Organization Unit
			rev_reason_code	sql_variant	Reverse Reason Code
			rev_remarks		Reverse Remarks
			hld_date	datetime	Hold Date
			hld_reason_code	sql_variant	Hold Reason Code
			hld_remarks		Hold Remarks
			auth_date	datetime	Authorized Date
			posting_date		Posing Date
			posting_status	sql_variant	Posing Status
			disc_comp_basis		Discount  Component Basis
			discount_proportional		Discount Proportional
			comp_bp_code		Component Bank/PTT Parallel Code
			bank_code		Bank Code
			lsv_id		LSV Id
			comp_acct_in		Component Accounting Information
			comp_bp_ref		Component Bank/PTT Reference
			comp_bp_acc_no		Component Bank/PTT Account Number
			esr_id		ESR Id
			vat_applicable		Value Added Tax Applicable
			vat_exchange_rate	bigint	Value Added Tax Exchange Rate
			vat_charge		Value Added Tax Charge
			non_vat_charge		Charge Other than Vat
			doc_level_disc		Document Level Discount
			vat_incl	sql_variant	Value Added Tax Include
			retain_init_distbn		Retain Initialize Distribution
			average_vat_rate	bigint	Average Value Added Tax Rate
			vat_excl_amount		Value Added Tax Exclude Amount
			vat_amount		Value Added Tax Amount
			vat_incl_amount		Value Added Tax Include Amount
			frt_cost_center	sql_variant	Freight Cost Center
			frt_analysis_code		Freight Ananlysis Code
			frt_subanalysis_code		Freight Subananlysis Code
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			batch_id	sql_variant	Batch Id
			pre_round_off_amount	bigint	Pre Round Off Amount
			cap_non_ded_charge	sql_variant	Other than Capital Deducted Charges
			rounded_off_amount	bigint	Rounded Off Amount
			doc_status	sql_variant	Document Status
			guid		Guid
			item_type		Item Type
			item_tcd_code		Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			item_qty	bigint	Item Quantity
			line_no	int	Line Number
			line_amount	bigint	Line Amount
			usage	sql_variant	Usage
			supp_code		Supplier Code
			pay_to_supp_name		Pay To Supplier Name
			account_code		Account Code
			pay_to_supp		Pay To Supplier
			tcd_comput		Tax Charge Discount Compute
			tcd_line_no	int	Tax Charge Discount Line Number
	sppi_invoice_dtl_tmp		guid	sql_variant	Guid
			invoice_category		Invoice Category
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			line_no	int	Line Number
			po_no	sql_variant	Purchase Order Number
			ordering_ou	int	Ordering Organization Unit
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_date	datetime	Reference Document Date
			ref_doc_ou	int	Reference Document Organization Unit
			supp_code	sql_variant	Supplier Code
			pay_term		Pay Term
			po_line_no	int	Purchar Order Line Number
			ref_doc_line_no		Reference Document Line Number
			tcd_type	sql_variant	Tax Charge Discount Type
			tcd_rate	bigint	Tax Charge Discount Rate
			tcd_amount		Tax Charge Discount Amount
			taxable_amount		Taxable Amount
			item_tcd_code	sql_variant	Item Tax Charge Discount
			item_tcd_variant		Item Tax Charge Variant
			uom		Unit Of Measurement
			quantity	bigint	Quantity
			unit_price		Unit Price
			rate_per		Rate Percentage
			amount		Amount
			remarks	sql_variant	Remarks
			cost_center		Cost Center
			analysis_code		Analysis Code
			sub_analysis_code		Subanalysis Code
			item_type		Item Type
			tcd_level		Tax Charge Discount Level
			tcd_on_line_no	int	Tax Charge Discount On Line Number
			pay_to_supplier	sql_variant	Pay To Supplier
			po_currency		Purchase Order Currency
			po_exch_rate	bigint	Purchase Order Exchange Rate
			po_pay_mode	sql_variant	Purchase Order Pay Mode
			po_desc		Purchase Order Description
			base_amount	bigint	Base Amount
			parallel_exchange_rate		Parallel Exchange Rate
			parallel_base_amount		Parallel Base Amount
			item_revenue_acc	sql_variant	Item Revenue Account
			tcd_acc		Tax Charge Discount Account
			mode_flag		Mode Flag
			item_description		Item Description
			serial_no	int	Serial Number
			payment_method	sql_variant	Payment Method
			net_line_amount	bigint	Net Line Amount
			discount_amount		Discount Amount
			item_tax_amount		Item Tax Amount
			tcdcomputation	sql_variant	Value Added Tax Computation
			supp_name		Supplier Name
			visible_line_no	int	Visible Line Number
			asset_proposal_no	sql_variant	Asset Proposal Number
			pors_flag		Purchase Order Release Slip Flag
			ordering_ou_name		Ordering Organization Unit Name
			order_percent	bigint	Order Percent
			base_value		Base Value
	sppi_invoice_hdr		tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			timestamp	int	Time Stamp	No
			tran_status	sql_variant	Transaction Status
			invoce_cat		Invoice Category
			num_type		Numbering Type
			tran_date	datetime	Transaction Date
			anchor_date		Anchor Date
			fb_id	sql_variant	Finance Book Id
			tran_currency		Transaction Currency
			exchange_rate	bigint	Exchange Rate
			pay_term	sql_variant	Pay Term
			payterm_version	int	Pay Term Version
			elec_pay	sql_variant	Electronic Payment
			pay_method		Pay Method
			pay_mode		Pay Mode
			pay_priority		Payment Priority
			payment_ou	int	Payment Organization Unit
			supp_code	sql_variant	Supplier Code
			pay_to_supp		Pay To Supplier
			supp_invoice_no		Supplier Invoice Number
			supp_invoice_date	datetime	Supplier Invoice Date
			supp_invoice_amount	bigint	Supplier Invoice Amount
			supp_ou	int	Supplier Organization Unit
			comments	sql_variant	Comments
			tran_amount	bigint	Transaction Amount
			par_exchange_rate		Parallel Exchange Rate
			item_amount		Item Amount
			tax_amount		Tax Amount
			disc_amount		Discount Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			rev_doc_no	sql_variant	Reversal Document Number
			rev_doc_ou	int	Reversal Document Organization Unit
			rev_date	datetime	Reversal Date
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_ou	int	Reference Document Organization Unit
			rev_reason_code	sql_variant	Reversal Reason Code
			rev_remarks		Reversal Remarks
			hld_date	datetime	Hold Date
			hld_reason_code	sql_variant	Hold Reason Code
			hld_remarks		Hold Remarks
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			disc_comp_basis		Discount Component Basis
			discount_proportional		Discount Proportional
			comp_bp_code		Component Book Posting Code
			bank_code		Bank Code
			lsv_id		LSV Id
			comp_acct_in		Component Accounting Information
			comp_bp_ref		Company Bank / PTT Reference
			comp_bp_acc_no		Company Bank / PTT Account Number
			esr_id		ESR Id
			partid_digits	int	Part Id Digits
			refno_digits		Reference Number Digits
			supp_acct_in	sql_variant	Supplier Accounting Information
			supp_bp_ref		Supplier Bank / PTT Reference
			supp_bp_acc_no		Supplier Bank / PTT Account Number
			vat_applicable		Value Added Tax Applicable
			vat_exchange_rate	bigint	Value Added Tax Exchange Rate
			vat_charge		Value Added Tax Charge
			non_vat_charge		Other than Value Added Tax Charges
			doc_level_disc		Document Level Discount
			vat_incl	sql_variant	Value Added Tax Include
			retain_init_distbn		Retain Initial Distribution
			cap_non_ded_charge		Other Than Capital Deduction Charges
			average_vat_rate	bigint	Average Value Added Tax Rate
			vat_excl_amount		Value Added Tax Exclude Amount
			vat_amount		Value Added Tax Amount
			vat_incl_amount		Value Added Tax Include Amount
			pre_round_off_amount		Pre-round Off Amount
			rounded_off_amount		Rounded Off Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			order_percent	bigint	Order Percentage
			batch_id	sql_variant	Batch Id
			esr_flag		ESR Flag
			tcal_exclusive_amt	bigint	Invoice Amount Exclusive Of Tax Calculation
			total_tcal_amount		Total Invoice Amount Exclusive Of Tax Calculation
			tcal_status	sql_variant	Tax Calculation Status
			supp_companycode		Supplier Company Code
			supp_comppttname		Supplier Component PTT Name
			supp_suplbank		Supplier Bank
			supp_suplbankname		Supplier Bank Name
			supp_swiftid		Supplier Swift Id
			supp_ibanno		Supplier IBAN Number
			supp_lsvcontractid		Supplier LSV Contract Id
			supp_contractref		Supplier Contract Reference
			supp_lsvfromdate	datetime	Supplier LSV From Date
			supp_lsvtodate		Supplier LSV To Date
			supp_contallowed	sql_variant	Supplier Contact Allowed
			supp_contactperson		Supplier Contact Person
			supp_bankclearno		Supplier Bank Cleareance Number
	sppi_invoice_hdr_tmp		timestamp	int	Time Stamp
			tran_status	sql_variant	Transaction Status
			tran_date	datetime	Transaction Date
			anchor_date		Anchor Date
			fb_id	sql_variant	Finance Book Id
			auto_adjust		Auto Adjust
			tran_currency		Transaction Currency
			exchange_rate	bigint	Exchange Rate
			pay_term	sql_variant	Pay Term
			elec_pay		Electronic Payment
			pay_method		Payment Method
			pay_to_supp		Pay To Supplier
			pay_to_supp_name		Pay To Supplier Name
			pay_mode		Payment Mode
			pay_priority		Payment  Priority
			payment_ou	int	Payment Organization Unit
			supp_code	sql_variant	Supplier Code
			supp_name		Supplier Name
			supp_invoice_no		Supplier Invoice Number
			supp_invoice_date	datetime	Supplier Invoice Date
			supp_invoice_amount	bigint	Supplier Invoice Amount
			supp_ou	int	Supplier Organization Unit
			comments	sql_variant	Comments
			address1		Address 1
			address2		Address 2
			address3		Address 3
			city		City
			state		State
			country		Country
			zip		Zip
			phone		Phone
			telex		Telex
			fax		Fax
			pager		Pager
			mobile		Mobile
			mailstop		Mail Stop
			email		Email
			url		Uniform Resource Locator
			contact		Contact
			tran_amount	bigint	Transaction Amount
			par_exchange_rate		Parallel Exchange Rate
			item_amount		Item Amount
			tax_amount		Tax Amount
			disc_amount		Discount Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			rev_doc_no	sql_variant	Reversal Document Number
			rev_doc_ou	int	Reversal Document Organization Unit
			rev_date	datetime	Reversal Date
			ref_doc_no	sql_variant	Reference Document Number
			ref_doc_ou	int	Reference Document Organization Unit
			rev_reason_code	sql_variant	Reversal Reason Code
			rev_remarks		Reversal Remarks
			hld_date	datetime	Hold Date
			hld_reason_code	sql_variant	Hold Reason Code
			hld_remarks		Hold Remarks
			auth_date	datetime	Authorized Date
			posting_date		Posting Date
			posting_status	sql_variant	Posting Status
			disc_comp_basis		Discount Component Basis
			comp_bp_code		Component Bank /PTT Code
			bank_code		Bank Code
			lsv_id		LSV Id
			comp_acct_in		Company Account In
			comp_bp_ref		Company Bank /PTT Reference
			comp_bp_acc_no		Company Bank /PTT Accounting Number
			esr_id		ESR Id
			partid_digits	int	Part Id Digits
			refno_digits		Reference Number Digits
			supp_acct_in	sql_variant	Supplier Accounting Information
			supp_bp_ref		Supplier Bank /PTT
			supp_bp_acc_no		Supplier Bank /PTT Account Number
			vat_exchange_rate	bigint	Value Added Tax Exchange Rate
			vat_charge		Value Added Tax Charge
			non_vat_charge		Other than Value Added Tax Charge
			doc_level_disc		Document Level Discount
			vat_incl	sql_variant	Value Added Tax Include
			retain_init_distbn		Retail Initial Distribution
			cap_non_ded_charge		Other than Capital Deduction Charges
			vat_excl_amount	bigint	Value Added Tax Exclude Amount
			vat_amount		Value Added Tax Amount
			vat_incl_amount		Value Added Tax Include Amount
			avg_vat_rate		Average Value Added Tax Rate
			disc_prop_flag	sql_variant	Discount Proposed Flag
			guid		Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			tran_ou	int	Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
	sppi_item_dtl		tran_type		Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Organization Number
			line_no	int	Line Number
			timestamp		Time Stamp	No
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			visible_line_no	int	Visible Line Number
			uom	sql_variant	Unit Of Measurement
			item_qty	bigint	Item Quantity
			invoice_rate		Invoice Rate
			rate_per		Rate Percentage
			item_amount		Item Amount
			proposal_no	sql_variant	Proposal Number
			pors_type		Proposal Type
			pors_no		Purchase Order Release Slip Number
			po_ou	int	Purchase Order Organization Unit
			remarks	sql_variant	Remarks
			item_type		Item Type
			tax_amount	bigint	Tax Amount
			disc_amount		Discount Amount
			line_amount		Line Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	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
			order_percent	bigint	Order Percentage
			base_value		Base Value
	sppi_nc_intxn_numtypes_tmp		guid	sql_variant	Guid
			num_type		Number Type
	sppi_notes_dtl		tran_type		Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			note_category		Note Category
			category_value		Category Value
			line_no	int	Line Number
			timestamp		Time Stamp	No
			note_text	sql_variant	Note Text
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	sppi_payment_dtl		tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			term_no		Term Number
			timestamp	int	Time Stamp	No
			posting_status	sql_variant	Posting Status
			posting_date	datetime	Posting Date
			due_date		Due Date
			due_amount_type	sql_variant	Due Amount Type
			due_percent	bigint	Due Percentage
			due_amount		Due Amount
			disc_comp_amount		Discount Computation Amount
			disc_amount_type	sql_variant	Discount Amount Type
			disc_date	datetime	Discount Date
			disc_percent	bigint	Discount Percentage
			disc_amount		Discount Amount
			penalty_percent		Penalty Percentage
			esr_ref_no	sql_variant	ESR Reference Number
			esr_coding_line		ESR Coding Line
			esr_amount	bigint	ESR Amount
			base_due_amount		Base Due Amount
			base_disc_amount		Base Discount Amount
			base_esr_amount		Base Bsr Amount
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	sppi_payment_dtl_tmp		tran_type	sql_variant	Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			term_no		Term Number
			timestamp	int	Time Stamp
			payterm_lineno		Pay Term Line Number
			posting_status	sql_variant	Posting Status
			posting_date	datetime	Posting Date
			due_date		Due Date
			due_amount_type	sql_variant	Due Amount Type
			due_percent	bigint	Due Percentage
			due_amount		Due Amount
			disc_comp_amount		Discount Computation Amount
			disc_amount_type	sql_variant	Discount Amount Type
			disc_date	datetime	Discount Date
			disc_percent	bigint	Discount Percentage
			disc_amount		Discount Amount
			penalty_percent		Penalty Percent
			esr_ref_no	sql_variant	ESR Reference Number
			esr_coding_line		ESR Coding Line
			esr_amount	bigint	ESR Amount
			base_due_amount		Base Due Amount
			base_disc_amount		Base Discount Amount
			base_esr_amount		Base ESR Amount
			guid	sql_variant	Guid
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	sppi_po_dtl_tmp		guid	sql_variant	Guid
			po_order_no		Purchase Order Number
			po_ou	int	Purchase Order Organization Unit
			po_amendmentno		Purchase Order Amendment Number
			po_date	datetime	Purchase Order Date
			po_authdate		Purchase Order Authorized Date
			supp_code	sql_variant	Supplier Code
			pay_to_supp		Payment To Supplier
			po_currency		Purchase Order Currency
			po_pay_mode		Purchase Order Payment Mode
			po_exch_rate	bigint	Purchase Order Exchange Rate
			po_line_no	int	Purchase Order Line Number
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_variant		Item Tax Charge Discount Variant
			uom		Unit Of Measurement
			quantity	bigint	Quantity
			rate		Rate
			rate_per		Rate Percentage
			item_tcd	sql_variant	Item Tax Charge Discount
			tcd_compute		Tax Charge Discount Compute
			tcd_on_line_no	int	Tax Charge Discount On Line Number
			analysis_code	sql_variant	Analysis Code
			sub_analysis_code		Subanalysis Code
			tcdtrate	bigint	Tax Charge Discount Rate
			tcdamount		Tax Charge Discount Amount
			cost_center	sql_variant	Cost Center
			asset_prop_no		Asset Proposal Number
			pors_flag		Purchase Order Release Slip Flag
			tcd_type		Tax Charge Discount Type
			item_amount	bigint	Item Amount
			taxable_amount		Taxable Amount
			pobalancequantity		Purhcase Order Balance Quantity
	sppi_po_order_no_tmp		guid	sql_variant	Guid
			po_no		Purchase Order Number
			invoice_category		Invoice Category
			pay_to_supp		Payment To Supplier
			po_currency		Purchase Order Currency
			payterm		Pay Term
	sppi_pt_intxn_paydtl_tmp		guid		Guid
			ouid	int	Organization Unit Id
			pay_term	sql_variant	Pay Term
			pay_term_no		Pay Term Number
			due_days	int	Due Days
			due_percentage	bigint	Due Percentage
			discount_days	int	Discount Days
			discount_percentage	bigint	Discount Percentage
			penalty_percentage		Penality Percentage
			disc_proportional	sql_variant	Discount Proportional
	sppi_qcd_intxn_codes_tmp		guid		Guid
			tran_type		Transaction Type
			reason_code		Reason Code
			reason_desc		Reason Description
	sppi_rpt_tmp		guid		Guid
			companyname		Company Name
			ouinstname		Organization Unit Instance Name
			invoicedate	datetime	Invoice Date
			invoicenumber	sql_variant	Invoice Number
			currency_code		Currency Code
			exchangerate	bigint	Exchange Rate
			status	sql_variant	Status
			fb		Finance Book
			suppliername		Supplier Name
			pono		Purchase Order Number
			itemcode		Item Code
			uom		Unit Of Measurement
			variant		Variant
			usage		Usage
			expense		Expense
			quantity	bigint	Quantity
			rateamount		Rate Amount
			amount		Amount
			sobitcd_value		Supplier Order Based Invoice Tax Charge Discount  Value
			totalvatamount		Total Tax Charge Discount Amount
			line_no	int	Line Number
			supplier_ref	sql_variant	Supplier Reference
			itemdesc		Item Description
			vatdesc		Tax Charge Discount Description
			sequence_no	int	Sequence Number
	sppi_tax_cal_temp		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
			Tran_Mode	sql_variant	Transaction Mode
			Called_From_Flag		Called From Flag
			Calling_Service_Name		Calling Service Name
			Original_Tran_No		Orginal Transaction Number
			original_tran_type		Orginal Transaction Type
			Applied_Flag		Applier Flag
			total_tcal_amount	bigint	Total Tax Calculation Amount
			tcal_excl_amount		Total Tax Calculation Exclusion  Amount
			tran_amount		Transaction Amount
			base_amount		Base Amount
			par_base_amount		Parallel Base Amount
			pre_round_off_amount		Pre-round Off Amount
			rounded_off_amount		Rounded Off Amount
	sppi_tcd_dtl		tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction  Organization Unit
			tran_no	sql_variant	Transaction  Number
			line_no	int	Line Number
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			tcd_version	int	Tax Charge Discount Version
			timestamp		Time Stamp	No
			item_type	sql_variant	Item Type
			tcd_level		Tax Charge Discount Level
			tcd_rate	bigint	Tax Charge Discount Rate
			taxable_amount		Taxable Amount
			tcd_amount		Tax Charge Discount Amount
			tcd_currency	sql_variant	Tax Charge Discount Currency
			usage		Usage
			base_amount	bigint	Base Amount
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Value
			base_value	bigint	Base Value
	sppi_tcd_dtl_tmp		guid	sql_variant	Guid
			tran_type		Transaction Type
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			line_no	int	Line Number
			item_tcd_code	sql_variant	Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			timestamp	int	Time Stamp
			item_type	sql_variant	Item Type
			tcd_level		Tax Charge Discount Level
			tcd_rate	bigint	Tax Charge Discount Rate
			taxable_amount		Taxable Amount
			tcd_amount		Tax Charge Discount Amount
			tcd_currency	sql_variant	Tax Charge Discount Currency
			usage		Usage
			base_amount	bigint	Base Amount
			par_base_amount		Parallel Base Amount
			cost_center	sql_variant	Cost Center
			analysis_code		Analysis Code
			subanalysis_code		Subanalysis Code
			remarks		Remarks
			createdby		Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			modeflag	sql_variant	Model Flag
			base_value	bigint	Base Value
	sppi_tcdcal_calcprocess_tmp		tcdcal_guid	sql_variant	Tax Charge Discount Guid
			tcdcal_tcdcode		Tax Charge Discount Code
			tcdcal_tcddocumentlevel		Tax Charge Discount Document Level
			tcdcal_tcdvariant		Tax Charge Discount Variant
			tcdcal_line_no	int	Tax Charge Discount Line Number
			tcdcal_tcdvalue	bigint	Tax Charge Discount Value
			tcdcal_bv_lineitem		Base Value on Line Item
			tcdcal_qty_lineitem		Line Item Quantity
			tcdcal_tcd_amount		Tax Charge Discount Amount
	sppi_vat_dtl		tran_type	sql_variant	Transaction Type	Yes
			tran_ou	int	Transaction Organization Unit
			tran_no	sql_variant	Transaction Number
			vat_line_no	int	Value Added Tax Line Number
			timestamp		Time Stamp	No
			doc_line_no		Document Line Number
			item_type	sql_variant	Item Type
			item_tcd_code		Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Code Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_var		Tax Charge Discount
			vat_rate	bigint	Value Added Tax
			inp_vat_deduct_per		Input Value Added Tax  Deductible Percentage
			item_amount		Item Amount
			vat_item_charge		Value Added Tax Charge
			non_vat_item_charge		Other than Vat Item Charges
			vat_dist_charge		Value Added Tax  Distributed charge
			item_level_disc_amount		Item Level Discount Amount
			dist_disc_amount		Distributed Discount Amount
			vat_tran_amount		Value Added Tax Transaction Amount
			corr_vat_tran_amount		Corrected Value Added Tax Transaction Amount
			vat_base_amount		Value Added Tax Base Amount
			corr_vat_base_amount		Corrected Value Added Tax Base Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
	sppi_vat_dtl_tmp		timestamp	int	Time Stamp
			tran_ou		Transaction Organization Unit
			tran_type	sql_variant	Transaction Type
			tran_no		Transaction Number
			doc_line_no	int	Document Line Number
			item_type	sql_variant	Item Type
			account_code		Account Code
			item_tcd_code		Item Tax Charge Discount Code
			item_tcd_var		Item Tax Charge Discount Variant
			vat_category		Value Added Tax Category
			vat_class		Value Added Tax Class
			tcd_var		Tax Charge Discount Variant
			vat_rate	bigint	Value Added Tax Rate
			inp_vat_deduct_per		Input Value Added Tax  Deductible Percentage
			item_amount		Item Amount
			vat_item_charge		Value Added Tax Item Charge
			non_vat_item_charge		Other than Value Added Tax Item Charge
			vat_dist_charge		Value Added Tax  Distributed charge
			item_level_disc_amount		Item Level Discount Amount
			dist_disc_amount		Distributed Discount Amount
			vat_tran_amount		Value Added Tax Transaction Amount
			corr_vat_tran_amount		Corrected Value Added Tax Transaction Amount
			vat_base_amount		Value Added Tax Base Amount
			corr_vat_base_amount		Corrected Value Added Tax Base Amount
			createdby	sql_variant	Created By
			createddate	datetime	Created Date
			modifiedby	sql_variant	Modified By
			modifieddate	datetime	Modified Date
			vat_line_no	int	Value Added Tax Line Number
			guid	sql_variant	Guid