


INSERT INTO ctdItemM (PracticeCode
	, ItemCode
	, ItemName
	, ItemType
	, ItemImage
	, StandardPrice
	, SellsPrice
	, ConsumptionTax
	, TransportPrice
	, Remarks
	, RegistrationType
	, SGroupCode
	, AddDate
	, UpdDate
	, AddProc
	, UpdProc
)
SELECT PracticeCode
	, ItemCode
	, ItemName
	, ItemType
	, ItemImage
	, StandardPrice
	, SellsPrice
	, null
	, TransportPrice
	, Remarks
	, RegistrationType
	, SGroupCode
	, AddDate
	, UpdDate
	, AddProc
	, UpdProc
FROM OLD_ctdItemM



INSERT INTO cthPTenantTItem (PracticeCode
	, TenantCode
	, ItemCode
	, ItemName
	, StockPrice
	, StandardPrice
	, SellsPrice
	, ConsumptionTax
	, TransportPrice
	, Remarks
	, RegistrationType
	, F
	, DisplayFlag
	, DisplaySeq
	, Remarks2
	, Remarks3
	, Remarks4
	, ItemImage
	, SalesImage1
	, SalesImage2
	, SalesImage3
	, SalesImage4
	, SalesImage5
	, AddDate
	, UpdDate
	, AddProc
	, UpdProc
)
SELECT PracticeCode
	, TenantCode
	, ItemCode
	, ItemName
	, StockPrice
	, StandardPrice
	, SellsPrice
	, null
	, TransportPrice
	, Remarks
	, RegistrationType
	, F
	, DisplayFlag
	, DisplaySeq
	, Remarks2
	, Remarks3
	, Remarks4
	, ItemImage
	, SalesImage1
	, SalesImage2
	, SalesImage3
	, SalesImage4
	, SalesImage5
	, AddDate
	, UpdDate
	, AddProc
	, UpdProc
FROM OLD_cthPTenantTItem



