Ever get confused about which fields do what when creating A/R – oriented SuiteQL reports? Here’s a table that help organize the fields and their meanings:
| Transaction Types | Table | Field | Meaning |
|---|---|---|---|
| All Types | transactionLine | foreignamount | Transaction amount in transaction currency |
| All Types | transactionAccountingLine | amount | Transaction amount in GL base currency |
| Invoice | transaction | foreignAmountPaid | Total paid amount, in the transaction currency |
| Invoice | transaction | foreignAmountUnpaid | Total unpaid (open) amount, in the transaction currency |
| Customer Deposit, Payment, Credit Memo | transaction | foreignPaymentAmountUnused | Total unapplied (open) amount in the transaction currency |
| Customer Deposit, Deposit Application, Payment, Credit Memo | transaction | foreignPaymentAmountUsed | Total applied amount in the transaction currency |
| Invoice, Journal Entry | transactionLine | foreignAmountPaid | Total paid amount, in the transaction currency (note: JE only if Dr to A/R) |
| Invoice, Journal Entry | transactionLine | foreignAmountUnpaid | Total unpaid amount, in the transaction currency (note: JE only if Dr to A/R) |
| Customer Deposit, Deposit Application, Payment, Credit Memo, Journal Entry | transactionLine | foreignPaymentAmountUsed | Total applied amount in the transaction currency (note: JE only if Cr to A/R) |
| Customer Deposit, Payment, Credit Memo, Journal Entry | transactionLine | foreignPaymentAmountUnused | Total unapplied (open) amount in the transaction currency (note: JE only if Cr to A/R) |
| Invoice, Journal Entry | transactionAccountingLine | amountPaid | The amount “settled” against a Debit to A/R, in GL base currency (note: JE only if Dr to A/R) |
| Invoice, Journal Entry | transactionAccountingLine | amountUnpaid | Total unpaid amount, in GL base currency (note: JE only if Dr to A/R) |
| Customer Deposit, Deposit Application, Payment, Credit Memo, Journal Entry | transactionAccountingLine | paymentAmountUsed | Total applied amount in GL base currency (note: JE only if Cr to A/R) |
| Customer Deposit, Payment, Credit Memo, Journal Entry | transactionAccountingLine | paymentAmountUnused | Total unapplied (open) amount in GL base currency (note: JE only if Cr to A/R) |
Conversations with Meir Bulman 