Table journal_item

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:

TABLE: journal_item

Field Name
Type
Size (value)
Comment
id
integer
11

auto-increment field used to uniquely identify each journal entry.
Primary Key: YES
Indexed: YES
Unique: YES

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:
ttl - Total entry amount
frt - Shipping/Freight charges
tax - Sales/VAT Tax entries

Payables:
poo - purchase order line item ordered
por - purchase order line item received
pod - purchase order line item expected delivery date
pop - purchase/receive item paid

Receivables:
soo - sales order line item ordered
sor - sales order line item shipped
sod - sales order line item delivered date
sos - sales/invoice item payment received

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: