Skip to content

Instantly share code, notes, and snippets.

@patrick711
Last active June 4, 2020 16:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patrick711/8cde1aaf8da0069d75a59626edd6fdb9 to your computer and use it in GitHub Desktop.
Save patrick711/8cde1aaf8da0069d75a59626edd6fdb9 to your computer and use it in GitHub Desktop.
This is an example of a DAC Extension Table, linking to the Warehouse table in Acumatica.
[Serializable]
[PXCacheName("Warehouse Trading Partner")]
[PXTable(typeof(INSite.siteID), IsOptional = true)]
public class ISPSMapadocINSiteExtension : PXCacheExtension<INSite>
{
#region Siteid
[PXDBInt(IsKey = true)]
[PXUIField(DisplayName = "Siteid")]
public virtual int? Siteid { get; set; }
public abstract class siteid : PX.Data.BQL.BqlInt.Field<siteid> { }
#endregion
#region Spstp
[PXDBBool()]
[PXUIField(DisplayName = "EDI Warehouse")]
public virtual bool? Spstp { get; set; }
public abstract class spstp : PX.Data.BQL.BqlBool.Field<spstp> { }
#endregion
#region SPSLastModifiedDateTime
[PXDBDate()]
[PXUIField(DisplayName = "Last Modified Date Time")]
public virtual DateTime? SPSLastModifiedDateTime { get; set; }
public abstract class sPSLastModifiedDateTime : PX.Data.BQL.BqlDateTime.Field<sPSLastModifiedDateTime> { }
#endregion
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment