CREATE TRIGGER noViewDrop
ON DATABASE
FOR DROP_VIEW
AS
        PRINT 'Cannot drop view';
        ROLLBACK
go

DROP VIEW	SO_VIEW
GO
CREATE VIEW [dbo].[SO_VIEW]
AS
SELECT     dbo.SO.PR_KEY AS PR_KEY_CTU, dbo.SO.ORGANIZATION_ID, dbo.SO.TRAN_ID, dbo.SO.TRAN_NO, dbo.SO.TRAN_DATE, dbo.SO.SBO_TRAN_ID, 
                      dbo.SO.SBO_TRAN_NO, dbo.SO.IS_OVER_CREDIT_LIMIT, dbo.SO.APPROVE_DATE, dbo.SO.RELEASE_DATE, dbo.SO.DELIVERY_DATE, dbo.SO.EMPLOYEE_ID, 
                      dbo.SO.MARKET_ID, dbo.SO.SHIPPING_METHOD_ID, dbo.SO.VEHICLE_ID, dbo.SO.CURRENCY_ID, dbo.SO.EXCHANGE_RATE, dbo.SO.EXCHANGE_RATE_EXTRA, 
                      dbo.SO.PR_DETAIL_NAME, dbo.SO.CONTACT_PERSON, dbo.SO.ADDRESS, dbo.SO.TAX_FILE_NUMBER, dbo.SO.PAYMENT_METHOD_ID, 
                      dbo.SO.PAYMENT_TERM_ID, dbo.SO.COMMENTS, dbo.SO.STATUS, dbo.SO.USER_ID, dbo.SO.APPROVER_ID, dbo.DM_ITEM.UNIT_ID AS UNIT_ID_WH, 
                      dbo.DM_ITEM.UNIT_ID_EXTRA, dbo.DM_ITEM.ITEM_NAME, dbo.DM_ITEM.ITEM_CLASS_ID, dbo.DM_JOB.JOB_CLASS_ID, dbo.SO.DRIVER_NAME, 
                      dbo.DM_PR_DETAIL.PR_DETAIL_CLASS_ID, dbo.SO.DELIVER_ORGANIZATION_ID, dbo.SO_DETAIL.PR_KEY, dbo.SO_DETAIL.FR_KEY, dbo.SO_DETAIL.LIST_ORDER, 
                      dbo.SO_DETAIL.ITEM_SOURCE_ID, dbo.SO_DETAIL.WAREHOUSE_ID, dbo.SO_DETAIL.PR_DETAIL_ID, dbo.SO_DETAIL.JOB_ID, dbo.SO_DETAIL.ITEM_ID, 
                      dbo.SO_DETAIL.DESCRIPTION, dbo.SO_DETAIL.DESCRIPTION_ULS, dbo.SO_DETAIL.UNIT_ID, dbo.SO_DETAIL.QUANTITY, dbo.SO_DETAIL.QUANTITY_EXTRA, 
                      dbo.SO_DETAIL.QUANTITY_WH, dbo.SO_DETAIL.UNIT_PRICE_ORIG, dbo.SO_DETAIL.UNIT_PRICE, dbo.SO_DETAIL.UNIT_PRICE_WH, 
                      dbo.SO_DETAIL.AMOUNT_ORIG, dbo.SO_DETAIL.AMOUNT, dbo.SO_DETAIL.AMOUNT_EXTRA, dbo.SO_DETAIL.VAT_INCOME_AMOUNT_ORIG, 
                      dbo.SO_DETAIL.VAT_INCOME_AMOUNT, dbo.SO_DETAIL.VAT_INCOME_AMOUNT_EXTRA, dbo.SO_DETAIL.VAT_TAX_ID, dbo.SO_DETAIL.VAT_TAX_RATE, 
                      dbo.SO_DETAIL.VAT_TAX_AMOUNT, dbo.SO_DETAIL.VAT_TAX_AMOUNT_ORIG, dbo.SO_DETAIL.VAT_TAX_AMOUNT_EXTRA, dbo.SO_DETAIL.EXPORT_TAX_RATE, 
                      dbo.SO_DETAIL.EXPORT_TAX_AMOUNT, dbo.SO_DETAIL.EXPORT_TAX_AMOUNT_ORIG, dbo.SO_DETAIL.EXPORT_TAX_AMOUNT_EXTRA, 
                      dbo.SO_DETAIL.DISCOUNT_RATE, dbo.SO_DETAIL.DISCOUNT_AMOUNT, dbo.SO_DETAIL.DISCOUNT_AMOUNT_ORIG, dbo.SO_DETAIL.DISCOUNT_AMOUNT_EXTRA, 
                      dbo.SO_DETAIL.LUX_TAX_RATE, dbo.SO_DETAIL.LUX_TAX_AMOUNT, dbo.SO_DETAIL.LUX_TAX_AMOUNT_ORIG, dbo.SO_DETAIL.LUX_TAX_AMOUNT_EXTRA, 
                      dbo.SO_DETAIL.TOTAL_AMOUNT, dbo.SO_DETAIL.TOTAL_AMOUNT_ORIG, dbo.SO_DETAIL.TOTAL_AMOUNT_EXTRA, dbo.SO_DETAIL.PRICE_LEVEL_ID, 
                      dbo.SO_DETAIL.ITEM_OP_ID, dbo.SO_DETAIL.DELIVERY_TIME, dbo.SO_DETAIL.IS_SII, dbo.SO_DETAIL.IS_DELIVERED, dbo.SO_DETAIL.IS_INVOICED, 
                      dbo.SO_DETAIL.QUANTITY_INVOICE, dbo.SO_DETAIL.QUANTITY_DELIVERY, dbo.SO_DETAIL.QUANTITY_SII, dbo.DM_PR_DETAIL.PR_ACCOUNT_ID, 
                      dbo.DM_PR_DETAIL.PR_ACCOUNT_ID1,DM_PR_DETAIL.PR_DETAIL_NAME AS PR_DETAIL_NAME_DETAIL,
					  SO_DETAIL.ITEM_HEIGHT,SO_DETAIL.ITEM_WIDTH,SO_DETAIL.ITEM_DEPTH,SO_DETAIL.ITEM_SIZE,SO_DETAIL.ITEM_LOCATION,SO_DETAIL.ITEM_SERI_NO,SO_DETAIL.ITEM_SERI_NO1,SO_DETAIL.ITEM_SERI_NO2,SO_DETAIL.ITEM_GRADE_ID,SO_DETAIL.ITEM_GRADE1_ID,SO_DETAIL.ITEM_STATUS_ID
FROM         dbo.SO INNER JOIN
                      dbo.SO_DETAIL ON dbo.SO.PR_KEY = dbo.SO_DETAIL.FR_KEY LEFT OUTER JOIN
                      dbo.DM_PR_DETAIL ON dbo.SO_DETAIL.PR_DETAIL_ID = dbo.DM_PR_DETAIL.PR_DETAIL_ID LEFT OUTER JOIN
                      dbo.DM_JOB ON dbo.SO_DETAIL.JOB_ID = dbo.DM_JOB.JOB_ID LEFT OUTER JOIN
                      dbo.DM_ITEM ON dbo.SO_DETAIL.ITEM_ID = dbo.DM_ITEM.ITEM_ID

GO