Transaction Details Table Fields and Placeholders

Invoice Summary Field

XML Template Placeholders

Notes

Transaction Date Label

{ids.label.tran_date}

This is a label. It can be changed or hardcoded.

Transaction Number Label

{ids.label.tran_no}

This is a label. It can be changed or hardcoded.

Transaction ID Label

ids.label.tran_id

This is a label. It can be changed or hardcoded.

Item Code Label

{ids.label.item_code}

This is a label. It can be changed or hardcoded.

Item Quantity Label

{ids.label.item_quantity}

This is a label. It can be changed or hardcoded.

Currency Label

{ids.label.currency}

This is a label. It can be changed or hardcoded.

Exchange Rate Label

{ids.label.exchange_rate}

This is a label. It can be changed or hardcoded.

Foreign Amount Label

{ids.label.foreign_amount}

This is a label. It can be changed or hardcoded.

Item Price Label

{ids.label.item_price}

This is a label. It can be changed or hardcoded.

Tax Label

{ids.label.line_tax}

This is a label. It can be changed or hardcoded.

Amount Label

{ids.label.line_amount}

This is a label. It can be changed or hardcoded.

Due Date Label

{ids.label.line_due_date}

This is a label. It can be changed or hardcoded.

Transaction Date Value

${transaction.trandate}

This data is sourced from the transaction record.

Transaction Number Value

${transaction.transactionnumber}

This data is sourced from the transaction record.

Transaction ID Value

transaction.tranid

This data is sourced from the transaction record.

Item Code Value

${transaction.item}

This data is sourced from the transaction record.

Item Quantity Value

${transaction.quantity}

This data is sourced from the transaction record.

Currency Value

${transaction.currency}

This data is sourced from the transaction record.

Exchange Rate Value

${transaction.exchangerate}

This data is sourced from the transaction record.

Foreign Value

${transaction.fxamount}

This data is sourced from the transaction record.

Item Price Value

${transaction.rate}

This data is sourced from the transaction record.

Item Tax Value

${transaction.taxamount}

This data is sourced from the transaction record.

Item Amount

${transaction.formulacurrency}

This data is sourced from the transaction record.

Due Date

For invoices:

${transaction.duedate}

For credit memos:

${transaction.custbody_jp_invoice_summary_due_date}

This data is sourced from the transaction record.

Note:

In addition to the fields in the previous table, the field PO#, ${transaction.otherrefnum}, in invoice and credit memo records can also be used in the invoice summary template. Aside from these, other fields in transaction records can't be added yet.

General Notices