Contents tagged with User defined fields

  • How to add User defined fields to any entity in Acumatica

    Hello everybody,

    today I want to describe how at code level you can add User defined fields in Acumatica to any entity. Sequence will be this:

    In PXDataSource add attribute EnableAttributes. It may look like this:

    <px:PXDataSource EnableAttributes="true" ID="ds" 

    2. For target entity create table with same name, but with suffix KvExt. Query for creation of such a table may look like this:

    CREATE TABLE [[TargetTable]KvExt](

    [CompanyID] [int] NOT NULL,

    [RecordID] [uniqueidentifier] NOT NULL,

    [FieldName] [varchar](50) NOT NULL,

    [ValueNumeric] [decimal](28, 8) NULL,

    [ValueDate] [datetime] NULL,

    [ValueString] [nvarchar](256) NULL,

    [ValueText] [nvarchar](max) NULL,

      … more