Menu
▾
▴
[Andro-hacker] SF.net SVN: andro:[1000] apps/finance/trunk/application/finance.dd.yaml
|
From: <ken...@us...> - 2008-12-24 15:10:37
|
Revision: 1000
http://andro.svn.sourceforge.net/andro/?rev=1000&view=rev
Author: kendowns
Date: 2008-12-24 15:10:34 +0000 (Wed, 24 Dec 2008)
Log Message:
-----------
Modified Paths:
--------------
apps/finance/trunk/application/finance.dd.yaml
Modified: apps/finance/trunk/application/finance.dd.yaml
===================================================================
--- apps/finance/trunk/application/finance.dd.yaml 2008-12-24 05:37:25 UTC (rev 999)
+++ apps/finance/trunk/application/finance.dd.yaml 2008-12-24 15:10:34 UTC (rev 1000)
@@ -26,6 +26,18 @@
# MODULES AND GROUPS
#
# ==================================================================
+group ordersadmin:
+ description: Orders Power Users
+ module ordering:
+ permsel: "Y"
+ permins: "Y"
+ permupd: "Y"
+ permdel: "Y"
+
+module ordering:
+ description: Orders
+ uisort: 100
+
group gladmin:
description: GL Power Users
module gl:
@@ -37,8 +49,304 @@
module gl:
description: Ledger
uisort: 500
+
+# ==================================================================
+#
+# ORDERS MODULE
+#
+# ==================================================================
+table orders:
+ module: ordering
+ description: Orders
+ uisort: 100
+ column recnum_ord:
+ suffix: _ord
+ description: Order
+ uisearch: "Y"
+ primary_key: "Y"
+ foreign_key customers:
+ uisearch: "Y"
+ column date:
+ uisearch: "Y"
+ column description:
+ description: Company Name
+ uisearch: "Y"
+ auto: fetch,customers.description
+ column first_name:
+ auto: fetch,customers.first_name
+ column last_name:
+ auto: fetch,customers.last_name
+ column add1:
+ auto: fetch,customers.add1
+ column add2:
+ auto: fetch,customers.add2
+ column city:
+ auto: fetch,customers.city
+ column state:
+ auto: fetch,customers.state
+ column zip9:
+ auto: fetch,customers.zip9
+ foreign_key custtypes:
+ column custtype:
+ auto: fetch,customers.custtype
+ column pct99_discount:
+ suffix: _discount
+ auto: fetch,custtypes.pct99_discount
+
+ column amt_retail:
+ suffix: _retail
+ description: Order Retail
+ auto: sum,orderlines.amt_retail
+ column amt_discount:
+ suffix: _discount
+ description: Total Discount
+ auto: sum,orderlines.amt_discount
+ column amt_net:
+ suffix: _net
+ description: Order Net
+ auto: sum,orderlines.amt_net
+ foreign_key taxauths:
+ column taxauth:
+ auto: fetchdef,customers.taxauth
+ column taxpct:
+ prefix: tax
+ description: Tax Percent
+ column amt_tax:
+ suffix: _tax
+ description: Tax Amount
+ auto: sum,orderlines.amt_tax
+ column amt_due:
+ suffix: _due
+ description: Amount Due
+ chain calc:
+ test 00:
+ return: @amt_net + @amt_tax
+ #column amt_payments:
+ # suffix: _payments
+ # description: Lifetime Payments
+ # auto: sum,payments.amt_paid
+ #column amt_balance:
+ # suffix: _balance
+ # description: Current Balance
+ # chain calc:
+ # test 00:
+ # return: @amt_due - @amt_payments
+
+
+table orderlines:
+ module: ordering
+ uisort: 110
+ nomenu: "Y"
+
+ column recnum_ol:
+ suffix: _ol
+ description: Order Line
+ primary_key: "Y"
+ foreign_key orders:
+
+ foreign_key items:
+ uisearch: "Y"
+ column price:
+ auto: fetch,items.price
+ uisearch: "Y"
+ column flag_taxable:
+ description: Taxable
+ suffix: _taxable
+ auto: fetch,items.flag_taxable
+ column qty:
+ uisearch: "Y"
+ column amt_retail:
+ suffix: _retail
+ description: Retail
+ chain calc:
+ test 00:
+ return: @price * @qty
+ column pct99_discount:
+ suffix: _discount
+ auto: distribute,orders.pct99_discount
+ column amt_discount:
+ suffix: _discount
+ description: Discount
+ chain calc:
+ test 00:
+ return: @amt_retail * @pct99_discount .01
+ column amt_net:
+ suffix: _net
+ description: Order Net
+ chain calc:
+ test 00:
+ return: @amt_retail - @amt_discount
+ column taxauth:
+ auto: distribute,orders.taxauth
+ column taxpct:
+ prefix: tax
+ description: Tax Percent
+ auto: distribute,orders.taxpct
+ column amt_tax:
+ suffix: _tax
+ description: Tax Amount
+ chain calc:
+ test 00:
+ compare: @flag_taxable = Y
+ return: @amt_net * @taxpct .01
+ test 01:
+ return: 0
+ column amt_due:
+ suffix: _due
+ description: Line Final
+ chain calc:
+ test 00:
+ return: @amt_net + @amt_tax
+
+
+
+#
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+#
+
+column customer:
+ type_id: int
+ automation_id: sequence
+ description: Customer
+table customers:
+ module: ordering
+ description: Customers
+ uisort: 200
+ spaceafter: "Y"
+
+ column customer:
+ primary_key: "Y"
+ uisearch: "Y"
+ column description:
+ description: Company Name
+ uisearch: "Y"
+ column first_name:
+ uisearch: "Y"
+ column last_name:
+ uisearch: "Y"
+ column add1:
+ column add2:
+ column city:
+ foreign_key states:
+ allow_empty: "Y"
+ column zip9:
+ foreign_key custtypes:
+ allow_empty: "Y"
+ foreign_key taxauths:
+
+ column amt_retail:
+ suffix: _retail
+ description: Lifetime Retail
+ auto: sum,orders.amt_retail
+ column amt_discount:
+ suffix: _discount
+ description: Lifetime Discount
+ auto: sum,orders.amt_discount
+ column amt_net:
+ suffix: _net
+ description: Lifetime Net Sales
+ auto: sum,orders.amt_net
+ column amt_payments:
+ suffix: _payments
+ description: Lifetime Payments
+ #auto: sum,orders.amt_paid
+ column amt_balance:
+ suffix: _balance
+ description: Current Balance
+ chain calc:
+ test 00:
+ return: @amt_net - @amt_payments
+
+
+#
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+#
+column sku:
+ type_id: vchar
+ colprec: 15
+ description: SKU
+table items:
+ module: ordering
+ uisort: 300
+ description: Items
+ spaceafter: "Y"
+
+
+ column sku:
+ primary_key: "Y"
+ uisearch: "Y"
+ column description:
+ uisearch: "Y"
+ column flag_taxable:
+ suffix: _taxable
+ description: Taxable
+ uisearch: "Y"
+ column price:
+ description: Price
+ uisearch: "Y"
+
+#
+# - - - - - - - - - - - - - - - - - - - - - - - - - - - -
+#
+
+column custtype:
+ type_id: vchar
+ colprec: 8
+ description: Customer Type
+
+table custtypes:
+ module: ordering
+ uisort: 900
+ x6profile: tabDiv
+ description: Customer Types
+
+ column custtype:
+ primary_key: "Y"
+ uisearch: "Y"
+ column description:
+ uisearch: "Y"
+ column pct99_discount:
+ suffix: _discount
+ description: Standard Discount
+ column cnt_customers:
+ suffix: _customers
+ auto: count,customers.skey
+
+column taxauth:
+ type_id: vchar
+ colprec: 11
+ description: Tax Authority
+table taxauths:
+ module: ordering
+ uisort: 910
+ x6profile: tabDiv
+ description: Tax Authorities
+
+ column taxauth:
+ primary_key: "Y"
+ uisearch: "Y"
+ column description:
+ uisearch: "Y"
+ column taxpct:
+ prefix: tax
+ description: Tax Percent
+ uisearch: "Y"
+ column cnt_customers:
+ suffix: _customers
+ uisearch: "Y"
+ description: Customers
+ auto: count,customers.skey
+ column cnt_orders:
+ suffix: _orders
+ uisearch: "Y"
+ description: Orders
+ auto: count,orders.skey
+
+
+
+
# ==================================================================
#
# GL MODULE
@@ -83,6 +391,7 @@
module: gl
uisort: 900
x6profile: tabdiv
+ x6all: "Y"
group gladmin:
permins: "N"
@@ -105,3 +414,4 @@
- [ Q, Equity , 3 ]
- [ I, Income , 4 ]
- [ E, Expense , 5 ]
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
