How can I retrieve taxCodes details from Netsuite ...
# suiteql
d
How can I retrieve taxCodes details from Netsuite using SuiteQL? When I query
salestaxitem
I don't get information like taxcode, rate, subsidiary, etc, instead:
Copy code
SELECT *
FROM salestaxitem
WHERE rownum = 1
Result:
Copy code
{
  "custrecord_4110_triplicate": "F",
  "custrecord_notional_tax_credit_account": null,
  "custrecord_4110_purchaser_issued": "F",
  "custrecord_4110_nondeductible_account": null,
  "custrecord_4110_electronic": "F",
  "custrecord_tax_exemption_reason": null,
  "custrecord_post_notional_tax_amount": "F",
  "custrecord_4110_category": null,
  "custrecord_4110_parent_alt": null,
  "custrecord_4110_non_operation": "F",
  "custrecord_deemed_supply": "F",
  "custrecord_4110_surcharge": "F",
  "custrecord_gcc_state": "F",
  "custrecord_4110_duplicate": "F",
  "custrecord_is_direct_cost_service": "F",
  "custrecord_4110_super_reduced": "F",
  "custrecord_4110_outside_customs": "F",
  "custrecord_4110_cash_register": "F",
  "custrecord_4110_special_territory": "F",
  "custrecord_4110_unknown_tax_credit": "F",
  "custrecord_4110_non_resident": "F",
  "isinactive": "F",
  "custrecord_4110_no_tax_invoice": "F",
  "custrecord_notional_tax_debit_account": null,
  "custrecord_4110_non_taxable": "F",
  "custrecord_deferred_on": null,
  "custrecord_4110_partial_credit": "F",
  "custrecord_4110_other_tax_evidence": "F",
  "custrecord_4110_reduced_rate": "F",
  "custrecord_for_digital_services": "F",
  "description": "EC Goods standard rate",
  "taxtype": 1,
  "custrecord_4110_capital_goods": "F",
  "custrecord_4110_non_deductible": "F",
  "custrecord_4110_suspended": "F",
  "custrecord_4110_no_tax_credit": "F",
  "custrecord_4110_reverse_charge_alt": "F",
  "custrecord_4110_paid": "F",
  "id": 12,
  "custrecord_4110_non_recoverable": "F",
  "custrecord_4110_duty": "F",
  "custrecord_4110_government": "F",
  "custrecord_4110_nondeductible_parent": null,
  "custrecord_4110_import": "F"
}
Can anyone advise? Thanks!
s
Would not be shocked if its not exposed to query.