The general journal table holds the journal entries for every transaction in PhreeBooks. The general journal is broken into two tables, main and item. The main table contains the overview settings that are common for every transaction. The item table contains each individual journal entry and is a many to one relationship with journal_main.
The table field definitions for the journal_main table are as follows:
Field Name |
Type |
Size (value) |
Comment |
id | integer |
11 |
auto-increment field used to uniquely identify each journal entry. |
ref_id | integer |
11 |
Links to the table journal_main id field. this field will be the same for every entry associated with a journal entry, i.e. purchase order, invoice. |
gl_type | char |
3 |
Specifies the journal item entry type. Entries are coded with the gl_type to track the journal entry. gl_type definitions are as follows: General: Payables: Receivables: Inventory: |
sku | varchar |
15 |
Inventory SKU number. |
qty | float |
Quantity of items asociated with this journal entry | |
description | varchar |
255 |
Item description |
debit_amount | float |
The monetary amount for debit transactions. | |
credit_amount | float |
The monetary amount for credit transactions. | |
gl_account | varchar |
15 |
The general leder account associated with this transaction. |
serialize | boolean |
0,1 |
Flag used for serialized items. |
serialize_number | varchar |
24 |
Item serial number (valid if serialize is set to 1) |
post_date | datetime |
Date and time the journal item was posted. |
Notes: