View GLBatch.xml
<?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" /> |
View DatabaseSlot.cs
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; |
View SessionLogger.cs
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; |
View Logger.cs
public static class Logger | |
{ | |
private const uint HRFileLocked = 0x80070020; | |
private const uint HRPortionOfFileLocked = 0x80070021; | |
[ThreadStatic] | |
private static bool IsRecursive; | |
public static void Initialise() | |
{ |
View TableValuedSQL.sql
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 |
View TableValuedDAC.cs
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 |
View VirtualDACs.cs
#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"})] |
View VirtualMaint.cs
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() |
View SelectorColumn.cs
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), |
View TableSpace.sql
create table #space | |
( | |
tn varchar(128), | |
rows varchar(128), | |
reserved varchar(128), | |
data varchar(128), | |
indexp varchar(128), | |
unused varchar(128) | |
) |
OlderNewer