name | id | parent_id -------------------------------+----+----------- OTAX S | 1 | OTAX R | 2 | OTAX X | 3 | OTAX O | 4 | ITAX S | 5 | ITAX R | 6 | ITAX X | 7 | ITAX O | 8 | GST + PST for sales (MB) | 9 | GST for sales - 5% (MB) | 10 | 9 PST for sales - 7% | 11 | 9 GST + PST for sales (PE) | 12 | GST for sales - 5% (PE) | 13 | 12 PST for sale - 10% | 14 | 12 GST + TVQ for sales | 15 | GST for sales - 5% (QC) | 16 | 15 TVQ for sales - 9.5% | 17 | 15 GST + PST for sales (SK) | 18 | GST for sales - 5% (SK) | 19 | 18 PST for sales - 5% (SK) | 20 | 18 TVH for sales - 12% | 21 | TVH for sales - 13% | 22 | TVH for sales - 13.5% | 23 | TVH for sales - 15% | 24 | GST for sales - 5% | 25 | GST + PST for purchases (MB) | 26 | GST for purchases - 5% (MB) | 27 | 26 PST for purchases - 7% | 28 | 26 GST + PST for purchases (PE) | 29 | GST for purchases - 5% (PE) | 30 | 29 ---------> Parent PST for purchases - 10% | 31 | 29 GST + TVQ for purchases | 32 | GST for purchases - 5% (QC) | 33 | 32 TVQ for purchases - 9.5% | 34 | 32 GST + PST for purchases (SK) | 35 | GST for purchases - 5% (SK) | 36 | 35 PST for purchases - 5% (SK) | 37 | 35 TVH for purchases - 12% | 38 | TVH for purchases - 13% | 39 | TVH for purchases - 13.5% | 40 | TVH for purchases - 15% | 41 | GST for purchases - 5% | 42 | TPS + TVP sur les ventes (MB) | 43 | 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 name | id | parent_id ------------------------------+-----+----------- GST + PST for purchases (SK) | 4 | GST + PST for purchases (SK) | 79 | GST + PST for sales (MB) | 10 | GST + PST for sales (PE) | 11 | GST + TVQ for sales | 13 | GST + PST for sales (SK) | 15 | GST + PST for sales (MB) | 85 | GST + PST for sales (PE) | 86 | GST + TVQ for sales | 88 | GST + PST for purchases (MB) | 22 | GST + PST for purchases (PE) | 24 | GST + PST for sales (SK) | 90 | GST + TVQ for purchases | 26 | GST + PST for purchases (MB) | 97 | GST for purchases - 5% | 1 | GST for sales - 5% (MB) | 2 | GST for purchases - 5% (QC) | 3 | GST for purchases - 5% (SK) | 5 | 4 TVH for purchases - 12% | 6 | TVH for purchases - 13% | 7 | TVH for purchases - 13.5% | 8 | TVH for purchases - 15% | 9 | GST for sales - 5% (PE) | 12 | 11 GST for sales - 5% (QC) | 14 | 13 GST for sales - 5% (SK) | 16 | 15 TVH for sales - 12% | 17 | TVH for sales - 13% | 18 | TVH for sales - 13.5% | 19 | TVH for sales - 15% | 20 | GST for sales - 5% | 21 | GST for purchases - 5% (MB) | 23 | 22 GST for purchases - 5% (PE) | 25 | 24 --> Parent PST for sales - 7% | 27 | 10 PST for purchases - 7% | 28 | 22 PST for sales - 5% (SK) | 29 | 15 PST for sale - 10% | 30 | 11 TVQ for purchases - 9.5% | 31 | 26 PST for purchases - 5% (SK) | 32 | 4 TVQ for sales - 9.5% | 33 | 13 PST for purchases - 10% | 34 | 24 GST + PST for purchases (PE) | 99 | GST + TVQ for purchases | 101 | GST for purchases - 5% | 76 | -----------------------------------------------------------------------------------