This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<sm:SiteMap xmlns:sm="http://acumatica.com/mobilesitemap" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> | |
<sm:Screen Id="GL301000" Type="SimpleScreen" DisplayName="Journal Transactions" Visible="true" Icon="system://NewsPaper" IsDefaultFavorite="true"> | |
<sm:Container Name="BatchSummary" FieldsToShow="3"> | |
<sm:Attachments Disabled="true" /> | |
<sm:Field Name="BatchNumber" /> | |
<sm:Field Name="TransactionDate" /> | |
<sm:Field Name="Description" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public class DatabaseSlotsExample : IPrefetchable | |
{ | |
protected List<string> values = new List<string>(); // store your values here | |
public static List<string> Values | |
{ | |
get | |
{ | |
//Get the values from the slot dynamically. By providing table name, you inform system when it should reset the slot. | |
return PXDatabase.GetSlot<DatabaseSlotsExample>("SlotSuperKey", typeof(YourTable)).values; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Collections.Specialized; | |
using System.Data.SqlClient; | |
using System.Diagnostics; | |
using System.Runtime.ExceptionServices; | |
using System.Runtime.Serialization; | |
using System.Text; | |
using System.Threading; | |
using System.Web; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public static class Logger | |
{ | |
private const uint HRFileLocked = 0x80070020; | |
private const uint HRPortionOfFileLocked = 0x80070021; | |
[ThreadStatic] | |
private static bool IsRecursive; | |
public static void Initialise() | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
if exists(select * from sys.objects where object_id = object_id('sp_GetBalanceSheet')) | |
drop function sp_GetBalanceSheet | |
go | |
CREATE FUNCTION dbo.sp_GetBalanceSheet(@period char(6)) | |
RETURNS @statistics TABLE ( | |
CompanyID int not null default(0), | |
Code int not null Identity(1,1), | |
BranchID int not null, | |
Description nvarchar(255) not null, | |
Balance decimal(19,4) not Null |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
namespace PX.Objects.GL | |
{ | |
using System; | |
using PX.Data; | |
[System.SerializableAttribute()] | |
public class StatisticsView : PX.Data.IBqlTable | |
{ | |
#region Code | |
public abstract class code : PX.Data.IBqlField |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#region Filter | |
[Serializable] | |
public class YearFilter : IBqlTable | |
{ | |
#region Year | |
public abstract class year : PX.Data.IBqlField { } | |
[PXDBInt()] | |
[PXDefault(2014)] | |
[PXUIField(DisplayName = "Year")] | |
[PXIntList(new Int32[] { 2013, 2014, 2015}, new String[] { "2013", "2014", "2015"})] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public class YearGroupMaint : PXGraph<YearGroupMaint> | |
{ | |
public PXFilter<YearFilter> Filter; | |
//[PXVirtualDAC] | |
public PXSelect<VirtualComparasion> Comparasions; | |
public PXSelect<YearGroup, Where<YearGroup.year, Equal<Required<YearGroup.year>>, Or<YearGroup.year, Equal<Required<YearGroup.year>>>>> YearGroups; | |
public PXCancel<YearFilter> Cancel; | |
public IEnumerable comparasions() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public class SOOrderExtension : PXCacheExtension<PX.Objects.SO.SOOrder> | |
{ | |
#region CustomerLocationID | |
public abstract class customerLocationID : PX.Data.IBqlField | |
{ | |
} | |
[PXMergeAttributesAttribute(Method = MergeMethod.Merge)] | |
[PXCustomizeSelectorColumns( | |
typeof(PX.Objects.CR.Location.locationCD), | |
typeof(PX.Objects.CR.Location.descr), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table #space | |
( | |
tn varchar(128), | |
rows varchar(128), | |
reserved varchar(128), | |
data varchar(128), | |
indexp varchar(128), | |
unused varchar(128) | |
) |
OlderNewer