| 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. |