report entry schema

Download Report Entry Schema

If you can't read please download the document

Upload: soma1243

Post on 07-Sep-2015

213 views

Category:

Documents


0 download

DESCRIPTION

report

TRANSCRIPT

entity_id : chararray, rpt_entry_fact_key : long, rpt_entry_legacy_key : long, rpt_fact_key : long, rpt_entry_minutia_key : long, rpt_entry_attribute_key : long, rpt_entry_custom_key : long, rpt_entry_transaction_type : chararray, rpt_entry_trans_type_name : long, rpt_entry_extn_key : long, parent_rpt_entry_fact_key : long, parent_rpt_entry_legacy_key : long, employee_key : long, location_key : long, payment_type_key : long, expense_type_key : long, expense_vendor_key : long, trans_date_key : long, trans_amt_currency_key : long, reporting_currency_key : long, reimbursement_currency_key : long, ccard_trans_key : long, auth_request_entry_fact_key : long, amt_range_key : long, travel_trans_key : long, travel_match_type : long, has_lodging_tax : long, travel_negotiated_rate : double, travel_trans_rate : double, day_fixed_key : long, day_reimbursable_key : long, car_log_entry_key : long, airline_fee_type_key : long, allocation_state_key : long, country_key : long, country_subdivision_key : long, post_processing_req : chararray, trans_amt : double, posted_reimb_amt : double, posted_rpt_amt : double, claimed_reimb_amt : double, claimed_rpt_amt : double, adjusted_reimb_amt : double, adjusted_rpt_amt : double, calc_adjusted_reimb_amt : double, calc_adjusted_rpt_amt : double, approved_reimb_amt : double, approved_rpt_amt : double, attendee_count : long, comment_count : long, except_count : long, rpt_amt_recalc_retries : long, car_rental_days : long, etl_batch_key : long, user_supp_vendor_name : chararray, ccard_supp_mc_code : chararray, ccard_supp_std_mc_code : chararray, ccard_supp_merchant_name : chararray, ccard_supp_merchant_dba_name : chararray, ccard_supp_merchant_street_add : chararray, ccard_supp_merchant_city : chararray, ccard_supp_merchant_zip : chararray, ccard_supp_merchant_state : chararray, ccard_supp_merchant_ctry_key : long, ccard_supp_merchant_ref_number : chararray, ccard_supp_merchant_tax_class : chararray, to_location : chararray, from_location : chararray, ticket_number : chararray, ereceipt_id : chararray, ereceipt_image_posted : long, ereceipt_type : long, is_receipt_required_flag : long, is_reviewed_flag : long, is_receipt_image_required_flag : long, receipt_type_cd : long, is_personal_expenditure_flag : long, is_travel_allowance_flag : long, has_vat_flag : long, foreign_or_domestic_cd : long, foreign_or_domestic : chararray, receipt_image_id : chararray, ereceipt_image_id : chararray, is_receipt_received_flag : long, record_locator : chararray, air_service_class_key : long, int_vendor_supplier_key : long, ext_vendor_supplier_key : long, has_affidavit_flag : long, has_attendees_flag : long, is_billable : long, is_expenseit_entry_flag : long, lodging_day_count : long, net_reclaim_adj_reimb_amt : double, net_reclaim_adj_rpt_amt : double, net_reclaim_reimb_amt : double, net_reclaim_rpt_amt : double, net_tax_adj_reimb_amt : double, net_tax_adj_rpt_amt : double, net_tax_reimb_amt : double, net_tax_rpt_amt : double, total_reclaim_adj_reimb_amt : double, total_reclaim_adj_rpt_amt : double, total_reclaim_posted_reimb_amt : double, total_reclaim_posted_rpt_amt : double, total_tax_adj_reimb_amt : double, total_tax_adj_rpt_amt : double, total_tax_posted_reimb_amt : double, total_tax_posted_rpt_amt : double, supplier_guid : chararray, country_name : chararray, country_code : chararray, country_subdivision_name : chararray, trans_amt_currency_name : chararray, trans_amt_currency_alpha_code : chararray, reimbursement_currency_name : chararray, reimbursement_currency_alpha_code : chararray, reporting_currency_name : chararray, reporting_currency_alpha_code : chararray, expense_type_name : chararray, expense_type_legacy_key : chararray, expense_type_spend_category_code : chararray, expense_type_spend_category_name : chararray, expense_vendor_name : chararray, allocation_state_name : chararray, rpt_entry_trans_type_name_name : chararray, has_lodging_tax_name : chararray, location_city_name : chararray, location_code : chararray, location_country_subdivision_name : chararray, location_country_code : chararray, location_country_name : chararray, payment_type_legacy_key : chararray, payment_type_cd : chararray, payment_type_name : chararray, ccard_supp_merchant_ctry_name : chararray, ccard_supp_merchant_ctry_code : chararray, foreign_or_domestic_name : chararray, is_receipt_image_required_flag_name : chararray, is_personal_expenditure_flag_name : chararray, is_travel_allowance_flag_name : chararray, is_reviewed_flag_name : chararray, is_receipt_required_flag_name : chararray, receipt_type_name : chararray, has_vat_flag_name : chararray, airline_fee_type_code : chararray, airline_fee_type_name : chararray, is_receipt_received_flag_name : chararray, air_service_class_air_svc_class_legacy_key : chararray, air_service_class_name : chararray, has_affidavit_flag_name : chararray, has_attendees_flag_name : chararray, is_billable_name : chararray, is_expenseit_entry_flag_name : chararray, posted_usd_amt : double, claimed_usd_amt : double, adjusted_usd_amt : double, calc_adjusted_usd_amt : double, approved_usd_amt : double, net_reclaim_adj_reimb_amt_usd : double, net_reclaim_reimb_amt_usd : double, net_tax_adj_reimb_amt_usd : double, net_tax_reimb_amt_usd : double, total_reclaim_adj_reimb_amt_usd : double, total_reclaim_posted_reimb_amt_usd : double, total_tax_adj_reimb_amt_usd : double, total_tax_posted_reimb_amt_usd : double