Contents tagged with Acumatica prefix usr

  • Acumatica modification existing tables with prefix Usr

    Hello everybody,

    today just a short hint. In case if you want to add some column in Acumatica DB, you should start field from usr prefix. For exaple if you want to add field Payrollcat, you should name it UsrPayrollcat. If you'll not use this advice, next update of Acumatica will remove your field, and you'll be very sad.

    For example you can use following template of code:

    IF EXISTS (SELECT * FROM SYS.columns WHERE name = N'UsrPayrollcat' and object_id = OBJECT_ID(N'PRPayrollDetails'))






    Alter table PRPayrollDetails

    ADD UsrPayrollcat nvarchar(1) NULL

    PRINT 'Column UsrPayrollcat was … more