.. _accounts-schema:

#############################
ACCOUNTS Data Table Columns
#############################

+---+---+----------------+-----+---+----------------------+--------+-----+-----+
|REQ| SM| COLUMN NAME    | TYPE| UC|VALIDATE              | DEFAULT| JUST| NOTE|
+===+===+================+=====+===+======================+========+=====+=====+
| -- -- -- -- -- -- -- -- -- -- -- -- Keys and Descriptions                    |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | ACCOUNT        | A   | U | VT=CONTACTS          |        | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | NAME           | AN  |   |                      |        | L30 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| -- -- -- -- -- -- -- -- -- -- -- -- Addresses                                |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | M | ADDRESSCODE    | AN  | U | A                    | null   | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESS        | AN  | U | VT=CONTACTS          | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESSCODE    | AN  | U | ST                   | null   | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESS        | AN  | U | VT=CONTACTS          | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESSCODE    | AN  | U | BT                   | null   | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESS        | AN  | U | VT=CONTACTS          | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESSCODE    | AN  | U | PF                   | null   | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | M | ADDRESS        | AN  | U | VT=CONTACTS          | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| -- -- -- -- -- -- -- -- -- -- -- -- Billing & Storage Terms                  |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | TERMS          | AN  | U | :ref:`terms-list`    | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | INVOICING      | AN  | U | :ref:`invoicing-list`| null   | L2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | PONUMBER       | AN  | U |                      | null   | L2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| O | S | DEFERHANDLING  | N.4 | U |                      | null   | R2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | RECEIVING      | AN  | U | :ref:`receiving-list`| null   | L2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | RECURRING      | AN  | U | :ref:`recurring-list`| null   | L2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| O | S | FREEDAYS       | N.0 | U |                      | null   | R2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| O | S | GRACEDAYS      | N.0 | U |                      | null   | R2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | VALUEDECLARED  | N.2 | U |                      | null   | L10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| M | S | VALUEPER       | AN  | U | :ref:`per-list`      | null   | L2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| -- -- -- -- -- -- -- -- -- -- -- -- Documents                                |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| O | S | FREIGHTPAY     | N.0 | U |                      | null   | R2  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| O | S | UNIQUECHECK    | N.2 | U |                      | null   | R10 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| -- -- -- -- -- -- -- -- -- -- -- -- Notes and Messages Entries               |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | MA| NOTECODE       | LC  | U | :ref:`note-list`     |        | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| P | MA| NOTE           | T   |   | paired: NOTECODE     |        | L80 |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+
| CO| MA| NOTEAPPLY      | LC  | U | :ref:`noteapply-list`|        | L4  |     |
+---+---+----------------+-----+---+----------------------+--------+-----+-----+

.. include:: ../resources/legend.rst