| EXPORT_ER_LINE_ID
|
N/A
|
INT
|
N
|
A unique number (Bob ID) that serves as the
primary key of this table. This is NOT the expense line item ID of
aler_expense_line_item table.
|
| EXPORT_ER_HDR_ID
|
N/A
|
INT
|
N
|
The Bob ID of the export_expense_header row
that is parent to this line item. This field establishes a foreign key
relationship back to the aler_expense_report_header table.
|
| EXLI_EXP_LINE_ITEM_ID
|
aler_expense_line_item - exp_line_item_id
|
INT
|
N
|
Foreign key back to the source table,
aler_expense_line_item. More than one occurrence of this value is possible if
the line item has multiple allocations.
|
| EXPORT_ER_LINE_STATUS
|
N/A
|
SMALLINT
|
Y
|
The export status of the line item. This
column is not being used at present.
|
| EXPORT_LINE_STATUS_ DATETIME
|
N/A
|
DATETIME
|
Y
|
The date and time, the line status was
updated. This column is not being used at present.
|
| EXLI_LINE_ALLOCATION_ID
|
aler_line_allocation - line_allocation_id
|
INT
|
N
|
Foreign key back to the source table,
aler_line_allocation.
|
| EXLI_ALLOC_BASE_AMT
|
aler_line_allocation - base_amount
|
NUMERIC (20, 10)
|
Y
|
The base amount for the line allocation.
This is the amount to be exported.
|
| EXLI_ALLOC_BASE_AMT_ CURRENCY
|
aler_line_allocation - base_amount_id
|
VARCHAR (10)
|
Y
|
The ISO code of the currency used for the
above base amount.
|
| EXLI_ALLOC_NATIVE_AMT
|
aler_line_allocation - native_amount
|
NUMERIC (20, 10)
|
Y
|
The amount for the allocation in its native
currency.
|
| EXLI_ALLOC_NATIVE_AMT_ CURR
|
aler_line_allocation - native_amount_id
|
VARCHAR(10)
|
Y
|
The ISO code of the currency used for the
above native amount.
|
| EXLI_EXPENSE_ITEM_DATE
|
aler_expense_line_item - expense_item_date
|
DATETIME
|
Y
|
Date that the expense was incurred.
|
| EXLI_ERLI_EXCH_RATE
|
aler_expense_line_item - erli_exch_rate
|
NUMERIC (20, 10)
|
Y
|
Exchange rate used to convert native amount
to base amount.
|
| EXLI_ALLOC_PERCENT_ ALLOTTED
|
aler_line_allocation - percent_allotted
|
NUMERIC (26, 16)
|
Y
|
Percentage accounted by this allocation for
the parent expense line.
|
| EXLI_ALLOC_COST_CENTER_NAME
|
alco_cost_center - cost_center_name
|
VARCHAR (255)
|
Y
|
The cost center name for the allocation, if
any. Derived from the alco_cost_center table, based on the cost_center_id
stored in the aler_line_allocation table.
|
| EXLI_ALLOC_COST_CENTER_CODE
|
alco_cost_center - cost_center_code
|
VARCHAR(255)
|
Y
|
The cost center code for the allocation, if
any. Derived from the alco_cost_center table, based on the cost_center_id
stored in the aler_line_allocation table.
|
| EXLI_ALLOC_PROJECT_CODE
|
alco_project_number - project_code
|
VARCHAR(255)
|
Y
|
The project code for the allocation, if any.
Derived from the table alco_project_number.
|
| EXLI_ALLOC_PARENT_PROJ_CODE
|
alco_project_number - parent_project_code
|
VARCHAR(255)
|
Y
|
The parent project code for the above
project code, if any. Derived from the table alco_project_number.
|
| EXLI_ALLOC_TOP_PROJECT_CODE
|
alco_project_number - top_project_code
|
VARCHAR(255)
|
Y
|
The top project code for the above project
code, if any. Derived from the table alco_project_number.
|
| EXLI_LINE_PAYMENT_ METHOD_CODE
|
aler_expense_line_item - payment_ type_id
|
INT
|
Y
|
The type of payment for the expense line
item. Valid Values are: 0 - unknown 1 - IBIP Corporate Card 2 - IBCP Corporate
Card 4 - Company Paid 5 - Personal Funds 6 - Applied LCF Values were derived
from alco_payment_method_info table's payment_method_code, via
alco_payment_type.
|
| EXLI_LINE_IS_PERSONAL_ FLAG
|
aler_expense_line_item - is_personal
|
SMALLINT
|
Y
|
Flag that designates if the expense line
item has been marked as a personal expense. Values are: 0 - expense is not
personal 1 - expense is personal If this field is 1, the expense is not
reimbursable and should not be exported to the external system.
|
| EXLI_EXPENSE_TYPE_LABEL
|
aler_expense_line_item - expense_ type_id
|
VARCHAR (255)
|
Y
|
Expense type of the expense line. Derived
from alco_expense_type table's expense_type_label.
|
| EXLI_EXPENSE_CATEGORY_LABEL
|
aler_expense_line_item - expense_ type_id
|
VARCHAR (255)
|
Y
|
Expense type category label of the expense
line. Derived from alco_expense_type table's category_label.
|
| EXLI_EXPENSE_GL_CODE
|
aler_expense_line_item - item_gl_code
|
VARCHAR (255)
|
Y
|
Expense line item's GL code.
|
| EXLI_EXPENSE_CATEGORY_CLASS
|
aler_expense_line_item - expense_ type_id
|
SMALLINT
|
Y
|
Expense type category class. Derived from
alco_expense_type table's category_class.
|
| EXLI_EXPENSE_SPECIAL_ CODE
|
aler_expense_line_item - expense_ type_id
|
INT
|
Y
|
Starting with rel 6.5.1 and 6.6, the
documented values (highlighted below) are not commonly used and are dependent
on having those special codes configured with the expense type itself. The more
common practice now is to setup an ADC DDLB and pull the value from the ADC
export data if you have one meal expense type. Another approach is to use the
external key to identify the particular expense_type (lunch). For example:
select a.expense_type_ekey, c.* from aler_expense_export_line a,
alco_guest_wrapper b, alco_guest c where a.EXLI_EXP_LINE_ITEM_ID=b.parent_id
and b.guest_id=c.guest_id Here are the current values available:
expense_special_code_id expense_special_code expense_special_code_name 830100 0
@@SAT_EXP_SPECIAL_CODE_1 830105 5 @@SAT_EXP_SPECIAL_CODE_2 830107 7
@@SAT_EXP_SPECIAL_CODE_3 830113 13 @@SAT_EXP_SPECIAL_CODE_4 830114 14
@@SAT_EXP_SPECIAL_CODE_5 830115 15 @@SAT_EXP_SPECIAL_CODE_6 830116 16
@@SAT_EXP_SPECIAL_CODE_7 830117 17 @@SAT_EXP_SPECIAL_CODE_8 830121 21
@@SAT_EXP_SPECIAL_CODE_9 830122 22 @@SAT_EXP_SPECIAL_CODE_10 830123 23
@@SAT_EXP_SPECIAL_CODE_VAT 830124 24 @@SAT_EXP_SPECIAL_CODE_ROOM_TAX Old
Method: Expense type special code. Derived from alco_expense_type table's
expense_special_code. A code that defines the processing attributes of an
expense type. Valid values are : ET_UNKNOWN = -1 ET_OTHER =0 ET_BREAKFAST =1
ET_DINNER =2 ET_LUNCH=3 ET_BUSINESS_MEALS=4 ET_ENTERTAINMENT =5 ET_GIFTS =6
ET_MILEAGE =7 ET_CHAR_DON=8 ET_GIFTS_LOGO=9 ET_PROM_SPON = 10
ET_SPOUSAL_LODGING = 11 ET_SPOUSAL_MEALS = 12 ET_SPOUSAL_TRAVEL = 13
ET_ENT_SPORTS = 14 ET_CLUB_MEMBERSHIP = 15 ET_CASH_ADVANCE= 16
ET_AIRLINE_TICKET= 17 ET_CAR_RENTAL= 21 ET_PAYMENT_MADE = 22
|
| EXLI_MAJOR_ACCOUNT
|
aler_expense_line_item - expense_type_id
|
VARCHAR (255)
|
Y
|
Used as a second source of GL codes.
Optional for an installation. Derived from col. Major_account of table
alco_expense_type
|
| EXLI_EXPENSE_EXTERNAL_SYSID
|
aler_expense_line_item - expense_type_id
|
VARCHAR (255)
|
Y
|
The key to identify an expense type in an
external system. Derived from col. External_system_id in table
alco_expense_type.
|
| EXLI_ERLI_AMT_PAID
|
aler_expense_line_ item - erli_amt_paid
|
NUMERIC (20, 10)
|
Y
|
This is the total amount approved for the
line. If the line has multiple allocations, this amount is the sum of all the
allocations base amounts. This value may be repeated in several rows in this
table when there are multiple allocations since a row in this table represents
a line/allocation combination. This is not the value to export. Allocation
amount for this entry should be used for export.
|
| EXLI_ERLI_NATIVE_AMT
|
aler_expense_line_item - erli_native_ amount
|
NUMERIC (20, 10)
|
Y
|
This column contains the expense line native
amount in the native currency. Its value, when converted, should equal the
PAID_AMOUNT.
|
| EXLI_ERLI_AMT_PAID_ CURRENCY
|
aler_expense_line_item - erli_amt_paid _id
|
VARCHAR (10)
|
Y
|
The ISO code of the currency for the
exli_erli_amt_paid amount. Derived from currency_code_iso of alco_currency
table.
|
| EXLI_ERLI_NATIVE_AMT_ CURRENCY
|
aler_expense_line_item - erli_native_
amount_id
|
VARCHAR (10)
|
Y
|
The ISO code for the currency for the
exli_erli_native_amt col. Derived from currency_code_iso of alco_currency
table.
|
| EXLI_VENDOR_NAME
|
aler_expense_line_item - vendor_id
|
VARCHAR (255)
|
Y
|
Vendor associated with the current expense
line. Derived from col. Vendor_name in table alco_vendor
|
| EXLI_VENDOR_GIVEN_SIC
|
aler_expense_line_item - vendor_id
|
VARCHAR (255)
|
Y
|
Above vendor's SIC code. Derived from col.
Vendor_given_sic in table alco_vendor
|
| exli_purpose
|
aler_expense_line_item - purpose_id
|
VARCHAR (255)
|
Y
|
Expense line purpose.
|
| Exli_expense_description
|
aler_expense_line_item - expense_
description
|
VARCHAR (255)
|
Y
|
Expense line description.
|
| Exli_city
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
City where expense was incurred.
|
| Exli_state
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
State where expense was incurred. Derived
from col. State_name in the table alco_city
|
| exli_country
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
Country where expense was incurred. Derived
from col. Country_name in the table alco_city
|
| EXLI_CC_CARD_NUMBER
|
alcc_card - ccard_account
|
VARCHAR (255)
|
Y
|
exli_cc_card_number is from
alcc_card.ccard_account Credit or charge card account number
|
| EXLI_CC_ISSUER
|
alcc_card - ccard_issuer
|
VARCHAR (255)
|
Y
|
exli_cc_issuer is from
alcc_card.ccard_issuer The name of the card, from the user's point of view
|
| EXLI_PAYMENT_TYPE_LABEL
|
alco_payment_type - payment_type_label -
|
VARCHAR (255)
|
Y
|
The payment label of the associated payment
type for the line item.
|
| Exli_ALLOC_project_charge_code
|
alco_project_number- project_charge_code
|
VARCHAR (255)
|
Y
|
The project charge code for the allocation,
if any. This column exists in earlier versions as exli_project_charge_ code.
Derived from the table alco_project_number.
|
| eXli_miles
|
aler_expense_line_item -miles
|
numeric(15,5)
|
Y
|
Mileage for mileage expense lines.
|
| eXli_odometer_start
|
aler_expense_line_item -odometer_start
|
numeric(15,5)
|
Y
|
Odometer start reading for mileage expense
lines.
|
| eXli_odometer_end
|
aler_expense_line_item -odometer_end
|
numeric(15,5)
|
Y
|
Odometer end reading for mileage expense
lines.
|
| EXLI_PERDIEM_AMOUNT
|
aler_expense_line_item - perdiem_ amount
|
numeric (20,10)
|
Y
|
exli_perdiem_amount is from
aler_expense_line_item.perdiem_amount
|
| EXLI_PERDIEM_AMOUNT_ currency
|
aler_expense_line_item - perdiem_ amount_id
|
VARCHAR (10)
|
Y
|
exli_perdiem_amount_currency is the iso code
of the currency with id aler_expense_line_item.perdiem_amount_id
|
| EXLI_CCt_REFERENCE
|
aler_expense_line_item - cct_reference
|
VARCHAR(255)
|
Y
|
Reference number if the expense is the
credit card transaction.
|
| Exli_alloc_is_billable
|
aler_line_allocation - is_billable
|
smallint
|
Y
|
Determines if the allocation is billable.
|
| Exli_county
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
County where expense is incurred.
|
| EXLI_SUBURB
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
Suburb where expense is incurred.
|
| EXLI_STREET
|
aler_expense_line_item - city_id
|
VARCHAR (255)
|
Y
|
Street where expense is incurred.
|
| ALLOC_BASE_CURRENCY_ EKEY
|
aler_line_allocation - base_amount_id
|
VARCHAR (255)
|
Y
|
External key identifying the base amount
currency for the allocation.
|
| ALLOC_NATIVE_CURRENCY_EKEY
|
aler_line_allocation - native_amount_id
|
VARCHAR (255)
|
Y
|
External key identifying the native amount
currency for the allocation.
|
| ALLOC_COST_CENTER_EKEY
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
External key identifying the cost center for
the allocation.
|
| ALLOC_PROJECT_EKEY
|
aler_line_allocation - project_number_id
|
VARCHAR (255)
|
Y
|
External key identifying the project for the
allocation.
|
| PAYMENT_TYPE_EKEY
|
aler_expense_line_item - payment_type_id
|
VARCHAR (255)
|
Y
|
External key identifying the payment type.
|
| EXPENSE_TYPE_EKEY
|
aler_expense_line_item - expense_type_id
|
VARCHAR (255)
|
Y
|
External key identifying the expense type.
|
| AMT_PAID_CURRENCY_EKEY
|
aler_expense_line_item - erli_amt_paid_id
|
VARCHAR (255)
|
Y
|
External key identifying the amount paid
currency.
|
| NATIVE_AMT_CURRENCY_ EKEY
|
aler_expense_line_item - erli_native_amt_id
|
VARCHAR (255)
|
Y
|
External key identifying the native amount
currency.
|
| VENDOR_EKEY
|
aler_expense_line_item - vendor_id
|
VARCHAR (255)
|
Y
|
External key identifying the vendor.
|
| PURPOSE_EKEY
|
aler_expense_line_item - purpose_id
|
VARCHAR (255)
|
Y
|
External key identifying the purpose.
|
| LOCATION_EKEY
|
aler_expense_line_item - location_id
|
VARCHAR (255)
|
Y
|
External key identifying the location.
|
| PERDIEM_AMOUNT_ CURRENCY_EKEY
|
aler_expense_line_item - perdiem_amount_id
|
VARCHAR (255)
|
Y
|
External key identifying the per diem amount
currency.
|
| CC_TRANSACTION_ID
|
aler_expense_line_item - cc_transaction_id
|
INT
|
Y
|
If this is a credit card transaction, this
is its id
|
| EXPENSE_ITEM_DEPART_ DATE
|
aler_expense_line_item - expense_item_
depart_date
|
DATETIME
|
Y
|
The departure date for the expense line
|
| ORIGIN_AIRPORT
|
aler_expense_line_item - origin_airport
|
VARCHAR (4)
|
Y
|
The origin airport code for the expense line
|
| DEST_AIRPORT
|
aler_expense_line_item - dest_airport
|
VARCHAR (4)
|
Y
|
The destination airport code for the expense
line
|
| BOOKING_AGENT_NAME
|
aler_expense_line_item - booking_agent
|
VARCHAR (50)
|
Y
|
Name of the booking agent for the expense
line
|
| BOOKING_AGENT_DESCRIPTION
|
aler_expense_line_item - booking_agent
|
VARCHAR (255)
|
Y
|
Description of the booking agent for the
expense line
|
| BOOKING_AGENT_EKEY
|
aler_expense_line_item - booking_agent
|
VARCHAR (255)
|
Y
|
External key identifying the booking agent
for the expense line
|
| TICKET_STATUS_NAME
|
aler_expense_line_item - ticket_status
|
VARCHAR (255)
|
Y
|
The ticket status name for the expense line
|
| TICKET_STATUS_EKEY
|
aler_expense_line_item - ticket_status
|
VARCHAR (255)
|
Y
|
External key identifying the ticket status
for the expense line
|
| TICKET_NUMBER
|
aler_expense_line_item - ticket_number
|
VARCHAR (50)
|
Y
|
Ticket number for the expense line
|
| CAR_RENTAL_AGREEMENT
|
aler_expense_line_item - car_rental_
agreement
|
VARCHAR (50)
|
Y
|
Car rental agreement for the expense line
|
| AIR_SERVICE_CLASS_CODE
|
aler_expense_line_item - airline_class_of_
service
|
VARCHAR (3)
|
Y
|
Air service class code for the expense line
|
| AIR_SERVICE_CLASS_NAME
|
aler_expense_line_item -
airline_class_of_service
|
VARCHAR (255)
|
Y
|
Air service class name for the expense line
|
| AIR_SERVICE_CLASS_EKEY
|
aler_expense_line_item -
airline_class_of_service
|
VARCHAR (255)
|
Y
|
External key identifying the air service
class for the expense line
|
| CAR_SERVICE_CLASS_CODE
|
aler_expense_line_item - car_class_of_
service
|
VARCHAR (3)
|
Y
|
Car service class code for the expense line
|
| CAR_SERVICE_CLASS_NAME
|
aler_expense_line_item -
car_class_of_service
|
VARCHAR (255)
|
Y
|
Car service class name for the expense line
|
| CAR_SERVICE_CLASS_EKEY
|
aler_expense_line_item - car_class_of_
service
|
VARCHAR (255)
|
Y
|
External key identifying the car service
class for the expense line
|
| HOTEL_SERVICE_CLASS_CODE
|
aler_expense_line_item - hotel_class_of_
service
|
VARCHAR (3)
|
Y
|
Hotel service class code for the expense
line
|
| HOTEL_SERVICE_CLASS_NAME
|
aler_expense_line_item - hotel_class_of_
service
|
VARCHAR (255)
|
Y
|
Hotel service class name for the expense
line
|
| HOTEL_SERVICE_CLASS_EKEY
|
aler_expense_line_item - hotel_class_of_
service
|
VARCHAR (255)
|
Y
|
External key identifying the hotel service
class for the expense line
|
| MILEAGE_RATE_NAME
|
aler_expense_line_item - mileage_rate_id
|
VARCHAR (40)
|
Y
|
Description of the applicable mileage rate.
It refers to description column in alco_mileage_rate table.
|
| MILEAGE_RATE_EKEY
|
aler_expense_line_item - mileage_rate_id
|
VARCHAR (255)
|
Y
|
External key identifying the applicable
mileage rate.
|
| MILEAGE_PASSENGER_NUM
|
aler_expense_line_item - mileage_
passenger_num
|
int
|
Y
|
Specifies how many passengers are on the
same rental vehicle.
|
| ALLOC_DEPARTMENT_NAME
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Name of the department the cost center of
the allocation belongs to.
|
| ALLOC_DEPARTMENT_CODE
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Code of the department the cost center of
the allocation belongs to.
|
| ALLOC_DIVISION_NAME
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Name of the division the cost center of the
allocation belongs to.
|
| ALLOC_DIVISION_CODE
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Code of the division of the cost center
allocation.
|
| ALLOC_COMPANY_NAME
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Name of the company of the cost center
allocation.
|
| ALLOC_COMPANY_CODE
|
aler_line_allocation - cost_center_id
|
VARCHAR (255)
|
Y
|
Code of the company the cost center of the
allocation belongs to.
|
| Cc_level3_detail_id
|
aler_level3_ attachment -
cc_level3_detail_id
|
INT
|
Y
|
cc_level3_detail_id is from
aler_level3_attachment.cc_level3_detail_id which is a foreign key to
alcc_level3_detail.cc_ level3_detail_id Key into alcc_level3_detail if created
from hotel folio.
|
| Guest_count
|
aler_expense_line_item - guest_count
|
INT
|
Y
|
line item total guest count
|
| paid_amount
|
aler_expense_line_item - erli_amt_paid
|
NUMERIC (20, 10)
|
Y
|
The amount of the expense in the user's
currency before the approved amount is applied. (exli_erli_amt_paid is the
amount of the expense after the approved amount is applied.)
|
| paid_amount_currency
|
aler_expense_line_item - erli_amt_paid_id
|
VARCHAR (10)
|
Y
|
The ISO code of the currency for
paid_amount. Derived from currency_code_iso of alco_currency table.
|
| FLEX_FIELD_STRING_1
|
aler_expense_line_item - flex_field_string_1
|
VARCHAR (255)
|
Y
|
Flex Field in String type
|
| FLEX_FIELD_STRING_2
|
aler_expense_line_item - flex_field_string_2
|
VARCHAR (255)
|
Y
|
Flex Field in String type
|
| FLEX_FIELD_STRING_3
|
aler_expense_line_item - flex_field_string_3
|
VARCHAR (255)
|
Y
|
Flex Field in String type
|
| FLEX_FIELD_STRING_4
|
aler_expense_line_item - flex_field_string_4
|
VARCHAR (255)
|
Y
|
Flex Field in String type
|
| FLEX_FIELD_INTEGER_1
|
alex_expense_line_item -
fles_field_integer_1
|
INT
|
Y
|
Flex Field in Integer type
|
| FLEX_FIELD_INTEGER_2
|
alex_expense_line_item -
flex_field_integer_2
|
INT
|
Y
|
Flex Field in Integer type
|
| FLEX_FIELD_DATE _1
|
aler_expense_line_item - flex_field_date_1
|
DATETIME
|
Y
|
Flex Field in Datetime type
|
| FLEX_FIELD_DATE _2
|
aler_expense_line_item - flex_field_date_2
|
DATETIME
|
Y
|
Flex Field in Datetime type
|
| FLEX_FIELD_AMT _1
|
aler_expense_line_item - flex_field_amount_1
|
NUMERIC (20)
|
Y
|
Flex Field in Decimal for Currency
|
| FLEX_FIELD_AMT_1_CURRENCY
|
aler_expense_line_item - flex_field_ amount
_1_id
|
VARCHAR (10)
|
Y
|
Flex Field for Currency Id
|
| FLEX_FIELD_AMT _2
|
aler_expense_line_item - flex_field_ amount
_2
|
NUMERIC (20)
|
Y
|
Flex Field in Decimal for Currency
|
| FLEX_FIELD_AMT_2_CURRENCY
|
aler_expense_line_item- flex_field_ amount
_2_id
|
VARCHAR (10)
|
Y
|
Flex Field for Currency Id
|
| FLEX_FIELD_LOC_1_EKEY
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location external key
|
| FLEX_FIELD_LOC_1_COUNTY
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this county
|
| FLEX_FIELD_LOC_1_STATE
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this state
|
| FLEX_FIELD_LOC_1_COUNTRY
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this country
|
| FLEX_FIELD_LOC_1_CITY
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this city
|
| FLEX_FIELD_LOC_1_SUBURB
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this suburb
|
| FLEX_FIELD_LOC_1_STREET
|
aler_expense_line_item -
flex_field_location_1_id
|
VARCHAR (255)
|
Y
|
Flex Field Location located in this street
|
| FLEX_FIELD_DDLB_1_CODE
|
aler_flex_ddlb_6 - flex_ddlb_code
|
VARCHAR (255)
|
Y
|
Code of Flex Field DDLB 1
|
| FLEX_FIELD_DDLB_1_VALUE
|
aler_flex_ddlb_6 - flex_ddlb_value
|
VARCHAR (255)
|
Y
|
Value of Flex Field DDLB 1
|
| FLEX_FIELD_DDLB_2_CODE
|
aler_flex_ddlb_7 - flex_ddlb_code
|
VARCHAR (255)
|
Y
|
Code of Flex Field DDLB 2
|
| FLEX_FIELD_DDLB_2_VALUE
|
aler_flex_ddlb_7 - flex_ddlb_value
|
VARCHAR (255)
|
Y
|
Value of Flex Field DDLB 2
|
| FLEX_FIELD_DDLB_3_CODE
|
aler_flex_ddlb_8 - flex_ddlb_code
|
VARCHAR (255)
|
Y
|
Code of Flex Field DDLB 3
|
| FLEX_FIELD_DDLB_3_VALUE
|
aler_flex_ddlb_8 - flex_ddlb_value
|
VARCHAR (255)
|
Y
|
Value of Flex Field DDLB 3
|
| FLEX_FIELD_DDLB_4_CODE
|
aler_flex_ddlb_9 - flex_ddlb_code
|
VARCHAR (255)
|
Y
|
Code of Flex Field DDLB 4
|
| FLEX_FIELD_DDLB_4_VALUE
|
aler_flex_ddlb_9 - flex_ddlb_value
|
VARCHAR (255)
|
Y
|
Value of Flex Field DDLB 4
|
| FLEX_FIELD_DDLB_5_CODE
|
aler_flex_ddlb_10 - flex_ddlb_code
|
VARCHAR (255)
|
Y
|
Code of Flex Field DDLB 5
|
| FLEX_FIELD_DDLB_5_VALUE
|
aler_flex_ddlb_10 - flex_ddlb_value
|
VARCHAR (255)
|
Y
|
Value of Flex Field DDLB 5
|
| EXLI_PCI_TOKEN
|
alcc_card - pci_token
|
VARCHAR (255)
|
Y
|
Token returned by PCI vendor
|
| ALLOC_SEGMENT1_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 1 name of allocation cost center
|
| ALLOC_SEGMENT1_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 1 code of allocation cost center
|
| ALLOC_SEGMENT2_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 2 name of allocation cost center
|
| ALLOC_SEGMENT2_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 2 code of allocation cost center
|
| ALLOC_SEGMENT3_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 3 name of allocation cost center
|
| ALLOC_SEGMENT3_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 3 code of allocation cost center
|
| ALLOC_SEGMENT4_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 4 name of allocation cost center
|
| ALLOC_SEGMENT4_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 4 code of allocation cost center
|
| ALLOC_SEGMENT5_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 5 name of allocation cost center
|
| ALLOC_SEGMENT5_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 5 code of allocation cost center
|
| ALLOC_SEGMENT6_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 6 name of allocation cost center
|
| ALLOC_SEGMENT6_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 6 code of allocation cost center
|
| ALLOC_SEGMENT7_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 7 name of allocation cost center
|
| ALLOC_SEGMENT7_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 7 code of allocation cost center
|
| ALLOC_SEGMENT8_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 8 name of allocation cost center
|
| ALLOC_SEGMENT8_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 8 code of allocation cost center
|
| ALLOC_SEGMENT9_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR (255)
|
Y
|
Segment 9 name of allocation cost center
|
| ALLOC_SEGMENT9_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR (255)
|
Y
|
Segment 9 code of allocation cost center
|
| SEGMENT_COUNT
|
alco_cost_center_config - segment_count
|
INTEGER
|
Y
|
The number of segments in this line item's
cost center.
|
| ALLOC_REVIEW_SEGMENT_NAME
|
alco_cost_center_rev_segment - segment_name
|
VARCHAR (255)
|
Y
|
The review segment name of this line item's
cost center.
|
| ALLOC_REVIEW_SEGMENT_CODE
|
alco_cost_center_rev_segment - segment_code
|
VARCHAR (255)
|
Y
|
The review segment code of this line item's
cost center.
|
| GUEST_ENTRY_MODE
|
aler_expense_line_item - guest_entry_mode
|
SMALLINT
|
Y
|
The guest entry mode (Count, Guests, or
Both)
|
| GUEST_AMOUNTS_EQUAL
|
aler_expense_line_item - guest_amounts_equal
|
SMALLINT
|
Y
|
Whether the line item amount is equally
split across guests
|
| GUEST_NO_SHOW_COUNT
|
aler_expense_line_item - guest_no_show_count
|
INTEGER
|
Y
|
The guest no-show
|
| PASSENGER_NAME
|
aler_expense_line_item – passenger_name
|
VARCHAR (255)
|
Y
|
Passenger name from passenger_name in
alcc_transaction_detail. Used on airfare transactions
|
| EXPORT_STATUS |
aler_expense_line_item – export_status |
INTEGER |
Y |
the export status (0=not exported, 1=exported, 2=marked for
re-export) |
| VOID_STATUS |
aler_expense_line_item – void_status |
INTEGER |
Y |
the void status (0=not voided, 1=voided, 2=this is a
reversal that cancels out a voided line item) |
| REVERSAL_LINE_ITEM_ID |
aler_expense_line_item – reversal_line_item_id |
INTEGER |
Y |
for voided/reversal line items, this is the matching
reversal/voided line item |
| EXPORT_DATE |
aler_expense_line_item – export_date |
DATETIME |
Y |
The date the item was first exported to the financial
system |
| TAX1 |
aler_expense_line_item – tax1 |
NUMERIC(28, 10) |
Y |
Store the tax value |
| TAX1_ID |
aler_expense_line_item – tax1_id |
INTEGER |
Y |
Store the tax currency id |
| TAX2 |
aler_expense_line_item – tax2 |
NUMERIC(28, 10) |
Y |
Store the tax value |
| TAX2_ID |
aler_expense_line_item – tax2_id |
INTEGER |
Y |
Store the tax currency id |
| BILLING_PERIOD |
aler_expense_line_item – billing period |
INTEGER |
Y |
The billing period from the credit card feed. The billing period describes
a statement period, similar to the statement date. Currently, only Visa is
setting the billing period. |