Thread: [Andro-hacker] SF.net SVN: andro:[1000] apps/finance/trunk/application/finance.dd.yaml

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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.




Thread: [Andro-hacker] SF.net SVN: andro:[1000] apps/finance/trunk/application/finance.dd.yaml

andro-hacker