Bills Export

Table 7-7 Bills Export

Element Name	Element Type	Description	Notes
Bills	Complex Element	Root element
hotel_code	Attribute	Identifies the property exporting data	Only one property is exported per file
date	Attribute	Identifies the date of the export	Only one day is exported per file
bill	Complex Element	Repeats for each distinct bill Record
customer_internal_id	Element	Internal id for the payee profile
bill_no	Element	Bill_no associated with reservation
bill_type	Element	Type of the bill
window	Element	The Window number of the bill
status	Element	Status of the bill
total_amount	Element	Total amount of the bill
guest_internal_id	Element	Internal id for the guest profile
queue_name	Element	Name of the printer queue
confirmation_no	Element	Confirmation number of the reservation .
arrival_date	Element	Arrival date of the guest
departure_date	Element	Departure date of the guest
guest_name	Element	Name of the guest
trx_no	Element	Unique number to identify the transations
trx_no_added_by	Element	Transaction number of the parent would be stored in case of Tax generations.
arrangment_id	Element	Arrangement id.
trx_package_no	Element	The Transaction number used to link the all the package elements for a particular day.
trx_code	Element	Transaction code against which this transaction is posted.
trx_date	Element	The date on which the transaction gets posted .
net_amount	Element	Significant in case of Inclusive taxes. If the charge is inclusive of taxes, this column tells us what the contribution of each transaction is.
debit_amount	Element	Debit amount of the reservation .
credit_amount	Element	Credit amount of the reservation .
fiscal_bill_no	Element	Fiscal_Bill number of the reservation .
invoice_no	Element	Invoice number of the reservation .
FOREIGN_CURRENCY	Element	Type of currency in which amount is paid

The following is generated export for Generic XML Back Office - Bill

<?xml version="1.0" encoding="UTF-8"?>
<bills hotel_code="DEMOHOTEL" date="2017-02-23">
  <bill customer_internal_id="947957">
    <bill_no>65</bill_no>
    <status>OK</status>
    <total_amount>180.00</total_amount>
    <guest_internal_id>947957</guest_internal_id>
    <reservation_info>
      <confirmation_no>1086003</confirmation_no>
      <arrival_date>2017-02-23</arrival_date>
      <departure_date>2017-02-23</departure_date>
      <guest_name>GuestName</guest_name>
    </reservation_info>
    <bill_detail>
      <transaction trx_no="903959">
        <trx_code>1000</trx_code>
        <trx_date>2017-02-23</trx_date>
        <net_amount>168.22</net_amount>
        <debit_amount>180.00</debit_amount>
      </transaction>
      <transaction trx_no="903960" trx_no_added_by="903959">
        <trx_code>8000</trx_code>
        <trx_date>2017-02-23</trx_date>
        <net_amount>11.78</net_amount>
      </transaction>
      <transaction trx_no="903961">
        <trx_code>9000</trx_code>
        <trx_date>2017-02-23</trx_date>
        <credit_amount>180.00</credit_amount>
      </transaction>
    </bill_detail>
  </bill>