Supplier Prepayment Invoice

Table Owner	Table Name	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	Transaction Type	Yes	No
		tran_ou	int	Transaction Organization Unit
		tran_no	sql_variant	Transaction 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	Original 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	Reference Transaction Finance Book Id
		reftran_no		Reference Transaction Number
		reftran_ou	int	Reference Transaction Organization Unit
		supp_code	sql_variant	Supplier Code
		ref_tran_type		Reference 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 Analysis 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	Purchase 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 Clearance 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		Purchase 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		Penalty 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		Original Transaction Number
		original_tran_type		Original 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