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) |