Acumatica пользовательская таблица и ошибка создания снимка ⇐ MySql

[Anonymous]

для myob acumatica у меня есть пользовательская таблица, которую я создаю для MySQL: < /p>

Код: Выделить всё

CREATE TABLE IF NOT EXISTS PMProjectServiceEquipment
(
ID INT AUTO_INCREMENT PRIMARY KEY,
ProjectID INT NULL,
ServiceEquipmentID INT NULL,

-- Acumatica system columns
CompanyID INT NOT NULL DEFAULT 1,
tstamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

NoteID CHAR(36) NULL,

CreatedByID CHAR(36) NULL,
CreatedByScreenID CHAR(8) NULL,
CreatedDateTime DATETIME NULL,

LastModifiedByID CHAR(36) NULL,
LastModifiedByScreenID CHAR(8) NULL,
LastModifiedDateTime DATETIME NULL
);
< /code>
У меня есть соответствующий ЦАП, как < /p>
using System;
using PX.Data;
using PX.Data.BQL;
using PX.Objects.PM;
using PX.Objects.FS;

namespace MyCustomisation
{
[Serializable]
public class PMProjectServiceEquipment : PXBqlTable, IBqlTable
{
#region ID
[PXDBIdentity(IsKey = true)]  // Auto-increment primary key
[PXUIField(DisplayName = "Record ID")]
public virtual int? ID { get; set; }

public abstract class id : BqlInt.Field { }
#endregion

#region ProjectID
[PXDBInt]
[PXUIField(DisplayName = "Project", Visibility = PXUIVisibility.SelectorVisible)]
[PXSelector(typeof(Search
),
SubstituteKey = typeof(PMProject.contractCD),
DescriptionField = typeof(PMProject.description))]
public virtual int? ProjectID { get; set; }
public abstract class projectID : BqlInt.Field { }
#endregion

#region ServiceEquipmentID
[PXDBInt]
[PXUIField(DisplayName = "Service Equipment", Visibility = PXUIVisibility.SelectorVisible)]
[PXSelector(typeof(Search),
typeof(FSEquipment.refNbr),
typeof(FSEquipment.descr),
typeof(FSEquipment.equipmentTypeID),
typeof(FSEquipment.serialNumber),
typeof(FSEquipment.ownerID),
SubstituteKey = typeof(FSEquipment.refNbr),
DescriptionField = typeof(FSEquipment.descr))]
public virtual int? ServiceEquipmentID { get; set; }
public abstract class serviceEquipmentID : BqlInt.Field { }
#endregion

#region NoteID
[PXNote] // maps to CHAR(36) in MySQL here
public virtual Guid? NoteID { get; set; }
public abstract class noteID : BqlGuid.Field { }
#endregion

#region Audit columns (MUST use these attributes)
[PXDBCreatedByID]
public virtual Guid? CreatedByID { get; set; }

public abstract class createdByID : BqlGuid.Field { }

[PXDBCreatedDateTime]
public virtual DateTime? CreatedDateTime { get; set; }

public abstract class createdDateTime : BqlDateTime.Field { }

[PXDBLastModifiedByID]
public virtual Guid? LastModifiedByID { get; set; }

public abstract class lastModifiedByID : BqlGuid.Field { }

[PXDBLastModifiedDateTime]
public virtual DateTime? LastModifiedDateTime { get; set; }

public abstract class lastModifiedDateTime : BqlDateTime.Field { }

[PXDBCreatedByScreenID]
public virtual string CreatedByScreenID { get; set; }

public abstract class createdByScreenID : PX.Data.BQL.BqlString.Field { }

[PXDBLastModifiedByScreenID]
public virtual string LastModifiedByScreenID { get; set; }

public abstract class lastModifiedByScreenID : PX.Data.BQL.BqlString.Field { }

[PXDBTimestamp]
public virtual byte[] Tstamp { get; set; } // concurrency token

public abstract class tstamp : BqlByteArray.Field { }
#endregion
}
}

У меня есть настройка экрана и работа, как и ожидалось. Таким образом, я настраиваю стол или ЦАП? Может быть, потому что MySQL помещает имя таблицы в нижний чехол?
Любая помощь будет оценена.

Подробнее здесь: https://stackoverflow.com/questions/797 ... g-snapshot