Today I needed to get all columns of specifict table.
SQL which you can use for this purpose is the following:
SELECT COLUMN_NAME 'All_Columns' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Specific table' more
Today I want in short share screen numering in Acumatica.
Let's say we have screen number like this: xx.yy.zz.tt
in that case
yy is screen sequential number
zz is screen type: 10 - setup, 20 - Maintenance, 30 - data entry, 40 - inquiry, 50 - processing, 60 - reports.
tt is sub screen sequential number