Hi. We are trying to get the intercompanyjournalen...
# general
p
Hi. We are trying to get the intercompanyjournalentry records through SuiteQL. When we see using recordModule.load(id), we get linebasecurrency, linefxrate(line level fields). How to get these fields in through suiteQL?
t
I think that both of those values are actually stored at the transaction header level. For example:
Copy code
SELECT
	Transaction.Type,
	Transaction.TranID,
	Transaction.TranDate,
	Transaction.Voided,
	TransactionLine.LineSequenceNumber,
	TransactionLine.Subsidiary,
	BUILTIN.DF( TransactionLine.Subsidiary ) AS SubsidiaryName,
	TransactionLine.Entity,
	BUILTIN.DF( TransactionLine.Entity ) AS EntityName,
	TransactionLine.NetAmount,
	BUILTIN.DF( Transaction.Currency ) AS Currency,
	Transaction.Exchangerate,
	BUILTIN.DF( TransactionLine.ExpenseAccount ) AS ExpenseAccount,
	TransactionLine.Eliminate,
	TransactionLine.IsRevRecTransaction,
	TransactionLine.CreditForeignAmount,
	TransactionLine.DebitForeignAmount,
	TransactionLine.Memo	
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
WHERE
	Transaction.JournalType = 'ADVANCED_INTERCOMPANY_JOURNAL'
	AND Transaction.ID = 240082
ORDER BY
	TransactionLine.LineSequenceNumber
I hope that helps.
p
Thanks a lot. Yes it helps.