table.schemaName = "PAL";
table.tableType = COLUMNSTORE;
table.description = "COPA Data";
table.columns = [
        {name = "Customer"; sqlType = NVARCHAR; nullable = false; length = 10; },
        {name = "Material"; sqlType = NVARCHAR; nullable = false; length = 7; },
        {name = "FiscPer"; sqlType = NVARCHAR; nullable = false; length = 7; },
        {name = "Period"; sqlType = NVARCHAR; nullable = false; length = 2; },
        {name = "FiscalYear"; sqlType = NVARCHAR; nullable = false; length = 4; },
        {name = "Currency"; sqlType = NVARCHAR; nullable = false; length = 3; },
        {name = "Unit"; sqlType = NVARCHAR; nullable = false; length = 2; },
        {name = "GrossAmount"; sqlType = DOUBLE; nullable = false; defaultValue = "0";},
        {name = "Quantity"; sqlType = DOUBLE; nullable = false; defaultValue = "0";}
];
table.primaryKey.pkcolumns = [ "Customer" , "Material" , "FiscPer" ];