Database Modifications - Revision history

Red1 at 01:49, 6 July 2007

2007-07-06T01:49:51Z

2007-07-01T07:00:54Z

SQL in SF notice and link

2007-03-08T10:48:27Z

2007-03-07T23:42:42Z

Syntax error in creation of 1st table

2007-02-27T10:15:56Z

2007-02-27T10:13:59Z

2007-02-26T06:34:18Z

2007-02-26T06:31:40Z

‎General Books

2007-02-19T19:44:31Z

2007-02-19T19:43:37Z

← Older revision		Revision as of 01:49, 6 July 2007
Line 126:		Line 126:
	(a) CLASSNAME NVARCHAR2(240) //It defines the classname for the print format for the slip printer		(a) CLASSNAME NVARCHAR2(240) //It defines the classname for the print format for the slip printer
	(b) ARGS NVARCHAR2(480) //the arguments (fields) that needs to be printed on the slip, takes default in absence of any.		(b) ARGS NVARCHAR2(480) //the arguments (fields) that needs to be printed on the slip, takes default in absence of any.
		+
		+	</PRE>
		+	=Links=
		+	*Return to [[Posterita]]

← Older revision		Revision as of 07:00, 1 July 2007
Line 1:		Line 1:
−	Following are the new Tables which have been added in posterita	+	*Following are the new Tables which have been added in posterita as well as changes needed.
		+	*The SQL is loaded to [http://downloads.sourceforge.net/adempiere/posterita.sql?use_mirror=osdn SourceForge Download]. Apply it to your ADempiere DB.
	<pre>		<pre>

@@ Line 85: / Line 85: @@
      CHECK(IsActive IN ('Y', 'N'))
+   )
    //The following tables have been modified to add the new fields.
@@ Line 106: / Line 109: @@
 . M_PRODUCT
-	a) GROUP1;
+	a) GROUP1 NVARCHAR2(255);
-	b) GROUP2;
+	b) GROUP2  NVARCHAR2(255);
          //Both these fields have been created to falicitate the user to have its own grouping in the reports apart
          //from the grouping already exists

@@ Line 23: / Line 23: @@
      Help           NVARCHAR2(2000)    ,
      Category       NVARCHAR2(120),
-     Sequence       NUMBER(10,0)
+     Sequence       NUMBER(10,0),
      primary key(U_Menu_ID),
      CHECK(IsActive IN ('Y', 'N')),
@@ Line 84: / Line 84: @@
      primary key(U_BlackListCheque_ID),
      CHECK(IsActive IN ('Y', 'N'))
-   );
    //The following tables have been modified to add the new fields.

@@ Line 90: / Line 90: @@
      a) OrderType NVARCHAR2(510); //the type of the order for the filters on the history etc
-     b) POSID NUMBER(10,0);  //ID of the POS Terminal to link the order with the terminal, required to sort out the earnings for a perticular terminal.
+     b) POSID NUMBER(10,0);  //ID of the POS Terminal to link the order with the terminal,
      c) AmountTendered NUMBER(22,2); //to find out about the tendered amount for an order.
      d) AmountRefunded NUMBER(22,2); //to find out about the refunded amount for an order.
@@ Line 97: / Line 98: @@
 . AD_USER
-      a) UserDiscount NUMBER(22,2); //security feature. User is only allowed to discount upton the limit specified in the 					    field
+      a) UserDiscount NUMBER(22,2);
-      b)	UserPIN NVARCHAR2(20);	  //PIN for the pin login feature
+       //security feature. User is only allowed to discount upton the limit specified in the field
       b)	UserPIN NVARCHAR2(20);
@@ Line 106: / Line 108: @@
 	a) GROUP1;
 	b) GROUP2;
-         //Both these fields have been created to falicitate the user to have its own grouping in the reports apart 				//from the grouping already exists
+         //Both these fields have been created to falicitate the user to have its own grouping in the reports apart
 	c) Keyword  NVARCHAR2(255); //All these fields are to group products according to some defined

@@ Line 67: / Line 67: @@
+   )
-   // This Table stores all the cheque numbers that have been blaklisted by the bank, a security feature demanded by on of the clients
+   // This Table stores all the cheque numbers that have been blaklisted by the bank,
    CREATE TABLE U_BlackListCheque

@@ Line 112: / Line 112: @@
   	f) Keyword4 NVARCHAR2(255);
-</pre>
 . AD_PRINTFORMAT

← Older revision		Revision as of 06:31, 26 February 2007
Line 113:		Line 113:

	</pre>		</pre>
		+
		+	4. AD_PRINTFORMAT
		+
		+	(a) CLASSNAME NVARCHAR2(240) //It defines the classname for the print format for the slip printer
		+	(b) ARGS NVARCHAR2(480) //the arguments (fields) that needs to be printed on the slip, takes default in absence of any.

@@ Line 1: / Line 1: @@
 Following are the new Tables which have been added in posterita
+<pre>
 //This Table is to store all the menus we have in posterita
@@ Line 104: / Line 104: @@
 	a) GROUP1;
 	b) GROUP2;
-		//Both these fields have been created to falicitate the user to have its own grouping in the reports apart 				from the grouping already exists
+        //Both these fields have been created to falicitate the user to have its own grouping in the reports apart 				//from the grouping already exists
 	c) Keyword  NVARCHAR2(255); //All these fields are to group products according to some defined
@@ Line 111: / Line 111: @@
 	e) Keyword3 NVARCHAR2(255);
   	f) Keyword4 NVARCHAR2(255);