Results 1 to 3 of 3

Thread: EntryType // what do they all represent?

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    128
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question EntryType // what do they all represent?

    Hi there,

    I'm in the pervasive database and get the below results. Question: Could someone (Neville I'm sure you know!) tell me which each number represents, please? If not for the entire sequence of EntryTypes (not shown here). Then just for the ones shown in the results?

    Code:
    select Distinct EntryType from OpenItem where dc = 'D'
    
    Returns:
    EntryType
    =========
            1
            2
            3
            5
            6
            8
            9
           11
           18
           19
           20
           31
           33
          103
          104
    
    select Distinct EntryType from OpenItem where dc = 'C'
    
    Retruns:
    EntryType
    =========
            2
            7

  2. #2
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    128
    Thanks
    15
    Thanked 3 Times in 3 Posts
    ahhh. Sorry, stupid question! I see where those numbers are coming from. If I go to Setup > Entry Type ... it's just the debit/credit of each cashbook. Got it

  3. #3
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    203
    Thanks
    0
    Thanked 33 Times in 29 Posts
    That will also vary per database, depending on the number of cashbooks / journals they have setup.
    The names of the entrytypes can also be pulled from the database. They are under the ledgerparameters file - entrytypedesc01 to entrytypedesc90.

Similar Threads

  1. UNFAIR DISMISSAL AND CCMA HEARINGS CAN YOUR LAWYER REPRESENT YOU?
    By Mike C in forum Labour Relations and Legislation Forum
    Replies: 2
    Last Post: 28-Mar-16, 08:09 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •