text: ﻿CREATE TABLE [dbo].[ADNO_Non-Admin_WithProratedAmounts] (
      [loc]             CHAR (2)        NULL,
      [dept]            CHAR (3)        NULL,
      [proj]            CHAR (4)        NULL,
      [project]         VARCHAR (24)    NULL,
      [accession]       CHAR (7)        NULL,
      [PI]              VARCHAR (30)    NULL,
      [f201]            DECIMAL (16, 2) NULL,
      [f202]            DECIMAL (16, 2) NULL,
      [f203]            DECIMAL (16, 2) NULL,
      [f204]            DECIMAL (16, 2) NULL,
      [f205]            DECIMAL (16, 2) NULL,
      [f231]            DECIMAL (16, 2) NULL,
      [f219]            DECIMAL (16, 2) NULL,
      [f219_prorate]    DECIMAL (16, 2) NULL,
      [f219_plus_admin] DECIMAL (16, 2) NULL,
      [f209]            DECIMAL (16, 2) NULL,
      [f310]            DECIMAL (16, 2) NULL,
      [f308]            DECIMAL (16, 2) NULL,
      [f311]            DECIMAL (16, 2) NULL,
      [f316]            DECIMAL (16, 2) NULL,
      [f312]            DECIMAL (16, 2) NULL,
      [f313]            DECIMAL (16, 2) NULL,
      [f314]            DECIMAL (16, 2) NULL,
      [f315]            DECIMAL (16, 2) NULL,
      [f318]            DECIMAL (16, 2) NULL,
      [f332]            DECIMAL (16, 2) NULL,
      [f220]            DECIMAL (16, 2) NULL,
      [f220_prorate]    DECIMAL (16, 2) NULL,
      [f220_plus_admin] DECIMAL (16, 2) NULL,
      [f22F]            DECIMAL (16, 2) NULL,
      [f221]            DECIMAL (16, 2) NULL,
      [f221_prorate]    DECIMAL (16, 2) NULL,
      [f221_plus_admin] DECIMAL (16, 2) NULL,
      [f222]            DECIMAL (16, 2) NULL,
      [f222_prorate]    DECIMAL (16, 2) NULL,
      [f222_plus_admin] DECIMAL (16, 2) NULL,
      [f223]            DECIMAL (16, 2) NULL,
      [f223_prorate]    DECIMAL (16, 2) NULL,
      [f223_plus_admin] DECIMAL (16, 2) NULL,
      [f233]            DECIMAL (16, 2) NULL,
      [f234]            DECIMAL (16, 2) NULL,
      [f241]            DECIMAL (16, 2) NULL,
      [f241_prorate]    DECIMAL (16, 2) NULL,
      [f241_plus_admin] DECIMAL (16, 2) NULL,
      [f242]            DECIMAL (16, 2) NULL,
      [f242_prorate]    DECIMAL (16, 2) NULL,
      [f242_plus_admin] DECIMAL (16, 2) NULL,
      [f243]            DECIMAL (16, 2) NULL,
      [f243_prorate]    DECIMAL (16, 2) NULL,
      [f243_plus_admin] DECIMAL (16, 2) NULL,
      [f244]            DECIMAL (16, 2) NULL,
      [f244_prorate]    DECIMAL (16, 2) NULL,
      [f244_plus_admin] DECIMAL (16, 2) NULL,
      [f350]            DECIMAL (16, 2) NULL
  );
  
  