Setting Up Your Accounting Structure › Creating a Lookup Table › Example 2: Defining Entities for a Department

Example 2: Defining Entities for a Department

Using the Accounting Sources Lookup panel below, we are defining six distinct entities for MBJ ORD Type within a structure called Department. Our Accounting Sources are:

ORD Field Name    St  Length

MBJ-JOBNAME       02  02
MBJ-ACCTCODE      04  04

DEPARTMENT Structure Length = 16

Therefore, our entries look like this: AA9999, where AA is the JOBNAME and 9999 represents the ACCTCODE value.

  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  : DEPTAB
        |
        |                        More: - + ____   Row 0001 of 0005
        | Cmd From range        To range          Return value
        |
        |  _  AA0001__________  AA0010__________  DEVELOPMENT_____
        |  _  AB0001__________  AB0020__________  QA______________
        |  _  AC0001__________  AC0005__________  SUPPORT_________
        |  _  BB0004__________  BB0009__________  ACCOUNTS PAYABLE
        |  _  BB0100__________  BB0300__________  RECEIPTS________
        |
        |   F5=Save   F6=Delete   F7=Bkwd   F8=Fwd
        +-----------------------------------------------------------+
 
  Command ===> ____________________________________________________________
  F1=Help  F3=Exit  F4=Prompt  F9=Command  F10=Action Bar  F12=Cancel  PA1=Susp

To enter the sixth range, you must press F5 to save the entries; then, scroll the screen forward using F8.

  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  : DEPTAB
        |
        |                        More: - + ____   Row 0006 of 0006
        | Cmd From range        To range          Return value
        |
        |  _  CC0000__________  DE0020__________  EASTERN SALES___
        |  _  ________________  ________________  ________________
        |  _  ________________  ________________  ________________
        |  _  ________________  ________________  ________________
        |  _  ________________  ________________  ________________
        |
        |   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: If our DEPARTMENT structure length had been defined as having a length of 10 on the Accounting Structures panel and you entered a Return Value that exceeded 10 characters, you would receive a message telling you that the entity's Return Value exceeds the length of the structure. In this case, you must provide a new Return Value with a character count that is less than or equal to the structure's length.

Remember: The return value can never be greater than the structure length defined on the Accounting Structure panel.