/dports/finance/ledgersmb12/ledgersmb/sql/legacy/ |
H A D | Pg-upgrade-1.4.0-1.6.0.sql | 6 alter table parts rename column income_accno to income_accno_id; 11 update parts set income_accno_id = 12 (select id from chart where chart.accno = parts.income_accno_id); 19 alter table defaults rename column income_accno to income_accno_id; 25 update defaults set income_accno_id = 26 (select id from chart where chart.accno = defaults.income_accno_id); 32 alter table invoice rename column income_accno to income_accno_id; 39 update invoice set income_accno_id = 40 (select id from chart where invoice.income_accno_id = chart.accno);
|
H A D | Pg-upgrade-1.6.0-1.8.0.sql | 4 income_accno_id int, field 16 … income_accno_id, expense_accno_id, invnumber, ordnumber, yearend, weightunit, businessnumber, ver…
|
H A D | Pg-upgrade-2.6.18-2.6.19.sql | 172 SELECT 'income_accno_id', income_accno_id::text FROM old_defaults
|
/dports/finance/sql-ledger/sql-ledger/sql/ |
H A D | Pg-upgrade-1.4.0-1.6.0.sql | 6 alter table parts rename column income_accno to income_accno_id; 11 update parts set income_accno_id = 12 (select id from chart where chart.accno = parts.income_accno_id); 19 alter table defaults rename column income_accno to income_accno_id; 25 update defaults set income_accno_id = 26 (select id from chart where chart.accno = defaults.income_accno_id); 32 alter table invoice rename column income_accno to income_accno_id; 39 update invoice set income_accno_id = 40 (select id from chart where invoice.income_accno_id = chart.accno);
|
H A D | Pg-upgrade-1.6.0-1.8.0.sql | 4 income_accno_id int, field 16 … income_accno_id, expense_accno_id, invnumber, ordnumber, yearend, weightunit, businessnumber, ver…
|
H A D | Pg-upgrade-2.7.11-2.7.12.sql | 46 income_accno_id int, field 63 …income_accno_id, expense_accno_id, bin, obsolete, bom, image, drawing, microfiche, partsgroup_id, …
|
H A D | DB2-tables.sql | 60 income_accno_id INTEGER, 177 income_accno_id INTEGER,
|
H A D | Oracle-tables.sql | 48 income_accno_id INTEGER, field 152 income_accno_id INTEGER, field
|
H A D | Pg-upgrade-2.7.5-2.7.6.sql | 33 insert into defau (fldname, fldvalue) values ('income_accno_id', (select income_accno_id from defau…
|
H A D | Pg-tables.sql | 167 income_accno_id int, field
|
H A D | UCOA-Form990-chart.sql | 229 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc…
|
H A D | UCOA-Form990EZ-chart.sql | 229 INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE acc…
|
/dports/www/interchange/interchange-5.6.3/lib/Vend/Accounting/ |
H A D | SQL_Ledger.pm | 538 my $sacc = $cfg->{income_accno_id} || 4020; 784 income_accno_id => 4020, 793 income_accno_id => sub { my $val = shift; return $val || shift || 0 }, 801 income_accno_id => 'select id from chart where accno = ?',
|
/dports/finance/ledgersmb12/ledgersmb/LedgerSMB/ |
H A D | AM.pm | 1401 income_accno_id => 'IC_income', 1467 $form->{defaults}{IC_income} = $form->{income_accno_id}; 1468 $form->{defaults}{IC_sale} = $form->{income_accno_id};
|
H A D | IR.pm | 118 && $ref->{income_accno_id} )
|
/dports/finance/sql-ledger/sql-ledger/SL/ |
H A D | JC.pm | 458 …$ref->{type} = ($ref->{inventory_accno_id} && $ref->{income_accno_id}) ? 'storescard' : 'timecard';
|
H A D | IS.pm | 1863 chart_id => $kit{$_}{income_accno_id}, 2450 unless ($ref->{inventory_accno_id} + $ref->{income_accno_id} + $ref->{expense_accno_id}) { 2646 if ($n = $ref->{inventory_accno_id} + $ref->{income_accno_id} + $ref->{expense_accno_id}) { 2647 next unless $ref->{income_accno_id};
|
H A D | IC.pm | 57 $form->{item} = 'labor' if ! $form->{income_accno_id}; 59 …$form->{item} = 'kit' unless $form->{inventory_accno_id} + $form->{income_accno_id} + $form->{expe… 1129 next unless $ref->{inventory_accno_id} + $ref->{income_accno_id} + $ref->{expense_accno_id};
|
H A D | IR.pm | 2177 unless ($ref->{inventory_accno_id} + $ref->{income_accno_id} + $ref->{expense_accno_id}) { 2365 if ($n = $ref->{inventory_accno_id} + $ref->{income_accno_id} + $ref->{expense_accno_id}) { 2366 next unless $ref->{income_accno_id};
|
/dports/finance/ledgersmb12/ledgersmb/bin/ |
H A D | jc.pl | 458 if ( $form->{income_accno_id} ) { 809 if ( $form->{income_accno_id} ) {
|
/dports/finance/ledgersmb12/ledgersmb/sql/ |
H A D | UCOA-Form990-chart.sql | 231 …INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where a…
|
H A D | UCOA-Form990EZ-chart.sql | 231 …INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where a…
|
H A D | Pg-database.sql | 169 income_accno_id int, field
|
/dports/finance/sql-ledger/sql-ledger/bin/mozilla/ |
H A D | jc.pl | 456 if ($form->{income_accno_id}) { 816 if ($form->{income_accno_id}) {
|
/dports/finance/sql-ledger/sql-ledger/bin/lynx/ |
H A D | jc.pl | 456 if ($form->{income_accno_id}) { 816 if ($form->{income_accno_id}) {
|