| ervd_vat_data_export_id |
|
INT |
N |
A unique Bob ID to use as PK. |
| ervd_export_expense_ line_id |
|
Int |
Y |
FK reference to the corresponding expense line ID. |
| ervd_erli_native_amt |
aler_expense_line_item - erli_native_amt |
NUMERIC (20,10) |
Y |
Native amount from expense line item |
| ervd_erli_native_amt_ currency |
aler_expense_line_item - erli_native_amt_id |
VARCHAR (10) |
Y |
The ISO code of the currency used for ERVD_ERLI_NATIVE_AMT. |
| ervd_guest_count |
|
SMALLINT |
Y |
The number of guests from the expense line item |
| ervd_miles |
aler_expense _line_item - miles |
numeric(15,5) |
Y |
The number of miles from the expense line item |
| ervd_td_gl_account |
alco_expense_account - td_gl_account |
VARCHAR (255) |
Y |
The Tax Deductible account and sub account, if any |
| ervd_ntd_gl_account |
alco_expense_account - ntd_gl_account |
VARCHAR (255) |
Y |
The Non Tax Deductible account and sub account, if any |
| ervd_vatd_gl_account |
alco_vat_account - vatd_gl_account |
VARCHAR (255) |
Y |
The VAT account and sub account, if any |
| ervd_vat_amount_ override |
aler_expense_line_item - vat_amount_override |
NUMERIC (20,10) |
Y |
If the auditor overrode the calculated VAT, it is stored here. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED |
| ervd_vat_guest_ override |
aler_expense_line_item - vat_guests_override |
INT |
Y |
If the auditor overrode the number of guests, it is stored here |
| ervd_vat_miles_ override |
aler_expense_line_item -exli_vat_miles_override |
INT |
Y |
If the auditor overrode the number of miles, it is stored here |
| ervd_td_amount |
aler_expense_line_item - td_amount |
NUMERIC 20,10) |
Y |
The Tax Deductible amount. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| ervd_ntd_amount |
aler_expense_line_item - ntd_amount |
NUMERIC 20,10) |
Y |
The Non Tax Deductible amount. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| ervd_vat_amount |
aler_expense_line_item - vat_amount |
NUMERIC 20,10) |
Y |
VAT or GST amount of the expense line item. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| NATIVE_AMT_CURRENCY_EKEY |
aler_expense_line_item - erli_native_amt_id |
VARCHAR (255) |
Y |
External key identifying the native amount currency. |
| EXPORT_ER_HDR_iD |
aler_expense_export_ header - export_er_hdr_id |
INT |
Y |
Foreign key reference to the exported expense report |
| SET_OF_BOOKS_NAME |
alco_vat_account - set_of_books_name |
VARCHAR (255) |
Y |
Name of the set of books. |
| SET_OF_BOOKS_ EXTERNAL_SYS_ID |
alco_vat_account - external_system_id |
VARCHAR (255) |
Y |
External system id for this set of books. |
| SET_OF_BOOKS_ DESCRIPTION |
alco_vat_account - description |
VARCHAR (255) |
Y |
Description of this set of books. |
| SET_OF_BOOKS_EKEY |
alco_vat_account - set_of_books_id |
VARCHAR (255) |
Y |
External key identifying this set of books |
| VAT_UNCLAIMED_AMOUNT |
aler_expense_line_item - vat_unclaimed_amount |
NUMERIC (20, 10) |
Y |
Unclaimed VAT or GST amount of the expense line item. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_ PERCENT_ ALLOTTED. |
| PST_AMOUNT |
aler_expense_line_item - pst_amount |
NUMERIC (20, 10) |
Y |
PST or QST amount of the expense line item. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| PST_AMOUNT_OVERRIDE |
aler_expense_line_item - pst_amount_override |
NUMERIC (20, 10) |
Y |
If the auditor overrode the calculated PST, it is stored here. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_ PERCENT_ ALLOTTED |
| PST_UNCLAIMED_ AMOUNT |
aler_expense_line_item - pst_unclaimed_amount |
NUMERIC (20, 10) |
Y |
Unclaimed PST or QST amount of the expense line item. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_ PERCENT_ ALLOTTED. |
| PST_GL_ACCOUNT |
alco_vat_account - pst_gl_account and pst_gl_subaccount |
VARCHAR(255) |
Y |
GL account for PST amount |
| VAT_UNCLAIMED_GL_ ACCOUNT |
alco_vat_account - vat_ unclaimed_gl_account and vat_unclaimed_gl_ subaccount |
VARCHAR(255) |
Y |
GL account for unclaimed VAT amount |
| PST_UNCLAIMED_GL_ ACCOUNT |
alco_vat_account - pst_ unclaimed_gl_account and pst_unclaimed_gl_ subaccount |
VARCHAR(255) |
Y |
GL account for unclaimed PST amount |
| BASE_CURRENCY |
aler_expense_line_item - erli_amt_paid_id |
VARCHAR(10) |
Y |
The user's currency |
| BASE_CURRENCY_EKEY |
aler_expense_line_item - erli_amt_paid_id |
VARCHAR(255) |
Y |
EKEY for the user's currency |
| TD_BASE_AMOUNT |
aler_expense_line_item - td_amount |
NUMERIC (20, 10) |
Y |
Tax Deductible amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| NTD_BASE_AMOUNT |
aler_expense_line_item - ntd_amount |
NUMERIC (20, 10) |
Y |
Non Tax Deductible amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ALLOTTED. |
| VAT_BASE_AMOUNT |
aler_expense_line_item - vat_amount |
NUMERIC (20, 10) |
Y |
VAT or GST amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ ALLOTTED. |
| VAT_BASE_AMOUNT_ OVERRIDE |
aler_expense_line_item - vat_amount_override |
NUMERIC (20, 10) |
Y |
If the auditor overrode the calculated VAT, it is stored here in the user's currency. If the line item was split allocated, this amount is the source amount (in the user's currency) multiplied by ALLOC_PERCENT_ ALLOTTED |
| VAT_UNCLAIMED_BASE_ AMOUNT |
aler_expense_line_item - vat_unclaimed_ amount |
NUMERIC (20, 10) |
Y |
Unclaimed VAT or GST amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ ALLOTTED. |
| PST_BASE_AMOUNT |
aler_expense_line_item - pst_amount |
NUMERIC (20, 10) |
Y |
PST or QST amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ ALLOTTED. |
| PST_BASE_AMOUNT_ OVERRIDE |
aler_expense_line_item - pst_amount_override |
NUMERIC (20, 10) |
Y |
If the auditor overrode the calculated PST, it is stored here in the user's currency. If the line item was split allocated, this amount is the source amount (in the user's currency) multiplied by ALLOC_PERCENT_ ALLOTTED |
| PST_UNCLAIMED_BASE_AMOUNT |
aler_expense_line_item - pst_unclaimed_ amount |
NUMERIC (20, 10) |
Y |
Unclaimed PST or QST amount of the expense line item in the user's currency. If the line item was split allocated, this amount is the source amount multiplied by ALLOC_PERCENT_ ALLOTTED. |
| ALLOC_PERCENT_ ALLOTTED |
aler_line_allocation - percent_allotted |
NUMERIC (26, 16) |
Y |
Percent of the amounts (except ervd_erli_native_ amt) allotted to this cost center or project |
| ALLOC_COST_CENTER_ NAME |
alco_cost_center- cost_ center_name |
VARCHAR(255) |
Y |
Name of cost center to which these amounts are charged |
| ALLOC_COST_CENTER_ CODE |
alco_cost_center- cost_ center_code |
VARCHAR(255) |
Y |
Code of cost center to which these amounts are charged |
| ALLOC_PROJECT_ CHARGE_CODE |
alco_project_number - project_charge_code |
VARCHAR(255) |
Y |
Project charge code of project to which these amounts are charged |
| ALLOC_PROJECT_CODE |
alco_project_number - project_code |
VARCHAR(255) |
Y |
Project code of project to which these amounts are charged |
| ALLOC_PARENT_PROJ_ CODE |
alco_project_number - parent_project_number_id |
VARCHAR(255) |
Y |
Parent project of project to which these amounts are charged |
| ALLOC_TOP_PROJECT_ CODE |
alco_project_number - top_project_code |
VARCHAR(255) |
Y |
The root project charge code |
| ALLOC_COST_CENTER_ EKEY |
|
VARCHAR(255) |
Y |
External key for cost center |
| ALLOC_PROJECT_EKEY |
|
VARCHAR(255) |
Y |
External key for cost project |
| ALLOC_DEPARTMENT_ NAME |
alco_department - department_name |
VARCHAR(255) |
Y |
Department name from cost center |
| ALLOC_DEPARTMENT_ CODE |
alco_department - department_code |
VARCHAR(255) |
Y |
Department code from cost center |
| ALLOC_DIVISION_NAME |
alco_division - division_ name |
VARCHAR(255) |
Y |
Division name from cost center |
| ALLOC_DIVISION_CODE |
alco_division - division_ code |
VARCHAR(255) |
Y |
Division code from cost center |
| ALLOC_COMPANY_NAME |
alco_company - company_name |
VARCHAR(255) |
Y |
Company name from cost center |
| ALLOC_COMPANY_CODE |
alco_company-company_code |
VARCHAR (255) |
Y |
Company code from cost center |
| EXPORT_ER_LINE_ID |
aler_expense_export_line - export_er_line_id |
INT |
Y |
A unique bobid to use as PK. |
| CALC_VAT_AMOUNT |
aler_line_allocation - native_amount |
NUMERIC(20) |
Y |
Calculated claimed VAT, disregarding any auditor overrides. This will equal ervd_vat_amount if VAT is not overridden. |
| CALC_VAT_BASE_AMOUNT |
aler_line_allocation - base_amount |
NUMERIC(20) |
Y |
Calculated claimed VAT in user's currency. This will equal vat_base_amount if VAT is not overridden. |
| CALC_VAT_UNCLAIMED_AMOUNT |
aler_line_allocation - native_amount |
NUMERIC(20) |
Y |
Calculated unclaimed VAT, disregarding any auditor overrides. This will equal vat_unclaimed_amount if VAT is not overridden. |
| CALC_VAT_UNCLAIMED_BASE_AMOUNT |
aler_line_allocation - base_amount |
NUMERIC(20) |
Y |
Calculated unclaimed VAT in user's currency. This will equal vat_unclaimed_base_amount if VAT is not overridden. |
| CALC_PST_AMOUNT |
aler_line_allocation - native_amount |
NUMERIC(20) |
Y |
Calculated claimed PST, disregarding any auditor overrides. This will equal pst_amount if PST is not overridden. |
| CALC_PST_BASE_AMOUNT |
aler_line_allocation - base_amount |
NUMERIC(20) |
Y |
Calculated claimed PST in user's currency. This will equal pst_base_amount if PST is not overridden. |
| CALC_PST_UNCLAIMED_AMOUNT |
aler_line_allocation - native_amount |
NUMERIC(20) |
Y |
Calculated unclaimed PST, disregarding any auditor overrides. This will equal pst_unclaimed_amount if PST is not overridden. |
| CALC_PST_UNCLAIMED_BASE_AMOUNT |
aler_line_allocation - base_amount |
NUMERIC(20) |
Y |
Calculated unclaimed PST in user's currency. This will equal pst_unclaimed_base_amount if PST is not overridden. |
| 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. |