.. index::
   ACCOUNT_P_AND_L_SPREADSHEET_ML

==============================
ACCOUNT_P_AND_L_SPREADSHEET_ML
==============================

.. default-role:: doc

:Description:

    Table used in Solutions AccountMapper program to fill the data in bottom search box. Downloaded from a Rutgers source (ask Cornelia Kinsella for source)



Columns
=======


**ID** ``int(11) NOT NULL``

   :Description:

       id primary key

   :Options:

      ``display="true", null="true", search="false", type=""``


**PARENT** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**VALUE** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**RANGE** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**DESCRIPTION** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**ACCOUNT TYPE** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**COMMENT/DEFINITION** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**RU Owner** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**Oracle** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**Banner** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**Team Comments** ``varchar(255) DEFAULT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()``

   :Options:

      ``display="true", null="true", search="false", type=""``