Table import_export

Table import_export hold the definitions and parameters to import or export data to PhreeBooks. In general, only data can be added to one table at a time. The exeptions are accounts (vendors, customers, employees) where shipping and billing addresses may also be imported. To import beginning balances, use the import beginning balances scripts as these scripts populate many tables and post the transaction properly to the journal.

Table Type: MyISAM

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
group_id char (3) NOT NULL

Hold the group the the import_export definition is a part of. Current defined groups are:
inv : Inventory
ap: Accounts Payable
ar : Accounts Receivable
hr: Employees (Human Resources)

custom enum (0,1) 1 Flag to indicate is this is a standard import/export definition or has been saved and customized for a particular purpose.
security varchar (10) NOT NULL Not used at this time
title varchar (32) NOT NULL Textual title of the import/export definition. Appears in the description tabs at the Import/Export main page.
description varchar (255) NOT NULL Textual descriptio to help identify what the purpose of the import/export definition is.
table_name varchar (32) NOT NULL Specifies the default table name without prefix to bas the import/export definition from.
primary_key varchar (32) NOT NULL Specifies the primary key from the table_name (above) to use as an index to retrieve data.
params text   Encoded field holds user specific parameters. NOTE: This field should not be edited in the database table.
criteria text   Encoded field holds user specific criteria. Fields include user defined criteria of which there may be more than one. NOTE: This field should not be edited in the database table.
options text   Encoded field holds user specific options. Fields such as export format, fielnames, etc. NOTE: This field should not be edited in the database table.