ALTER   PROC [dbo].[TR_REQ_PAYMENT_INVOICE_Import] (
	@p_FR_BR_ID VARCHAR(15) = NULL,
	@p_LEVLEL VARCHAR(15) = NULL,
	@p_WARE_HOUSE VARCHAR(15) = NULL,
	@p_XmlData XML=NULL
)
AS
BEGIN

	DECLARE @tmpTABLE TABLE(
		STT INT IDENTITY(1, 1) PRIMARY KEY,
		INVOICE_SIGN NVARCHAR(500),
		INVOICE_NO_SIGN VARCHAR(15),
		INVOICE_NO NVARCHAR(50),
		INVOICE_DT VARCHAR(20),
		SELLER NVARCHAR(500),
		TAX_NO NVARCHAR(15),
		GOODS_NAME NVARCHAR(500),
		PRICE DECIMAL(18,2),
		TAX DECIMAL(18,2),
		VAT DECIMAL(18,2),
		TOTAL_AMT DECIMAL(18,2)
	)

	DECLARE @hdoc INT
	EXEC sp_xml_preparedocument @hdoc OUTPUT, @p_XmlData
	
	INSERT INTO @tmpTABLE
	SELECT * FROM OPENXML(@hDoc, '/Root/XmlData', 2)
	WITH (
		INVOICE_SIGN NVARCHAR(500),
		INVOICE_NO_SIGN VARCHAR(15),
		INVOICE_NO NVARCHAR(50),
		INVOICE_DT VARCHAR(20),
		SELLER NVARCHAR(500),
		TAX_NO NVARCHAR(15),
		GOODS_NAME NVARCHAR(500),
		PRICE DECIMAL(18,2),
		TAX DECIMAL(18,2),
		VAT DECIMAL(18,2),
		TOTAL_AMT DECIMAL(18,2)
	)

	SELECT
		T.INVOICE_SIGN, T.INVOICE_NO,
		 CONVERT(DATE,T.INVOICE_DT,103) AS INVOICE_DT, T.SELLER, T.TAX_NO, T.GOODS_NAME,
		T.PRICE, T.TAX, T.VAT, (T.PRICE + T.VAT) AS TOTAL_AMT
	FROM @tmpTABLE T
	ORDER BY T.STT ASC

END