[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue/gnue-config accounting/gl/defaults/insert-...
|
From: |
Neil Tiffin |
|
Subject: |
gnue/gnue-config accounting/gl/defaults/insert-... |
|
Date: |
Sun, 02 Sep 2001 08:29:39 -0700 |
CVSROOT: /home/cvs
Module name: gnue
Changes by: Neil Tiffin <address@hidden> 01/09/02 08:29:39
Modified files:
gnue-config/accounting/gl/defaults: insert-en-status.geas
insert-en-type.geas
gnue-config/base/acct/defaults: insert-en-acct-trans.geas
gnue-config/base/currency/defaults:
insert-en-ISO4217-currency.geas
gnue-config/base/language/defaults:
insert-ISO639LanguageCodes.geas
gnue-config/base/location/defaults: insert-en-country-codes.geas
insert-en-us-states.geas
gnue-config/base/person/defaults: insert-en-comm-type.geas
insert-en-prefix.geas
insert-en-suffix.geas
gnue-config/base/units/defaults: insert-en-help-unit.geas
insert-en-unit.geas
gnue-config/sales/sales-order/defaults: insert-en-line-type.geas
Log message:
Change objectid to sys_id for all .geas files. Sync up with Reinhard's
changes to geas server.
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/location/defaults/insert-en-us-states.geas.diff?cvsroot=OldCVS&tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-prefix.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/person/defaults/insert-en-suffix.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/base/units/defaults/insert-en-unit.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text
Patches:
Index: gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas
diff -u gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas:1.3
gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas:1.4
--- gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas:1.3 Sat Jul
7 06:13:51 2001
+++ gnue/gnue-config/accounting/gl/defaults/insert-en-status.geas Sun Sep
2 08:29:38 2001
@@ -3,10 +3,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-status.geas,v 1.3 2001/07/07 13:13:51 ntiffin Exp $
+-- $Id: insert-en-status.geas,v 1.4 2001/09/02 15:29:38 ntiffin Exp $
--
-INSERT INTO gl_acct__status (objectid, name, abbreviation, postable) VALUES
+INSERT INTO gl_acct__status (sys_id, name, abbreviation, postable) VALUES
('GEAS-OBJECT-ID', 'Active', 'A', true);
('GEAS-OBJECT-ID', 'InActive', 'I', false);
('GEAS-OBJECT-ID', 'DeActivated', 'D', false);
Index: gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas
diff -u gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas:1.3
gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas:1.4
--- gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas:1.3 Sat Jul
7 06:13:51 2001
+++ gnue/gnue-config/accounting/gl/defaults/insert-en-type.geas Sun Sep 2
08:29:38 2001
@@ -3,9 +3,9 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-type.geas,v 1.3 2001/07/07 13:13:51 ntiffin Exp $
+-- $Id: insert-en-type.geas,v 1.4 2001/09/02 15:29:38 ntiffin Exp $
-INSERT INTO gl_acct__type (objectid, name, description) VALUES
+INSERT INTO gl_acct__type (sys_id, name, description) VALUES
('GEAS-OBJECT-ID', 'Assets', 'Assets');
('GEAS-OBJECT-ID', 'Liabilities', 'Liabilities');
('GEAS-OBJECT-ID', 'Expenses', 'Expenses');
Index: gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas
diff -u gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas:1.1
gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas:1.2
--- gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas:1.1 Sat Aug
25 12:46:34 2001
+++ gnue/gnue-config/base/acct/defaults/insert-en-acct-trans.geas Sun Sep
2 08:29:38 2001
@@ -3,12 +3,12 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-acct-trans.geas,v 1.1 2001/08/25 19:46:34 ntiffin Exp $
+-- $Id: insert-en-acct-trans.geas,v 1.2 2001/09/02 15:29:38 ntiffin Exp $
--
-- typically the account number will be added based on the implementation.
--
-INSERT INTO "base_acct__transactions" (objectid, code, account, debit_credit,
name) VALUES
+INSERT INTO "base_acct__transactions" (sys_id, code, account, debit_credit,
name) VALUES
('GEAS-OBJECT-ID', 01, '000000', 'D', 'Customer Invoice Transaction');
('GEAS-OBJECT-ID', 02, '000000', 'D', 'Customer Invoice Adj Transaction');
('GEAS-OBJECT-ID', 03, '000000', 'C', 'Customer Credit Transaction');
Index: gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas
diff -u
gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas:1.3
gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas:1.4
--- gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas:1.3
Sat Jul 7 06:13:51 2001
+++ gnue/gnue-config/base/currency/defaults/insert-en-ISO4217-currency.geas
Sun Sep 2 08:29:38 2001
@@ -17,10 +17,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-ISO4217-currency.geas,v 1.3 2001/07/07 13:13:51 ntiffin
Exp $
+-- $Id: insert-en-ISO4217-currency.geas,v 1.4 2001/09/02 15:29:38 ntiffin
Exp $
--
-INSERT INTO "currency__currency" (objectid, code, description,
default_decimals) VALUES
+INSERT INTO "currency__currency" (sys_id, code, description, default_decimals)
VALUES
('GEAS-OBJECT-ID', 'ADP', 'Andorran Peseta',2);
('GEAS-OBJECT-ID', 'AED', 'United Arab Emirates Dirham',2);
Index: gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas
diff -u
gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas:1.3
gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas:1.4
--- gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas:1.3
Sat Jul 7 06:13:51 2001
+++ gnue/gnue-config/base/language/defaults/insert-ISO639LanguageCodes.geas
Sun Sep 2 08:29:38 2001
@@ -7,10 +7,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-ISO639LanguageCodes.geas,v 1.3 2001/07/07 13:13:51 ntiffin Exp $
+-- $Id: insert-ISO639LanguageCodes.geas,v 1.4 2001/09/02 15:29:38 ntiffin Exp $
--
-INSERT INTO language__language (objectid, code, desc_en, desc_fr) VALUES
+INSERT INTO language__language (sys_id, code, desc_en, desc_fr) VALUES
('GEAS-OBJECT-ID', 'aa', 'Afar', 'afar');
('GEAS-OBJECT-ID', 'ab', 'Abkhazian', 'abkhaze');
('GEAS-OBJECT-ID', 'af', 'Afrikaans', 'afrikaans');
Index: gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas
diff -u
gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas:1.3
gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas:1.4
--- gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas:1.3
Sat Jul 7 06:13:51 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-country-codes.geas
Sun Sep 2 08:29:39 2001
@@ -5,10 +5,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-country-codes.geas,v 1.3 2001/07/07 13:13:51 ntiffin Exp $
+-- $Id: insert-en-country-codes.geas,v 1.4 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO location__country (objectid, description, phone_code, code) VALUES
+INSERT INTO location__country (sys_id, description, phone_code, code) VALUES
('GEAS-OBJECT-ID', 'Afghanistan', '', 'AF');
('GEAS-OBJECT-ID', 'Albania', '355', 'AL');
('GEAS-OBJECT-ID', 'Algeria', '213', 'AG');
Index: gnue/gnue-config/base/location/defaults/insert-en-us-states.geas
diff -u gnue/gnue-config/base/location/defaults/insert-en-us-states.geas:1.3
gnue/gnue-config/base/location/defaults/insert-en-us-states.geas:1.4
--- gnue/gnue-config/base/location/defaults/insert-en-us-states.geas:1.3
Sat Jul 7 06:13:51 2001
+++ gnue/gnue-config/base/location/defaults/insert-en-us-states.geas Sun Sep
2 08:29:39 2001
@@ -5,10 +5,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-us-states.geas,v 1.3 2001/07/07 13:13:51 ntiffin Exp $
+-- $Id: insert-en-us-states.geas,v 1.4 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO location__region (objectid, "desc", code, country) VALUES
+INSERT INTO location__region (sys_id, "desc", code, country) VALUES
('GEAS-OBJECT-ID', 'Alabama', 'AL', 'US');
('GEAS-OBJECT-ID', 'Alaska', 'AK', 'US');
('GEAS-OBJECT-ID', 'American Samoa', 'AS', 'US');
Index: gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas
diff -u gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas:1.1
gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas:1.2
--- gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas:1.1 Sat Jul
7 07:25:40 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-comm-type.geas Sun Sep
2 08:29:39 2001
@@ -3,10 +3,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-comm-type.geas,v 1.1 2001/07/07 14:25:40 ntiffin Exp $
+-- $Id: insert-en-comm-type.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO "person__comm_type" (objectid, code, "desc") VALUES
+INSERT INTO "person__comm_type" (sys_id, code, "desc") VALUES
('GEAS-OBJECT-ID', 'PH', 'Phone');
('GEAS-OBJECT-ID', 'FX', 'Fax');
('GEAS-OBJECT-ID', 'EM', 'E-Mail');
Index: gnue/gnue-config/base/person/defaults/insert-en-prefix.geas
diff -u gnue/gnue-config/base/person/defaults/insert-en-prefix.geas:1.1
gnue/gnue-config/base/person/defaults/insert-en-prefix.geas:1.2
--- gnue/gnue-config/base/person/defaults/insert-en-prefix.geas:1.1 Sat Jul
7 07:25:40 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-prefix.geas Sun Sep 2
08:29:39 2001
@@ -3,10 +3,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-prefix.geas,v 1.1 2001/07/07 14:25:40 ntiffin Exp $
+-- $Id: insert-en-prefix.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO "person__name_prefix" (objectid, prefix) VALUES
+INSERT INTO "person__name_prefix" (sys_id, prefix) VALUES
('GEAS-OBJECT-ID','Doctor');
('GEAS-OBJECT-ID','Dr');
('GEAS-OBJECT-ID','Heer');
Index: gnue/gnue-config/base/person/defaults/insert-en-suffix.geas
diff -u gnue/gnue-config/base/person/defaults/insert-en-suffix.geas:1.1
gnue/gnue-config/base/person/defaults/insert-en-suffix.geas:1.2
--- gnue/gnue-config/base/person/defaults/insert-en-suffix.geas:1.1 Sat Jul
7 07:25:40 2001
+++ gnue/gnue-config/base/person/defaults/insert-en-suffix.geas Sun Sep 2
08:29:39 2001
@@ -3,10 +3,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-suffix.geas,v 1.1 2001/07/07 14:25:40 ntiffin Exp $
+-- $Id: insert-en-suffix.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO "person__name_suffix" (objectid, suffix) VALUES
+INSERT INTO "person__name_suffix" (sys_id, suffix) VALUES
('GEAS-OBJECT-ID','Jr.');
('GEAS-OBJECT-ID','Sr.');
('GEAS-OBJECT-ID','II');
Index: gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas
diff -u gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas:1.1
gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas:1.2
--- gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas:1.1 Sun Aug
26 20:02:24 2001
+++ gnue/gnue-config/base/units/defaults/insert-en-help-unit.geas Sun Sep
2 08:29:39 2001
@@ -3,14 +3,11 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-help-unit.geas,v 1.1 2001/08/27 03:02:24 ntiffin Exp $
+-- $Id: insert-en-help-unit.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO "language__help" (objectid, code, dialect, name, help_text,
tool_tip, label) VALUES
+INSERT INTO "language__help" (sys_id, code, dialect, name, help_text,
tool_tip, label) VALUES
('GEAS-OBJECT-ID', 'en', 'us', 'base_item__item.item_code', 'Internal part
code for this item.', 'Part Number', ' ');
('GEAS-OBJECT-ID', 'en', 'us', 'base_item__item.short_desc', 'For use on
screens and other limited spaces.', ' ', ' ');
('GEAS-OBJECT-ID', 'en', 'us', 'base_item__item.long_desc', 'For mostly
external use on reports, purchase orders and other places where clarity is
required.', ' ', ' ');
-
- ('GEAS-OBJECT-ID', 'en', 'us', ' ', ' ', ' ', ' ');
-
-For mostly external use on reports, purchase orders and other places where
clarity is required.
\ No newline at end of file
+
\ No newline at end of file
Index: gnue/gnue-config/base/units/defaults/insert-en-unit.geas
diff -u gnue/gnue-config/base/units/defaults/insert-en-unit.geas:1.1
gnue/gnue-config/base/units/defaults/insert-en-unit.geas:1.2
--- gnue/gnue-config/base/units/defaults/insert-en-unit.geas:1.1 Sun Aug
26 20:02:24 2001
+++ gnue/gnue-config/base/units/defaults/insert-en-unit.geas Sun Sep 2
08:29:39 2001
@@ -3,10 +3,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-unit.geas,v 1.1 2001/08/27 03:02:24 ntiffin Exp $
+-- $Id: insert-en-unit.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO "unit__unit" (objectid, code, desc, decimals) VALUES
+INSERT INTO "unit__unit" (sys_id, code, desc, decimals) VALUES
('GEAS-OBJECT-ID','lbs', 'pounds', 3);
('GEAS-OBJECT-ID','kg', 'kilogram', 3);
('GEAS-OBJECT-ID','each', 'each', 0);
Index: gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas
diff -u
gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas:1.1
gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas:1.2
--- gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas:1.1
Mon Aug 27 16:38:07 2001
+++ gnue/gnue-config/sales/sales-order/defaults/insert-en-line-type.geas
Sun Sep 2 08:29:39 2001
@@ -5,10 +5,10 @@
-- This is a special file format that is converted by the
-- GEAS sql loader into valid sql
--
--- $Id: insert-en-line-type.geas,v 1.1 2001/08/27 23:38:07 ntiffin Exp $
+-- $Id: insert-en-line-type.geas,v 1.2 2001/09/02 15:29:39 ntiffin Exp $
--
-INSERT INTO so__line_type (objectid, code, desc) VALUES
+INSERT INTO so__line_type (sys_id, code, desc) VALUES
('GEAS-OBJECT-ID', 'Svc', 'Service');
('GEAS-OBJECT-ID', 'Tax', 'Tax');
('GEAS-OBJECT-ID', 'Frt', 'Freight');
- gnue/gnue-config accounting/gl/defaults/insert-...,
Neil Tiffin <=