BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0189'); UPDATE action_trigger.event_definition SET template = $$ [%- USE date -%] [%- # find a lineitem attribute by name and optional type BLOCK get_li_attr; FOR attr IN li.attributes; IF attr.attr_name == attr_name; IF !attr_type OR attr_type == attr.attr_type; attr.attr_value; LAST; END; END; END; END -%]
Vendor |
[% target.provider.name %]
[% target.provider.addresses.0.street1 %]
[% target.provider.addresses.0.street2 %]
[% target.provider.addresses.0.city %]
[% target.provider.addresses.0.state %]
[% target.provider.addresses.0.country %]
[% target.provider.addresses.0.post_code %]
|
Ship to / Bill to |
[% target.ordering_agency.name %]
[% target.ordering_agency.billing_address.street1 %]
[% target.ordering_agency.billing_address.street2 %]
[% target.ordering_agency.billing_address.city %]
[% target.ordering_agency.billing_address.state %]
[% target.ordering_agency.billing_address.country %]
[% target.ordering_agency.billing_address.post_code %]
|
PO# | ISBN or Item # | Title | Quantity | Unit Price | Line Total | Notes |
---|---|---|---|---|---|---|
[% target.id %] | [% isbn || ident %] | [% PROCESS get_li_attr attr_name = 'title' %] | [% count %] | [% price %] | [% litotal %] |
|
Sub Total | [% subtotal %] |