39b05243-765f-40b6-b204-3d80c9b6c2d7 HAB - Custom Fields combined This plugin builds multiple combo boxes, custom fields and custom field lookups. true false 0 Atronics Consulting 7.0.175.0 Imports JiwaFinancials.Jiwa Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports System.Data.SqlClient Imports System.Drawing Imports System.Data Imports System.Collections.Generic Public Class FormPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaFormPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub SetupBeforeHandlers(ByVal JiwaForm As JiwaApplication.IJiwaForm, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaFormPlugin.SetupBeforeHandlers End Sub Public Sub Setup(ByVal JiwaForm As JiwaApplication.IJiwaForm, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaFormPlugin.Setup End Sub End Class Public Class BusinessLogicPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaBusinessLogicPlugin Private _InventoryObject As JiwaInventory.Inventory Private _DebtorObject As JiwaDebtors.Debtor Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function '************* from HAB end Public Sub Setup(ByVal JiwaBusinessLogic As JiwaApplication.IJiwaBusinessLogic, ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaBusinessLogicPlugin.Setup _InventoryObject = DirectCast(JiwaBusinessLogic, JiwaInventory.Inventory) AddHandler _InventoryObject.CustomFieldValues.Changed, AddressOf CustomFieldValues_Changed _DebtorObject = DirectCast(JiwaBusinessLogic, JiwaDebtors.Debtor) AddHandler _DebtorObject.CustomFieldValues.Changed, AddressOf CustomFieldValues_Changed End Sub '******* Private Sub CustomFieldValues_Changed(item As JiwaApplication.CustomFields.CustomFieldValue, e As System.ComponentModel.PropertyChangedEventArgs) If item.CustomField.PluginCustomField.Name = "Arbitration" Then If item.Contents Is Nothing Then item.Contents = "1" End If Else If item.CustomField.PluginCustomField.Name = "Insurance" Then If item.Contents Is Nothing Then item.Contents = "1" End If Else If item.CustomField.PluginCustomField.Name = "Franchise" Then If item.Contents Is Nothing Then item.Contents = "1" End If Else If item.CustomField.PluginCustomField.Name = "PrcingBasis" Then If item.Contents Is Nothing Then item.Contents = "1" End If Else If item.CustomField.PluginCustomField.Name = "PriceType" Then If item.Contents Is Nothing Then item.Contents = "1" End If Else If item.CustomField.PluginCustomField.Name = "WebCategory_Brand" Then If item.Contents Is Nothing Then item.Contents = "1" End If End If End Sub End Class Public Class ApplicationManagerPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaApplicationManagerPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub Setup(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaApplicationManagerPlugin.Setup End Sub End Class Public Class CustomFieldPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaCustomFieldPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.FormatCell If CustomField.PluginCustomField.Name = "Arbitration" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("Friendly") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("Friendly") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "Insurance" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("Buyers Care") MyDisplayItems.Add("Sellers Care") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("Buyers Care") MyUnderlyingValues.Add("Sellers Care") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "Franchise" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("Net Shipped Weight 0.5 Percent Franchise") MyDisplayItems.Add("Net Shipped Weight 1.0 Percent Franchise") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("Net Shipped Weight 0.5 Percent Franchise") MyUnderlyingValues.Add("Net Shipped Weight 1.0 Percent Franchise") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "PrcingBasis" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("DTS") MyDisplayItems.Add("Ex Store") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("DTS") MyUnderlyingValues.Add("Ex Store") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "PriceType" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("Lb") MyDisplayItems.Add("Ton") MyDisplayItems.Add("1") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("c/lb") MyUnderlyingValues.Add("PMT") MyUnderlyingValues.Add("P/Kg") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray ' Else If CustomField.PluginCustomField.Name = "Spare2" Then ' Dim MyDisplayItems As New List(Of String) ' Dim MyUnderlyingValues As New List(Of String) ' ' MyDisplayItems.Add("Not Set") ' MyDisplayItems.Add("Net Shipped Weight 0.5 Percent Franchise") ' MyDisplayItems.Add("Net Shipped Weight 1.0 Percent Franchise") ' ' MyUnderlyingValues.Add("1") ' MyUnderlyingValues.Add("2") ' MyUnderlyingValues.Add("3") ' ' DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData ' DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray ' DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "PaymentType" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("CAD Against 1st Presentation") MyDisplayItems.Add("Withinb 48 hours of receipt of documents") MyDisplayItems.Add("Payment on Receipt of Fax Documents") MyDisplayItems.Add("14 days from Receipt of Documents") MyDisplayItems.Add("30 days from Bill of Lading Date") MyDisplayItems.Add("45 days from Bill of Lading Date") MyDisplayItems.Add("60 days from Bill of Lading Date") MyDisplayItems.Add("90 days from Bill of Lading Date") MyDisplayItems.Add("120 days from Bill of Lading Date") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("CAD Against 1st Presentation") MyUnderlyingValues.Add("Withinb 48 hours of receipt of documents") MyUnderlyingValues.Add("Payment on Receipt of Fax Documents") MyUnderlyingValues.Add("14 days from Receipt of Documents") MyUnderlyingValues.Add("30 days from Bill of Lading Date") MyUnderlyingValues.Add("45 days from Bill of Lading Date") MyUnderlyingValues.Add("60 days from Bill of Lading Date") MyUnderlyingValues.Add("90 days from Bill of Lading Date") MyUnderlyingValues.Add("120 days from Bill of Lading Date") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray Else If CustomField.PluginCustomField.Name = "ShippingPeriod" Then Dim MyDisplayItems As New List(Of String) Dim MyUnderlyingValues As New List(Of String) MyDisplayItems.Add("Not Set") MyDisplayItems.Add("1-15 Jan") MyDisplayItems.Add("16-31 Jan") MyDisplayItems.Add("1-31 Jan") MyDisplayItems.Add("1-14 Feb") MyDisplayItems.Add("15-28 Feb") MyDisplayItems.Add("1-28 Feb") MyDisplayItems.Add("1-15 Mar") MyDisplayItems.Add("16-31 Mar") MyDisplayItems.Add("1-31 Mar") MyDisplayItems.Add("1-15 Apr") MyDisplayItems.Add("16-30 Apr") MyDisplayItems.Add("1-30 Apr") MyDisplayItems.Add("1-15 May") MyDisplayItems.Add("16-31 May") MyDisplayItems.Add("1-31 May") MyDisplayItems.Add("1-15 Jun") MyDisplayItems.Add("16-30 Jun") MyDisplayItems.Add("1-30 Jun") MyDisplayItems.Add("1-15 Jul") MyDisplayItems.Add("16-31 Jul") MyDisplayItems.Add("1-31 Jul") MyDisplayItems.Add("1-15 Aug") MyDisplayItems.Add("16-31 Aug") MyDisplayItems.Add("1-31 Aug") MyDisplayItems.Add("1-15 Sep") MyDisplayItems.Add("16-30 Sep") MyDisplayItems.Add("1-30 Sep") MyDisplayItems.Add("1-15 Oct") MyDisplayItems.Add("16-31 Oct") MyDisplayItems.Add("1-31 Oct") MyDisplayItems.Add("1-15 Nov") MyDisplayItems.Add("16-31 Nov") MyDisplayItems.Add("1-31 Nov") MyDisplayItems.Add("1-15 Dec") MyDisplayItems.Add("16-31 Dec") MyDisplayItems.Add("1-31 Dec") MyUnderlyingValues.Add("") MyUnderlyingValues.Add("1-15 Jan") MyUnderlyingValues.Add("16-31 Jan") MyUnderlyingValues.Add("1-31 Jan") MyUnderlyingValues.Add("1-14 Feb") MyUnderlyingValues.Add("15-28 Feb") MyUnderlyingValues.Add("1-28 Feb") MyUnderlyingValues.Add("1-15 Mar") MyUnderlyingValues.Add("16-31 Mar") MyUnderlyingValues.Add("1-31 Mar") MyUnderlyingValues.Add("1-15 Apr") MyUnderlyingValues.Add("16-30 Apr") MyUnderlyingValues.Add("1-30 Apr") MyUnderlyingValues.Add("1-15 May") MyUnderlyingValues.Add("16-31 May") MyUnderlyingValues.Add("1-31 May") MyUnderlyingValues.Add("1-15 Jun") MyUnderlyingValues.Add("16-30 Jun") MyUnderlyingValues.Add("1-30 Jun") MyUnderlyingValues.Add("1-15 Jul") MyUnderlyingValues.Add("16-31 Jul") MyUnderlyingValues.Add("1-31 Jul") MyUnderlyingValues.Add("1-15 Aug") MyUnderlyingValues.Add("16-31 Aug") MyUnderlyingValues.Add("1-31 Aug") MyUnderlyingValues.Add("1-15 Sep") MyUnderlyingValues.Add("16-30 Sep") MyUnderlyingValues.Add("1-30 Sep") MyUnderlyingValues.Add("1-15 Oct") MyUnderlyingValues.Add("16-31 Oct") MyUnderlyingValues.Add("1-31 Oct") MyUnderlyingValues.Add("1-15 Nov") MyUnderlyingValues.Add("16-31 Nov") MyUnderlyingValues.Add("1-31 Nov") MyUnderlyingValues.Add("1-15 Dec") MyUnderlyingValues.Add("16-31 Dec") MyUnderlyingValues.Add("1-31 Dec") DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).EditorValue = FarPoint.Win.Spread.CellType.EditorValue.ItemData DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).Items = MyDisplayItems.ToArray DirectCast(GridObject.Activesheet.Cells(Row, Col).CellType, FarPoint.Win.Spread.CellType.ComboBoxCellType).ItemData = MyUnderlyingValues.ToArray End If End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.ReadData Dim SQLParam As SqlClient.SqlParameter = Nothing Dim SQLReader As SqlDataReader = Nothing If CustomField.PluginCustomField.Name.Trim = "40-SalesPartNo" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT dbo.IN_Main.Partno, dbo.IN_Main.Description FROM dbo.IN_Main WHERE PartNo = @PartNo ORDER BY PartNo " Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@PartNo", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} / {1}", .Sanitise(SQLReader, "PartNo"), .Sanitise(SQLReader, "Description")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ElseIf CustomField.PluginCustomField.Name.Trim = "43-Estate" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT CR_Main.AccountNo, CR_Main.Name FROM CR_Main INNER JOIN CN_Main ON CR_Main.CreditorId=CN_Main.CreditorId " SQL += " INNER JOIN CN_GroupLink On CN_Main.ProspectId=CN_GroupLink.ProspectId And CN_GroupLink.GroupId='ESTATE' WHERE CR_Main.AccountNo = @CreditorAcct" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@CreditorAcct", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} / {1}", .Sanitise(SQLReader, "AccountNo"), .Sanitise(SQLReader, "Name")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ElseIf CustomField.PluginCustomField.Name.Trim = "FXContract" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT TOP (100) PERCENT CR_ForwardCover.ContractNo, dbo.FX_Currency.ShortName, CR_ForwardCover.CurrencyRate, " SQL += "CR_ForwardCover.FXAmount - FXAmtValue As CoverRemaining FROM dbo.CR_ForwardCover As CR_ForwardCover " SQL += "INNER JOIN dbo.FX_Currency On dbo.FX_Currency.RecID = CR_ForwardCover.FX_Main_RecID " SQL += "INNER JOIN (Select CR_ForwardCover_RecID, SUM(FXAmount) As FXAmtValue From dbo.CR_ForwardCoverTransactions Group By CR_ForwardCover_RecID) As CTran " SQL += "On CR_ForwardCover.RecID = CTran.CR_ForwardCover_RecID WHERE (CR_ForwardCover.FXAmount - FXAmtValue) > 0 AND CR_ForwardCover.ContractNo = @ContractNo " Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@ContractNo", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} / {1} / {2} / {3}", .Sanitise(SQLReader, "ContractNo"), .Sanitise(SQLReader, "ShortName"), .Sanitise(SQLReader, "CurrencyRate"), .Sanitise(SQLReader, "CoverRemaining")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ''**** Inserted by JMI 07/12/16 ElseIf CustomField.PluginCustomField.Name.Trim = "PO_No" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT TOP (100) PERCENT CR_ForwardCover.ContractNo, dbo.FX_Currency.ShortName, CR_ForwardCover.CurrencyRate, " SQL += "CR_ForwardCover.FXAmount - FXAmtValue As CoverRemaining FROM dbo.CR_ForwardCover As CR_ForwardCover " SQL += "INNER JOIN dbo.FX_Currency On dbo.FX_Currency.RecID = CR_ForwardCover.FX_Main_RecID " SQL += "INNER JOIN (Select CR_ForwardCover_RecID, SUM(FXAmount) As FXAmtValue From dbo.CR_ForwardCoverTransactions Group By CR_ForwardCover_RecID) As CTran " SQL += "On CR_ForwardCover.RecID = CTran.CR_ForwardCover_RecID WHERE (CR_ForwardCover.FXAmount - FXAmtValue) > 0 AND CR_ForwardCover.ContractNo = @ContractNo " Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@ContractNo", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} / {1} / {2} / {3}", .Sanitise(SQLReader, "ContractNo"), .Sanitise(SQLReader, "ShortName"), .Sanitise(SQLReader, "CurrencyRate"), .Sanitise(SQLReader, "CoverRemaining")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ''**** ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApproval" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT HR_Staff.FName, HR_Staff.SName FROM HR_Staff " SQL += "INNER JOIN HR_CustomSettingValues On HR_Staff.StaffID = HR_CustomSettingValues.StaffID " SQL += "INNER JOIN HR_CustomSetting On HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID " SQL+= "WHERE HR_CustomSetting.SettingName = 'AuthorisePurchaseOrders' AND HR_CustomSettingValues.Contents = '1' AND FName = @StaffName" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@StaffName", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} {1}", .Sanitise(SQLReader, "FName"), .Sanitise(SQLReader, "SName")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApprovalSQ" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT HR_Staff.FName, HR_Staff.SName FROM HR_Staff " SQL += "INNER JOIN HR_CustomSettingValues On HR_Staff.StaffID = HR_CustomSettingValues.StaffID " SQL += "INNER JOIN HR_CustomSetting On HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID " SQL+= "WHERE HR_CustomSetting.SettingName = 'AuthorisePurchaseOrders' AND HR_CustomSettingValues.Contents = '1' AND FName = @StaffName" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@StaffName", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} {1}", .Sanitise(SQLReader, "FName"), .Sanitise(SQLReader, "SName")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApprovalSO" Then Dim SQL As String = "" With JiwaApplication.Manager.Instance.Database Try SQL = "SELECT HR_Staff.FName, HR_Staff.SName FROM HR_Staff " SQL += "INNER JOIN HR_CustomSettingValues On HR_Staff.StaffID = HR_CustomSettingValues.StaffID " SQL += "INNER JOIN HR_CustomSetting On HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID " SQL+= "WHERE HR_CustomSetting.SettingName = 'AuthoriseSalesOrders' AND HR_CustomSettingValues.Contents = '1' AND FName = @StaffName" Using SQLCmd As SqlCommand = New SqlCommand(SQL, .SQLConnection, .SQLTransaction) SQLParam = New SqlParameter("@StaffName", System.Data.SqlDbType.Char) SQLParam.Value = CustomFieldValue.Contents SQLCmd.Parameters.Add(SQLParam) SQLReader = .ExecuteReader(SQLCmd) If SQLReader.Read = True Then CustomFieldValue.DisplayContents = String.Format("{0} {1}", .Sanitise(SQLReader, "FName"), .Sanitise(SQLReader, "SName")) End If End Using SQLReader.Close() Finally If Not SQLReader Is Nothing Then SQLReader.Close() End If End Try End With End If End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaCustomFieldPlugin.ButtonClicked If CustomField.PluginCustomField.Name = "40-SalesPartNo" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 1 .UsePinBoard = False .Caption = "Sales PartNo" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "Partno" .SQLStr = "SELECT dbo.IN_Main.InventoryId, dbo.IN_Main.Partno, dbo.IN_Main.Description FROM dbo.IN_Main " .OrderBy = "ORDER BY Partno" .AddColumn("IDInventoryId", vbString, "", 0, 1) .AddColumn("Partno", vbString, "", 50, 2) .AddColumn("Description", vbString, "", 50, 3) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With ElseIf CustomField.PluginCustomField.Name.Trim = "43-Estate" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 2 .UsePinBoard = False .Caption = "Estate" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "Estate" .SQLStr = "SELECT dbo.CR_Main.CreditorId, dbo.CR_Main.AccountNo, dbo.CR_Main.Name FROM dbo.CR_Main INNER JOIN [dbo].[CN_Main] ON CR_Main.CreditorId=CN_Main.CreditorId INNER JOIN [dbo].[CN_GroupLink] ON CN_Main.ProspectId=CN_GroupLink.ProspectId AND CN_GroupLink.GroupId='ESTATE' " .OrderBy = "ORDER BY AccountNo" .AddColumn("CreditorId", vbString, "", 0, 1) .AddColumn("AccountNo", vbString, "", 50, 2) .AddColumn("Name", vbString, "", 50, 3) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With ElseIf CustomField.PluginCustomField.Name.Trim = "FXContract" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 3 .UsePinBoard = False .Caption = "FXContract" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "FXContract" .SQLStr = "SELECT TOP (100) PERCENT CR_ForwardCover.RecID, CR_ForwardCover.ContractNo, dbo.FX_Currency.ShortName, CR_ForwardCover.CurrencyRate, CR_ForwardCover.FXAmount - FXAmtValue AS CoverRemaining FROM dbo.CR_ForwardCover AS CR_ForwardCover INNER JOIN dbo.FX_Currency ON dbo.FX_Currency.RecID = CR_ForwardCover.FX_Main_RecID INNER JOIN (Select CR_ForwardCover_RecID, SUM(FXAmount) as FXAmtValue From dbo.CR_ForwardCoverTransactions Group By CR_ForwardCover_RecID) as CTran ON CR_ForwardCover.RecID = CTran.CR_ForwardCover_RecID WHERE (CR_ForwardCover.FXAmount - FXAmtValue) > 0 " .OrderBy = "ORDER BY ContractNo" .AddColumn("RecID", vbString, "", 0, 1) .AddColumn("ContractNo", vbString, "", 40, 2) .AddColumn("ShortName", vbString, "", 30, 3) .AddColumn("CurrencyRate", vbString, "", 30, 4) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApproval" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 4 .UsePinBoard = False .Caption = "ContractApproval" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "ContractApproval" .SQLStr = "SELECT HR_Staff.StaffID, HR_Staff.FName, HR_Staff.SName FROM HR_Staff INNER JOIN HR_CustomSettingValues ON HR_Staff.StaffID = HR_CustomSettingValues.StaffID INNER JOIN HR_CustomSetting ON HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID WHERE HR_CustomSetting.SettingName = 'AuthorisePurchaseOrders' AND HR_CustomSettingValues.Contents = '1' " .OrderBy = "ORDER BY FName" .AddColumn("StaffID", vbString, "", 0, 1) .AddColumn("FName", vbString, "", 50, 2) .AddColumn("SName", vbString, "", 50, 3) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApprovalSQ" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 5 .UsePinBoard = False .Caption = "ContractApproval" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "ContractApproval" .SQLStr = "SELECT HR_Staff.StaffID, HR_Staff.FName, HR_Staff.SName FROM HR_Staff INNER JOIN HR_CustomSettingValues ON HR_Staff.StaffID = HR_CustomSettingValues.StaffID INNER JOIN HR_CustomSetting ON HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID WHERE HR_CustomSetting.SettingName = 'AuthorisePurchaseOrders' AND HR_CustomSettingValues.Contents = '1' " .OrderBy = "ORDER BY FName" .AddColumn("StaffID", vbString, "", 0, 1) .AddColumn("FName", vbString, "", 50, 2) .AddColumn("SName", vbString, "", 50, 3) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With ElseIf CustomField.PluginCustomField.Name.Trim = "ContractApprovalSO" Then Dim AOption As JiwaApplication.JiwaSearch.SearchOption With JiwaApplication.Manager.Instance.Search .Clear() .FilterNo = 6 .UsePinBoard = False .Caption = "ContractApproval" AOption = New JiwaApplication.JiwaSearch.SearchOption With AOption .Title = "ContractApproval" .SQLStr = "SELECT HR_Staff.StaffID, HR_Staff.FName, HR_Staff.SName FROM HR_Staff INNER JOIN HR_CustomSettingValues ON HR_Staff.StaffID = HR_CustomSettingValues.StaffID INNER JOIN HR_CustomSetting ON HR_CustomSettingValues.SettingID = HR_CustomSetting.SettingID WHERE HR_CustomSetting.SettingName = 'AuthoriseSalesOrders' AND HR_CustomSettingValues.Contents = '1' " .OrderBy = "ORDER BY FName" .AddColumn("StaffID", vbString, "", 0, 1) .AddColumn("FName", vbString, "", 50, 2) .AddColumn("SName", vbString, "", 50, 3) End With .AddSearchOption(AOption) AOption = Nothing If .Show(FormObject) = DialogResult.OK Then CustomFieldValue.Contents = .Fields(2).FieldValue CustomFieldValue.DisplayContents = .Fields(2).FieldValue End If End With End If End Sub '***** 1 End Class Public Class LineCustomFieldPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaLineCustomFieldPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.FormatCell End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.ReadData End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaApplication.IJiwaLineCustomFieldPlugin.ButtonClicked End Sub End Class Public Class SystemSettingPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaSystemSettingPlugin Public Overrides Function InitializeLifetimeService() As Object ' returning null here will prevent the lease manager ' from deleting the Object. Return Nothing End Function Public Sub FormatCell(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.FormatCell End Sub Public Sub ReadData(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.ReadData End Sub Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaApplication.SystemSettings.Setting) Implements JiwaApplication.IJiwaSystemSettingPlugin.ButtonClicked End Sub End Class Public Class ScheduledExecutionPlugin Inherits System.MarshalByRefObject Implements JiwaApplication.IJiwaScheduledExecutionPlugin Public Sub Execute(ByVal Plugin As JiwaApplication.Plugin.Plugin, ByVal Schedule As JiwaApplication.Schedule.Schedule) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.Execute End Sub Public Sub OnServiceStart(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStart End Sub Public Sub OnServiceStopping(ByVal Plugin As JiwaApplication.Plugin.Plugin) Implements JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStopping End Sub End Class Report VisualBasic a837ba6c-4575-45fe-bb44-c50866b51ee6 Inventory Maintenance JiwaFinancials.Jiwa.JiwaInventoryUI.InventoryMaintenanceForm 43140ef2-2369-49c9-b527-e6c554e8a0f9 Debtor Maintenance JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor feb59440-471f-43e9-8b60-26812cdb50ae JiwaApplication, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll 81868dc9-1fcd-4f7c-86c3-2d499bea3c5f mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll f16222f2-16e6-4e39-b338-4231d1366251 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll c2021065-259c-4571-b4b7-259f5e61817c System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll 9c9b58fe-b388-40e3-adb6-3bd3c77ac279 JiwaODBC, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll 6ed7630a-99a3-41c4-a223-70e22e186c0d System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll 58edc0bc-04d7-4d93-bd10-71ed0975a446 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll 07b9bf50-3866-4ff1-9916-02262c593d58 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll e6394949-2e95-4c58-a2ed-fe41444b8679 Microsoft.SqlServer.Smo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll e960f489-76c2-4c77-a131-98ea508275ce Microsoft.SqlServer.ConnectionInfo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll bf1bae66-1335-4e44-84f1-fc28e2be324f System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 87a1f040-a25f-486d-aa6c-9439f4b6bc91 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.v13.1.dll 463af8b4-cc86-48c4-a2da-5b4c5d3d696c Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll 54f70b82-f976-4ef9-874f-a322c1475dfc Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll c71fca2b-6ffa-4036-8dc0-892b38f0ffaf Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll fe8df9a7-9669-4bcf-9b01-2c45307e58f1 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 56ed0395-0042-4337-a95a-e2a018eb0248 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll 758180ce-924d-43fa-b4d2-bb263873fa3d FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.Spread.dll 08e3d7b1-475b-4773-b570-5193253022bc Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll 249405d1-4b56-4586-8a56-d07f7a167ae9 Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll 06582eeb-baf7-471b-bf33-3ef1cc3c4919 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 9e01059b-b7cf-4da4-a79d-0338a3773fc3 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll 48b62f0b-67f4-494d-9c18-451533b999e5 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 2f66f9da-5bd5-4551-9317-6f1691e6f7cf ServiceStack, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll 52d2602f-bcf2-4058-802c-c7caf05be576 ActiproSoftware.SyntaxEditor.WinForms, Version=12.1.304.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll d5adc539-9439-4756-bb96-3542dff6b251 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll e6d824f1-fbb5-44c5-b22a-f1d12c6533d4 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=12.1.304.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 805f26b4-a7d4-444c-9232-3927f6d360ab JiwaEncryption, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll 2161fbd3-076d-4a8f-9ce4-7efd44ea67f7 Microsoft.SqlServer.Dac, Version=13.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll 910d84a7-0e8e-4fa2-85a4-2dac1663d111 CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.2000.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll 211945db-a1d2-4e7f-82d4-e6055511ca30 CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.2000.0__692fbea5521e1304\CrystalDecisions.Shared.dll 054df80d-4dfe-4d9c-9e0b-7ee8b65b0d5c CrystalDecisions.ReportAppServer.Controllers, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll 2c9692c0-025a-4d42-81f1-33e9cba42b27 System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 0d643140-1930-4f00-b5de-9f86cf351829 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 48fee762-f1c9-4a0e-ad20-1408f252d681 JiwaLib, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 3d30c91e-b226-4c8d-b09c-2dcf7f63d740 Microsoft.ApplicationInsights, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 51e5b072-8f63-49df-8b23-b40305cd9719 CrystalDecisions.Windows.Forms, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.2000.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll b2fbaa35-7e9c-4742-8e63-65b88066e859 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll 4b342428-0657-49cf-b760-2c055e30d1a8 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Shared.v13.1.dll 206f8c12-f2f8-4e6b-8ffb-0c113f294122 Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c Microsoft.Office.Interop.Outlook.dll C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll 68f164cf-2310-412c-9d80-f72fedad472e ActiproSoftware.Shared.WinForms, Version=12.1.304.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll b933b203-7dc4-4255-84d8-f45445fec82e FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.dll 99614a12-fb2d-44f5-8fd4-197e6d2da28b System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 70c084df-08bb-4d13-b263-525a4d188e87 CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll c52dfb3b-147f-423d-a915-5c80e40d669c CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.2000.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll a052f043-af35-4129-82c0-541e37271a2d ServiceStack.Interfaces, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll cda6a591-c9df-4af1-8ec0-1cca48047f82 ServiceStack.Server, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll cbb852dd-3f46-4163-acad-198c325e3d1a ServiceStack.OrmLite, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll f5e01a28-a4ff-40ba-989c-66d85aaf63d8 JiwaInventoryUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaInventoryUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaInventoryUI.dll 0d1a749f-cff6-404c-baf1-04279dfc0837 JiwaInventory, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaInventory.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaInventory.dll 4a58e283-3748-41a8-9bc2-979495c0d50a JiwaDebtorsUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtorsUI.dll 2db94cb3-5f8c-4935-91e4-6c3c1fb1ec9c JiwaDebtors, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtors.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtors.dll 06039449-12c9-47bd-b766-ce1640a748f0 JiwaDebtorAdjustments, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorAdjustments.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtorAdjustments.dll e5c235f8-1b6e-477f-ad74-78ba2080be9d JiwaDebtorInvoices, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorInvoices.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtorInvoices.dll cc30b470-87f3-4999-b222-7122e080a8eb JiwaCashBookUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBookUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaCashBookUI.dll e074b314-f278-40e6-bada-5ea75db80648 JiwaDebtorAdjustmentsUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorAdjustmentsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtorAdjustmentsUI.dll 4965b638-9f60-43dc-9baf-7e76838462eb JiwaDebtorInvoicesUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorInvoicesUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaDebtorInvoicesUI.dll 264be128-c9aa-481e-8e07-d04968e6ec22 JiwaCashBook, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBook.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaCashBook.dll d304d780-0792-41ad-af6c-c2cad214277f JiwaSalesUI, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSalesUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaSalesUI.dll d50eda35-11b4-48b9-8e2d-8d3348839ea2 LumenWorks.Framework.IO, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c LumenWorks.Framework.IO.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\LumenWorks.Framework.IO.dll 2b830849-f0b8-4311-9e0c-4ce50abf64df System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.Linq.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll C2DC4BF0-58F3-4E22-B078-84DD56977FD9 Custom Field 1 Custom Field 1 1 Text Creditor Maintenance 5D33BC06-BE52-49D6-ABDA-81717D02A71B Custom Field 2 Custom Field 2 2 Text Creditor Maintenance CD26940A-0406-4BDB-A712-71C148F9BB30 Custom Field 3 Custom Field 3 3 Text Creditor Maintenance FD27871D-5AA4-429A-9BB7-9F41ECFBA9C9 Custom Field 4 Custom Field 4 4 Text Creditor Maintenance FarmSize FarmSize Farm Size (Hectares) 5 Integer Creditor Maintenance Region Region Region/Area 6 Text Creditor Maintenance Soil Soil Soil 7 Text Creditor Maintenance MinAltitude MinAltitude Minimum Altitude (m) 8 Integer Creditor Maintenance MaxAltitude MaxAltitude Maximum Altitude (m) 9 Integer Creditor Maintenance ShowEstate Show as Filter Show this Estate as a filter on the Neotek website 10 Checkbox Creditor Maintenance 2B66F015-1E26-4451-8036-E873B9110285 BankDetails To Include Credit card option on Invoice 4 Checkbox Debtor Maintenance CAD57200-EE5D-4E17-97EB-331396F2DA11 AlternateDays Alternate Days of Payment for Tea 5 Text Debtor Maintenance Restricted Restricted Restrict products which this Debtor sees on the Neotek website, to products which have a price defined on one of the following Pricing tabs on the inventory maintenance screen: Debtor Specific, Debtor Class Specific, Selling or Group Pricing. 6 Checkbox Debtor Maintenance FlowID Flow ID Indicates the debtor is registered as a Fair Trade customer. 7 Text Debtor Maintenance DefaultDeliveryDays Default Delivery Days Lead time in days from order to delivery. Initial values set based on State, as follows: WA - 7, QLD - 5, TAS - 4, NSW, SA, ACT - 3 8 Integer Debtor Maintenance QuoteOnly Quote Only Indicates if debtor can only request a quote or confirm delivery of reserved orders. 9 Checkbox Debtor Maintenance EnableDeliveryCutoff Enable Delivery Days Enable the use of specific delivery days 10 Checkbox Debtor Maintenance MondayCutoff Monday Monday 11 Checkbox Debtor Maintenance TuesdayCutoff Tuesday Tuesday 12 Checkbox Debtor Maintenance WednesdayCutoff Wednesday Wednesday 13 Checkbox Debtor Maintenance ThursdayCutoff Thursday Thursday 14 Checkbox Debtor Maintenance FridayCutoff Friday Friday 15 Checkbox Debtor Maintenance NeotekCallCode NeotekCallCode Code used in the Neotek sales system to determine the call cycle an account is rostered on. A - 4 days, B - 6, C - 8. 16 Text Debtor Maintenance 284CB820-47A6-49EF-9C64-25BF4AA3B9F0 AuthoriseSalesOrders Able to Authorise Sales Orders 1 Checkbox Staff Maintenance 5E1621BE-141C-440E-B084-32FB85D31945 AuthoriseSalesQuotes Able to Authorise Sales Quotes 2 Checkbox Staff Maintenance 6633580B-CA5C-452E-8277-691BD5C68B80 AuthorisePurchaseOrders Able to Authorise Purchase Orders 3 Checkbox Staff Maintenance 2 01-PalletSize No of Bags or Cartons per Pallet 1 Integer Inventory Maintenance 5 10-InnerUnit InnerUnits 4 Text Inventory Maintenance BagType 20-Packaging Packaging 5 Text Inventory Maintenance PackSize Carton Size Restrict the quantities this product may be ordered on the Neotek website (eg. if set to 5 then - this product may only be ordered in multiples of 5) 8 Integer Inventory Maintenance Grade 21-Screen1 Screen1 9 Integer Inventory Maintenance Screen 22-Screen2 Screen2 12 Integer Inventory Maintenance Varietal 22-Varietal Varietal 13 Text Inventory Maintenance 476988ed-7af5-4ca6-a948-1adad8be0c28 WebSpecial Check this box for Web Special Items 14 Checkbox Inventory Maintenance 4 23-BlendComponents Components of the Blend 15 Text Inventory Maintenance BeanAppearance 24-Appearance Appearance 16 Text Inventory Maintenance LiquorColour 25-Liquor Colour Liquor Colour 17 Text Inventory Maintenance HarvestDate 37-Grade Grade 18 Text Inventory Maintenance PONumber 39-PONumber PO Number 19 Text Inventory Maintenance SalesPartNo 40-SalesPartNo Sales Part No 20 Lookup Inventory Maintenance LotNumber 40-LotNumber LotNumber 21 Text Inventory Maintenance Exporter 41-Exporter Exporter 22 Text Inventory Maintenance CropYear 42-CropYear Crop Year 23 Text Inventory Maintenance ESTATE 43-Estate Estate 24 Lookup Inventory Maintenance BeanDensity 44-BeanDensity Bean Density (Kg/hl) 25 Float Inventory Maintenance MoistureContent 45-MoistureContent Moisture Content (%) 26 Float Inventory Maintenance ScreenType1 46-ScreenType1 Screen Type 1 27 Text Inventory Maintenance ScreenSize1 47-ScreenSize1 Screen Size 1 28 Integer Inventory Maintenance ScreenPerc1 48-ScreenPerc1 Screen % 1 29 Integer Inventory Maintenance ScreenType2 49-ScreenType2 Screen Type 2 30 Text Inventory Maintenance ScreenSize2 50-ScreenSize2 Screen Size 2 31 Integer Inventory Maintenance ScreenPerc2 51-ScreenPerc2 Screen % 2 32 Integer Inventory Maintenance ScreenType3 52-ScreenType3 Screen Type 3 33 Text Inventory Maintenance ScreenSize3 53-ScreenSize3 Screen Size 3 34 Integer Inventory Maintenance ScreenPerc3 54-ScreenPerc3 Screen % 3 35 Integer Inventory Maintenance Fragrance 60-Fragrance Fragrance / Aroma 36 Float Inventory Maintenance Flavour 61-Flavour Flavour 37 Float Inventory Maintenance Aftertaste 62-Aftertaste Aftertaste 38 Float Inventory Maintenance Acidity 63-Acidity Acidity 39 Float Inventory Maintenance Body 64-Body Body 40 Float Inventory Maintenance Balance 65-Balance Balance 41 Float Inventory Maintenance CuppingScore 71-CuppingScore Q Cupping Scores 42 Float Inventory Maintenance CuppingScoreDesc 72-CuppingScoreDesc Q Cupping Score Description 43 Text Inventory Maintenance CuppingNotes 73-TastingNotes Tasting Notes 44 Text Inventory Maintenance OptimalRoastColour 74-OptimalRoastColour Optimal Roast Colour 45 Text Inventory Maintenance LotCreated 80-LotCreated Lot Created Date 46 Date Inventory Maintenance Defects 99-Defects Defects 47 Text Inventory Maintenance UntilDate New Until Set the product to be marked as "New" on Neotek website until given date. 48 Date Inventory Maintenance ETADate ETA Date Set the product to be marked as "Coming Soon" on Neotek website until given date. 49 Date Inventory Maintenance AEE51BC9-AE54-4082-BDA2-7E70F0C408DE Arbitration Arbitration 1 Combo Purchase Order 7DCAE3CF-527C-4E41-A961-70370AE11987 Insurance Insurance 2 Combo Purchase Order 8582C3EC-235C-494F-988A-B61B03C72756 Container Container 3 Text Purchase Order DE50661B-0B0F-40AE-8EC4-286D979C4C0B MonthYearofNYMarketContract Month Year of NY Market Contract 4 Text Purchase Order 7BA7CFC7-A86A-4752-A1D4-44DD05A10D46 MonthYearofLondonMarketContract Month Year of London Market Contract 5 Text Purchase Order 7BC9D714-8889-44FD-8A92-78A3FC14930A Franchise Franchise 6 Combo Purchase Order CFA4965F-4C5B-4374-A15A-B2536D0C41F2 PaymentType Payment Type 7 Combo Purchase Order EE675E97-1C26-4F9A-B89E-796677112C2D DocumentaryRequirements Include Ususal Documentary Requirements 8 Checkbox Purchase Order DE24EE00-D7C0-44BA-8127-6C418CCE04CF AQIS Note Include AQIS Note on Contract 9 Checkbox Purchase Order 25AD7701-AC6D-48C0-AE89-2FF381268C8A ShippingPeriod Shipping Period 10 Combo Purchase Order 3A9AB1DB-3B07-4B53-939E-9F53289CD6CE YearOfShipment Year Of Shipment 11 Text Purchase Order 0FD7A233-FBA9-49BC-B7D7-2C707CC14075 SupplierReference Supplier Reference 12 Text Purchase Order FC7BE7F3-2310-4359-B2E1-B8F21C50CF85 FXContract Select the Foreign Currency Contract To Use 13 Lookup Purchase Order 92497DDF-C069-4248-828B-56D3CE33DB57 ContractApproval Who has approved the contract? 14 Lookup Purchase Order B0D9B13E-5B72-4350-8585-C883E9017EF4 PreShippingSample Is Pre Shipping Sample Required 15 Checkbox Purchase Order 582C0348-CD2D-42A8-AC3B-BD70E8F83026 PreShipmentSampleReceived Check if Pre Shipment Sample Has Been Received 16 Checkbox Purchase Order EB0FA39CA8054773B7F9 PricingBasis What is the basis for pricing? 1 Combo Sales Quote 99A5CFED55944F299578 DTSLocation DTS Location 2 Text Sales Quote CA9E0FA76FB34EF09D9E ContractApprovalSQ Who has approved this quote? 3 Lookup Sales Quote 24E57E4EC8F54762BDFF ValidDays No of days the quote is valid for 4 Integer Sales Quote 4686B2D8604442E5AB84 PrcingBasis Pricing Based On 1 Combo Sales Order 80EA8068150343719241 IncludeAQISNote Include AQIS Note on Contract 2 Checkbox Sales Order 4EB99444B5284E8A8783 ContractApprovalSO Who has approved this contract? 3 Lookup Sales Order 0405FE2379B54E61805F TickToIncludeOnContract Tick to include PO Ref on Contract 4 Checkbox Sales Order FF900E1AAE654B14B0F7 HABPORef HAB PO Ref 5 Text Sales Order 733466BA-4405-460E-AA06-39B37AED83FF 25-LiquorColour LiquorColour 6 Text Sales Order DateReleasedToWeb DateReleasedToWeb Neotek Latest date the SO was released to web. 7 Text Sales Order Email Email Email address of person who placed order 8 Text Sales Order PaymentRef PaymentRef Payment Gateway Transaction Reference 9 Text Sales Order WebRef WebRef Neotek Website Order Number 10 Text Sales Order 13C7E435-6B64-4A56-A246-40CDC52B2F85 FlowID Flow ID 11 Text Sales Order 15930033-4d4c-42d2-a9a0-78a587147a33 Contract Tick if this is a Contract 11 Checkbox Sales Order 969b9538-4f5c-43e5-a554-11741b345b75 PO_No On Purchase Order Number 1 Lookup Sales Order Line 6CAEA658-7C5B-41C7-9C16-D653ACA349C0 Sundry 1 1 Text Shipments 37E38311-12D8-4F29-9992-DC4B4E05815A Sundry 2 2 Text Shipments 60E765E7-FA3E-4A35-AE61-985C48295B2D Sundry 3 3 Text Shipments C1641AFD-F9DA-4547-9919-941ED5DA466A Sundry 4 4 Text Shipments E99F8A19-736F-4806-B588-15E73355C086 Sundry 5 5 Text Shipments DE06366E-01F1-42E5-A4DA-11A5651FC977 Sundry 6 6 Text Shipments 0A94D4AC-0E16-4EB9-A45C-0E253FCC8664 Sundry 7 7 Text Shipments 370F0A16-7592-46EA-9D89-37CDAEC8EADE Sundry 8 8 Text Shipments 4DF48EC8-B7AD-4500-887B-47246CC83F3A Sundry 9 9 Text Shipments 3EA04CE9-4910-428B-A4E2-5D0EAE22DAC5 Sundry 10 10 Text Shipments eb7e79b9-c830-4c02-8657-810b7e36bd50 PriceType Price Type 1 Combo Purchase Order Lines