Table current_status

Table current_status holds the next available reference number for various PhreeBooks activities. PhreeBooks will not allow duplicate numbers in the journal for any of these numbers. Fields that are type varchar can use alphanumeric values.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto-increment number for record id.
next_po_num int (11) 0 Holds the next vendor purchase order number.
next_so_num varchar (16) NOT NULL Holds the next customer sales order number.
next)inv_num int (11) 0 Holds the next customer invoice number.
next_check_num int (11) 0 Holds the next vendor payment number.
next_deposit_num varchar (16) NOT NULL Holds the next customer receipt deposit number.
next_shipment_num int (11) 0 Holds the next shipment reference number.
next_cm_num varchar (16) NOT NULL Holds the next customer credit memo number.
next_ap_quote_num varchar (16) NOT NULL Holds the next vendor quote number.
next_ar_quote_num varchar (16) NOT NULL Holds the next customer quote number.