Hello NetSuite gurus! Hope you can help me locate a field via a SuiteScript. We are attempting to pull out Item Receipts (IRs) but are noticing the amount field (Rate in the UI) is not a record in the results. Does anyone know where the amount value is stored via the SuiteScript/Rest API or in which db table as it is not in the transaction table? We can see that as a field when creating at saved search and workbook, but can't locate the field via a SuiteScript. Does anyone know what record/table we need to join to find this field?

try effective rate on the saved search? in formulas will be below :v

{effectiverate}