TeamWox HelpAccountingTemplatesFields Values

Macros of Fields Values

The macros of the values of fields are specified using the following construction:

<tw:macro_name />

The following groups of macros are available for composing templates:

Macros of Information about Beneficiary Company

The beneficiary company is the one that is specified in the "Supplier" field while creating an order. The information about the beneficiary company is taken from the "Organizations" module.

  • COMPANY_BEN_NAME — company name.
  • COMPANY_BEN_PHONE — phone number.
  • COMPANY_BEN_FAX — fax number.
  • COMPANY_BEN_EMAIL — e-mail address.
  • COMPANY_BEN_WEB — website address.
  • COMPANY_BEN_ADDRESS_REGISTERED — registered address.
  • COMPANY_BEN_ADDRESS_POSTAL — postal address.
  • COMPANY_BEN_TIN — TIN.
  • COMPANY_BEN_KPP — KPP
  • COMPANY_BEN_RATING — rating.
  • COMPANY_BEN_TYPE — type.
  • COMPANY_BEN_STATUS — status.
  • COMPANY_BEN_CONTACT — contact person.
  • COMPANY_BEN_COMMENT — comment.
  • COMPANY_BEN_LEADSOURCE — lead source.
  • COMPANY_BEN_ACCOUNT — account of the organization in the bank (settlement account).
  • COMPANY_BEN_BANK — bank name.
  • COMPANY_BEN_BANK_ADDRESS — bank address.
  • COMPANY_BEN_BANK_SWIFT — bank SWIFT.
  • COMPANY_BEN_BANK_ACCOUNT — bank account.
  • COMPANY_BEN_MANAGER — manager of organization.
  • COMPANY_BEN_CIDCID, a unique identifier of organization with the checksum.

Macros of Information about Paying Company

The paying company is the one that is specified in the "Recipient" field while creating an order. The information about this company is also taken from the "Organizations" module. The set of macros is the same as specified above but the "_PAY_" symbols are used in their names instead of "_BEN_":

  • COMPANY_PAY_NAME — company name.
  • COMPANY_PAY_PHONE — phone number.
  • COMPANY_PAY_FAX — fax number.
  • COMPANY_PAY_EMAIL — e-mail address.
  • COMPANY_PAY_WEB — website address.
  • COMPANY_PAY_ADDRESS_REGISTERED — registered address.
  • COMPANY_PAY_ADDRESS_POSTAL — postal address.
  • COMPANY_PAY_TIN — TIN.
  • COMPANY_PAY_KPP — KPP.
  • COMPANY_PAY_RATING — rating.
  • COMPANY_PAY_TYPE — type.
  • COMPANY_PAY_STATUS — status.
  • COMPANY_PAY_CONTACT — contact person.
  • COMPANY_PAY_COMMENT — comment.
  • COMPANY_PAY_LEADSOURCE — lead source.
  • COMPANY_PAY_ACCOUNT — account of the organization in the bank (settlement account).
  • COMPANY_PAY_BANK — bank name.
  • COMPANY_PAY_BANK_ADDRESS — bank address.
  • COMPANY_PAY_BANK_SWIFT — bank SWIFT.
  • COMPANY_PAY_BANK_ACCOUNT — bank account.
  • COMPANY_PAY_MANAGER — manager of organization.
  • COMPANY_PAY_CIDCID, a unique identifier of organization with the checksum.

Macros of Order Details

The details of the order are taken from the page of editing it.

  • INVOICE_NUMBER — order number.
  • INVOICE_BOOK — name of the book the order belongs to.
  • INVOICE_DATE — date to which the order is made. It is selected when viewing the order.
  • INVOICE_OPER_DATE — date of order.
  • INVOICE_CREATE_TIME — date of order creation.
  • INVOICE_MODIFY_TIME — date of last modification of order.
  • INVOICE_AMOUNT — amount to be paid by the order.
  • INVOICE_AMOUNT_TAX — tax amount.
  • INVOICE_AMOUNT_NO_TAX — amount to be paid by the order without tax.
  • INVOICE_AMOUNT_TAX_STRING —  tax amount in words.
  • INVOICE_CURRENCY — accounting currency.
  • INVOICE_MANAGER — manager of the order.
  • INVOICE_COMMENT — comment to the order.
  • INVOICE_AUTHOR — author of the order.
  • INVOICE_MODIFY — name of the employee that made last changes to the order.
  • INVOICE_LINES — number of items (products) in the order.

Macros of Information about Products in Orders

This information is also taken from the currently selected order. Each macro gives the information about one data field of a product. In order to obtain information about all products in the order, one should use the special construction.

  • INVOICE_LINE_COUNTER — serial number of the product line.
  • INVOICE_LINE_PRODUCT — product name.
  • INVOICE_LINE_UNIT — units of measurement of the product.
  • INVOICE_LINE_PERIOD — periodicity of the product supplying.
  • INVOICE_LINE_START_DATE — date of the beginning of product supplying.
  • INVOICE_LINE_END_DATE — date of the end of product supplying.
  • INVOICE_LINE_PRICE — price for unit of product.
  • INVOICE_LINE_PRICE_NO_TAX — price for the unit of product without tax.
  • INVOICE_LINE_QUANTITY — quantity.
  • INVOICE_LINE_AMOUNT — amount to be paid for the product.
  • INVOICE_LINE_AMOUNT_NO_TAX — amount to be paid for the product without tax.
  • INVOICE_LINE_TAX — tax rate.
  • INVOICE_LINE_AMOUNT_TAX — tax amount.
  • INVOICE_LINE_COMMENT — comment.
  • INVOICE_LINE_COMMENT_INFO — this macro also substitutes the comment to the product, but if that field is empty then the text of comment to the order itself is substituted.
  • INVOICE_LINE_DEBIT — displays the product price if its value is positive. This macro is used for forming the account reconciliation for an organization. If an organization, for which the account reconciliation is formed, supplies a product, the product price is considered as a positive value. If the organization receives the product, the product price is considered as a negative value. Thus, using this macro you can display the Debit rate for the organization.
  • INVOICE_LINE_CREDIT — displays the product price if its value is negative. This macro is used for forming the account reconciliation for an organization. If an organization, for which the account reconciliation is formed, supplies a product, the product price is considered as a positive value. If the organization receives the product, the product price is considered as a negative value. Thus, using this macro you can display the Credit rate for the organization.

← Macros Fields Names →