projects
/
Pman.Xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2aad27d
)
pgsql/investigations/ar-cash.sql
author
Edward
<edward@roojs.com>
Wed, 5 Feb 2014 06:30:31 +0000
(14:30 +0800)
committer
Edward
<edward@roojs.com>
Wed, 5 Feb 2014 06:30:31 +0000
(14:30 +0800)
pgsql/investigations/ar-cash.sql
patch
|
blob
|
history
diff --git
a/pgsql/investigations/ar-cash.sql
b/pgsql/investigations/ar-cash.sql
index
957449b
..
8bff3ef
100644
(file)
--- a/
pgsql/investigations/ar-cash.sql
+++ b/
pgsql/investigations/ar-cash.sql
@@
-141,13
+141,13
@@
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
-ALTER FUNCTION x_ar_verify_c
reditmemo
(integer)
+ALTER FUNCTION x_ar_verify_c
ash
(integer)
OWNER TO admin;
-SELECT x_ar_verify_c
reditmemo(aropen_id) FROM aropen where aropen_doctype = 'C' order by aropen
_id asc;
+SELECT x_ar_verify_c
ash(arapply_id) FROM arapply where arapply_source_doctype = 'K' AND arapply_target_doctype = 'I' order by arapply
_id asc;