Oracle Fusion Cloud Applications - FSCM(ERP & SCM)

Explore the interactive ERD

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	PKFK
`ledger_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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