Importing Ledgers

Ledgers import requires reference to the OPERA Cloud Confirmation Number; therefore, the profile and reservation import must be completed initially. When the Unique Confirmation Number for Linked Reservations OPERA Control is active, also provide the Reservation Name ID for uniqueness.

• 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