Accounts Payables provides services to other packages and provides a basic UI for directly managing accounts payables.

Features

Converted:

• Data model for Postgresql.
• Num2text in SL, lc_number_to_text

Planned:

Basic posting/editing via web and service (and/or callback?), and modifying the progress of an order.

notes

see accounts-ledger documentation for related information and overall project status

sql-ledger        package-key  table name

<table_name>        qal_<table_name>

Need to add package_key to data model.

porting notes and guidelines

Any functions dependent on accounts payable (AP) are moved to this package. When something is dependent on two or more accounting packages, it is moved into the "full accounting features" accounts-desk package.

functions and procedures

lc_number_to_text proc is made from the the SL Num2text procedure which has localized cases in the locale directories, and the default Num2text.pm in sql-ledger/SL/

SQL

The Oracle SQL will be added after the PG SQL has settled a bit.

Some of the SQL has been changed to the OpenACS standards. See http://openacs.org/doc/current/eng-standards-plsql.html and http://openacs.org/wiki

for Postgresql:

INT changed to INTEGER
some of the TEXT types were changed to VARCHAR so that they get indexed
FLOAT changed to NUMERIC