projects
/
Pman.Xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
76c1301
)
metasql/registrar.contracts.sql
author
Edward
<edward@roojs.com>
Wed, 17 Dec 2014 08:40:09 +0000
(16:40 +0800)
committer
Edward
<edward@roojs.com>
Wed, 17 Dec 2014 08:40:09 +0000
(16:40 +0800)
metasql/registrar.contracts.sql
patch
|
blob
|
history
diff --git
a/metasql/registrar.contracts.sql
b/metasql/registrar.contracts.sql
index
8191087
..
f96a8da
100644
(file)
--- a/
metasql/registrar.contracts.sql
+++ b/
metasql/registrar.contracts.sql
@@
-22,14
+22,14
@@
SELECT
custinfo.cust_curr_id,
aropen.aropen_amount,
aropen.aropen_distdate
- ), 0) AS
aropen_amount_base
,
+ ), 0) AS
cust_aropen_amount
,
aropen.aropen_paid AS aropen_paid,
COALESCE(currtocurr(
aropen.aropen_curr_id,
custinfo.cust_curr_id,
aropen.aropen_paid,
aropen.aropen_distdate
- ), 0) AS
aropen_paid_base
,
+ ), 0) AS
cust_aropen_paid
,
item.item_number AS item_number,
item.item_descrip1 AS item_descrip1
FROM