Several tables are included and must be populated by the end user in order to access some of the features of the Accounts Receivable and Work Orders program.  The tables and their intended purposes are listed below:

• accounts: An internal table that is the master table for keeping track of accounts. This table is populated directly from the main Accounts Receivable screen and should only be used as a backdoor for viewing the accounts data. 

• building: Used for creating a list of building descriptions and codes.

• complex: Used for creating a list complex descriptions and codes.

• complexunit: Used to join specific complex codes to specific building and unit codes in order to allow drop down lists to be limited based upon selected items.  This table should be populated using the Link Complexes, Builidings & Units menu option found in the Edit Tables screen menu.

• employees:  For creating a list of employees.

• invoice: An internal table used to track the invoices that have been created.  This table is created directly from the invoice menu option on the Work Orders main screen.

• transactlog: An internal table used to track all transactions. This table is populated directly from the ledger tab of the main Accounts Receivable screen and should only be used for viewing the accounts transaction data.

• unit: Used for creating a list of unit descriptions and codes.

• workorders: An internal table that is the master table for keeping track of work orders.  This table is populated directly from the main Work Orders screen and should only be used as a backdoor for viewing the work order data.

• workdetail: An internal table that is a detail table for keeping track of work orders.  This table is populated directly from the main Work Orders screen and should only be used as a backdoor for viewing the work order detail data.

To access a table, click on the Table drop down menu and then select the table that you wish to view or edit.

Place the cursor in each cell of the grid and populate the cells with the appropriate values. 

Here are  few guidelines for editing records within the Edit Tables screen:

• The cursor must be moved off of the current row and onto another row in order for any changes to take effect. 
• To delete a row, you must press [CTRL] + [DELETE].
• Serial fields are auto-increment fields and do not require or allow a value to be inserted. 
• Description and Code  fields must be populated and each Code field must be unique within the table. 
• Inact fields must be populated with an A (for Active) or an I (for Inactive). 

Typically, master records such as the ones described here should not be deleted after the data have been used by the program.  Instead, if a master record becomes obsolete, it should be inactivated in order to preserve the historical data.

One special menu option is for linking complexes, buildings, and units.  This menu is accessed via the Link Complexes, Buildings & Units selection under the Link menu.

Once the Relate Complexes to Units screen opens the grid will be populated with building and unit combinations that have already been related to that complex. Additional buildings and units can be added for the complex by selecting a complex and then populating the building and unit edit boxes.  Click the add button to add a new record or use the update and remove buttons to manipulate existing rows in the grid.