fldvalue (reference) in projects: dports

Project(s)

Full Search
Definition
Symbol
File Path
History
Type

Searched refs:fldvalue (Results 1 – 25 of 112) sorted by relevance

12 3 4 5

/dports/finance/sql-ledger/sql-ledger/sql/
H A D	Pg-upgrade-2.7.5-2.7.6.sql	31 create table defau (fldname text, fldvalue text); field 37 insert into defau (fldname, fldvalue) values ('sinumber', (select sinumber from defaults)); 38 insert into defau (fldname, fldvalue) values ('sonumber', (select sonumber from defaults)); 39 insert into defau (fldname, fldvalue) values ('yearend', (select yearend from defaults)); 42 insert into defau (fldname, fldvalue) values ('version', (select version from defaults)); 43 insert into defau (fldname, fldvalue) values ('currencies', (select curr from defaults)); 44 insert into defau (fldname, fldvalue) values ('closedto', (select closedto from defaults)); 45 insert into defau (fldname, fldvalue) values ('revtrans', '0'); 46 insert into defau (fldname, fldvalue) values ('ponumber', (select ponumber from defaults)); 49 insert into defau (fldname, fldvalue) values ('audittrail', '0'); [all …]
H A D	Hungary-chart.sql	48 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 49 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 50 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 51 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 52 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 53 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 54 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '0');
H A D	Hungary-UTF8-chart.sql	48 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 49 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 50 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 51 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 52 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 53 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 54 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '0');
H A D	US_Service_Company-chart.sql	67 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 68 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 69 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'lbs'); 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Pg-upgrade-2.8.6-2.8.7.sql	`11 update curr set rn = 1 where curr = (select substr(fldvalue,1,3) from defaults where fldname = 'cur… 16 insert into defaults (fldname,fldvalue) values ('precision', 2); 19 update defaults set fldvalue = '2.8.7' where fldname = 'version';`
H A D	Bahasa-Indonesia-Default-chart.sql	72 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 76 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 77 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Brazil-General-UTF8-chart.sql	69 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Brazil-General-chart.sql	69 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Canada-English_General-chart.sql	69 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Canada-French_General-chart.sql	78 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 84 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Canada-French-UTF8_General-chart.sql	78 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 84 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Estonian-KA2-chart.sql	69 insert into defaults (fldname, fldvalue) values ('inventory_accno_id', (select id from chart where … 70 insert into defaults (fldname, fldvalue) values ('income_accno_id', (select id from chart where acc… 71 insert into defaults (fldname, fldvalue) values ('expense_accno_id', (select id from chart where ac… 72 insert into defaults (fldname, fldvalue) values ('fxgain_accno_id', (select id from chart where acc… 73 insert into defaults (fldname, fldvalue) values ('fxloss_accno_id', (select id from chart where acc… 74 insert into defaults (fldname, fldvalue) values ('weightunit', 'kg'); 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Estonian-UTF8-chart.sql	69 insert into defaults (fldname, fldvalue) values ('inventory_accno_id', (select id from chart where … 70 insert into defaults (fldname, fldvalue) values ('income_accno_id', (select id from chart where acc… 71 insert into defaults (fldname, fldvalue) values ('expense_accno_id', (select id from chart where ac… 72 insert into defaults (fldname, fldvalue) values ('fxgain_accno_id', (select id from chart where acc… 73 insert into defaults (fldname, fldvalue) values ('fxloss_accno_id', (select id from chart where acc… 74 insert into defaults (fldname, fldvalue) values ('weightunit', 'kg'); 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	German-Service-Company-UTF8-chart.sql	68 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 69 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	German-Service-Company-chart.sql	68 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 69 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 70 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 71 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 72 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 73 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 74 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Danish-Default-chart.sql	74 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 76 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 77 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Danish-UTF8-Default-chart.sql	74 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 75 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 76 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 77 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Simplified-Chinese_Default-chart.sql	77 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Dutch-Default-chart.sql	79 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 84 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 85 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Traditional-Chinese_Default-UTF8-chart.sql	77 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	US_Manufacturing-chart.sql	81 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 84 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 85 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 86 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'lbs'); 87 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Simplified-Chinese_Default-UTF8-chart.sql	77 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Traditional-Chinese_Default-chart.sql	77 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 78 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 79 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 80 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 81 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 82 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 83 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Venezuela-UTF8-chart.sql	87 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 88 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 89 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 90 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 91 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 92 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 93 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
H A D	Venezuela-chart.sql	87 INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE … 88 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc… 89 INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE ac… 90 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE acc… 91 INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE acc… 92 INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 93 INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');

12 3 4 5