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_ |
This data is sourced from the transaction record. |
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.