Bills Export
Table 8-11 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 |
Attribute |
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 |
Unique, internal ID for the payee profile |
Can be used to link to the customers file to obtain additional info on the customer (internal_id tag) |
|
queue_name |
Element |
Name of the printer queue |
|
|
reservation_info |
Complex Element |
Reservation Info |
|
|
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 |
Attribute |
Unique number to identify the transations |
|
|
trx_no_added_by |
Attribute |
Transaction number of the parent would be stored in case of Tax generations. |
|
|
bill_detail |
Complex Element |
Bill Detail |
|
|
transaction |
Complex Element |
Transaction |
|
|
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 for countries where Fiscal Folio Printing is enabled. May be blank in others. Usually the number returned by the fiscal printer or government web service. |
|
|
invoice_no |
Element |
Invoice number of the reservation . |
|
|
foreign_currency |
Element |
Type of currency in which amount is paid |
|
|
foreign_amount |
Element |
Foreign Amount |
|
|
name_tax_type |
Simple Element |
Name tax type of the payee profile |
The following is generated export for Generic XML Back Office -
Bill
<?xml version="1.0" encoding="UTF-8"?> <?xml version="1.0" encoding="UTF-8"?> <?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>
< <?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>
<bill customer_internal_id="947959">
<bill_no>66</bill_no>
<status>OK</status>
<total_amount>450.00</total_amount>
<invoice_no>44</invoice_no>
<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="903962">
<trx_code>9080</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>450.00</credit_amount>
</transaction>
<transaction trx_no="903955">
<trx_code>2000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>93.46</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="903956" trx_no_added_by="903955">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>6.54</net_amount>
</transaction>
<transaction trx_no="903957">
<trx_code>2110</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>150.00</net_amount>
<debit_amount>150.00</debit_amount>
</transaction>
<transaction trx_no="903958">
<trx_code>2150</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>200.00</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947973">
<bill_no>67</bill_no>
<status>OK</status>
<total_amount>220.00</total_amount>
<guest_internal_id>947973</guest_internal_id>
<reservation_info>
<confirmation_no>1086062</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="903970">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>205.61</net_amount>
<debit_amount>220.00</debit_amount>
</transaction>
<transaction trx_no="903971" trx_no_added_by="903970">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>14.39</net_amount>
</transaction>
<transaction trx_no="903972">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>220.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947975">
<bill_no>68</bill_no>
<status>OK</status>
<total_amount>750.00</total_amount>
<invoice_no>45</invoice_no>
<guest_internal_id>947973</guest_internal_id>
<reservation_info>
<confirmation_no>1086062</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="903967">
<trx_code>3020</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>250.00</net_amount>
<debit_amount>250.00</debit_amount>
</transaction>
<transaction trx_no="903968">
<trx_code>2000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>280.37</net_amount>
<debit_amount>300.00</debit_amount>
</transaction>
<transaction trx_no="903969" trx_no_added_by="903968">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>19.63</net_amount>
</transaction>
<transaction trx_no="903973">
<trx_code>9080</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>750.00</credit_amount>
</transaction>
<transaction trx_no="903966">
<trx_code>2020</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>200.00</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947989">
<bill_no>69</bill_no>
<status>OK</status>
<total_amount>700.00</total_amount>
<guest_internal_id>947989</guest_internal_id>
<reservation_info>
<confirmation_no>1086155</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="903994">
<trx_code>2070</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>200.00</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
<transaction trx_no="903995">
<trx_code>2010</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>300.00</net_amount>
<debit_amount>300.00</debit_amount>
</transaction>
<transaction trx_no="903993">
<trx_code>2100</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>100.00</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="903996">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>93.46</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="903997" trx_no_added_by="903996">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>6.54</net_amount>
</transaction>
<transaction trx_no="903999">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>700.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947991">
<bill_no>70</bill_no>
<status>OK</status>
<total_amount>850.00</total_amount>
<guest_internal_id>947991</guest_internal_id>
<reservation_info>
<confirmation_no>1086163</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="904000">
<trx_code>3050</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>150.00</net_amount>
<debit_amount>150.00</debit_amount>
</transaction>
<transaction trx_no="904001">
<trx_code>3060</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>250.00</net_amount>
<debit_amount>250.00</debit_amount>
</transaction>
<transaction trx_no="904002">
<trx_code>3070</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>350.00</net_amount>
<debit_amount>350.00</debit_amount>
</transaction>
<transaction trx_no="904003">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>93.46</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="904004" trx_no_added_by="904003">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>6.54</net_amount>
</transaction>
<transaction trx_no="904006">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>850.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947993">
<bill_no>71</bill_no>
<status>OK</status>
<total_amount>710.00</total_amount>
<guest_internal_id>947993</guest_internal_id>
<reservation_info>
<confirmation_no>1086170</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="904010">
<trx_code>2000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>186.92</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
<transaction trx_no="904011" trx_no_added_by="904010">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>13.08</net_amount>
</transaction>
<transaction trx_no="904007">
<trx_code>5020</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>40.00</net_amount>
<debit_amount>40.00</debit_amount>
</transaction>
<transaction trx_no="904008">
<trx_code>2150</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>100.00</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="904009">
<trx_code>3150</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>150.00</net_amount>
<debit_amount>150.00</debit_amount>
</transaction>
<transaction trx_no="904012">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>205.61</net_amount>
<debit_amount>220.00</debit_amount>
</transaction>
<transaction trx_no="904013" trx_no_added_by="904012">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>14.39</net_amount>
</transaction>
<transaction trx_no="904014">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>710.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947995">
<bill_no>72</bill_no>
<status>OK</status>
<total_amount>417.70</total_amount>
<guest_internal_id>947995</guest_internal_id>
<reservation_info>
<confirmation_no>1086177</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="904015">
<trx_code>2000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>186.92</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
<transaction trx_no="904016" trx_no_added_by="904015">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>13.08</net_amount>
</transaction>
<transaction trx_no="904017">
<trx_code>2010</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>100.00</net_amount>
<debit_amount>100.00</debit_amount>
</transaction>
<transaction trx_no="904018">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>110.00</net_amount>
<debit_amount>110.00</debit_amount>
</transaction>
<transaction trx_no="904019" trx_no_added_by="904018">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>7.70</net_amount>
<debit_amount>7.70</debit_amount>
</transaction>
<transaction trx_no="904021">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>417.70</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947957">
<bill_no>73</bill_no>
<status>OK</status>
<total_amount>380.00</total_amount>
<guest_internal_id>947957</guest_internal_id>
<reservation_info>
<confirmation_no>1086211</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="904030">
<trx_code>2000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>186.92</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
<transaction trx_no="904031" trx_no_added_by="904030">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>13.08</net_amount>
</transaction>
<transaction trx_no="904032">
<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="904033" trx_no_added_by="904032">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>11.78</net_amount>
</transaction>
<transaction trx_no="904029">
<trx_code>9150</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>100.00</credit_amount>
</transaction>
<transaction trx_no="904034">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>280.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947997">
<bill_no>74</bill_no>
<status>OK</status>
<total_amount>380.00</total_amount>
<guest_internal_id>947997</guest_internal_id>
<reservation_info>
<confirmation_no>1086192</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="904035">
<trx_code>2020</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>200.00</net_amount>
<debit_amount>200.00</debit_amount>
</transaction>
<transaction trx_no="904038" trx_package_no="904037">
<trx_code>9300</trx_code>
<trx_date>2017-02-23</trx_date>
<debit_amount>180.00</debit_amount>
</transaction>
<transaction trx_no="904039" trx_package_no="904037">
<trx_code>1000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>158.88</net_amount>
</transaction>
<transaction trx_no="904040" trx_no_added_by="904039" trx_package_no="904037">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>11.12</net_amount>
</transaction>
<transaction trx_no="904041" trx_package_no="904037">
<trx_code>2050</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>10.00</net_amount>
</transaction>
<transaction trx_no="904036">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>200.00</credit_amount>
</transaction>
<transaction trx_no="904042">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>180.00</credit_amount>
</transaction>
</bill_detail>
</bill>
<bill customer_internal_id="947989">
<bill_no>75</bill_no>
<status>OK</status>
<total_amount>680.00</total_amount>
<guest_internal_id>947989</guest_internal_id>
<reservation_info>
<confirmation_no>1086231</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="904047">
<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="904048" trx_no_added_by="904047">
<trx_code>8000</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>11.78</net_amount>
</transaction>
<transaction trx_no="904046">
<trx_code>2010</trx_code>
<trx_date>2017-02-23</trx_date>
<net_amount>500.00</net_amount>
<debit_amount>500.00</debit_amount>
</transaction>
<transaction trx_no="904049">
<trx_code>9000</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>480.00</credit_amount>
</transaction>
<transaction trx_no="904045">
<trx_code>9150</trx_code>
<trx_date>2017-02-23</trx_date>
<credit_amount>200.00</credit_amount>
</transaction>
</bill_detail>
</bill>
</bills> trx_date>2017-02-23</trx_date>
<credit_amount>180.00</credit_amount>
</transaction>
</bill_detail>
</bill>
</bills>
Parent topic: Generic XML Back Office Export-Specifications