oe table

``oe'' ( ``id'' integer nextval('id'::text),
``ordnumber'' text,
``transdate'' date date('now'::text),
``vendor_id'' integer,
``customer_id'' integer,
``amount'' double precision,
``netamount'' double precision,
``reqdate'' date,
``taxincluded'' boolean,
``shippingpoint'' text,
``notes'' text,
``curr'' character(3)
);

NAME

Vend::Accounting::SQL-Ledger - SQL-Ledger Accounting Interface for Interchange

DESCRIPTION

This module is an attempt to create a set of callable routines that will allow the easy integration of the SQL-Ledger Accounting package with Interchange.

It handles the mapping of the Interchange variable names to the appropriate SQL-Ledger ones as well as parsing the html returned by the SQL-Ledger ``''.

Background: SQL-Ledger Accounting ``www.sql-ledger.org'' is a multiuser, double entry, accounting system written in Perl and is licensed under the General Public License.

The SQL-Ledger SQL-Ledger functions can be accessed from the command line by passing all the variables in one long string to the perl script. The variable=value pairs must be separated by an ampersand. See ``www.sql-ledger.org/misc/api.html'' for more details on the command line interface.

------------------------------------------------------------------

This module also happens to be the author's first perl module and probably his second or third perl program in addition to ``Hello World''. :)

So please go easy on me. -Daniel

Schema

``id'' start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;

``makemodel'' ( ``id'' integer,
``parts_id'' integer,
``name'' text
); ``gl'' ( ``id'' integer nextval('id'::text),
``source'' text,
``description'' text,
``transdate'' date date('now'::text)
);

``chart'' ( ``id'' integer nextval('id'::text),
``accno'' integer,
``description'' text,
``charttype'' character(1) 'A',
``gifi'' integer,
``category'' character(1),
``link'' text
);

``defaults'' ( ``inventory_accno_id'' integer,
``income_accno_id'' integer,
``expense_accno_id'' integer,
``fxgain_accno_id'' integer,
``fxloss_accno_id'' integer,
``invnumber'' text,
``ordnumber'' text,
``yearend'' character varying(5),
``curr'' text,
``weightunit'' character varying(5),
``businessnumber'' text,
``version'' character varying(8)
);

``acc_trans'' ( ``trans_id'' integer,
``chart_id'' integer,
``amount'' double precision,
``transdate'' date date('now'::text),
``source'' text,
``cleared'' boolean 'f',
``fx_transaction'' boolean 'f'
);

``invoice'' ( ``id'' integer nextval('id'::text),
``trans_id'' integer,
``parts_id'' integer,
``description'' text,
``qty'' real,
``allocated'' real,
``sellprice'' double precision,
``fxsellprice'' double precision,
``discount'' real,
``assemblyitem'' boolean 'f'
);

``vendor'' ( ``id'' integer nextval('id'::text),
``name'' character varying(35),
``addr1'' character varying(35),
``addr2'' character varying(35),
``addr3'' character varying(35),
``addr4'' character varying(35),
``contact'' character varying(35),
``phone'' character varying(20),
``fax'' character varying(20),
``email'' text,
``notes'' text,
``terms'' smallint 0,
``taxincluded'' boolean
);

``customer'' ( ``id'' integer nextval('id'::text),
``name'' character varying(35),
``addr1'' character varying(35),
``addr2'' character varying(35),
``addr3'' character varying(35),
``addr4'' character varying(35),
``contact'' character varying(35),
``phone'' character varying(20),
``fax'' character varying(20),
``email'' text,
``notes'' text,
``discount'' real,
``taxincluded'' boolean,
``creditlimit'' double precision 0,
``terms'' smallint 0,
``shiptoname'' character varying(35),
``shiptoaddr1'' character varying(35),
``shiptoaddr2'' character varying(35),
``shiptoaddr3'' character varying(35),
``shiptoaddr4'' character varying(35),
``shiptocontact'' character varying(20),
``shiptophone'' character varying(20),
``shiptofax'' character varying(20),
``shiptoemail'' text
);

``parts'' ( ``id'' integer nextval('id'::text),
``partnumber'' text,
``description'' text,
``bin'' text,
``unit'' character varying(5),
``listprice'' double precision,
``sellprice'' double precision,
``lastcost'' double precision,
``priceupdate'' date date('now'::text),
``weight'' real,
``onhand'' real 0,
``notes'' text,
``makemodel'' boolean 'f',
``assembly'' boolean 'f',
``alternate'' boolean 'f',
``rop'' real,
``inventory_accno_id'' integer,
``income_accno_id'' integer,
``expense_accno_id'' integer,
``obsolete'' boolean 'f'
);

``assembly'' ( ``id'' integer,
``parts_id'' integer,
``qty'' double precision
);

``ar'' ( ``id'' integer nextval('id'::text),
``invnumber'' text,
``ordnumber'' text,
``transdate'' date date('now'::text),
``customer_id'' integer,
``taxincluded'' boolean,
``amount'' double precision,
``netamount'' double precision,
``paid'' double precision,
``datepaid'' date,
``duedate'' date,
``invoice'' boolean 'f',
``shippingpoint'' text,
``terms'' smallint 0,
``notes'' text,
``curr'' character(3)
);

``ap'' ( ``id'' integer nextval('id'::text),
``invnumber'' text,
``transdate'' date date('now'::text),
``vendor_id'' integer,
``taxincluded'' boolean,
``amount'' double precision,
``netamount'' double precision,
``paid'' double precision,
``datepaid'' date,
``duedate'' date,
``invoice'' boolean 'f',
``ordnumber'' text,
``curr'' character(3)
);

``partstax'' ( ``parts_id'' integer,
``chart_id'' integer
);

``tax'' ( ``chart_id'' integer,
``rate'' double precision,
``taxnumber'' text
);

``customertax'' ( ``customer_id'' integer,
``chart_id'' integer
);

``vendortax'' ( ``vendor_id'' integer,
``chart_id'' integer
);

``oe'' ( ``id'' integer nextval('id'::text),
``ordnumber'' text,
``transdate'' date date('now'::text),
``vendor_id'' integer,
``customer_id'' integer,
``amount'' double precision,
``netamount'' double precision,
``reqdate'' date,
``taxincluded'' boolean,
``shippingpoint'' text,
``notes'' text,
``curr'' character(3)
);

``orderitems'' ( ``trans_id'' integer,
``parts_id'' integer,
``description'' text,
``qty'' real,
``sellprice'' double precision,
``discount'' real
);

``exchangerate'' ( ``curr'' character(3),
``transdate'' date,
``buy'' double precision,
``sell'' double precision
);