Importing Ledgers
-
For deposit ledger, a 'balance forward' amount is posted to each reservation. The Deposit Ledger Balance Forward Transaction Code OPERA Control must reference a transaction code setup as other-payment type.
-
For guest ledger, a 'balance forward' amount is posted to each reservation sub-account (1-8). The Guest Ledger Balance Forward Transaction Code OPERA Control must reference a sales/non-revenue charge transaction code (with no tax generates).
-
For AR Ledger Invoices, a 'balance forward' amount is posted. The Old Balance Transaction Code OPERA Control must reference a transaction a sales/non-revenue charge transaction code (with no tax generates).
Note:
Package ledger (allowances) cannot be imported.
Deposit Ledger
Column Name | Description | Max Data Length | Sample Data | Mandatory |
---|---|---|---|---|
RES_UNIQUE_ID_DEPOSIT |
Unique sequence auto-generated field to identify a unique row like a primary key column |
20 |
Ex:(300065) |
|
RES_CONFIRMATION_NUMBER |
OPERA Cloud Reservation Confirmation Number |
20 |
Ex:(2803423) |
|
RESV_NAME_ID |
Reservation Name ID |
20 |
Ex:(300065) |
|
RES_DEPOSIT_BALANCE |
Deposit Amount (Enter a debit amount to post as a credit to deposit ledger) |
Number |
Ex:(4000) |
|
Guest Ledger
-
Reservation balance is imported per sub-account (billing windows 1-8).
-
COMP sub-accounts (101-108) are not supported.
Column Name | Description | Max Data Length | Sample Data | Mandatory |
---|---|---|---|---|
RES_UNIQUE_ID_DEPOSIT |
Unique sequence auto-generated field to identify a unique row like a primary key column |
20 |
Ex:(300065) |
|
RES_CONFIRMATION_NUMBER |
OPERA Cloud Reservation Confirmation Number |
20 |
Ex:(2803423) |
|
RES_FOLIO VIEW |
Reservation Sub Account (Billing Window 1-8) |
1 |
Ex:(4000) |
|
RES_GUEST_BALANCE |
Sub Account Balance Amount (Enter a debit amount to post as a debit to the guest ledger) |
Number |
Ex:(4000) |
|
RESV_NAME_ID |
Reservation Name ID |
20 |
Ex:(300065) |
|
AR Ledger - AR Account Invoices
AR balance is imported per Invoice, per AR Account.
Column Name | Description | Max Data Length | Sample Data | Mandatory |
---|---|---|---|---|
AR_UNIQUE_ID_INVOICE_NO |
Unique sequence auto-generated field to identify a unique row like a primary key column |
20 |
Ex:(300065) |
|
AR_INVOICE_TRX_DATE |
AR Invoice Transaction Date |
Date (YYYYMMDD) |
Ex:(20231130) |
|
AR_INVOICE_FOLIO_NO |
Actual Bill Number (will be displayed on the reference field) |
20 |
Ex:(236457) |
|
AR_INVOICE_BALANCE |
AR Invoice Balance |
Number |
Ex:(4000) |
|
AR_INVOICE_AGE_BUCKET |
AR Invoice Age Bucket (Range) per setup of Aging Level Details OPERA Control |
1 |
Ex:(4) |
|
AR_INVOICE_ACCOUNT_NO |
AR Account Number |
20 |
Ex:(2803423 |
|
Related Topics
Parent topic: About Data Import