City Ledger Export
The City Ledger File contains one record per invoice or payment generated on the day affecting Accounts Receivable. Includes Credit Card Transfers (credit card payments configured to be sent to AR).
Amounts can be grouped by ACCOUNT_NO. Bill number and Reservation information are included to ease charge recognition. The sum of the AMOUNT column will match the AR Ledger Report in OPERA Cloud(DEBIT – CREDIT columns).
Table 8-11 City Ledger Export
Element Name | Element Type | Description | Notes |
---|---|---|---|
city_ledger |
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 |
transaction_type |
Attribute |
Type of transaction code |
|
trx_code |
Attribute |
Transaction code against which this transaction is posted. |
|
bill_no |
Element |
Bill_no associated with reservation |
|
invoice_no |
Element |
Invoice number of the reservation . |
|
amount |
Element |
Amount of the bill |
|
customer_internal_id |
Attribute |
Internal id for the payee profile |
|
account_name |
Element |
City_ledger account name |
|
account_number |
Element |
City_ledger account number |
|
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 |
|
credit_card_last_4_digits |
Element |
Last four digit of the credit card |
|
transaction_type |
Element |
Type of transaction code |
|
trx_code |
Element |
Transaction code against which this transaction is posted. |
|
bill_no |
Element |
Bill_no associated with reservation |
|
invoice_no |
Element |
Invoice number of the reservation . |
|
amount |
Element |
Amount of the bill |
|
credit_card_last_4_digits |
Element |
Last four digit of the credit card |
|
account_info |
Complex Element |
Account Info |
|
customer_internal_id |
Attribute |
Internal id for the payee profile |
|
account_name |
Element |
City_ledger account name |
|
account_number |
Element |
City_ledger account number |
|
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 |
|
<?xml version="1.0" encoding="UTF-8"?> <?xml version <?xml version="1.0" encoding="UTF-8"?>
<city_ledger hotel_code="DEMOHOTEL" date="2017-02-23">
<transaction trx_code="9080" transaction_type="INVOICE">
<bill_no>66</bill_no>
<invoice_no>44</invoice_no>
<amount>450.00</amount>
<account_info customer_internal_id="947959">
<account_name>Demo Company</account_name>
<account_number>DEMO00001</account_number>
</account_info>
<reservation_info>
<confirmation_no>1086003</confirmation_no>
<arrival_date>2017-02-23</arrival_date>
<departure_date>2017-02-23</departure_date>
<guest_name>Name, Guest</guest_name>
</reservation_info>
</transaction>
<transaction trx_code="9080" transaction_type="INVOICE">
<bill_no>68</bill_no>
<invoice_no>45</invoice_no>
<amount>750.00</amount>
<account_info customer_internal_id="947975">
<account_name>Demo Hospitality</account_name>
<account_number>DEMO0002</account_number>
</account_info>
<reservation_info>
<confirmation_no>1086062</confirmation_no>
<arrival_date>2017-02-23</arrival_date>
<departure_date>2017-02-23</departure_date>
<guest_name>Name, Guest</guest_name>
</reservation_info>
</transaction>
</city_ledger> ="1.0" encoding="UTF-8"?>
<city_ledger hotel_code="DEMOHOTEL" date="2017-02-23">
<transaction trx_code="9080" transaction_type="INVOICE">
<bill_no>66</bill_no>
<invoice_no>44</invoice_no>
<amount>450.00</amount>
<account_info customer_internal_id="947959">
<account_name>Demo Company</account_name>
<account_number>DEMO00001</account_number>
</account_info>
<reservation_info>
<confirmation_no>1086003</confirmation_no>
<arrival_date>2017-02-23</arrival_date>
<departure_date>2017-02-23</departure_date>
<guest_name>Name, Guest</guest_name>
</reservation_info>
</transaction>
<transaction trx_code="9080" transaction_type="INVOICE">
<bill_no>68</bill_no>
<invoice_no>45</invoice_no>
<amount>750.00</amount>
<account_info customer_internal_id="947975">
<account_name>Demo Hospitality</account_name>
<account_number>DEMO0002</account_number>
</account_info>
<reservation_info>
<confirmation_no>1086062</confirmation_no>
<arrival_date>2017-02-23</arrival_date>
<departure_date>2017-02-23</departure_date>
<guest_name>Name, Guest</guest_name>
</reservation_info>
</transaction>
</city_ledger>
Parent topic: Generic XML Back Office Export-Specifications