Diogo
06/04/2021, 8:28 AMsalestaxitem
I don't get information like taxcode, rate, subsidiary, etc, instead:
SELECT *
FROM salestaxitem
WHERE rownum = 1
Result:
{
"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!Sandii
06/04/2021, 3:47 PM