Previous Topic: Creating a Lookup Table

Next Topic: Example 2: Defining Entities for a Department

Setting Up Your Accounting Structure › Creating a Lookup Table › Example 1: Defining Entities for a Division

Example 1: Defining Entities for a Division

Using the Accounting Sources Lookup panel below, we are defining four distinct entities for MBJ ORD Types within a structure called Division. In Example 2 in Example 2: Defining Accounting Sources Using a Lookup Table, we indicated that our accounting sources were:

ORD Field Name    St  Length

MBJ-JOBNAME       01  04
MBJ-ACCTCODE      01  08
MBJ-USER-INFO     01  04

Therefore, our entries look like those shown on the panel below.


---------------------------------
▼A B C D 1 2 3 4 1 2 3 8 X Y Z 1▼
|-------|---------------|--------
|1 2 3 4|1 2 3 4 5 6 7 8|1 2 3 4|
-JOBNAME|----ACCTCODE---|-USER---
                          INFO


  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 0001 of 0004
        | Cmd From range        To range          Return value
        |
        |  _  ABCD12345678XYZ1  CDEF12345678XYZ1  GARDEN CITY_____
        |  _  DBCD12345678XYZ1  EDEF12345678XYZ1  DALLAS__________
        |  _  GBCD12345678XYZ1  IDEF12345678XYZ1  PRINCETON_______
        |  _  JBCD12345678XYZ1  PDEF12345678XYZ1  RESTON__________
        |  _  ________________  ________________  ________________
        |
        |   F5=Save   F6=Delete   F7=Bkwd   F8=Fwd
        +-----------------------------------------------------------+
 
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp