Setting Up Your Accounting Structure › Creating a Lookup Table

Creating a Lookup Table

The Lookup Table is an optional feature. It is used to name specific entities within an accounting structure and return a meaningful name for each entity you define. For example, an accounting structure's entities might be composed of entries that look like:

          AA0000
          ZZ9999
          --|__|
           | |
           | --The fourth through seventh positions of ACCTCODE
           --The first two positions of JOBNAME

Most likely very few people in your organization would be able to identify specific entities using the above codes. However, by using the Lookup Table, you can assign a meaningful name to the above structure's entities (for example, Accounting for AA0000 and Operations for ZZ9999).

Note: Once you define a Lookup Table, you are not restricted to the ORD type from which the table was invoked. However, the return value (the number of characters) and From and To range length must be consistent. There is no limit on the number of Lookup Table entries you can create.

The following is a sample Accounting Sources Lookup panel. The protected display fields, preceded by colons (:), display information you entered on the Accounting Sources Entry panel. A description of the Accounting Sources Lookup panel is provided next.

  USERID                   CA PMA Chargeback                  MM/DD/YY HH:MM:SS
  __    Acctdefs   Cbdefs   Query   Data   Period   Options   Exit   Help
        +-- CBASRCU ------ Accounting Sources Lookup ---------------+
        |      Panel  Exit  Help
        | ---------------------------------------------------------
        |  Type information. Then select an action.
        |
        |  Version . . . :                   DM Version : PROD
        |  Lookup table  : DIVTAB
        |
        |                         More: - + ____  Row 0000 of 0000
        | Cmd From range        To range          Return value
        |
        |     ________________  ________________  ________________
        |     ________________  ________________  ________________
        |     ________________  ________________  ________________
        |     ________________  ________________  ________________
        |     ________________  ________________  ________________
        |
        |   F5=Save   F6=Delete   F7=Bkwd   F8=Fwd
        +-----------------------------------------------------------+
 
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

Note: The first time the Accounting Sources Lookup panel appears, you are in insert mode; no lines appear under the Cmd column, the scroll bar does not show a row count, and the only active panel function keys are F2, F5, and F11. When you press F5 (Save), you receive a message telling you the insert is successful. At this point, you are in update mode. The panel scroll bar provides a row count, the Cmd column is active (lines appear under the column) and all panel function keys are active. Pressing F5 (Save) displays a message telling you the update is successful.

Access

The Accounting Sources Lookup Table panel appears when you press F11 (Lookup) on the Accounting Sources Entry panel.

----------------
| Acctg Sources|__________
|     Entry    |         |
| > F11        |         v
----------------  -----------------
                  | Acctg Sources |
                  |     Lookup    |
                  |     Panel     |
                  -----------------

Input

The following Accounting Sources Lookup panel fields are available for input:

Cmd

This column is used to specify commands. Valid commands include:

D Deletes individual rows from the table.

I Inserts row(s) into the table using the Accounting Sources Insert (CBASRCI) pop-up window. Refer to page Sample Entry Panel Insert Pop-Up Window for information on how to use the Insert window.

From range

Enter the starting value that defines an accounting entity for the structure named in the Structure display field at the top of the Accounting Sources Entry panel. Examples are provided on the next page.

Note that you can use the SQL wildcard % in the From range. If you do so, the To range must be blank. For example, to check for the occurrence of the value A in the third position of a string, specify: %%A%. Because the first match is used, you should order your entries with wildcards first, followed by explicit (full) values in the From range. If a record does not match any of the entries, then the last item defined in the Lookup Table is used.

To range

Enter the ending value to complete the range defining the entity. Examples are provided on the next page.

Return value

Enter the name (up to 16 alphanumeric characters) you want stored in the database. This name is also available for display when doing queries and printing invoices; it cannot be greater than the accounting structure length.

Caution If CA PMA Chargeback encounters a record that has not been defined in the Lookup Table, it defaults to the last entry's return value.

Note: The sequence of your entries is important only if you have overlapping sources. In the event of overlapping ranges, CA PMA Chargeback stops its search at the first match. For example, if you specify:

From range       To range        Return value
AA0001           AZ0001          New York
AB9999           AC0001          New Jersey

You would never see a return value of New Jersey, since the search stops when it encounters the first true condition.

Tip

Try adding % as the last entry and assign it a value of other or undefined.

From range       To range        Return value
  %                              Other

Scrolling

F7 and F8 let you scroll backward and forward through the Structure selection list. You can also use the scroll bar to move through the list.

Actions

F5=Save

Saves any data you entered.

F6=Delete

Deletes the entire Lookup Table. To delete an entry, type D on that entry and press enter.