| Data element |
Definition |
ADJUSTMENT_AMT
Indexed - no
Format - number
May be null? yes |
Adjustment amount for the transaction. |
ARRIVAL_DATE
Indexed - no
Format - date
May be null? yes |
Date of arrival at the lodging location. |
BAR_CHRG
Indexed - no
Format - number
May be null? yes |
Bar charge amount. |
CCT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a credit card transaction. |
CCTL_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a credit card lodging transaction. |
CHRG_DESCRIPTION
Indexed - no
Format - varchar2(50)
May be null? yes |
Description of charges. |
DAILY_ROOM_RATE
Indexed - no
Format - number
May be null? yes |
Daily room rate for the lodging transaction. |
DAILY_ROOM_TAX
Indexed - no
Format - number
May be null? yes |
Daily room tax amount for the lodging transaction. |
DEPARTURE_DATE
Indexed - no
Format - date
May be null? yes |
Date of departure from the lodging location. |
FOLIO_NUM
Indexed - no
Format - varchar2(32)
May be null? yes |
Lodging folio number. |
FOOD_CHRG
Indexed - no
Format - number
May be null? yes |
Food charge amount. |
GIFT_CHRG
Indexed - no
Format - number
May be null? yes |
Gift shop charge amount. |
GUEST_NAME
Indexed - no
Format - varchar2(50)
May be null? yes |
Name of the guest associated with the lodging transaction. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the credit card lodging transaction record was last modified. |
LAUNDRY_CHRG
Indexed - no
Format - number
May be null? yes |
Laundry charge amount. |
LODGING_CITY
Indexed - no
Format - varchar2(64)
May be null? yes |
City in which the lodging transaction occurred. |
LODGING_COUNTRY
Indexed - yes
Format - varchar2(64)
May be null? yes |
Country in which the lodging transaction occurred. |
LODGING_STATE
Indexed - no
Format - varchar2(64)
May be null? yes |
State in which the lodging transaction occurred. |
LODGING_ZIP
Indexed - no
Format - varchar2(20)
May be null? yes |
Zip code in which the lodging transaction occurred. |
MOVIE_CHRG
Indexed - no
Format - number
May be null? yes |
Movie charge amount. |
NUM_IN_PARTY
Indexed - no
Format - varchar2(4)
May be null? yes |
Number of guests in the lodging transaction party. |
NUM_OF_ROOM_NIGHTS
Indexed - no
Format - number
May be null? yes |
Number of room nights associated with the lodging transaction. |
NUM_OF_ROOMS
Indexed - no
Format - number
May be null? yes |
Number of rooms associated with the lodging transaction. |
OTHER_CHRG
Indexed - no
Format - number
May be null? yes |
Amount of other charges. |
PARKING_CHRG
Indexed - no
Format - number
May be null? yes |
Parking charge amount. |
PHONE_CHRG
Indexed - no
Format - number
May be null? yes |
Phone charge amount. |
PREPAID_AMT
Indexed - no
Format - number
May be null? yes |
Amount prepaid for the lodging transaction. |
ROOM_TYPE
Indexed - no
Format - varchar2(4)
May be null? yes |
Type of room associated with the lodging transaction. |
TIP_CHRG
Indexed - no
Format - number
May be null? yes |
Tips charge amount. |
TOTAL_LODGING_AMT
Indexed - no
Format - number
May be null? yes |
Total lodging amount. |
TOTAL_NON_ROOM_CHRG
Indexed - no
Format - number
May be null? yes |
Total amount of non-room charges. |
TOTAL_ROOM_TAX
Indexed - no
Format - number
May be null? yes |
Total tax amount for the transaction. |
