# Oracle Fusion Cloud Applications - FSCM(ERP & SCM) schema ERD

Table and field reference for the Fivetran Oracle Fusion Cloud Applications - FSCM(ERP & SCM) connector.

## Table & Field Reference

### journal_category_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| je_category_name | String | PK |
| created_by | String |  |
| creation_date | Instant |  |
| je_category_key | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| object_ver_num | Double |  |
| tl_created_by | String |  |
| tl_creation_date | Instant |  |
| tl_description | String |  |
| tl_je_category_name | String |  |
| tl_language | String |  |
| tl_last_update_date | Instant |  |
| tl_last_update_logn | String |  |
| tl_last_updated_by | String |  |
| tl_source_lang | String |  |
| tl_user_je_cat_name | String |  |

### journal_import_reference_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| import_reference_id | Long | PK |
| je_batch_id | Long | FK |
| je_header_id | Long | FK |
| created_by | String |  |
| creation_date | Instant |  |
| gl_sl_link_id | Long |  |
| gl_sl_link_table | String |  |
| je_line_num | Long |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| object_version_number | Long |  |
| reference_1 | String |  |
| subledger_doc_sequence_id | Double |  |
| subledger_doc_sequence_value | Double |  |

### transaction_line_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| customer_trx_line_id | Long | PK |
| customer_trx_id | Long | FK |
| amount_includes_tax_flag | String |  |
| auth_complete_flag | String |  |
| authorization_number | String |  |
| autorule_complete_flag | String |  |
| autotax | String |  |
| billing_period_end_date | Instant |  |
| billing_period_start_date | Instant |  |
| contract_end_date | Instant |  |
| contract_start_date | Instant |  |
| created_by | String |  |
| creation_date | Instant |  |
| default_ussgl_transaction_code | String |  |
| default_ussgl_trx_code_context | String |  |
| deferral_exclusion_flag | String |  |
| description | String |  |
| doc_line_id_char_1 | String |  |
| extended_amount | Double |  |
| historical_flag | String |  |
| interface_line_attribute_1 | String |  |
| interface_line_context | String |  |
| invoiced_line_acctg_level | String |  |
| item_context | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| line_intended_use | String |  |
| line_number | Double |  |
| line_type | String |  |
| link_to_parentline_attribute_1 | String |  |
| link_to_parentline_context | String |  |
| object_version_number | Long |  |
| org_id | Long |  |
| override_auto_accounting_flag | String |  |
| product_category | String |  |
| product_fisc_classification | String |  |
| product_type | String |  |
| quantity_invoiced | Double |  |
| quantity_ordered | Double |  |
| reason_code | String |  |
| recurring_bill_flag | String |  |
| requires_manual_scheduling | String |  |
| revenue_amount | Double |  |
| rule_end_date | Instant |  |
| rule_start_date | Instant |  |
| sales_order | String |  |
| sales_order_date | Instant |  |
| sales_order_line | String |  |
| sales_order_source | String |  |
| source_data_key_1 | String |  |
| source_document_line_number | String |  |
| tax_action | String |  |
| tax_classification_code | String |  |
| tax_exempt_flag | String |  |
| tax_exempt_number | String |  |
| tax_exempt_reason_code | String |  |
| tax_invoice_number | String |  |
| tax_rate | Double |  |
| tax_vendor_return_code | String |  |
| taxable_amount | Double |  |
| translated_description | String |  |
| trx_business_category | String |  |
| unit_selling_price | Double |  |
| unit_standard_price | Double |  |
| uom_code | String |  |
| user_defined_fisc_class | String |  |

### journal_source_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| je_source_name | String | PK |
| created_by | String |  |
| creation_date | Instant |  |
| eff_date_rule_code | String |  |
| imp_using_key_flag | String |  |
| je_source_key | String |  |
| journal_apprvl_flag | String |  |
| journal_ref_flag | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| object_version_num | Long |  |
| override_edits_flag | String |  |
| tl_created_by | String |  |
| tl_creation_date | Instant |  |
| tl_description | String |  |
| tl_je_source_name | String |  |
| tl_language | String |  |
| tl_last_update_date | Instant |  |
| tl_last_update_log | String |  |
| tl_last_updated_by | String |  |
| tl_source_lang | String |  |
| tl_user_je_src_name | String |  |
| user_language | String |  |

### location_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Long | PK |
| actual_content_source | String |  |
| addr_element_attribute_1 | String |  |
| addr_element_attribute_2 | String |  |
| addr_element_attribute_3 | String |  |
| addr_element_attribute_4 | String |  |
| addr_element_attribute_5 | String |  |
| address_1 | String |  |
| address_2 | String |  |
| address_3 | String |  |
| address_4 | String |  |
| address_effective_date | Instant |  |
| address_expiration_date | Instant |  |
| address_lines_phonetic | String |  |
| building | String |  |
| city | String |  |
| clli_code | String |  |
| comments | String |  |
| country | String |  |
| county | String |  |
| created_by | String |  |
| created_by_module | String |  |
| creation_date | Instant |  |
| date_validated | Instant |  |
| description | String |  |
| do_not_validate_flag | String |  |
| fa_location_id | Long |  |
| floor_number | String |  |
| house_type | String |  |
| internal_flag | String |  |
| language | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| latitude | Double |  |
| location_created_by | String |  |
| location_creation_date | Instant |  |
| location_directions | String |  |
| location_enabled_flag | String |  |
| location_end_date_active | Instant |  |
| location_last_update_date | Instant |  |
| location_last_update_login | String |  |
| location_last_updated_by | String |  |
| location_segment_1 | String |  |
| location_start_date_active | Instant |  |
| location_summary_flag | String |  |
| longitude | Double |  |
| orig_system_reference | String |  |
| position | String |  |
| postal_code | String |  |
| postal_plus_4_code | String |  |
| province | String |  |
| sales_tax_geocode | String |  |
| sales_tax_inside_city_limits | String |  |
| short_description | String |  |
| state | String |  |
| status_flag | String |  |
| timezone_code | String |  |
| validated_flag | String |  |
| validation_status_code | String |  |

### balance_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| actual_flag | String | PK |
| currency_code | String | PK |
| period_name | String | PK |
| code_combination_id | Long | PK, FK |
| ledger_id | Long | PK, FK |
| begin_balance_cr | Double |  |
| begin_balance_cr_beq | Double |  |
| begin_balance_dr | Double |  |
| begin_balance_dr_beq | Double |  |
| encumbrance_type_id | Long |  |
| last_update_date | Instant |  |
| last_updated_by | String |  |
| object_version_number | Long |  |
| period_net_cr | Double |  |
| period_net_cr_beq | Double |  |
| period_net_dr | Double |  |
| period_net_dr_beq | Double |  |
| period_num | Long |  |
| period_year | Long |  |
| project_to_date_cr | Double |  |
| project_to_date_cr_beq | Double |  |
| project_to_date_dr | Double |  |
| project_to_date_dr_beq | Double |  |
| quarter_to_date_cr | Double |  |
| quarter_to_date_cr_beq | Double |  |
| quarter_to_date_dr | Double |  |
| quarter_to_date_dr_beq | Double |  |
| translated_flag | String |  |

### journal_header_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| je_header_id | Long | PK |
| accrual_rev_je_header_id | Long | FK |
| je_batch_id | Long | FK |
| ledger_id | Long | FK |
| parent_je_header_id | Long | FK |
| reversed_je_header_id | Long | FK |
| accrual_rev_change_sign_flag | String |  |
| accrual_rev_change_sign_flag_transient | String |  |
| accrual_rev_effective_date | Instant |  |
| accrual_rev_period_name | String |  |
| accrual_rev_status | String |  |
| actual_flag | String |  |
| balanced_je_flag | String |  |
| close_acct_seq_assign_id | Double |  |
| close_acct_seq_value | Double |  |
| close_acct_seq_version_id | Double |  |
| control_total | Double |  |
| created_by | String |  |
| creation_date | Instant |  |
| currency_code | String |  |
| currency_conversion_date | Instant |  |
| currency_conversion_rate | Double |  |
| currency_conversion_type | String |  |
| date_created | Instant |  |
| default_effective_date | Instant |  |
| description | String |  |
| display_alc_journal_flag | String |  |
| encumbrance_type_id | Long |  |
| external_reference | String |  |
| intercompany_mode | Long |  |
| je_category | String |  |
| je_from_sla_flag | String |  |
| je_source | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| legal_entity_id | Long |  |
| multi_bal_seg_flag | String |  |
| multi_currency_flag | String |  |
| name | String |  |
| object_version_number | Long |  |
| originating_bal_seg_value | String |  |
| period_name | String |  |
| post_currency_code | String |  |
| post_multi_currency_flag | String |  |
| posted_date | Instant |  |
| posted_date_time | Instant |  |
| posting_acct_seq_assign_id | Double |  |
| posting_acct_seq_value | Double |  |
| posting_acct_seq_version_id | Double |  |
| reference_date | Instant |  |
| running_total_accounted_cr | Double |  |
| running_total_accounted_dr | Double |  |
| running_total_cr | Double |  |
| running_total_dr | Double |  |
| status | String |  |

### code_combination_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| code_combination_id | Long | PK |
| account_type | String |  |
| alternate_code_combination_id | Long |  |
| chart_of_accounts_id | Long |  |
| created_by | String |  |
| creation_date | Instant |  |
| detail_budgeting_allowed_flag | String |  |
| detail_posting_allowed_flag | String |  |
| enabled_flag | String |  |
| end_date_active | Instant |  |
| financial_category | String |  |
| jgzz_recon_flag | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| object_version_number | Long |  |
| preserve_flag | String |  |
| segment_1 | String |  |
| start_date_active | Instant |  |
| summary_flag | String |  |

### invoice_line_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| line_number | Long | PK |
| invoice_id | Long | PK, FK |
| account_segment | String |  |
| accounting_date | Instant |  |
| adjustment_reason | String |  |
| amount | Double |  |
| assessable_value | Double |  |
| asset_book_type_code | String |  |
| assets_tracking_flag | String |  |
| balancing_segment | String |  |
| base_amount | Double |  |
| budget_date | Instant |  |
| cancelled_flag | String |  |
| cc_reversal_flag | String |  |
| cost_center_segment | String |  |
| country_of_supply | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| def_acctg_period_type | String |  |
| default_dist_ccid | Long |  |
| deferred_acctg_flag | String |  |
| description | String |  |
| discarded_flag | String |  |
| disputable_flag | String |  |
| distribution_set_id | Long |  |
| expenditure_type | String |  |
| expense_group | String |  |
| final_match_flag | String |  |
| fos_xface_flag | String |  |
| funds_status | String |  |
| generate_dists | String |  |
| historical_flag | String |  |
| income_tax_region | String |  |
| invoice_includes_prepay_flag | String |  |
| item_description | String |  |
| justification | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| lcm_enabled_flag | String |  |
| line_selected_for_appl_flag | String |  |
| line_selected_for_release_flag | String |  |
| line_source | String |  |
| line_type_lookup_code | String |  |
| manufacturer | String |  |
| match_type | String |  |
| merchant_document_number | String |  |
| merchant_name | String |  |
| merchant_reference | String |  |
| merchant_tax_reg_number | String |  |
| merchant_taxpayer_id | String |  |
| model_number | String |  |
| object_version_number | Long |  |
| org_id | Long |  |
| original_amount | Double |  |
| original_base_amount | Double |  |
| overlay_dist_code_concat | String |  |
| pa_cc_processed_code | String |  |
| period_name | String |  |
| pjc_billable_flag | String |  |
| pjc_capitalizable_flag | String |  |
| pjc_context_category | String |  |
| pjc_expenditure_item_date | Instant |  |
| po_distribution_id | Double |  |
| po_header_id | Double |  |
| po_line_id | Double |  |
| po_line_location_id | Double |  |
| primary_intended_use | String |  |
| product_category | String |  |
| product_fisc_classification | String |  |
| product_table | String |  |
| product_type | String |  |
| program_update_date | Instant |  |
| prorate_across_all_items | String |  |
| quantity_invoiced | Double |  |
| rcv_transaction_id | Double |  |
| receipt_currency_code | String |  |
| receipt_missing_flag | String |  |
| receipt_required_flag | String |  |
| receipt_verified_flag | String |  |
| reference_1 | String |  |
| reference_2 | String |  |
| reference_key_1 | String |  |
| request_id | Long |  |
| rounding_amt | Double |  |
| serial_number | String |  |
| set_of_books_id | Long |  |
| source_entity_code | String |  |
| source_event_class_code | String |  |
| source_trx_level_type | String |  |
| summary_tax_line_id | Double |  |
| tax | String |  |
| tax_already_calculated_flag | String |  |
| tax_classification_code | String |  |
| tax_jurisdiction_code | String |  |
| tax_rate | Double |  |
| tax_rate_code | String |  |
| tax_regime_code | String |  |
| tax_status_code | String |  |
| trx_business_category | String |  |
| type_1099 | String |  |
| unit_meas_lookup_code | String |  |
| unit_price | Double |  |
| user_defined_fisc_class | String |  |
| ussgl_transaction_code | String |  |
| warranty_number | String |  |
| wfapproval_status | String |  |

### period_status_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| application_id | Long | PK |
| period_name | String | PK |
| ledger_id | Long | PK, FK |
| adjustment_period_flag | String |  |
| closing_status | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| effective_period_num | Long |  |
| end_date | Instant |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| object_version_number | Long |  |
| period_num | Long |  |
| period_type | String |  |
| period_year | Long |  |
| quarter_num | Long |  |
| quarter_start_date | Instant |  |
| set_of_books_id | Long |  |
| start_date | Instant |  |
| year_start_date | Instant |  |

### supplier_site_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| vendor_site_id | Double | PK |
| vendor_id | Long | FK |
| aging_onset_point | String |  |
| allow_substitute_receipts_flag | String |  |
| allow_unordered_receipts_flag | String |  |
| always_take_disc_flag | String |  |
| amount_includes_tax_flag | String |  |
| ap_tax_rounding_rule | String |  |
| area_code | String |  |
| attention_ar_flag | String |  |
| auto_calculate_interest_flag | String |  |
| auto_tax_calc_flag | String |  |
| auto_tax_calc_override | String |  |
| b_2_b_comm_method_code | String |  |
| b_2_b_site_code | String |  |
| bank_charge_bearer | String |  |
| bank_charge_deduction_type | String |  |
| buyer_managed_transport_flag | String |  |
| consumption_advice_frequency | String |  |
| consumption_advice_summary | String |  |
| country_of_origin_code | String |  |
| create_debit_memo_flag | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| customer_num | String |  |
| ece_tp_location_code | String |  |
| email_address | String |  |
| enforce_ship_to_location_code | String |  |
| exclude_freight_from_discount | String |  |
| exclude_tax_from_discount | String |  |
| fax | String |  |
| fax_area_code | String |  |
| fax_country_code | String |  |
| fob_lookup_code | String |  |
| freight_terms_lookup_code | String |  |
| gapless_inv_num_flag | String |  |
| hold_all_payments_flag | String |  |
| hold_flag | String |  |
| hold_future_payments_flag | String |  |
| hold_reason | String |  |
| hold_unmatched_invoices_flag | String |  |
| inactive_date | Instant |  |
| inspection_required_flag | String |  |
| invoice_channel | String |  |
| invoice_currency_code | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| match_option | String |  |
| mode_of_transport | String |  |
| offset_tax_flag | String |  |
| offset_vat_code | String |  |
| pay_date_basis_lookup_code | String |  |
| pay_group_lookup_code | String |  |
| pay_on_code | String |  |
| pay_on_receipt_summary_code | String |  |
| pay_on_use_flag | String |  |
| pay_site_flag | String |  |
| payment_currency_code | String |  |
| pcard_site_flag | String |  |
| phone | String |  |
| phone_country_code | String |  |
| phone_extension | String |  |
| po_ack_reqd_code | String |  |
| primary_pay_site_flag | String |  |
| purchasing_hold_reason | String |  |
| purchasing_site_flag | String |  |
| qty_rcv_exception_code | String |  |
| receipt_days_exception_code | String |  |
| receipt_required_flag | String |  |
| rfq_only_site_flag | String |  |
| selling_company_identifier | String |  |
| service_level | String |  |
| ship_via_lookup_code | String |  |
| shipping_control | String |  |
| supplier_notif_method | String |  |
| tax_country_code | String |  |
| tax_reporting_site_flag | String |  |
| telex | String |  |
| terms_date_basis | String |  |
| vat_code | String |  |
| vat_registration_num | String |  |
| vendor_site_code | String |  |
| vendor_site_code_alt | String |  |

### transaction_type_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| cust_trx_type_id | Long | PK |
| accounting_affect_flag | String |  |
| allocate_tax_freight | String |  |
| allow_freight_flag | String |  |
| allow_future_acct_date_flag | String |  |
| allow_overapplication_flag | String |  |
| control_completion_level_code | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| creation_sign | String |  |
| cust_trx_type_seq_id | Long |  |
| default_printing_option | String |  |
| default_status | String |  |
| description | String |  |
| document_type | String |  |
| drawee_issued_flag | String |  |
| end_date | Instant |  |
| exclude_from_late_charges | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| legal_entity_id | Long |  |
| magnetic_format_code | String |  |
| name | String |  |
| natural_application_only_flag | String |  |
| object_version_number | Long |  |
| post_to_gl | String |  |
| set_id | Long |  |
| signed_flag | String |  |
| start_date | Instant |  |
| status | String |  |
| tax_calculation_flag | String |  |
| type | String |  |

### transaction_header_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| customer_trx_id | Long | PK |
| address_verification_code | String |  |
| approval_code | String |  |
| bill_plan_period | Double |  |
| bill_template_name | String |  |
| br_amount | Double |  |
| br_on_hold_flag | String |  |
| br_unpaid_flag | String |  |
| cc_error_code | String |  |
| cc_error_flag | String |  |
| cc_error_text | String |  |
| comments | String |  |
| complete_flag | String |  |
| control_completion_reason_code | String |  |
| created_by | String |  |
| created_from | String |  |
| creation_date | Instant |  |
| credit_method_for_installments | String |  |
| credit_method_for_rules | String |  |
| ct_reference | String |  |
| customer_reference | String |  |
| default_tax_exempt_flag | String |  |
| default_taxation_country | String |  |
| del_contact_email_address | String |  |
| delivery_method_code | String |  |
| document_sub_type | String |  |
| exchange_rate | Double |  |
| exchange_rate_type | String |  |
| finance_charges | String |  |
| fiscal_doc_access_key | String |  |
| fiscal_doc_status | String |  |
| fob_point | String |  |
| intercompany_flag | String |  |
| interface_header_attribute_1 | String |  |
| interface_header_context | String |  |
| internal_notes | String |  |
| invoice_currency_code | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| late_charges_assessed | String |  |
| old_trx_number | String |  |
| orig_system_batch_name | String |  |
| override_remit_account_flag | String |  |
| payment_attributes | String |  |
| payment_server_order_num | String |  |
| prepayment_flag | String |  |
| printing_option | String |  |
| printing_pending | String |  |
| purchase_order | String |  |
| purchase_order_revision | String |  |
| ready_for_xml_delivery_flag | String |  |
| reason_code | String |  |
| recurred_from_trx_number | String |  |
| requires_manual_scheduling | String |  |
| rev_rec_application | String |  |
| ship_via | String |  |
| source_document_type | String |  |
| source_system | String |  |
| special_instructions | String |  |
| status_trx | String |  |
| structured_payment_reference | String |  |
| trx_business_category | String |  |
| trx_class | String |  |
| trx_class_lookup_type | String |  |
| trx_number | String |  |
| upgrade_method | String |  |
| user_defined_fisc_class | String |  |
| waybill_number | String |  |

### ledger_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| ledger_id | Long | PK |
| ret_earn_code_combination_id | Long | FK |
| accounted_period_type | String |  |
| allow_intercompany_post_flag | String |  |
| ap_doc_sequencing_option_flag | String |  |
| ar_doc_sequencing_option_flag | String |  |
| automate_sec_jrnl_rev_flag | String |  |
| autorev_after_open_prd_flag | String |  |
| bal_seg_column_name | String |  |
| bal_seg_value_option_code | String |  |
| chart_of_accounts_id | Long |  |
| complete_flag | String |  |
| completion_status_code | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| currency_code | String |  |
| daily_translation_rate_type | String |  |
| description | String |  |
| enable_automatic_tax_flag | String |  |
| enable_average_balances_flag | String |  |
| enable_budgetary_control_flag | String |  |
| enable_je_approval_flag | String |  |
| enable_reconciliation_flag | String |  |
| enable_reval_ss_track_flag | String |  |
| enf_seq_date_correlation_code | String |  |
| first_ledger_period_name | String |  |
| jrnls_group_by_date_flag | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| latest_opened_period_name | String |  |
| ledger_category_code | String |  |
| minimum_threshold_amount | Double |  |
| name | String |  |
| net_closing_bal_flag | String |  |
| object_type_code | String |  |
| period_average_rate_type | String |  |
| period_end_rate_type | String |  |
| period_set_name | String |  |
| pop_up_stat_account_flag | String |  |
| prior_prd_notification_flag | String |  |
| require_budget_journals_flag | String |  |
| reval_from_pri_lgr_curr | String |  |
| sequencing_mode_code | String |  |
| short_name | String |  |
| sla_accounting_method_code | String |  |
| sla_accounting_method_type | String |  |
| sla_bal_by_ledger_curr_flag | String |  |
| sla_description_language | String |  |
| sla_ledger_cash_basis_flag | String |  |
| sla_sequencing_flag | String |  |
| suspense_allowed_flag | String |  |
| threshold_amount | Double |  |
| track_rounding_imbalance_flag | String |  |
| translate_eod_flag | String |  |
| translate_qatd_flag | String |  |
| translate_yatd_flag | String |  |
| validate_journal_ref_date | String |  |

### cust_profile_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| cust_account_profile_id | Long | PK |
| account_status | String |  |
| auto_rec_incl_disputed_flag | String |  |
| b_2_b_tp_code | String |  |
| charge_on_finance_charge_flag | String |  |
| cons_bill_level | String |  |
| cons_inv_flag | String |  |
| cons_inv_type | String |  |
| created_by | String |  |
| created_by_module | String |  |
| credit_balance_statements | String |  |
| credit_checking | String |  |
| credit_classification | String |  |
| credit_currency_code | String |  |
| credit_hold | String |  |
| credit_items_flag | String |  |
| credit_rating | String |  |
| credit_review_cycle | String |  |
| discount_terms | String |  |
| disputed_transactions_flag | String |  |
| dunning_letters | String |  |
| exchange_rate_type | String |  |
| hold_charged_invoices_flag | String |  |
| interest_calculation_period | String |  |
| interest_charges | String |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| late_charge_calculation_trx | String |  |
| late_charge_type | String |  |
| lockbox_matching_option | String |  |
| match_by_autoupdate_flag | String |  |
| multiple_interest_rates_flag | String |  |
| override_terms | String |  |
| pref_contact_method | String |  |
| printing_option_code | String |  |
| review_cycle | String |  |
| risk_code | String |  |
| send_statements | String |  |
| status | String |  |
| stmt_delivery_method | String |  |
| tax_printing_option | String |  |
| txn_delivery_method | String |  |
| xml_cb_flag | String |  |
| xml_cm_flag | String |  |
| xml_dm_flag | String |  |
| xml_inv_flag | String |  |

### invoice_distribution_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| invoice_distribution_id | Long | PK |
| dist_code_combination_id | Long | FK |
| invoice_id | Long | FK |
| accounting_date | Instant |  |
| adjustment_reason | String |  |
| amount | Double |  |
| asset_book_type_code | String |  |
| assets_addition_flag | String |  |
| assets_tracking_flag | String |  |
| awt_flag | String |  |
| base_amount | Double |  |
| budget_date | Instant |  |
| cancellation_flag | String |  |
| cc_reversal_flag | String |  |
| country_of_supply | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| description | String |  |
| dist_match_type | String |  |
| distribution_class | String |  |
| distribution_line_number | Long |  |
| exchange_rate_type | String |  |
| expenditure_type | String |  |
| expense_group | String |  |
| final_match_flag | String |  |
| fully_paid_acctd_flag | String |  |
| funds_status | String |  |
| income_tax_region | String |  |
| intended_use | String |  |
| inventory_transfer_status | String |  |
| invoice_includes_prepay_flag | String |  |
| invoice_line_number | Double |  |
| justification | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| line_type_lookup_code | String |  |
| match_status_flag | String |  |
| matched_uom_lookup_code | String |  |
| merchant_document_number | String |  |
| merchant_name | String |  |
| merchant_reference | String |  |
| merchant_tax_reg_number | String |  |
| merchant_taxpayer_id | String |  |
| object_version_number | Long |  |
| org_id | Long |  |
| pa_addition_flag | String |  |
| pa_cmt_xface_flag | String |  |
| period_name | String |  |
| pjc_billable_flag | String |  |
| pjc_capitalizable_flag | String |  |
| pjc_context_category | String |  |
| pjc_expenditure_item_date | Instant |  |
| posted_flag | String |  |
| program_update_date | Instant |  |
| rcv_charge_addition_flag | String |  |
| receipt_currency_code | String |  |
| receipt_missing_flag | String |  |
| receipt_required_flag | String |  |
| receipt_verified_flag | String |  |
| recovery_rate_code | String |  |
| recovery_rate_name | String |  |
| recovery_type_code | String |  |
| reference_1 | String |  |
| reference_2 | String |  |
| reversal_flag | String |  |
| rounding_amt | Double |  |
| tax_already_distributed_flag | String |  |
| tax_recoverable_flag | String |  |
| taxable_amount | Double |  |
| taxable_base_amount | Double |  |
| total_dist_amount | Double |  |
| total_dist_base_amount | Double |  |
| type_1099 | String |  |

### journal_line_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| je_line_num | Long | PK |
| je_header_id | Long | PK, FK |
| code_combination_id | Long | FK |
| ledger_id | Long | FK |
| accounted_cr | Double |  |
| accounted_dr | Double |  |
| created_by | String |  |
| creation_date | Instant |  |
| currency_code | String |  |
| currency_conversion_date | Instant |  |
| currency_conversion_rate | Double |  |
| currency_conversion_type | String |  |
| description | String |  |
| effective_date | Instant |  |
| entered_cr | Double |  |
| entered_dr | Double |  |
| gl_sl_link_id | Double |  |
| gl_sl_link_table | String |  |
| ignore_rate_flag | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| line_type_code | String |  |
| object_version_number | Long |  |
| period_name | String |  |
| reference_1 | String |  |
| stat_amount | Double |  |
| status | String |  |
| subledger_doc_sequence_id | Double |  |
| subledger_doc_sequence_value | Double |  |

### invoice_header_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Long | PK, FK |
| vendor_id | Long | FK |
| vendor_site_id | Long | FK |
| amount_applicable_to_discount | Double |  |
| amount_paid | Double |  |
| approval_description | String |  |
| approval_ready_flag | String |  |
| approval_status | String |  |
| approved_amount | Double |  |
| awt_flag | String |  |
| bank_charge_bearer | String |  |
| base_amount | Double |  |
| budget_date | Instant |  |
| cancelled_amount | Double |  |
| cancelled_by | String |  |
| cancelled_date | Instant |  |
| check_vat_amount_paid | String |  |
| control_amount | Double |  |
| correction_period | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| cust_registration_code | String |  |
| cust_registration_number | String |  |
| delivery_channel_code | String |  |
| description | String |  |
| disc_is_inv_less_tax_flag | String |  |
| discount_amount_taken | Double |  |
| doc_category_code | String |  |
| document_sub_type | String |  |
| employee_address_code | String |  |
| exchange_date | Instant |  |
| exchange_rate | Double |  |
| exchange_rate_type | String |  |
| exclude_freight_from_discount | String |  |
| exclusive_payment_flag | String |  |
| expenditure_type | String |  |
| fiscal_doc_access_key | String |  |
| force_revalidation_flag | String |  |
| funds_status | String |  |
| gl_date | Instant |  |
| historical_flag | String |  |
| image_document_num | String |  |
| import_document_number | String |  |
| intercompany_flag | String |  |
| internal_contact_email | String |  |
| invoice_amount | Double |  |
| invoice_currency_code | String |  |
| invoice_date | Instant |  |
| invoice_num | String |  |
| invoice_received_date | Instant |  |
| invoice_type_lookup_code | String |  |
| job_definition_name | String |  |
| job_definition_package | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| legal_entity_id | Long |  |
| locked_by | String |  |
| net_of_retainage_flag | String |  |
| object_version_number | Long |  |
| org_id | Long |  |
| party_id | Long |  |
| pay_curr_invoice_amount | Double |  |
| pay_group_lookup_code | String |  |
| pay_proc_trxn_type_code | String |  |
| payment_cross_rate_type | String |  |
| payment_currency_code | String |  |
| payment_function | String |  |
| payment_method_code | String |  |
| payment_method_lookup_code | String |  |
| payment_reason_code | String |  |
| payment_reason_comments | String |  |
| payment_status_flag | String |  |
| po_matched_flag | String |  |
| port_of_entry_code | String |  |
| posting_status | String |  |
| product_table | String |  |
| quick_credit | String |  |
| reference_1 | String |  |
| reference_2 | String |  |
| reference_key_1 | String |  |
| remit_to_address_name | String |  |
| remit_to_supplier_name | String |  |
| remittance_message_1 | String |  |
| remittance_message_2 | String |  |
| remittance_message_3 | String |  |
| routing_status_lookup_code | String |  |
| set_of_books_id | Long |  |
| settlement_priority | String |  |
| source | String |  |
| supplier_tax_invoice_number | String |  |
| tax_invoice_internal_seq | String |  |
| taxation_country | String |  |
| temp_cancelled_amount | Double |  |
| terms_date | Instant |  |
| terms_id | Long |  |
| total_tax_amount | Double |  |
| trx_business_category | String |  |
| unique_remittance_identifier | String |  |
| uri_check_digit | String |  |
| user_defined_fisc_class | String |  |
| ussgl_transaction_code | String |  |
| ussgl_trx_code_context | String |  |
| voucher_num | String |  |
| wfapproval_status | String |  |

### supplier_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| vendor_id | Long | PK |
| alias_party_name | String |  |
| allow_awt_flag | String |  |
| alternate_name_party_name | String |  |
| attribute_13 | String |  |
| bc_not_applicable_flag | String |  |
| business_relationship | String |  |
| corporate_website | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| creation_source | String |  |
| customer_num | String |  |
| end_date_active | Instant |  |
| federal_reportable_flag | String |  |
| income_tax_id | String |  |
| income_tax_id_flag | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| name_control | String |  |
| ni_number | String |  |
| ni_number_flag | String |  |
| object_version_number | Long |  |
| one_time_flag | String |  |
| organization_type_lookup_code | String |  |
| parent_party_id | Double |  |
| parent_vendor_id | Double |  |
| party_id | Double |  |
| segment_1 | String |  |
| spend_auth_review_status | String |  |
| standard_industry_class | String |  |
| start_date_active | Instant |  |
| state_reportable_flag | String |  |
| tax_reporting_name | String |  |
| taxpayer_country | String |  |
| type_1099 | String |  |
| vendor_type_lookup_code | String |  |

### journal_batch_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| je_batch_id | Long | PK |
| parent_je_batch_id | Long | FK |
| accounted_period_type | String |  |
| actual_flag | String |  |
| approval_status_code | String |  |
| approver_employee_id | Long |  |
| average_journal_flag | String |  |
| chart_of_accounts_id | Long |  |
| control_total | Double |  |
| created_by | String |  |
| creation_date | Instant |  |
| date_created | Instant |  |
| default_effective_date | Instant |  |
| default_period_name | String |  |
| description | String |  |
| error_message | String |  |
| funds_status_code | String |  |
| group_id | Long |  |
| je_source | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| name | String |  |
| object_version_number | Long |  |
| period_set_name | String |  |
| posted_date | Instant |  |
| posting_run_id | Long |  |
| request_id | Long |  |
| running_total_accounted_cr | Double |  |
| running_total_accounted_dr | Double |  |
| running_total_cr | Double |  |
| running_total_dr | Double |  |
| status | String |  |

## Relationships

- journal_import_reference_extract_pvo(je_header_id) → journal_header_extract_pvo(je_header_id)
- journal_import_reference_extract_pvo(je_batch_id) → journal_batch_extract_pvo(je_batch_id)
- transaction_line_extract_pvo(customer_trx_id) → transaction_header_extract_pvo(customer_trx_id)
- balance_extract_pvo(ledger_id) → ledger_extract_pvo(ledger_id)
- balance_extract_pvo(code_combination_id) → code_combination_extract_pvo(code_combination_id)
- journal_header_extract_pvo(je_batch_id) → journal_batch_extract_pvo(je_batch_id)
- journal_header_extract_pvo(ledger_id) → ledger_extract_pvo(ledger_id)
- journal_header_extract_pvo(accrual_rev_je_header_id) → journal_header_extract_pvo(je_header_id)
- journal_header_extract_pvo(reversed_je_header_id) → journal_header_extract_pvo(je_header_id)
- journal_header_extract_pvo(parent_je_header_id) → journal_header_extract_pvo(je_header_id)
- invoice_line_extract_pvo(invoice_id) → invoice_header_extract_pvo(invoice_id)
- period_status_extract_pvo(ledger_id) → ledger_extract_pvo(ledger_id)
- supplier_site_extract_pvo(vendor_id) → supplier_extract_pvo(vendor_id)
- ledger_extract_pvo(ret_earn_code_combination_id) → code_combination_extract_pvo(code_combination_id)
- invoice_distribution_extract_pvo(invoice_id) → invoice_header_extract_pvo(invoice_id)
- invoice_distribution_extract_pvo(dist_code_combination_id) → code_combination_extract_pvo(code_combination_id)
- journal_line_extract_pvo(je_header_id) → journal_header_extract_pvo(je_header_id)
- journal_line_extract_pvo(code_combination_id) → code_combination_extract_pvo(code_combination_id)
- journal_line_extract_pvo(ledger_id) → ledger_extract_pvo(ledger_id)
- invoice_header_extract_pvo(invoice_id) → supplier_extract_pvo(vendor_id)
- invoice_header_extract_pvo(vendor_id) → supplier_extract_pvo(vendor_id)
- invoice_header_extract_pvo(vendor_site_id) → supplier_site_extract_pvo(vendor_site_id)
- journal_batch_extract_pvo(parent_je_batch_id) → journal_batch_extract_pvo(je_batch_id)