CHMlib Logo
You are reading help file online using chmlib.com
CrisisHelper - First Aid in Tough Times of World Economic Crisis


_bm0 Invoice Template Variables

Top  Previous  Next

Dataset:

DATASET WITH COLUMN NAME

DESCRIPTION

\DTLINKJOBS:CJOB_PONUMB\

Client PO

\DTLINKJOBS:CJOB_NAME\

Job Name

\DTLINKJOBS:CJOB_ASSIGNED\

Assigned

\DTLINKJOBS:CJOB_DEADLINE\

Deadline

\DTLINKJOBS:CJOB_ISCOMPLETED\

Completed (Boolean: True/False)

\DTLINKJOBS:CJOB_COMPLETED\

Completed

\DTLINKJOBS:CJOB_PRICE\

Unit Price

\DTLINKJOBS:CJOB_VOLUME\

Volume

\DTLINKJOBS:CJOB_FEE_KIND\

Pricing

\DTLINKJOBS:CJOB_RATE\

Exchange Rate

\DTLINKJOBS:CJOB_TOTAL\

Job Total

\DTLINKJOBS:CJOB_INSTRUCTION\

Instructions

\DTLINKJOBS:CJOB_WORKNOTES\

Work Notes

\DTLINKJOBS:CJOB_COUNTNOTES\

Count Notes

\DTLINKJOBS:SERV_NAME\

Service

\DTLINKJOBS:UNIT_NAME\

Units

\DTLINKJOBS:PROJ_CODE\

Project Code

\DTLINKJOBS:CJOB_CODE\

Job Code

 

_bm2

 

INVOICE

VARIABLE

DESCRIPTION

\STATUS\

Invoice status (For example: “Expected within 30 days”, “Settled 5 days earlier” etc.)

\DATE_ DUE\

\SETTLEMENT_DATE\

\DUE_DATE\

Date when invoice is due in following format: 10/4/2006.

\DATE_DUE_LONG\

\SETTLEMENT_LONGDATE\

\DUE_DATELONG\

Date when invoice is due in following format: Monday, October 04, 2006.

\INVOICE_DATE\

\INV_DATE\

Date invoice sent in following format: 10/4/2006.

\INVOICE_DATE_LONG\

\INVOICE_LONGDATE\

Date invoice sent in following format: Monday, October 04, 2006.

\INVOICE _CODE\

\INV_CODE\

Invoice code

\INVOICE _GLOBAL_CODE\

\INV_GLOBAL\

\INV_GLOBALLONG\

Invoice global code.

\INVOICE_TOTAL\

\INV_TOTAL\

Invoice total.

\JOBS_TOTAL\

Jobs total.

\TAX1\

\TAX\

Used in algorithms (If tax exists = True, if it doesn’t = False)

\TAX1_NAME\

\TAX1NAME\

\TAXNAME\

Tax 1 name.

\TAX1_VALUE\

\TAX1VALUE\

\TAXVALUE\

Tax value.

\TAX2\

Used in algorithms (If tax 2 exists = True, if it doesn’t = False)

\TAX2_NAME\

\TAX2NAME\

Tax 2 name.

\TAX2_VALUE\

\TAX2VALUE\

Tax 2 value.

\DISCOUNT1\

\DISCOUNT\

Used in algorithms (If discount exists = True, if it does not = False)

\DISCOUNT1_NAME\

\DISCOUNTNAME\

\DISCOUNT1NAME\

Discount 1 name.

\DISCOUNT1_VALUE\

\DISCOUNT1VALUE\

\DISCOUNTVALUE\

Discount 1 value.

\DISCOUNT2\

Used in algorithms (If Discount 2 exists = True, if it does not = False)

\DISCOUNT2_NAME\

\DISCOUNT2NAME\

Discount 2 name.

\DISCOUNT2_VALUE\

\DISCOUNTVALUE\

Discount 2 value.

\TAXES\

Used in algorithms (If any tax is set = True, if it they are not = False)

\DISCOUNTS\

Used in algorithms (If any discount is set = True, if there are no = False)

\AFTER_DISCOUNT1\

\AFTERDISCOUNT1\

\AFTERDISCOUNT\

Total after Discount1 applied.

\NET_JOBS_TOTAL\

\NETJOBSTOTAL\

Jobs total with discounts.

\AFTER_TAX1\

\AFTERTAX1\

Total after Tax1 applied.

\INV_DUE\

\INVOICE_DUE\

Balance due.

\INV_PAID\

\INVOICE_PAID\

Sum paid by this Invoice.

\INV_IS_PAID\

Used in algorithms (If the Invoice is paid = True, if it’s not = False)

\BEFORE_ADJUSTMENTS\

Invoice total excluding Adjustments

 

_bm2

 

See Also: Logic of Templates



You are reading help file online using chmlib.com

If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com
Partner sites: Logo Design, Simple Anti-Crisis Accounting Software, Voice Search for Web