Workday Financial Management

Explore the interactive ERD

Table & Field Reference

billing_schedule_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`address_component_name`	String
`submunicipality`	String
`type`	String

expense_credit_card_transaction

Column	Type	Keys
`id`	String	PK
`converted_currency_id`	String	FK
`source_currency_id`	String	FK
`account_number`	String
`air_carrier_code`	String
`air_routing`	String
`amount`	Double
`arrival_date`	LocalDate
`assignee_id`	String
`billing_date`	LocalDate
`cardholder_id`	String
`cardholder_name`	String
`charge_description`	String
`charge_description_line_1`	String
`charge_description_line_2`	String
`class_of_service`	String
`class_of_service_id`	String
`converted_amount`	Double
`converted_tax_amount`	Double
`corporate_account_code`	String
`corporate_account_id`	String
`cost_center_code`	String
`cost_center_id`	String
`credit_card_category_code`	String
`credit_card_category_id`	String
`credit_card_merchant_location`	String
`credit_card_merchant_name`	String
`credit_card_transaction_status_code`	String
`credit_card_transaction_status_id`	String
`currency_exchange_rate`	Double
`daily_rate`	Double
`departure_date`	LocalDate
`destination_airport_code`	String
`destination_city`	String
`destination_country`	String
`destination_state`	String
`domestic`	Boolean
`duns_number_for_supplier`	String
`euro_billed_amount`	Double
`euro_billed_tax_amount`	Double
`expense_credit_card_file_ids`	Json
`expense_credit_card_id`	String
`expense_credit_card_token`	String
`expense_credit_card_transaction_ref_code`	String
`expense_credit_card_transaction_ref_id`	String
`expense_payee`	String
`financial_category_code`	String
`market_code`	String
`match_switch`	String
`match_type_code`	String
`merchant_address`	String
`merchant_city`	String
`merchant_code`	String
`merchant_code_id`	String
`merchant_country`	String
`merchant_country_region`	String
`merchant_document_number`	String
`merchant_postal_code`	String
`merchant_tax_id`	String
`mis_industry_code`	String
`mis_industry_code_id`	String
`number_of_days_or_nights`	Double
`origination_airport_code`	String
`origination_city`	String
`origination_country`	String
`origination_state`	String
`participant_name`	String
`posted_date`	LocalDate
`purchase_order_number`	String
`reason_for_assignment`	String
`reference_number`	String
`release_number`	String
`sales_taxes_collected`	Boolean
`supplier_reference_number`	String
`tax_amount`	Double
`ticket_number`	String
`transaction_date`	LocalDate
`transaction_type_code`	String
`transaction_type_id`	String

lease_payment_line

Column	Type	Keys
`index`	Int	PK
`supplier_contract_lease_amendment_id`	String	PKFK
`amount`	Double
`payment_date`	LocalDate

purchase_order_acknowledgement_line_alternate_item

Column	Type	Keys
`index`	Int	PK
`purchase_order_acknowledgement_line_id`	String	PKFK
`manufacturer_id`	String	FK
`external_name`	String
`value`	String

revenue_recognition_schedule_installment_schedule

Column	Type	Keys
`line_id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`first_installment_amount`	Double
`last_installment_amount`	Double
`line_code`	String
`regular_installment_amount`	Double

commodity_code

Column	Type	Keys
`id`	String	PK
`commodity_code_type_id`	String	FK
`parent_commodity_code_id`	String	FK
`commodity_code`	String
`description`	String
`inactive`	Boolean
`short_description`	String

requisition_service_request_line_close_status

Column	Type	Keys
`index`	Long	PK
`service_request_line_index`	Long	PK
`requisition_id`	String	PKFK
`close_comments`	String
`close_date`	LocalDate
`close_reason_code`	String
`is_closed`	Boolean

project_timesheet

Column	Type	Keys
`_fivetran_id`	String	PK
`worker_id`	String	FK
`locked_in_workday`	Boolean
`period_code`	String
`period_id`	String
`project_timesheet_code`	String
`timesheet_ref_id`	String
`timesheet_type_is_project_worksheet`	Boolean

supplier_contact_phone

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`country_iso_code`	String
`international_phone_code`	String
`phone_code`	String
`phone_device_type`	String
`phone_extension`	String
`phone_number`	String

request_for_quote_response_line

Column	Type	Keys
`id`	String	PK
`request_for_quote_line_id`	String	FK
`request_for_quote_response_id`	String	FK
`end_date`	LocalDate
`line_item_description`	String
`line_type`	String
`no_bid`	Boolean
`quantity`	Double
`requested_delivery_date`	LocalDate
`response_lead_time`	Double
`response_line_description`	String
`response_memo`	String
`response_price`	Double
`response_quantity`	Double
`rfq_line_memo`	String
`rfq_line_number`	Double
`start_date`	LocalDate
`target_price`	Double
`unit_of_measure_code`	String

requisition_attachment

Column	Type	Keys
`index`	Long	PK
`requisition_id`	String	PKFK
`attachment_category_id`	String
`content_type`	String
`description`	String
`external_file_location`	String
`file_name`	String

customer_contract_line_data

Column	Type	Keys
`line_number`	Double	PK
`customer_contract_id`	String	PKFK
`alternate_customer_contract_line_id`	String	FK
`line_company_id`	String	FK
`original_customer_contract_line_id`	String	FK
`revenue_recognition_schedule_template_id`	String	FK
`sales_item_id`	String	FK
`allocation_percentage`	Double
`billable_project`	String
`billable_transaction_tax`	Boolean
`billing_only_customer_contract_line`	String
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`bundle_line_number`	Double
`contract_line_description`	String
`contract_line_fee`	String
`contract_line_type`	String
`contract_rate_sheet`	String
`customer_contract_line_end_date`	LocalDate
`customer_contract_line_revenue_override_amount`	Double
`customer_contract_line_start_date`	LocalDate
`deferred_revenue`	Boolean
`document_status`	String
`exclude_from_calculation`	Boolean
`extended_amount`	Double
`fair_value_extended_amount`	Double
`fair_value_unit_price`	Double
`first_installment_amount`	Double
`frequency_behavior`	String
`last_installment_amount`	Double
`line_billing_notes`	String
`line_invoice_memo`	String
`line_invoice_memo_override`	String
`line_item_description_override`	String
`list_extended_amount`	Double
`list_unit_price`	Double
`lower_range_percentage`	Double
`mid_range`	Double
`new_business`	Boolean
`number_of_installments`	Double
`quantity`	Double
`quantity_2`	Double
`range_high`	Double
`range_low`	Double
`recalculate_fv_unit_price`	Boolean
`receivable_contract_line_reference_id`	String
`regular_installment_amount`	Double
`relative_selling_price_allocation`	Double
`renewable`	Boolean
`revenue_allocation_calculation_basis`	String
`revenue_category`	String
`revenue_recognition_line_notes`	String
`revenue_treatment`	String
`tax_applicability`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure`	String
`unit_of_measure_2`	String
`upper_range_percentage`	Double
`usage_billing_rate`	String
`use_standard_rate_sheet`	Boolean
`withholding_tax_code`	String
`zero_revenue`	Boolean

customer_date_milestone

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`comments`	String
`complete`	Boolean
`completed_on`	LocalDate
`customer_milestone_code`	String
`estimated_completion_date`	LocalDate
`name`	String
`type`	String

purchase_item_group

Column	Type	Keys
`id`	String	PK
`name`	String
`purchase_item_group_code`	String

fund_hierarchy

Column	Type	Keys
`id`	String	PK
`parent_fund_hierarchy_id`	String	FK
`fund_hierarchy_code`	String
`fund_hierarchy_is_inactive`	Boolean
`fund_hierarchy_name`	String
`include_fund_hierarchy_id_in_name`	Boolean
`organization_subtype_code`	String
`organization_subtype_id`	String

recall_company_detail

Column	Type	Keys
`id`	String	PK
`recall_reaction_id`	String	PKFK
`company_id`	String	FK
`comments`	String
`create_responses`	Boolean
`inventory_location`	Double
`inventory_site`	Double
`issue_line`	Double
`no_action_needed`	Boolean
`purchase_order_line`	Double

business_document_line_split

Column	Type	Keys
`id`	String	PK
`credit_card_transaction_id`	String	PKFK
`line_index`	Long	PKFK
`procurement_card_transaction_verification_id`	String	PKFK
`budget_date`	LocalDate
`extended_amount`	Double
`memo`	String
`quantity`	Double

business_document_line_split_worktag

Column	Type	Keys
`worktag_id`	String	PK
`business_document_line_split_id`	String	PKFK
`credit_card_transaction_id`	String	PKFK
`line_index`	Long	PKFK
`procurement_card_transaction_verification_id`	String	PKFK

receipt_line_goods_item_split

Column	Type	Keys
`index`	Int	PK
`receipt_id`	String	PKFK
`receipt_line_goods_item_index`	Int	PKFK
`extended_amount`	Double
`memo`	String
`quantity`	Double

company_tax_id

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`primary_tax_id`	Boolean
`tax_id_text`	String
`transaction_tax_id`	Boolean

company_alternate_fiscal_schedule

Column	Type	Keys
`fiscal_schedule_code`	String	PK
`company_id`	String	PKFK

inventory_shipment_line

Column	Type	Keys
`line_number`	Double	PK
`inventory_shipment_id`	String	PKFK
`purchase_item_id`	String	FK
`line_item_description`	String
`memo`	String
`quantity`	Double

organization_job_profile_exempt

Column	Type	Keys
`location_context_id`	String	PK
`job_profile_id`	String	PKFK
`organization_id`	String	PKFK
`job_exempt`	Boolean

compensation_grade_profile

Column	Type	Keys
`id`	String	PK
`compensation_grade_id`	String	PKFK
`compensation_plan_id`	String	FK
`compensation_grade_profile_code`	String
`currency_code`	String
`description`	String
`effective_date`	LocalDate
`frequency_code`	String
`inactive`	Boolean
`is_override_allowed`	Boolean
`maximum`	Double
`midpoint`	Double
`minimum`	Double
`name`	String
`number_of_segments`	Double
`segment_1_top`	Double
`segment_2_top`	Double
`segment_3_top`	Double
`segment_4_top`	Double
`segment_5_top`	Double
`spread`	Double

unspc_code_range

Column	Type	Keys
`id`	String	PK
`resource_category_id`	String	PKFK
`range_from`	Double
`range_to`	Double
`use_on_po`	Boolean

allocation_pool_hierarchy

Column	Type	Keys
`id`	String	PK
`superior_allocation_pool_hierarchy_id`	String	FK
`allocation_pool_hierarchy_name`	String
`allocation_pool_hierarchy_reference_id`	String
`inactive`	Boolean
`include_allocation_pool_hierarchy_id_in_name`	Boolean
`organization_subtype_code`	String
`organization_subtype_id`	String

allocation_pool_worktag

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`accounting_worktag_type_code`	String
`accounting_worktag_type_id`	String
`allocation_pool_worktag_value_code`	String
`allocation_pool_worktag_value_id`	String
`allocation_pool_worktag_value_source_code`	String
`allocation_pool_worktag_value_source_id`	String

customer_contract_discount_and_premium

Column	Type	Keys
`id`	String	PK
`contract_discount_and_premium_code`	String
`end_date`	LocalDate
`in_use`	Boolean
`is_inactive`	Boolean
`notes`	String
`percentage`	Double
`start_date`	LocalDate
`type`	String

hotel_detail

Column	Type	Keys
`index`	Long	PK
`expense_credit_card_transaction_id`	String	FK
`audio_visual_charges`	Double
`banquet_charges`	Double
`business_center_charges`	Double
`cash_disbursements_amount`	Double
`conference_room_charges`	Double
`customer_vat_num`	String
`gift_shop_charges`	Double
`gratuity_charges`	Double
`health_club_charges`	Double
`hotel_total_tax_amount`	Double
`internet_access_charges_amount`	Double
`laundry_dry_clean_amount`	Double
`lounge_bar_charges`	Double
`mini_bar_charges`	Double
`movie_charges`	Double
`no_show_indicator`	Boolean
`prepaid_expenses_amount`	Double
`restaurant_charges_amount`	Double
`room_service_charges_amount`	Double
`tax_exempt_indicator`	Boolean
`telephone_charges`	Double
`total_amount_charged_on_credit_card_amount`	Double
`total_charges_amount`	Double
`total_non_room_charges_amount`	Double
`total_non_room_tax_amount`	Double
`total_room_tax`	Double
`transportation_charges`	Double
`valet_charges`	Double

supplier_group

Column	Type	Keys
`id`	String	PK
`supplier_group_id`	String
`supplier_group_name`	String

customer_contact_phone

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`country_iso_code`	String
`international_phone_code`	String
`phone_code`	String
`phone_device_type`	String
`phone_extension`	String
`phone_number`	String

billing_schedule_address_line

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`address_line`	String
`descriptor`	String
`type`	String

override_revenue_allocation_configuration_line

Column	Type	Keys
`index`	Long	PK
`revenue_allocation_configuration_id`	String	PKFK
`company_id`	String	FK
`allocation_basis`	String
`fair_value_price_list`	String
`line_override_defaults_data`	Json
`lower_range_percentage`	Double
`override_revenue_allocation_configuration_code`	String
`override_revenue_allocation_configuration_line_code`	String
`upper_range_percentage`	Double

supplier_invoice_assignment_rule_currency

Column	Type	Keys
`currency_id`	String	PKFK
`supplier_invoice_assignment_rule_id`	String	PKFK

revenue_recognition_schedule_multi_period_allocation

Column	Type	Keys
`multi_period_allocation_id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`multi_period_allocation`	String
`multi_period_allocation_amount`	Double
`multi_period_allocation_description`	String
`multi_period_allocation_from_date`	LocalDate
`multi_period_allocation_percent`	Double
`multi_period_allocation_to_date`	LocalDate

organization

Column	Type	Keys
`id`	String	PK
`manager_id`	String	FK
`organization_owner_id`	String	FK
`superior_organization_id`	String	FK
`top_level_organization_id`	String	FK
`available_for_hire`	Boolean
`availibility_date`	Instant
`code`	String
`description`	String
`external_url`	String
`hiring_freeze`	Boolean
`inactive`	Boolean
`inactive_date`	LocalDate
`include_manager_in_name`	Boolean
`include_organization_code_in_name`	Boolean
`last_updated_date_time`	Instant
`location`	String
`name`	String
`organization_code`	String
`staffing_model`	String
`sub_type`	String
`sub_type_code`	String
`sub_type_descriptor`	String
`supervisory_position_availability_date`	LocalDate
`supervisory_position_earliest_hire_date`	LocalDate
`supervisory_position_time_type`	String
`supervisory_position_worker_type`	String
`type`	String
`type_descriptor`	String
`visibility`	String

allocation_definition_used_by_organization

Column	Type	Keys
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`organization_id`	String	PKFK
`source_type_id`	String	PKFK
`organization_code`	String

sales_item_allowed_worktag

Column	Type	Keys
`allowed_worktag_id`	String	PKFK
`sales_item_id`	String	PKFK
`worktag_type_id`	String	PKFK
`allowed_worktag_code`	Json

sales_item_price_list_worktag

Column	Type	Keys
`effective_date`	LocalDate	PK
`accounting_worktag_type_id`	String	PKFK
`sales_item_price_list_id`	String	PKFK

inventory_return_order

Column	Type	Keys
`id`	String	PK
`date`	LocalDate
`inventory_return_order_code`	String

supplier_contract_amendment_goods_line

Column	Type	Keys
`line_number`	String	PK
`supplier_contract_amendment_id`	String	PKFK
`companyfor_invoices_id`	String	FK
`location`	String	FK
`ship_to_contact_id`	String	FK
`cancel_supplier_contract_line`	Boolean
`consigned_quantity`	Double
`conversion_factor`	Double
`description`	String
`end_date`	LocalDate
`extended_amount`	Double
`line_on_hold`	Boolean
`memo`	String
`quantity`	Double
`retention`	Boolean
`ship_to_address`	String
`specified_in_service_date`	LocalDate
`start_date`	LocalDate
`tax_code`	String
`unit_cost`	Double

requisition_service_request_line_split_worktag

Column	Type	Keys
`worktag_id`	String	PK
`requisition_id`	String	PKFK
`service_line_split_index`	Long	PKFK
`service_request_line_index`	Long	PKFK

procurement_card_transaction_verification_summary

Column	Type	Keys
`credit_card_transaction_id`	String	PK
`procurement_card_transaction_verification_id`	String	PKFK
`purchase_order_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`transaction_currency_id`	String	FK
`charge_description`	String
`extended_amount`	Double
`sales_tax_collected`	Boolean
`transaction_date`	LocalDate

inventory_storage_location

Column	Type	Keys
`id`	String	PK
`location_identifier`	String
`location_name`	String

allocation_definition_basis_ledger_account_filter

Column	Type	Keys
`ledger_account_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`ledger_account_code`	String	FK

customer_invoice_line

Column	Type	Keys
`id`	String	PK
`customer_contract_line_id`	String	FK
`customer_invoice_id`	String	FK
`intercompany_affiliate_id`	String	FK
`revenue_category_id`	String	FK
`ship_to_customer_id`	String	FK
`amount_released`	Double
`amount_retained`	Double
`analytical_amount`	Double
`calculated_tax_amount`	Double
`customer_invoice_line_code`	String
`deferred_revenue`	Boolean
`extended_amount`	Double
`from_date`	LocalDate
`line_item_description`	String
`line_order`	String
`memo`	String
`quantity`	Double
`quantity_2`	Double
`receivable_contract_line_code`	String
`ship_to_address`	String
`tax_applicability_code`	String
`tax_code`	String
`to_date`	LocalDate
`transaction_date`	LocalDate
`unit_cost`	Double
`unit_of_measure_2_code`	String
`unit_of_measure_code`	String
`withholding_tax_code`	String

bank_statement_summary

Column	Type	Keys
`balance_type_code`	String	PK
`bank_statement_id`	String	PKFK
`alternate_balance_type_code`	String
`amount`	BigDecimal
`debit`	Boolean
`item_count`	BigDecimal

allocation_group_set

Column	Type	Keys
`allocation_group_set_name`	String	PK
`allocation_time_frame_id`	String	PK
`allocation_group_set_code`	String
`allocation_group_set_description`	String
`allocation_group_set_id`	String
`allocation_time_frame_code`	String
`fiscal_summary_schedule_code`	String
`fiscal_summary_schedule_id`	String
`inactive`	Boolean

allocation_pool

Column	Type	Keys
`name`	String	PK
`company_id`	String	FK
`allocation_pool_code`	String
`allocation_pool_description`	String
`allocation_pool_plan_code`	String
`allocation_pool_plan_id`	String
`allocation_pool_reference_id`	String
`allocation_pool_tier_code`	String
`allocation_pool_tier_id`	String
`company_code`	String
`id`	String
`inactivation_date`	LocalDate
`include_allocation_pool_id_in_name`	Boolean
`primary_balancing_worktag_id`	String

receipt_adjustment_item_line_split

Column	Type	Keys
`index`	Int	PK
`receipt_adjustment_item_line_id`	String	PKFK
`extended_amount`	Double
`memo`	String
`quantity`	Double

sales_item_fair_value_price_list

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`price_list_name`	String
`sales_item_fair_value_price_list_code`	String

customer_activity

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`customer_id`	String	FK
`invoice_document_due_date`	LocalDate
`sequence_number`	String
`transaction_additions`	Double
`transaction_date`	LocalDate
`transaction_number`	String
`transaction_subtractions`	Double
`transaction_type`	String

billing_installment_milestone

Column	Type	Keys
`id`	String	PK
`billing_installment_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`milestone`	String

payment_group

Column	Type	Keys
`group_id`	String	PK
`payment_message_id`	String	PKFK
`currency_id`	String
`group_payment_count`	Double
`group_payment_sum`	Double
`group_rejected_payment_count`	Double
`group_reprocessed_payment_count`	Double
`payment_date`	LocalDate
`payment_type_id`	String

allocation_definition_basis_dimension_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`worktag_type_code`	String

requisition

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`deliver_to_location_id`	String	FK
`par_location_id`	String	FK
`requester_id`	String	FK
`requesting_inventory_site_id`	String	FK
`requisition_sourcing_buyer_id`	String	FK
`additional_procedure_details`	String
`comments`	String
`consolidate_requisition_on_po`	Boolean
`document_link`	String
`exclude_ship_to_address_when_consolidating_requisition_lines`	Boolean
`external_requisition_reference_id`	String
`external_system_id`	String
`freight_amount`	Double
`high_priority`	Boolean
`internal_memo`	String
`medical_record_number`	String
`memo_to_suppliers`	String
`origin`	String
`other_charges`	Double
`patient_id`	String
`physician_id`	String
`procedure`	String
`procedure_date`	LocalDate
`procedure_number`	String
`procurement_credit_card_id`	String
`reason_code`	String
`requesting_entity_code`	String
`requisition_date`	LocalDate
`requisition_document_status_code`	String
`requisition_number`	String
`requisition_type_code`	String
`ship_to_address_code`	String
`submit`	Boolean
`supplier_representative`	String
`supplier_sales_order_number`	String
`verified_by`	String

requisition_deliverables_line_close_status

Column	Type	Keys
`deliverables_line_index`	Long	PK
`index`	Long	PK
`requisition_id`	String	PKFK
`close_comments`	String
`close_date`	LocalDate
`close_reason_code`	String
`is_closed`	Boolean

allocation_pool_allocation_account

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`ledger_account_id`	String	FK
`ledger_account_code`	String
`source_for_allocation_pool_allocation_account`	Boolean

customer_payment_remittance

Column	Type	Keys
`index`	Int	PK
`customer_payment_id`	String	PKFK
`bill_to_customer_id`	String	FK
`amount_to_pay`	Double
`amount_to_pay_in_invoice_currency`	Double

custom_worktag

Column	Type	Keys
`configuration_code`	String	PK
`id`	String	PK
`worktag_code`	String	PK
`inactive`	Boolean
`value`	String

supplier_invoice_adjustment

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`original_invoice_id`	String	FK
`payment_term_id`	String	FK
`supplier_connection_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`accounting_date_override`	LocalDate
`additional_reference_number`	String
`adjustment_date`	LocalDate
`adjustment_reason`	String
`adjustment_received_date`	LocalDate
`budget_date`	LocalDate
`cancel_accounting_date`	LocalDate
`control_total_amount`	Double
`currency_rate_date_override`	LocalDate
`currency_rate_lookup_override`	Double
`currency_rate_manual_override`	Double
`default_currency_rate`	Double
`default_tax_option`	String
`document_currency_conversion_rate`	Double
`document_link`	String
`document_memo`	String
`due_date_override`	LocalDate
`external_po_number`	String
`freight_amount`	Double
`gapless_document_number`	String
`increase_liability`	Boolean
`invoice_accounting_date`	LocalDate
`locked_in_workday`	Boolean
`manual_override_percent`	Double
`on_hold`	Boolean
`original_invoice_supplier_reference_number`	String
`other_charges`	Double
`override_payment_type_code`	String
`payment_practices`	Boolean
`rate_basis_date`	LocalDate
`rate_override`	Boolean
`ship_to_address`	String
`submit`	Boolean
`supplier_document_received`	Boolean
`supplier_invoice_adjustment_code`	String
`supplier_invoice_number`	String
`tax_amount`	Double
`tax_code_reference`	String
`use_default_supplier_connection`	Boolean
`withholding_tax_amount`	Double

advanced_ship_notice_line_lot_information

Column	Type	Keys
`lot_identifier`	String	PK
`advanced_ship_notice_line_id`	String	PKFK
`expiration_date`	LocalDate
`manufacture_date`	LocalDate
`memo`	String
`quantity`	Double

customer_invoice_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`customer_invoice_id`	String	PKFK
`customer_invoice_line_id`	String	PKFK

supplier_classification

Column	Type	Keys
`id`	String	PK
`country_id`	String
`external_site`	Boolean
`inactive`	Boolean
`name`	String
`supplier_classification_code`	String

revenue_recognition_schedule_status

Column	Type	Keys
`id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`schedule_status_code`	String

billing_schedule_bill_to_contact

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`business_entity_contact`	String

project_task

Column	Type	Keys
`id`	String	PK
`task_name`	String	PK
`description`	String
`inactive`	Boolean
`project_task_name_code`	String
`task_code`	String

journal_source

Column	Type	Keys
`id`	String	PK
`enable_suspense_processing_for_web_service`	Boolean
`journal_source_id`	String
`journal_source_name`	String
`process_award_costs`	Boolean
`source_for_accounting_journal`	Boolean
`source_for_ad_hoc_bank_transaction`	Boolean
`source_for_workday_operational_journal`	Boolean
`suspense_threshold_percent`	Double

requisition_goods_line_split

Column	Type	Keys
`index`	Long	PK
`item_request_line_index`	Long	PKFK
`requisition_id`	String	PKFK
`budget_date`	LocalDate
`business_document_line_split_id`	String
`extended_amount`	Double
`line_split_allocation_id`	String
`memo`	String
`quantity`	Double

project_worker_rate

Column	Type	Keys
`currency_id`	String	PKFK
`project_standard_cost_rate_sheet_id`	String	PKFK
`project_standard_cost_rate_snapshot_id`	Long	PKFK
`worker_id`	String	PKFK
`delete`	Boolean
`hourly_rate`	Double
`project_worker_rate_standard_cost_rate_detail_id`	String
`worker_code`	String

resource_forecast_line_allocation

Column	Type	Keys
`index`	Long	PK
`resource_forecast_id`	String	PKFK
`resource_forecast_line_id`	String	PKFK
`forecasted_hours`	Double
`period_start_date`	LocalDate

customer_status

Column	Type	Keys
`customer_status_value_id`	String	PK
`customer_id`	String	PKFK
`business_entity_status_value`	String
`customer_status_change_reason_description`	String
`reason_for_customer_status_change`	String

billing_installment_line_tax_code

Column	Type	Keys
`id`	String	PK
`billing_installment_id`	Long	PKFK
`billing_installment_line_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`tax_code`	String

receipt_line_contingent_worker_hours

Column	Type	Keys
`index`	Int	PK
`receipt_id`	String	PKFK
`hours`	Double

request_for_quote_line_split

Column	Type	Keys
`id`	String	PK
`request_for_quote_line_id`	String	FK
`extended_amount`	Double
`memo`	String
`quantity`	Double
`request_for_quote_line_split_id`	String
`request_for_quote_line_split_reference`	Json

company_industry_code

Column	Type	Keys
`industry_code_id`	String	PK
`company_id`	String	PKFK
`industry_code_text`	String

requisition_item_request_line

Column	Type	Keys
`index`	Long	PK
`requisition_id`	String	PKFK
`commodity_code_id`	String	FK
`deliver_to_location_id`	String	FK
`inventory_site_location_id`	String	FK
`line_company_id`	String	FK
`ship_to_contact_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`budget_date`	LocalDate
`extended_amount`	Double
`fulfillment_source_code`	String
`goods_requisition_line_id`	String
`is_line_closed`	Boolean
`item_code`	String
`item_description`	String
`item_id`	String
`lot_number`	String
`lot_serial_information_code`	String
`mark_purchase_order_as_issued`	Boolean
`memo`	String
`no_charge`	Boolean
`order_from_connection_code`	String
`packaging_string`	String
`purchase_order_line_id`	String
`quantity`	Double
`requested_delivery_date`	LocalDate
`rfq_required`	Boolean
`serial_number`	String
`ship_to_address_code`	String
`source_this_line`	Boolean
`spend_category_id`	String
`supplier_item_identifier`	String
`tax_applicability_id`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure_code`	String

company_allow_accounting_in_arrears

Column	Type	Keys
`originating_transaction_code`	String	PK
`company_id`	String	PKFK

job_category

Column	Type	Keys
`id`	String	PK
`description`	String
`inactive`	Boolean
`name`	String

request_for_quote_award_line

Column	Type	Keys
`id`	String	PK
`request_for_quote_award_id`	String	FK
`request_for_quote_line_id`	String	FK
`request_for_quote_response_line_id`	String	FK
`amount_awarded`	Double
`award_amount`	Double
`award_quantity`	Double
`deliver_to_location`	String
`end_date`	LocalDate
`item_description`	String
`line_number`	Double
`line_type`	String
`memo`	String
`requested_delivery_date`	LocalDate
`response_price`	Double
`rfq_line_amount`	Double
`rfq_line_quantity`	Double
`rfq_line_quantity_awarded`	Double
`rfq_line_unit_cost`	Double
`ship_to_address`	String
`start_date`	LocalDate
`target_price`	Double
`unit_cost`	Double
`unit_of_measure_code`	String

billing_schedule_template_milestone

Column	Type	Keys
`id`	String	PK
`billing_schedule_template_id`	String	PKFK
`milestone`	String

receipt_adjustment_service_line

Column	Type	Keys
`id`	String	PK
`purchase_order_id`	String	FK
`receipt_adjustment_id`	String	FK
`actual_amount_received`	Double
`deliver_to_location`	String
`extended_amount`	Double
`item_description`	String
`memo`	String
`original_amount_received`	Double
`purchase_order_line_id`	String
`purchase_order_line_number`	String
`receipt_adjustment_reason`	String
`receipt_line_id`	String
`spend_category_code`	String
`supplier_contract_line_id`	String

project_task_resource

Column	Type	Keys
`project_task_resource_id`	String	PK
`project_id`	String	FK
`estimated_hours`	Double
`memo`	String
`percent_allocation`	Double
`project_code`	String
`project_plan_code`	String
`project_plan_task_id`	String
`project_resource_ids`	Json
`project_resource_plan_detail_code`	String
`project_resource_plan_detail_id`	String
`resource_end_date`	LocalDate
`resource_start_date`	LocalDate

cost_center_container_organization

Column	Type	Keys
`cost_center_id`	String	PKFK
`custom_organization_id`	String	PKFK

payment_term_rule

Column	Type	Keys
`payment_term_rule_id`	String	PK
`payment_term_id`	String	PKFK
`apply_cutoff_condition`	Boolean
`payment_rule_type_id`	String
`payment_term_rule_order`	String
`rule_modifier_value`	Double

resource_category_related_worktags

Column	Type	Keys
`worktag_type_id`	String	PK
`resource_category_id`	String	PKFK
`default_worktag_id`	String	FK
`replace_all_allowed_values`	Boolean
`required_on_transaction`	Boolean
`required_on_transaction_for_validation`	Boolean
`worktag_type_code`	String

supplier_classification_field_choice

Column	Type	Keys
`id`	String	PK
`supplier_classification_field_id`	String	PKFK
`field_choice_label`	String
`line_order`	String

supplier_invoice_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`supplier_invoice_id`	String	PKFK
`supplier_invoice_line_index`	Long	PKFK

line_override_default

Column	Type	Keys
`id`	String	PK
`override_revenue_allocation_configuration_line_id`	Long	PKFK
`revenue_allocation_configuration_id`	String	PKFK
`sales_item_group_id`	String	FK
`sales_item_id`	String	FK
`allocation_basis`	String
`lower_range_percentage`	String
`revenue_allocation_configuration_line_override_details_code`	String
`upper_range_percentage`	String

allocation_pool_restricted_source_company

Column	Type	Keys
`allocation_pool_name`	String	PKFK
`organization_id`	String	PKFK
`organization_code`	String

revenue_recognition_installment_line_worktag

Column	Type	Keys
`line_index`	Long	PKFK
`revenue_recognition_installment_id`	Long	PKFK
`revenue_recognition_schedule_id`	String	PKFK
`worktag_id`	String	PKFK

customer_group_mapping

Column	Type	Keys
`customer_group_id`	String	PKFK
`customer_id`	String	PKFK

business_entity_contact_type_tenanted

Column	Type	Keys
`fivetran_id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`business_entity_contact_type_tenanted_code`	String
`id`	String

customer

Column	Type	Keys
`id`	String	PK
`balance_default_currency_id`	String	FK
`credit_limit_currency_id`	String	FK
`currency_id`	String	FK
`customer_category_id`	String	FK
`default_payment_type_id`	String	FK
`direct_debit_payment_type_id`	String	FK
`payment_terms_id`	String	FK
`remit_from_customer_id`	String	FK
`always_separate_payments`	Boolean
`approval_status`	String
`business_entity_name`	String
`business_entity_phonetic_name`	String
`commercial_credit_score`	Double
`commercial_credit_score_date`	LocalDate
`commercial_credit_score_note`	String
`composite_risk_date`	LocalDate
`composite_risk_note`	String
`composite_risk_score`	Double
`credit_limit`	Double
`credit_verification_date`	LocalDate
`customer_code`	String
`customer_preferred_language`	String
`customer_preferred_locale`	String
`customer_reference`	String
`customer_satisfaction_date`	LocalDate
`customer_satisfaction_note`	String
`customer_satisfaction_score`	Double
`duns_number`	String
`electronic_invoicing_government_issued_customer_id`	String
`electronic_invoicing_intermediary_vendor_id`	String
`electronic_invoicing_start_date`	LocalDate
`electronic_invoicing_vendor_issued_customer_id`	String
`exempt`	Boolean
`exempt_from_dunning`	Boolean
`external_entity_code`	String
`followup_date`	LocalDate
`hierarchy_credit_limit`	Double
`last_12_months_sales_amount`	Double
`mandate_required`	Boolean
`name`	String
`overdue_balance`	Double
`submit`	Boolean
`tax_code`	String
`total_balance`	Double
`worktag_only`	Boolean
`ytd_sales_amount`	Double

business_entity_email_address

Column	Type	Keys
`id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`email_address`	String
`email_code`	String
`email_comment`	String

all_included_ledger_account

Column	Type	Keys
`included_ledger_account_id`	String	PKFK
`ledger_account_summary_id`	String	PKFK
`included_ledger_account_code`	String

billing_schedule_invoice_delivery_type_default

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`default_invoice_delivery_type`	String

inventory_stock_request_line

Column	Type	Keys
`id`	String	PK
`inventory_stock_request_id`	String	PKFK
`backorder_quantity`	Double
`extended_amount`	Double
`fulfillment_date`	LocalDate
`hold_from_fulfillment`	Boolean
`is_a_backorder`	Boolean
`is_in_transit`	Boolean
`item_description`	String
`line_memo`	String
`original_requested_quantity`	Double
`picked_quantity`	Double
`quantity_shipped`	Double
`requested_delivery_date`	LocalDate
`requested_quantity`	Double
`stock_request_line_number`	Double
`unit_cost`	Double

business_entity_address_subregion

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`subregion_data`	String
`type`	String

supplier_contract_goods_line

Column	Type	Keys
`line_number`	String	PK
`supplier_contract_id`	String	PKFK
`company_for_invoices_id`	String	FK
`consigned_quantity`	Double
`conversion_factor`	Double
`description`	String
`do_not_auto_renew`	Boolean
`end_date`	LocalDate
`extended_amount`	Double
`in_service_date_option`	String
`interest_line`	Boolean
`line_on_hold`	Boolean
`location`	String
`maximum_charge_control_amount`	Double
`memo`	String
`minimum_charge_control_amount`	Double
`packaging_string`	String
`percentage`	Double
`quantity`	Double
`renewal_amount`	Double
`renewal_quantity`	Double
`renewed_by_line_number`	String
`renews_line_number`	String
`retention`	Boolean
`ship_to_address`	String
`specified_in_service_date`	String
`spend_category`	String
`start_date`	LocalDate
`tax_applicability`	String
`tax_code`	String
`tax_point_date_type`	String
`unit_cost`	Double
`unit_of_measure`	String
`unit_residual_value`	Double

alternate_purchase_item

Column	Type	Keys
`index`	Long	PK
`purchase_item_id`	String	PKFK
`manufacturer_id`	String	FK
`alternate_item_identifier_value`	String
`item_identifier_type_code`	String
`unit_of_measure_code`	String

billing_schedule_template_attachment_on_invoice

Column	Type	Keys
`id`	String	PK
`billing_schedule_template_id`	String	PKFK
`attachments_on_invoice`	String

supplier_refund

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`payment_type_id`	String	FK
`supplier_id`	String	FK
`accounting_date`	LocalDate
`application_date`	LocalDate
`cancel_accounting_date`	LocalDate
`deposit_reference`	String
`memo`	String
`refund_amount`	Double
`refund_application_status`	String
`refund_number`	String
`refund_reference`	String
`refund_status`	String
`submit`	Boolean
`supplier_refund_id`	String

advanced_ship_notice_line_alternate_item

Column	Type	Keys
`alternate_identifier_value`	String	PK
`advanced_ship_notice_line_id`	String	PKFK
`manufacturer_id`	String	FK
`external_name`	String

company_account_translation_currency

Column	Type	Keys
`company_id`	String	PKFK
`currency_id`	String	PKFK

billing_schedule_milestone

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`milestone`	String

included_spend_categories

Column	Type	Keys
`included_spend_category_id`	String	PK
`spend_category_hierarchy_id`	String	PKFK
`included_spend_category_code`	String

rfq_award_contract_default

Column	Type	Keys
`index`	Int	PK
`request_for_quote_award_id`	String	PKFK
`payment_term_id`	String	FK
`bill_to_contact`	String
`contract_end_date`	LocalDate
`contract_name`	String
`contract_start_date`	LocalDate
`payment_terms_reference`	Json
`ship_to_contact`	String

purchase_supplier_item

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	PKFK
`catalog_item_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`supplier_item_id`	String	FK
`calculate_price_based_on_conversion_factor`	Boolean
`inactive`	Boolean
`item_description`	String
`item_url`	String
`lead_time`	Double
`packaging_string`	String
`pricing_effective_date`	LocalDate
`sourcing_priority`	Double
`supplier_item_identifier`	String

billing_schedule_invoice_delivery_type_override

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`override_invoice_delivery_type`	String

commodity_code_type_level

Column	Type	Keys
`order`	String	PK
`commodity_code_type_id`	String	PKFK
`length`	Double
`name`	String

supplier_item_unit_of_measure

Column	Type	Keys
`unit_of_measure_code`	String	PK
`supplier_item_id`	String	PKFK
`conversion_factor`	Double
`default`	Boolean
`effective_date`	Instant
`inactive`	Boolean
`just_in_time`	Boolean
`lead_time`	Double
`minimum_order_quantity`	Double
`unit_price`	Double

excluded_journal_source

Column	Type	Keys
`excluded_journal_source_id`	String	PK
`allocation_plan_id`	String	PKFK
`excluded_journal_source_code`	String

supplier_invoice_installment_status

Column	Type	Keys
`status`	String	PK
`supplier_invoice_installment_id`	String	PKFK

journal_entry_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`journal_entry_id`	String	PKFK
`journal_entry_line_index`	Long	PKFK

business_entity_contact_type

Column	Type	Keys
`fivetran_id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`business_entity_contact_type_code`	String
`id`	String

revenue_recognition_schedule_type

Column	Type	Keys
`id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`schedule_type`	String

supplier_contract_amendment

Column	Type	Keys
`id`	String	PK
`buyer_id`	String	FK
`company_hierarchy_id`	String	FK
`company_id`	String	FK
`companyfor_purchase_order_id`	String	FK
`companyfor_supplier_invoice_id`	String	FK
`contract_specialist_id`	String	FK
`currency_id`	String	FK
`purchase_order_payment_terms_id`	String	FK
`scheduled_invoice_override_payment_type_id`	String	FK
`supplier_contract_to_amend_id`	String	FK
`supplier_id`	String	FK
`supplier_invoice_payment_terms_id`	String	FK
`supplierfor_supplier_invoice_id`	String	FK
`amendment_date`	LocalDate
`amendment_description`	String
`amendment_number`	String
`amendment_signed_date`	LocalDate
`amendment_status`	String
`amendment_status_reference`	Json
`automatically_renew`	Boolean
`bill_to_address`	String
`bill_to_contact_detail`	String
`catalog_discount_percent`	Double
`contract_document_link`	String
`contract_end_date`	LocalDate
`contract_name`	String
`contract_overview`	String
`contract_reference`	String
`contract_signed_date`	LocalDate
`contract_start_date`	LocalDate
`contract_type`	String
`contract_version`	Double
`credit_card`	String
`default_tax_code`	String
`document_status`	String
`estimated_retention_release_date`	LocalDate
`gpo_contract_reference`	String
`notice_period`	Double
`on_hold`	Boolean
`order_from_connection`	String
`original_contract_amount`	Double
`override_payment_type`	String
`percent_to_retain`	Double
`purchase_order_issue_option`	String
`renewal_term`	Double
`retention_memo`	String
`send_expiration_notification`	Boolean
`ship_to_address`	String
`ship_to_contact_detail`	String
`supplier_connectionfor_supplier_invoice`	String
`supplier_contract_amendment_reference_id`	String
`supplier_contract_amendment_type`	String
`supplier_contract_lease_amendment_type`	String
`supplier_invoice_reference_number`	String
`system_generated`	Boolean
`third_party_retention`	Boolean
`total_contract_amount`	Double
`use_default_supplier_connection`	Boolean

sales_item_price_list

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`price_list_name`	String
`sales_item_price_list_code`	String

sales_item_related_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`sales_item_id`	String	PKFK
`default_worktag_id`	String	FK
`replace_all_allowed_values`	Boolean
`required_on_transaction`	Boolean
`required_on_transaction_for_validation`	Boolean
`worktag_type_code`	String

restricted_to_pool_company

Column	Type	Keys
`restricted_to_pool_company_id`	String	PK
`allocation_plan_id`	String	PKFK
`restricted_to_pool_company_code`	String

sales_item_price_list_rule_line_worktag

Column	Type	Keys
`sales_item_price_list_id`	String	PKFK
`sales_item_price_list_rule_line_id`	Long	PKFK
`worktag_id`	String	PKFK

worktag

Column	Type	Keys
`attribute`	String	PK
`id`	String	PK
`descriptor`	String
`value`	String

customer_contract_discounts_and_premiums_applied

Column	Type	Keys
`contract_discount_and_premium_id`	String	PKFK
`customer_contract_id`	String	PKFK

inventory_transaction

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`supplier_id`	String	FK
`accounting_date_for_inventory_transaction`	LocalDate
`average_cost_in_base_currency`	Double
`base_unit_cost`	Double
`consigned`	Boolean
`cost_markup`	Double
`external_id`	String
`prior_average_cost`	Double
`third_party_warehouse_receipt`	Boolean
`total_base_quantity_on_hand`	Double
`transaction_base_currency_conversion_rate`	Double
`transaction_date_time`	Instant
`transaction_stocking_quantity`	Double
`transaction_unit_cost`	Double

customer_contract_amendment_data

Column	Type	Keys
`customer_contract_amendment_id`	String	PKFK
`alternate_customer_contract_id`	String	FK
`bill_to_customer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`customer_contract_type_id`	String	FK
`master_customer_contract_id`	String	FK
`original_customer_contract_id`	String	FK
`payment_terms_id`	String	FK
`payment_type_id`	String	FK
`related_customer_contract_id`	String	FK
`salesperson_id`	String	FK
`ship_to_customer_id`	String	FK
`sold_to_customer_id`	String	FK
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`contract_description`	String
`contract_name`	String
`contract_signed_date`	LocalDate
`current_contract_amount`	Double
`customer_contract_effective_date`	LocalDate
`customer_contract_number`	String
`default_tax_code`	String
`installment_billing_schedule_template_code`	String
`locked_in_workday`	Boolean
`lower_range_percentage`	Double
`multiple_element_revenue_allocation`	Boolean
`no_allocation_threshold`	Boolean
`on_hold`	Boolean
`po_number`	String
`revenue_allocated`	Boolean
`ship_to_address`	String
`submit`	Boolean
`transaction_billing_schedule_template_code`	String
`upper_range_percentage`	Double
`version`	Double

allocation_group_line

Column	Type	Keys
`allocation_definition_id`	String	PK
`display_order`	String	PK
`allocation_group_name`	String	PKFK
`allocation_group_set_name`	String	PKFK
`allocation_time_frame_id`	String	PKFK
`group_order`	String	PKFK
`allocation_definition_code`	String
`allocation_group_line_id`	String
`budget_structure_code`	String
`budget_structure_id`	String

job_profile

Column	Type	Keys
`id`	String	PK
`compensation_grade_id`	String	FK
`job_category_id`	String	FK
`additional_job_description`	String
`critical_job`	Boolean
`description`	String
`difficulty_to_fill`	String
`effective_date`	LocalDate
`inactive`	Boolean
`include_job_code_in_name`	Boolean
`job_profile_code`	String
`level`	String
`management_level`	String
`private_title`	String
`public_job`	Boolean
`referral_payment_plan`	String
`summary`	String
`title`	String
`union_code`	String
`union_membership_requirement`	String
`work_shift_required`	Boolean
`work_study_award_source_code`	String
`work_study_requirement_option_code`	String

compensation_grade

Column	Type	Keys
`id`	String	PK
`compensation_plan_id`	String	FK
`compensation_grade_code`	String
`currency_code`	String
`description`	String
`effective_date`	LocalDate
`frequency_code`	String
`inactive`	Boolean
`is_first_step_during_compensation_proposal_assigned`	Boolean
`is_override_allowed`	Boolean
`maximum`	Double
`midpoint`	Double
`minimum`	Double
`name`	String
`number_of_segments`	Double
`pay_level`	String
`segment_1_top`	Double
`segment_2_top`	Double
`segment_3_top`	Double
`segment_4_top`	Double
`segment_5_top`	Double
`spread`	Double

purchase_order_deliverables_line

Column	Type	Keys
`index`	Int	PK
`purchase_order_id`	String	PKFK
`supplier_contract_id`	String	FK
`budget_date`	LocalDate
`close_status`	String
`deliverables_order_line_code`	String
`extended_amount`	Double
`line_number`	Double
`memo`	String
`prepaid`	Boolean
`retention`	Boolean
`supplier_contract_line_id`	String

purchase_order_goods_line

Column	Type	Keys
`index`	Int	PK
`purchase_order_id`	String	PKFK
`commodity_code_id`	String	FK
`company_id`	String	FK
`ship_to_contract_id`	String	FK
`supplier_contract_id`	String	FK
`budget_date`	LocalDate
`deliver_to_location_gln`	String
`deliver_to_location_id`	String
`deliver_to_location_location_identifier`	String
`due_date`	LocalDate
`extended_amount`	Double
`goods_purchase_order_line_id`	String
`invoice_status`	String
`item_description`	String
`item_id`	String
`line_number`	Double
`lot_number`	String
`memo`	String
`packaging_string`	String
`payment_status`	String
`prepaid`	Boolean
`quantity`	Double
`receiving_status`	String
`requested_as_no_charge`	Boolean
`requested_delivery_date`	LocalDate
`resource_category`	String
`retention`	Boolean
`serial_number`	String
`ship_to_address_id`	String
`ship_to_global_location_number`	String
`ship_to_location_identifier`	String
`shipping_status`	String
`storage_location_id`	String
`supplier_contract_line_id`	String
`supplier_item_identifier`	String
`supplier_part_auxiliary_id`	String
`supplier_part_id`	String
`tracking_status`	String
`unit_cost`	Double
`unit_of_measure_code`	String
`unspsc_code`	String

revenue_category

Column	Type	Keys
`id`	String	PK
`code`	String
`maps_to_spend_category`	String
`revenue_category_inactive`	String
`revenue_category_name`	String
`tax_applicability`	String

account_posting_rule_set

Column	Type	Keys
`id`	String	PK
`account_posting_rule_set_code`	String
`account_posting_rule_set_name`	String
`account_set_id`	String

consolidated_invoice_payment_type

Column	Type	Keys
`id`	String	PK
`consolidated_invoice_id`	String	PKFK
`payment_type`	String

supplier_invoice_schedule

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`statutory_invoice_type_id`	String	FK
`supplier_connection_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`auto_submit_for_approval`	Boolean
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedules`	Boolean
`date_option`	String
`day_of_month`	Double
`distribute_by_quantity`	Boolean
`distribution_method`	String
`frequency`	String
`from_date`	LocalDate
`number_of_installments`	Double
`schedule_description`	String
`schedule_on_hold`	Boolean
`submit`	Boolean
`supplier_contract_line_id`	String
`supplier_invoice_reference_number`	String
`supplier_invoice_schedule_code`	String
`system_generated`	Boolean
`tax_code`	String
`to_date`	LocalDate
`use_default_supplier_connection`	Boolean

sales_item_price_list_rule_line

Column	Type	Keys
`index`	Long	PK
`sales_item_price_list_id`	String	PKFK
`sales_item_group_id`	String	FK
`sales_item_id`	String	FK
`effective_date`	LocalDate
`unit_of_measure`	String
`unit_price`	Double

company

Column	Type	Keys
`id`	String	PK
`account_posting_rule_set_id`	String	FK
`account_set_id`	String	FK
`alternate_account_set_id`	String	FK
`currency_id`	String	FK
`default_account_set_id`	String	FK
`organization_code`	String	FK
`account_control_rule_set_id`	String
`account_translation_rule_set_code`	String
`accounting_date_required`	Boolean
`allow_invoice_accounting_in_arrears`	Boolean
`availability_date`	LocalDate
`average_daily_balance_rule_code`	String
`average_daily_balance_start_date`	LocalDate
`award_cost_processing_rule_code`	String
`award_cost_processing_rule_id`	String
`begin_effective_date_to_generate_award_costs`	LocalDate
`currency_rate_type_code`	String
`default_reporting_book_code`	String
`disallow_change_to_operations_transactions_in_closed_periods`	Boolean
`do_not_apply_payment_to_invoices_on_hold`	Boolean
`electronic_invoicing_agreement_date`	LocalDate
`enable_automatic_journal_line_numbering`	Boolean
`fiscal_schedule_code`	String
`generate_award_costs_at_business_process_completion`	Boolean
`ignore_award_line_dates_for_award_costs`	Boolean
`include_organization_code_in_name`	Boolean
`include_organization_id_in_name`	Boolean
`is_advanced_customer_payment_auto_application`	Boolean
`keep_debit_credit_and_reverse_sign`	Boolean
`organization_active`	Boolean
`organization_name`	String
`organization_phonetic_name`	String
`prevent_changes_to_invoice_after_final_print_run`	Boolean
`procurement_options_data_allow_change_of_uom_and_unit_cost_of_non_stockable_purchase_item_on_non_replenishment_requisition`	Boolean
`procurement_options_data_allow_change_of_uom_and_unit_cost_of_purchase_item_on_bill_only_requisition`	Boolean
`procurement_options_data_allow_change_of_uom_and_unit_cost_of_stockable_purchase_item_on_replenishment_requisition`	Boolean
`procurement_options_data_allow_change_of_uom_of_stockable_purchase_item_on_non_replenishment_requisition`	Boolean
`procurement_options_data_automatically_close_purchase_orders`	Boolean
`procurement_options_data_consolidate_requisitions_on_purchase_orders`	Boolean
`procurement_options_data_disable_default_delivery_type_for_stock_items`	Boolean
`procurement_options_data_disable_lot_and_serials_capture_on_receipt`	Boolean
`procurement_options_data_disable_project_based_service_lines_on_requisitions`	Boolean
`procurement_options_data_disable_service_lines_on_requisitions`	Boolean
`procurement_options_data_enable_freight_and_other_charges_on_requisition`	Boolean
`procurement_options_data_enable_requisition_line_attributes_to_default_from_linked_purchase_item`	Boolean
`procurement_options_data_enable_requisition_line_defaults`	Boolean
`procurement_options_data_enable_transaction_tax_on_requisition`	Boolean
`procurement_options_data_enable_unit_of_measure_change_for_catalog_items_on_requisitions`	Boolean
`procurement_options_data_exclude_catalog_and_supplier_items_from_secondary_suppliers_in_catalog_search`	Boolean
`procurement_options_data_exclude_header_worktags_from_business_process`	Boolean
`procurement_options_data_exclude_purchase_items_having_catalog_or_supplier_item_entries`	Boolean
`procurement_options_data_exclude_received_quantities_from_draft_and_in_progress_receipts`	Boolean
`procurement_options_data_generate_pdfs_for_all_purchase_orders`	Boolean
`procurement_options_data_lot_capture_mandatory_on_receipt`	Boolean
`procurement_options_data_serials_capture_mandatory_on_receipt`	Boolean
`procurement_options_data_show_purchase_items_when_there_is_no_priority_supplier`	Boolean
`procurement_tax_option_code`	String
`reverse_debit_credit`	Boolean
`tax_recovery_pro_rate_factor_percentage`	Double
`tax_service_name`	String
`use_third_party_tax_service`	Boolean
`vat_on_payment`	Boolean

requesting_entity

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`purchase_item_list_id`	String	FK
`inactive`	Boolean
`name`	String
`requesting_entity_id`	String

requisition_service_request_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`requisition_id`	String	PKFK
`service_request_line_index`	Long	PKFK

company_supplier_invoice_attribute

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`display_on_supplier_invoice`	Boolean
`display_on_supplier_invoice_adjustment`	Boolean
`display_on_supplier_invoice_request`	Boolean
`supplier_invoice_attribute_template_id`	String

revenue_recognition_installment_line

Column	Type	Keys
`index`	Long	PK
`revenue_recognition_installment_id`	Long	PKFK
`revenue_recognition_schedule_id`	String	PKFK
`sales_item_id`	String	FK
`amount`	Double
`from_date`	LocalDate
`line_code`	String
`line_id`	String
`line_item_description`	String
`override_amount`	Double
`override_rate`	Double
`revenue_category`	String
`to_date`	LocalDate

customer_contract_template

Column	Type	Keys
`id`	String	PK
`contract_type_id`	String	FK
`customer_contract_template_code`	String
`description`	String
`multiple_element_revenue_allocation`	Boolean
`name`	String

purchase_order_contingent_worker_line_time_code

Column	Type	Keys
`index`	Int	PK
`time_code`	String	PK
`purchase_order_id`	String	PKFK

trip_leg_detail_name_match

Column	Type	Keys
`index`	Long	PK
`trip_leg_detail_id`	String	PKFK
`expense_credit_card_transaction_id`	String	FK
`ticket_detail_id`	String	FK
`carrier_code_id`	String
`carrier_code_ref_code`	String
`confidence_percentage`	Double

request_for_quote_response

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`request_for_quote_id`	String	FK
`sourcing_buyer_id`	String	FK
`supplier_id`	String	FK
`end_date`	Instant
`recorded_by`	String
`request_for_quote_response_code`	String
`request_for_quote_terms_and_conditions`	String
`response_date`	Instant
`response_memo`	String
`rfq_document_date`	LocalDate
`rfq_document_memo`	String
`rfq_response_status`	String
`shipping_instruction`	String
`shipping_method`	String
`shipping_terms_code`	String
`start_date`	Instant

trip_leg_detail

Column	Type	Keys
`id`	String	PK
`expense_credit_card_transaction_id`	String	FK
`ticket_detail_id`	String	FK
`arrival_date`	LocalDate
`arrival_time`	String
`carrier_code`	String
`carrier_number`	String
`class_of_service`	String
`class_of_service_code`	String
`class_of_service_id`	String
`conjunction_ticket`	String
`coupon_number`	String
`departure_tax_amount`	Double
`departure_time`	String
`destination`	String
`destination_code`	String
`destination_id`	String
`endorsements`	String
`exchange_ticket_number`	String
`fare_base`	String
`leg_number`	Double
`origin`	String
`origin_code`	String
`origin_id`	String
`refund_indicator`	Boolean
`stopover_indicator`	String
`travel_date`	LocalDate
`trip_leg_fare_amount`	Double
`trip_leg_fee_amount`	Double
`trip_leg_tax_amount`	Double

currency

Column	Type	Keys
`id`	String	PK
`currency_code`	String
`delivered_currency_precision`	Double
`description`	String
`is_precision_overridden`	Boolean
`numeric_code`	String
`override_currency_precision`	Double
`precision`	Double
`retired`	Boolean
`symbol`	String

customer_address_level_tax_details

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`address_code`	String
`inactive`	Boolean
`reference_code`	String
`tax_id_identification`	String
`tax_id_type_code`	String
`transaction_tax_id`	Boolean
`transaction_tax_status_code`	String

requisition_item_request_line_close_status

Column	Type	Keys
`index`	Long	PK
`item_request_line_index`	Long	PK
`requisition_id`	String	PKFK
`close_comments`	String
`close_date`	LocalDate
`close_reason_code`	String
`is_closed`	Boolean

item_lot

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`expiration_date`	LocalDate
`lot_identifier`	String
`manufacture_date`	LocalDate
`memo`	String

goods_delivery_ticket

Column	Type	Keys
`id`	String	PK

requisition_deliverables_line_project_phase

Column	Type	Keys
`deliverables_line_index`	Long	PK
`index`	Long	PK
`requisition_id`	String	PKFK
`end_date`	LocalDate
`extended_amount`	Double
`memo`	String
`phase_name`	String
`phase_status`	String
`project_plan_phase_id`	String
`start_date`	LocalDate

inventory_shipment

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`inventory_picking_list_id`	String	FK
`inventory_stock_request_id`	String	FK
`document_date`	LocalDate
`fulfillment_date`	LocalDate
`has_priority`	Boolean
`memo`	String

supplier_contact_address

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`address_code`	String
`country_city_code`	String
`country_region_code`	String
`country_region_descriptor`	String
`last_modified`	Instant
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String

payment

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`payment_group_id`	String	FK
`amount_as_text`	String
`cancel_accounting_date`	LocalDate
`check_number`	String
`check_or_advice_number`	Double
`currency_description`	String
`currency_symbol`	String
`discount_taken`	Double
`payment_accounting_date`	LocalDate
`payment_amount`	Double
`payment_memo`	String
`payment_reference_number`	String
`payment_status`	String
`payroll_payment_display_order`	Double
`prenote_flag`	Boolean
`settlement_run_number`	String

supplier_classification_field

Column	Type	Keys
`id`	String	PK
`supplier_classification_id`	String	PKFK
`field_external_site`	Boolean
`field_required`	Boolean
`field_title`	String

request_for_quote

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`document_date`	LocalDate
`exclude_target_price`	Boolean
`memo`	String
`request_for_quote_code`	String
`rfq_end_date`	Instant
`rfq_number`	String
`rfq_start_date`	Instant
`status`	String
`submit`	Boolean
`time_zone`	String
`title`	String
`type`	String

included_ledger_account_range

Column	Type	Keys
`index`	Long	PK
`ledger_account_summary_id`	String	PKFK
`from_value`	String
`to_value`	String

allocation_plan_book_codes_mapping

Column	Type	Keys
`allocation_journal_book_code_id`	String	PK
`source_journal_book_code_id`	String	PK
`allocation_plan_id`	String	PKFK
`allocation_journal_blank_book_code`	String
`allocation_journal_book_code`	String
`source_journal_blank_book_code`	String
`source_journal_book_code`	String

cost_center_related_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`cost_center_id`	String	PKFK
`default_worktag`	String
`replace_all_allowed_values`	Boolean
`required_on_transaction`	Boolean
`required_on_transaction_for_validation`	Boolean
`worktag_type_code`	String

sales_item_fair_value_price_list_rule_line_worktag

Column	Type	Keys
`sales_item_fair_value_price_list_id`	String	PKFK
`sales_item_fair_value_price_list_rule_line_id`	Long	PKFK
`worktag_id`	String	PKFK

consolidated_invoice

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`payment_term_id`	String	FK
`amount_due`	Double
`bill_to_address`	String
`code`	String
`document_payment_status`	String
`document_status`	String
`due_date`	LocalDate
`include_child_customers`	Boolean
`invoice_date`	LocalDate
`invoice_number`	String
`memo`	String
`net_invoice_amount`	Double
`tax_amount`	Double
`total_invoice_amount`	Double
`withholding_tax_amount`	Double

fund_hierarchy_funds_reference

Column	Type	Keys
`fund_hierarchy_id`	String	PKFK
`fund_id`	String	PKFK

supplier_category

Column	Type	Keys
`id`	String	PK
`supplier_category_id`	String
`supplier_category_name`	String

billing_schedule

Column	Type	Keys
`id`	String	PK
`bill_to_customer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`invoice_type_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`auto_submit_invoices_for_approval`	Boolean
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedule_via_contract_amendment`	Boolean
`bill_to_address`	String
`billed_in_arrears`	Boolean
`billing_cycle`	String
`billing_limit`	Double
`billing_method`	String
`billing_period`	String
`billing_schedule_code`	String
`day_of_month`	Double
`day_of_week`	String
`do_not_bill_over_installment_total`	Boolean
`enable_consumption_of_prepaid_balance`	Boolean
`estimated_retention_release_date`	LocalDate
`frequency`	String
`from_date`	LocalDate
`generate_installments`	Boolean
`include_tax_on_prepaid`	Boolean
`installment_recurrence`	Double
`invoice_memo`	String
`invoice_prepaid_installments_with_other_transaction_types`	Boolean
`number_of_installments`	Double
`percent_to_retain`	Double
`po_number`	String
`populate_with_default_bill_to_contacts`	Boolean
`project_invoice_summary_definition`	String
`prorate_first_and_last_installment`	Boolean
`recurring_invoice_day`	Double
`retention_memo`	String
`review_not_required_to_bill`	Boolean
`schedule_description`	String
`schedule_on_hold`	Boolean
`schedule_type`	String
`submit`	Boolean
`third_party_retention`	Boolean
`to_date`	LocalDate
`use_from_date`	Boolean
`use_to_date`	Boolean

restricted_to_ledger_type

Column	Type	Keys
`restricted_to_ledger_type_id`	String	PK
`allocation_plan_id`	String	PKFK
`restricted_to_ledger_type_code`	String

supplier_invoice_installment

Column	Type	Keys
`id`	String	PK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`supplier_invoice_id`	String	FK
`supplier_invoice_schedule_id`	String	FK
`from_date`	LocalDate
`installment_number`	Double
`invoice_date`	LocalDate
`memo`	String
`on_hold`	Boolean
`supplier_invoice_installment_code`	String
`tax_code`	String
`to_date`	LocalDate
`use_installment_overrides`	Boolean

purchase_order_change_order

Column	Type	Keys
`id`	String	PK
`bill_to_contact_id`	String	FK
`buyer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`purchase_order_id`	String	FK
`ship_to_contact_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`acknowledgement_expected`	Boolean
`bill_to_contact_detail`	String
`change_order_reason`	String
`change_order_reason_comments`	String
`change_order_reference_id`	String
`change_order_status`	String
`default_tax_code`	String
`default_tax_option_code`	String
`document_date`	LocalDate
`document_link`	String
`document_number`	String
`due_date`	LocalDate
`estimated_retention_release_date`	LocalDate
`expected_release_date`	LocalDate
`external_po_number`	String
`freight_amount`	Double
`internal_memo`	String
`issue_option_code`	String
`memo`	String
`order_version`	Double
`other_charges`	Double
`percent_to_retain`	Double
`retention_memo`	String
`ship_to_contact_detail`	String
`shipping_instruction`	String
`shipping_method`	String
`shipping_terms_code`	String
`tax_amount`	Double
`third_party_retention`	Boolean
`use_prepaid_posting_rules_for_receipt_accruals`	Boolean

sales_item

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`purchase_item_id`	String	FK
`revenue_recognition_schedule_template_id`	String	FK
`alternate_name`	String
`enable_bulk_quantity_pricing`	Boolean
`estimated_selling_price`	Double
`fulfillment_required`	Boolean
`inactive`	Boolean
`is_a_bundle`	Boolean
`item_description`	String
`item_identifier`	String
`item_name`	String
`item_unit_price`	Double
`price_type`	String
`project_template`	String
`renewable`	Boolean
`revenue_category`	String
`revenue_recognition_method`	String
`revenue_treatment`	String
`sales_item_code`	String
`tax_applicability`	String
`third_party_evidence`	Double
`unit_of_measure`	String
`unit_of_measure_2`	String
`uom_priced_at_quantities_of`	Double
`vsoe_price`	Double
`worktag_only`	Boolean

sales_item_group

Column	Type	Keys
`id`	String	PK
`sales_item_group_code`	String
`sales_item_group_name`	String
`sales_item_group_type`	String

requisition_deliverables_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`deliverables_line_index`	Long	PKFK
`requisition_id`	String	PKFK

allocation_pool_optional_balancing_worktag

Column	Type	Keys
`accounting_worktag_id`	String	PK
`allocation_pool_name`	String	PKFK
`accounting_worktag_code`	String

customer_group

Column	Type	Keys
`id`	String	PK
`customer_group_code`	String
`name`	String

organization_assignment

Column	Type	Keys
`organization_id`	String	PKFK
`reference_organization_id`	String	PKFK
`reference_organization_type`	String

project_timesheet_line

Column	Type	Keys
`index`	Long	PK
`project_timesheet_fivetran_id`	String	PKFK
`activity_id`	String
`memo`	String
`percent_complete`	Double
`project_code`	String
`project_plan_code`	String
`time_code_id`	String
`time_code_ref_code`	String
`work_assignment_code`	String
`work_assignment_version_code`	String
`work_function_code`	String
`worksheet_allocation_percent`	Double
`worktag_ids`	Json

business_entity_web_address

Column	Type	Keys
`id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`web_address`	String
`web_address_code`	String
`web_address_comment`	String

business_entity_address_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`submunicipality_data`	String
`type`	String

requisition_goods_line_split_worktag

Column	Type	Keys
`worktag_id`	String	PK
`goods_line_split_index`	Long	PKFK
`item_request_line_index`	Long	PKFK
`requisition_id`	String	PKFK

payment_type

Column	Type	Keys
`id`	String	PK
`payment_method_id`	String
`payment_type_id`	String
`payment_type_name`	String

company_supplier_account_option

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`allow_different_invoicing_and_purchasing_supplier`	Boolean
`enable_payment_practices_reporting`	Boolean

catalog_item_tag

Column	Type	Keys
`item_tag_id`	String	PK
`catalog_item_id`	String	PKFK

request_for_quote_response_bid_response

Column	Type	Keys
`id`	String	PK
`request_for_quote_response_id`	String	FK
`memo`	String
`name`	String
`request_for_quote_bid_response_memo`	String
`response_required`	Boolean
`response_value`	String
`type`	String

sales_item_fair_value_price_list_rule_line

Column	Type	Keys
`index`	Long	PK
`sales_item_fair_value_price_list_id`	String	PKFK
`related_sales_item_id`	String	FK
`sales_item_group_id`	String	FK
`sales_item_id`	String	FK
`amount`	Double
`effective_date`	LocalDate
`percent`	Double
`price_type`	String

return_line_split

Column	Type	Keys
`id`	String	PK
`return_id`	String	FK
`budget_date`	LocalDate
`business_document_line_split_id`	String
`extended_amount`	Double
`memo`	String
`quantity`	Double

purchase_item

Column	Type	Keys
`id`	String	PK
`commodity_code_id`	String	FK
`currency_id`	String	FK
`purchase_item_group_id`	String	FK
`purchase_item_list_id`	String	FK
`accounting_treatment_code`	String
`default_as_service_request`	Boolean
`inbound_alert_period_in_days`	Double
`is_expiration_date_required`	Boolean
`is_manufacturer_required`	Boolean
`item_description`	String
`item_identifier`	String
`item_name`	String
`item_unit_price`	Double
`item_url`	String
`last_updated`	Instant
`lot_control`	Boolean
`outbound_alert_period_in_days`	Double
`packaging_string`	String
`preferred_item`	Boolean
`purchase_item_code`	String
`requisition_fulfillment_source_code`	String
`resource_category`	String
`serial_control_method_code`	String
`tax_applicability_code`	String
`use_item_manufacturers_only`	Boolean

allocation_pool_worktag_override_rule_condition

Column	Type	Keys
`condition_id`	String	PK
`rule_item_index`	Long	PK
`worktag_override_rule_id`	String	PKFK
`condition_code`	String
`worktag_override_rule_name`	String

allocation_plan

Column	Type	Keys
`id`	String	PK
`account_set_id`	String	FK
`currency_id`	String	FK
`account_set_code`	String
`allocation_plan_reference_id`	String
`currency_code`	String
`default_balancing_worktag_id`	String
`description`	String
`fiscal_schedule_code`	String
`fiscal_schedule_id`	String
`group_by_date_code`	String
`group_by_date_id`	String
`inactive`	Boolean
`include_new_pools_in_hierarchy_code`	String
`include_new_pools_in_hierarchy_id`	String
`name`	String
`restricted_to_book_code`	String
`restricted_to_book_id`	String

requisition_deliverables_line

Column	Type	Keys
`index`	Long	PK
`requisition_id`	String	PKFK
`line_company_id`	String	FK
`project_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`budget_date`	LocalDate
`deliverables_requisition_line_id`	String
`due_date`	LocalDate
`end_date`	LocalDate
`extended_amount`	Double
`is_line_closed`	Boolean
`mark_purchase_order_as_issued`	Boolean
`memo`	String
`purchase_order_line_id`	String
`quantity`	Double
`source_this_line`	Boolean
`spend_category_id`	String
`start_date`	LocalDate
`tax_applicability_id`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure_code`	String

item_identifier_type

Column	Type	Keys
`id`	String	PK
`allow_multiples`	Boolean
`for_item_uom`	Boolean
`inactive`	Boolean
`item_identifier_is_external`	Boolean
`item_identifier_is_unique`	Boolean
`item_identifier_type_code`	String
`item_identifier_type_length`	Double
`item_identifier_type_name`	String
`use_in_supplier_catalog_mapping`	Boolean

revenue_recognition_schedule_line

Column	Type	Keys
`line_id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`line_code`	String

goods_delivery_ticket_line

Column	Type	Keys
`id`	String	PK
`goods_delivery_ticket_id`	String	PKFK
`goods_delivery_line_number`	Double
`item_description`	String
`quantity`	Double

business_entity_phone

Column	Type	Keys
`id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`country_isocode`	String
`device_type`	String
`international_phone_code`	String
`phone_code`	String
`phone_extension`	String
`phone_number`	String

invoice_type

Column	Type	Keys
`id`	String	PK
`country_id`	String
`invoice_type_code`	String
`invoice_type_description`	String
`invoice_type_in_use`	Boolean
`invoice_type_inactive`	Boolean
`invoice_type_value`	String
`usage_location_reference`	String

consolidated_invoice_bill_to_contact

Column	Type	Keys
`id`	String	PK
`consolidated_invoice_id`	String	PKFK
`bill_to_contact`	String

billing_schedule_template

Column	Type	Keys
`id`	String	PK
`contract_type_id`	String	FK
`auto_submit_invoices_for_approval`	Boolean
`automatically_generate_installments`	Boolean
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedule_for_approval`	Boolean
`automatically_submit_schedule_via_contract_amendment`	Boolean
`billing_cycle`	String
`billing_frequency`	String
`billing_method`	String
`billing_schedule_billed_in_arrears`	Boolean
`billing_schedule_template_code`	String
`billing_schedule_template_name`	String
`billing_type`	String
`customer_invoice_type`	String
`day_of_month`	Int
`day_of_the_week`	String
`generate_installment_with_to_date`	Boolean
`group_all_related_contract_lines`	Boolean
`include_tax_on_prepaid`	Boolean
`invoice_memo`	String
`number_of_installments`	Int
`project_invoice_summary_definition`	String
`review_not_required_to_bill`	Boolean
`schedule_description`	String
`schedule_type`	String
`separate_billing_schedule`	Boolean
`use_from_date`	Boolean
`use_to_date`	Boolean

report_group_ledger_account_summary

Column	Type	Keys
`id`	String	PK
`ledger_account_summary_id`	String	PKFK
`ledger_account_summary_code`	String

billing_schedule_installment_schedule

Column	Type	Keys
`line_id`	String	PK
`billing_schedule_id`	String	PKFK
`first_installment_amount`	Double
`last_installment_amount`	Double
`line_code`	String
`regular_installment_amount`	Double

supplier_invoice_installment_line

Column	Type	Keys
`supplier_contract_line_id`	String	PK
`supplier_invoice_installment_id`	String	PKFK
`from_date`	LocalDate
`line_description`	String
`line_order`	String
`payment_amount`	Double
`quantity`	Double
`retention_amount`	Double
`to_date`	LocalDate
`total_amount`	Double
`unit_cost`	Double
`unit_of_measure_code`	String
`use_line_overrides`	Boolean

billing_schedule_transaction_attachment_type

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`transaction_attachment_type_code`	String

supplier_catalog

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`supplier_id`	String	FK
`catalog_name`	String
`supplier_catalog_reference_id`	String

sales_item_bundle

Column	Type	Keys
`sales_item_bundle_id`	String	PKFK
`sales_item_id`	String	PKFK

organization_job_profile

Column	Type	Keys
`job_profile_id`	String	PK
`organization_id`	String	PKFK
`critical_job`	Boolean
`difficulty_to_fill`	String
`job_category_id`	String
`job_family_id`	String
`job_profile_name`	String
`management_level_id`	String
`work_shift_required`	Boolean

billing_schedule_subregion

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`descriptor`	String
`subregion`	String
`type`	String

supplier_item

Column	Type	Keys
`id`	String	PK
`catalog_item_id`	String	FK
`currency_id`	String	FK
`manufacturer_id`	String	FK
`purchase_item_id`	String	FK
`supplier_id`	String	FK
`calculate_price_based_on_conversion_factor`	Boolean
`item_description`	String
`item_name`	String
`item_url`	String
`lead_time`	Double
`manufacturer_part_number`	String
`sourcing_priority`	Double
`supplier_item_identifier`	String

supplier_invoice_assignment_rule_supplier

Column	Type	Keys
`supplier_id`	String	PKFK
`supplier_invoice_assignment_rule_id`	String	PKFK

allocation_group_set_financial_entry

Column	Type	Keys
`budget_structure_or_ledger_type_id`	String	PK
`allocation_group_set_name`	String	PKFK
`allocation_time_frame_id`	String	PKFK
`budget_structure_code`	String
`ledger_type_code`	String

account_posting_rule

Column	Type	Keys
`index`	Long	PK
`account_posting_rule_set_id`	String	PKFK
`default_ledger_account_code`	String	FK
`account_posting_rule_type_code`	String
`default_ledger_account_id`	String
`default_resulting_worktag_id`	String
`default_resulting_worktag_reference`	Json
`enable_control_account_warning`	Boolean

customer_contract

Column	Type	Keys
`id`	String	PK
`alternate_customer_contract_id`	String	FK
`bill_to_customer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`customer_contract_type_id`	String	FK
`master_customer_contract_id`	String	FK
`original_customer_contract_id`	String	FK
`payment_terms_id`	String	FK
`payment_type_id`	String	FK
`related_customer_contract_id`	String	FK
`salesperson_id`	String	FK
`ship_to_customer_id`	String	FK
`sold_to_customer_id`	String	FK
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`contract_description`	String
`contract_name`	String
`contract_signed_date`	LocalDate
`current_contract_amount`	Double
`customer_contract_code`	String
`customer_contract_effective_date`	LocalDate
`customer_contract_number`	String
`default_tax_code`	String
`installment_billing_schedule_template_code`	String
`locked_in_workday`	Boolean
`lower_range_percentage`	Double
`multiple_element_revenue_allocation`	Boolean
`no_allocation_threshold`	Boolean
`on_hold`	Boolean
`po_number`	String
`revenue_allocated`	Boolean
`ship_to_address`	String
`submit`	Boolean
`transaction_billing_schedule_template_code`	String
`upper_range_percentage`	Double
`version`	Double

allocation_definition_target_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`user_entered_worktag_id`	String
`worktag_type_code`	String
`worktag_value_is_from_id`	String

currency_rate_type

Column	Type	Keys
`currency_rate_type_id`	String	PK
`id`	String	PK
`currency_rate_type_default`	Boolean
`currency_rate_type_description`	String

catalog_item_supplier_contract

Column	Type	Keys
`catalog_item_id`	String	PKFK
`supplier_contract_id`	String	PKFK

allocation_group_set_organization

Column	Type	Keys
`allocation_group_set_name`	String	PKFK
`allocation_time_frame_id`	String	PKFK
`organization_id`	String	PKFK

inventory_picking_list

Column	Type	Keys
`id`	String	PK
`directed_pick`	Boolean
`document_date`	LocalDate
`document_number`	String
`fulfillment_date`	LocalDate
`has_priority`	Boolean
`memo`	String

obligation_ledger

Column	Type	Keys
`id`	String	PK
`ledger_id`	String	PKFK
`create_journal_entries_for_expenses`	Boolean
`create_journal_entries_for_fringe_benefits`	Boolean
`create_journal_entries_for_payroll_transactions`	Boolean
`create_journal_entries_for_procurement`	Boolean
`enable_obligation_ledger`	Boolean
`ledger_period_roll_forward_for_procurement`	Boolean

project_cost_rate_rule

Column	Type	Keys
`order`	String	PK
`currency_id`	String	PKFK
`project_standard_cost_rate_sheet_id`	String	PKFK
`project_standard_cost_rate_snapshot_id`	Long	PKFK
`delete`	Boolean
`hourly_rate`	Double
`project_cost_rate_rule_standard_cost_rate_detail_id`	String
`rule_code`	String
`rule_id`	String

allocation_pool_hierarchy_pool

Column	Type	Keys
`allocation_pool_id`	String	PK
`allocation_pool_hierarchy_id`	String	PKFK
`allocation_pool_code`	String
`allocation_pool_hierarchy_name`	String

allocation_definition_basis_company_filter

Column	Type	Keys
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`organization_id`	String	PKFK
`source_type_id`	String	PKFK
`organization_code`	String

allocation_group_line_dependent_allocation

Column	Type	Keys
`dependent_allocation_definition_id`	String	PK
`allocation_group_name`	String	PKFK
`allocation_group_set_name`	String	PKFK
`allocation_time_frame_id`	String	PKFK
`group_order`	String	PKFK
`dependent_allocation_definition_code`	String

billing_installment_line_tax_applicability

Column	Type	Keys
`id`	String	PK
`billing_installment_id`	Long	PKFK
`billing_installment_line_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`tax_applicability`	String

compensation_plan

Column	Type	Keys
`id`	String	PK
`bonus_plan_performance_factor_compensation_matrix_id`	String	FK
`bonus_plan_performance_matrix_compensation_matrix_id`	String	FK
`merit_plan_compensation_matrix_id`	String	FK
`stock_plan_compensation_matrix_id`	String	FK
`allowance_plan_amount`	Double
`allowance_plan_apply_full_time_equivalent`	Boolean
`allowance_plan_calculation_compensation`	String
`allowance_plan_compensation_basis`	String
`allowance_plan_currency`	String
`allowance_plan_default_units`	Double
`allowance_plan_element`	String
`allowance_plan_exclude_from_merit`	Boolean
`allowance_plan_frequency`	String
`allowance_plan_no_individual_override`	Boolean
`allowance_plan_per_unit_amount`	Double
`allowance_plan_percent_ceiling_amount`	Double
`allowance_plan_percent_ceiling_currency`	String
`allowance_plan_percentage`	Double
`allowance_plan_reimbursement_expense_accumulator`	String
`allowance_plan_reimbursement_expense_item`	String
`allowance_plan_unit_of_measure`	String
`base_plan_currency`	String
`base_plan_element`	String
`base_plan_exclude_from_merit`	Boolean
`base_plan_frequency`	String
`base_plan_hourly_amount`	Double
`base_plan_hourly_minimum_wage`	Boolean
`base_plan_salary_apply_full_time_equivalent`	Boolean
`base_plan_unit_salary_default_units`	Double
`base_plan_unit_salary_no_individual_override`	Boolean
`base_plan_unit_salary_per_unit_amount`	Double
`base_plan_unit_salary_unit_of_measure`	String
`bonus_plan_allow_individual_targets`	Boolean
`bonus_plan_amount`	Double
`bonus_plan_apply_full_time_equivalent`	Boolean
`bonus_plan_calculation_compensation`	String
`bonus_plan_compensation_basis`	String
`bonus_plan_currency`	String
`bonus_plan_deferred_compensation_calculation`	String
`bonus_plan_deferred_compensation_stock_plan`	String
`bonus_plan_element`	String
`bonus_plan_frequency`	String
`bonus_plan_include_active_employees_assigned`	Boolean
`bonus_plan_include_active_employees_in_waiting_period`	Boolean
`bonus_plan_percentage`	Double
`bonus_plan_performance_factor_apply_net_attainment`	Boolean
`bonus_plan_performance_factor_bonus_modifier`	String
`bonus_plan_performance_factor_weight`	Double
`bonus_plan_performance_matrix_apply_net_attainment`	Boolean
`bonus_plan_performance_matrix_bonus_modifier`	String
`bonus_plan_performance_matrix_use_matrix_as_reference_only`	Boolean
`bonus_plan_performance_scorecard`	String
`bonus_plan_rounding_rule`	String
`bonus_plan_time_proration`	String
`bonus_plan_waiting_period`	String
`calculated_plan_calculation`	String
`calculated_plan_currency`	String
`calculated_plan_element`	String
`calculated_plan_exclude_from_total_salary_and_allowance_compensation`	Boolean
`calculated_plan_frequency`	String
`calculated_plan_is_dynamic_calculated_plan`	Boolean
`calculated_plan_is_event_driven_calculated_plan`	Boolean
`commission_plan_currency`	String
`commission_plan_draw_amount`	Double
`commission_plan_draw_duration`	String
`commission_plan_draw_frequency`	String
`commission_plan_element`	String
`commission_plan_frequency`	String
`commission_plan_recoverable`	Boolean
`commission_plan_target_amount`	Double
`compensation_plan_code`	String
`description`	String
`effective_date`	LocalDate
`future_payment_plan_allow_individual_targets`	Boolean
`future_payment_plan_amount`	Double
`future_payment_plan_currency`	String
`future_payment_plan_element`	String
`future_payment_plan_frequency`	String
`future_payment_plan_include_all_bonus_compensation_plan`	Boolean
`future_payment_plan_include_one_time_payment_compensation_plan`	Boolean
`inactive`	Boolean
`merit_plan_allow_individual_targets`	Boolean
`merit_plan_amount_calculation_compensation`	String
`merit_plan_amount_compensation_basis`	String
`merit_plan_amount_manage_by_compensation_basis`	Boolean
`merit_plan_currency`	String
`merit_plan_frequency`	String
`merit_plan_include_active_employees_in_waiting_period`	Boolean
`merit_plan_include_active_employess_assigned`	Boolean
`merit_plan_percentage_calculation_compensation`	String
`merit_plan_percentage_compensation_basis`	String
`merit_plan_percentage_manage_by_compensation_basis`	Boolean
`merit_plan_required_amount`	Double
`merit_plan_rounding_rule`	String
`merit_plan_subject_to_statutory_minimum`	Boolean
`merit_plan_target_percentage`	Double
`merit_plan_time_proration`	String
`merit_plan_use_matrix_as_reference_only`	Boolean
`merit_plan_waiting_period`	String
`name`	String
`period_plan_calculation_compensation`	String
`period_plan_compensation_basis`	String
`period_plan_default_compensation_multiplier`	Double
`period_plan_element`	String
`period_plan_unit_of_duration`	String
`stock_plan_allow_target_override`	Boolean
`stock_plan_amount_data_currency`	String
`stock_plan_amount_data_rounding_rule`	String
`stock_plan_amount_data_target_amount`	Double
`stock_plan_amount_data_use_target_currency`	Boolean
`stock_plan_percent_data_calculation_compensation`	String
`stock_plan_percent_data_compensation_basis`	String
`stock_plan_percent_data_rounding_rule`	String
`stock_plan_percent_data_target_percent`	Double
`stock_plan_unit_data_target_shares`	Double
`stock_plan_use_as_reference_only`	Boolean

currency_conversion_rate

Column	Type	Keys
`id`	String	PK
`from_currency_id`	String	FK
`target_currency_id`	String	FK
`calculate_inverse_rate`	Boolean
`currency_rate`	Double
`currency_rate_type_code`	String
`effective_timestamp`	Instant

allocation_plan_tier

Column	Type	Keys
`tier_order`	String	PK
`allocation_plan_id`	String	PKFK
`allocation_pool_tier_reference_id`	String
`name`	String
`not_available_for_selection`	Boolean

sales_item_tiered_pricing

Column	Type	Keys
`index`	Long	PK
`sales_item_price_list_id`	String	PKFK
`sales_item_price_list_rule_line_id`	Long	PKFK
`quantity_from`	Double
`unit_price`	Double

project_role_rate

Column	Type	Keys
`role_id`	String	PK
`currency_id`	String	PKFK
`project_standard_cost_rate_sheet_id`	String	PKFK
`project_standard_cost_rate_snapshot_id`	Long	PKFK
`delete`	Boolean
`hourly_rate`	Double
`project_role_standard_cost_rate_detail_id`	String
`role_code`	String

related_worktag

Column	Type	Keys
`index`	Long	PK
`project_id`	String	PKFK
`default_worktag_id`	String	FK
`allowed_worktag_ids`	Json
`replace_all_allowed_values`	Boolean
`required_on_transaction`	Boolean
`required_on_transaction_for_validation`	Boolean
`worktag_type_code`	String
`worktag_type_id`	String

purchase_order_acknowledgement_line

Column	Type	Keys
`id`	String	PK
`purchase_order_acknowledgement_id`	String	PKFK
`backorder_date`	LocalDate
`backordered_quantity`	Double
`item_identifier`	String
`memo`	String
`po_acknowledgement_line_description`	String
`purchase_order_acknowledgement_line_code`	String
`purchase_order_line_id`	String
`quantity`	Double
`status`	String
`unit_cost`	Double
`unit_of_measure_code`	String

customer_contract_amendment

Column	Type	Keys
`id`	String	PK
`customer_contract_id`	String	FK
`active_amendment_type`	String
`amendment_description`	String
`amendment_effective_date`	LocalDate
`amendment_number`	String
`amendment_signed_date`	LocalDate
`customer_contract_amendment_code`	String
`customer_contract_change_without_amendment`	Boolean
`incremental_update`	Boolean
`new_contract_status`	String
`schedules_exist_on_customer_contract`	Boolean

restricted_to_source_company

Column	Type	Keys
`restricted_to_source_company_id`	String	PK
`allocation_plan_id`	String	PKFK
`restricted_to_source_company_code`	String

bank_statement_transaction

Column	Type	Keys
`index`	Long	PK
`bank_statement_id`	String	PKFK
`additional_reference_field_1`	String
`additional_reference_field_2`	String
`additional_reference_field_3`	String
`additional_reference_field_4`	String
`additional_reference_field_5`	String
`alternate_transaction_type_code`	String
`amount`	BigDecimal
`bank_reference_number`	String
`currency_exchange_rate`	BigDecimal
`customer_reference_number`	String
`debit`	Boolean
`originating_currency`	String
`originating_currency_amount`	BigDecimal
`reversal_indicator`	Boolean
`text`	String
`transaction_date`	String
`transaction_type_code`	String
`value_date`	String

alternate_customer_contract

Column	Type	Keys
`id`	String	PK
`alternate_customer_contract_id`	String	FK
`bill_to_customer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`customer_contract_type_id`	String	FK
`master_customer_contract_id`	String	FK
`original_customer_contract_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`related_customer_contract_id`	String	FK
`salesperson_id`	String	FK
`ship_to_customer_id`	String	FK
`sold_to_customer_id`	String	FK
`alternate_customer_contract_code`	String
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`contract_description`	String
`contract_name`	String
`contract_signed_date`	LocalDate
`current_contract_amount`	Double
`customer_contract_code`	String
`customer_contract_effective_date`	LocalDate
`customer_contract_number`	String
`default_tax_code`	String
`installment_billing_schedule_template_code`	String
`locked_in_workday`	Boolean
`lower_range_percentage`	Double
`multiple_element_revenue_allocation`	Boolean
`no_allocation_threshold`	Boolean
`on_hold`	Boolean
`po_number`	String
`revenue_allocated`	Boolean
`ship_to_address`	String
`submit`	Boolean
`transaction_billing_schedule_template_code`	String
`upper_range_percentage`	Double
`version`	Double

personal_information

Column	Type	Keys
`type`	String	PK
`id`	String	PKFK
`tobacco_use`	Boolean

project_timesheet_day

Column	Type	Keys
`index`	Long	PK
`project_timesheet_fivetran_id`	String	PKFK
`project_timesheet_line_id`	Long	PKFK
`date`	LocalDate
`hours`	Double

request_for_quote_line_bid_requirement

Column	Type	Keys
`index`	Int	PK
`request_for_quote_line_id`	String	PKFK
`memo`	String
`name`	String
`response_required`	Boolean
`sequence_number`	Double
`type`	String

audit_tag

Column	Type	Keys
`id`	String	PK
`code`	String
`inactive`	Boolean
`name`	String

headcount_plan_line

Column	Type	Keys
`index`	Long	PK
`headcount_plan_id`	String	PKFK
`headcount_plan_index`	Long	PKFK
`currency_id`	String	FK
`ledger_account_code`	String	FK
`award_posting_interval_code`	String
`cost_of_workforce_amount`	Double
`fiscal_posting_interval_code`	String
`fiscal_summary_interval_code`	String
`fiscal_summary_schedule_code`	String
`fiscal_time_interval_id`	String
`ledger_account_id`	String
`line_order`	String
`memo`	String
`planned_fte_amount`	Double
`planned_headcount_amount`	Double
`position_status_code`	String
`position_status_id`	String
`year`	Double

business_entity_im

Column	Type	Keys
`id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`im_address`	String
`im_comment`	String
`im_type`	String
`instant_messenger_code`	String

supervisory_organization_location

Column	Type	Keys
`location_id`	String	PK
`organization_id`	String	PKFK
`location_code`	String

business_unit

Column	Type	Keys
`id`	String	PK
`business_unit_code`	String
`business_unit_is_inactive`	Boolean
`business_unit_name`	String
`include_business_unit_id_in_name`	Boolean

manufacturer

Column	Type	Keys
`id`	String	PK
`inactive`	Boolean
`manufacturer_code`	String
`manufacturer_name_reference`	String
`manufacturer_url_reference`	String

supplier_contract_amendment_catalog

Column	Type	Keys
`supplier_catalog_id`	String	PKFK
`supplier_contract_amendment_id`	String	PKFK

supplier_item_advanced_pricing

Column	Type	Keys
`advanced_pricing_id`	String	PK
`supplier_item_id`	String	PKFK
`currency_id`	String	FK
`supplier_contract_id`	String	FK
`advanced_pricing_code`	String
`contract_price`	Double
`end_date`	Instant
`inactive`	Boolean
`just_in_time`	Boolean
`start_date`	Instant
`unit_of_measure_code`	String
`unit_price`	Double

business_unit_hierarchy

Column	Type	Keys
`id`	String	PK
`parent_business_unit_hierarchy_id`	String	FK
`business_unit_hierarchy_code`	String
`business_unit_hierarchy_is_inactive`	Boolean
`business_unit_hierarchy_name`	String
`include_business_unit_hierarchy_id_in_name`	Boolean
`organization_sub_type_code`	String

resource_forecast_line

Column	Type	Keys
`id`	String	PK
`resource_forecast_id`	String	PKFK
`project_resource_code`	String
`project_resource_id`	String
`resource_forecast_line_code`	String
`resource_plan_line_code`	String
`resource_plan_line_id`	String
`task_code`	String
`task_id`	String

name_match

Column	Type	Keys
`index`	Long	PK
`expense_credit_card_transaction_id`	String	PKFK
`supplier_id`	String	FK
`confidence_percentage`	Double
`destination_city_code`	String
`destination_city_id`	String
`merchant_code`	String
`merchant_id`	String
`origin_city_code`	String
`origin_city_id`	String

request_for_quote_response_line_bid_response

Column	Type	Keys
`id`	String	PK
`request_for_quote_response_line_id`	String	FK
`memo`	String
`name`	String
`request_for_quote_bid_response_memo`	String
`response_required`	Boolean
`response_value`	String
`type`	String

cost_center_restricted

Column	Type	Keys
`cost_center_id`	String	PKFK
`organization_id`	String	PKFK

customer_tax_entity_activity_code

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`code`	String
`country_id`	String
`description`	String
`entity_activity_code`	String
`entity_activity_type_code`	String

worker_position

Column	Type	Keys
`position_id`	String	PK
`worker_id`	String	PKFK
`job_family_id`	String	FK
`job_profile_id`	String	FK
`business_title`	String
`critical_job`	Boolean
`default_weekly_hours`	Double
`difficulty_to_fill`	String
`effective_date`	LocalDate
`employee_type`	String
`end_date`	LocalDate
`end_employment_date`	LocalDate
`exclude_from_head_count`	Boolean
`expected_assignment_end_date`	LocalDate
`external_employee`	String
`federal_withholding_fein`	String
`frequency`	String
`full_time_equivalent_percentage`	Double
`headcount_restriction_code`	String
`home_country`	String
`host_country`	String
`international_assignment_type`	String
`is_primary_job`	Boolean
`job_exempt`	Boolean
`management_level_code`	String
`management_level_descriptor`	String
`paid_fte`	Double
`pay_group`	String
`pay_rate`	String
`pay_rate_type`	String
`pay_through_date`	LocalDate
`payroll_entity`	String
`payroll_file_number`	String
`position_code`	String
`position_time_type`	String
`position_title`	String
`position_worker_type`	String
`regular_paid_equivalent_hours`	Double
`scheduled_weekly_hours`	Double
`specify_paid_fte`	Boolean
`specify_working_fte`	Boolean
`start_date`	LocalDate
`start_international_assignment_reason`	String
`work_hours_profile`	String
`work_shift`	String
`work_shift_required`	Boolean
`work_space`	String
`worker_hours_profile_classification`	String
`worker_type`	String
`working_fte`	Double
`working_time_frequency`	String
`working_time_unit`	String
`working_time_value`	Double
`academic_pay_setup_data_`
`business_site_summary_`

recall_line

Column	Type	Keys
`id`	String	PK
`recall_id`	String	PKFK
`global_trade_number_id`	String
`item_description`	String
`item_identifier`	String
`lot_identifiers`	String
`manufacture_from_date`	LocalDate
`manufacture_to_date`	LocalDate
`manufacturer_part_id`	String
`memo`	String
`name`	String
`national_drug_code`	String
`number`	Double
`serial_identifiers`	String
`universal_part_number`	String

business_plan_detail

Column	Type	Keys
`id`	String	PK
`index`	Long	PK
`company_id`	String	FK
`award_contract_id`	String
`award_posting_interval_code`	String
`award_proposal_code`	String
`business_plan_details_ref_id`	String
`business_plan_structure_id`	String
`currency_id`	String
`fiscal_posting_interval_code`	String
`fiscal_time_interval_id`	String
`organizing_dimension_id`	String
`plan_memo`	String
`project_budget_code`	String
`year`	Int

allocation_definition_basis_worktag_filter

Column	Type	Keys
`worktag_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK

customer_category

Column	Type	Keys
`id`	String	PK
`customer_category_code`	String
`name`	String

intercompany_customer_contract

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`sold_to_customer_id`	String	FK
`contract_description`	String
`contract_name`	String
`contract_signed_date`	LocalDate
`effective_date`	LocalDate

customer_contract_line_worktag

Column	Type	Keys
`worktag_id`	String	PKFK
`customer_contract_id`	String	FK
`customer_contract_line_number`	String	FK
`worktag_code`	Json

other_hotel_service

Column	Type	Keys
`index`	Long	PK
`expense_credit_card_transaction_id`	String	PKFK
`hotel_detail_id`	Long	PKFK
`other_service_amount`	Double
`other_service_code`	String
`other_service_type`	Double

compensation_matrix

Column	Type	Keys
`id`	String	PK
`compensation_matrix_code`	String
`description`	String
`effective_date`	LocalDate
`name`	String
`rating_scale`	String

receipt_adjustment_item_line_lot

Column	Type	Keys
`index`	Int	PK
`receipt_adjustment_item_line_id`	String	PKFK
`quantity`	Double

project_standard_cost_rate_snapshot

Column	Type	Keys
`index`	Long	PK
`currency_id`	String	PKFK
`project_standard_cost_rate_sheet_id`	String	PKFK
`company_id`	Json
`default_hourly_rate`	Double
`effective_date`	LocalDate
`first_priority_code`	String
`first_priority_id`	String
`second_priority_code`	String
`second_priority_id`	String
`third_priority_code`	String
`third_priority_id`	String

organization_document_field_result

Column	Type	Keys
`integration_document_field`	String	PK
`organization_id`	String	PKFK
`value`	String

billing_schedule_contract_line

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`contract_line`	String

requisition_item_request_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`item_request_line_index`	Long	PKFK
`requisition_id`	String	PKFK

supplier_invoice

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`supplier_connection_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`supplier_invoice_request_id`	String	FK
`accounting_date_override`	LocalDate
`budget_date`	LocalDate
`cancel_accounting_date`	LocalDate
`control_amount_total`	Double
`currency_rate_date_override`	LocalDate
`currency_rate_lookup_override`	Double
`currency_rate_manual_override`	Double
`default_currency_rate`	Double
`document_currency_conversion_rate`	Double
`document_link`	String
`document_status`	String
`due_date_override`	LocalDate
`external_po_number`	String
`freight_amount`	Double
`from_date`	LocalDate
`gapless_document_number`	String
`gross_invoice_amount`	Double
`invoice_accounting_date`	LocalDate
`invoice_date`	LocalDate
`invoice_number`	String
`invoice_received_date`	LocalDate
`locked_in_workday`	Boolean
`manual_override_percent`	Double
`memo`	String
`number_of_installments`	Double
`on_hold`	Boolean
`other_charges`	Double
`payment_practices`	Boolean
`prepaid`	Boolean
`rate_basis_date`	LocalDate
`rate_override`	Boolean
`release_date`	LocalDate
`retention_memo`	String
`submit`	Boolean
`supplier_document_received`	Boolean
`supplier_invoice_code`	String
`supplier_invoice_number`	String
`tax_amount`	Double
`tax_only`	Boolean
`total_amount_released`	Double
`total_amount_retained`	Double
`use_default_supplier_connection`	Boolean
`use_invoice_date`	Boolean
`withholding_tax_amount`	Double

supplier_contact_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`address_component_name`	String
`submunicipality`	String
`type`	String

billing_schedule_prepaid_installment_milestone

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`prepaid_installment_and_mapping_id`	String	PKFK
`prepaid_installment_id`	String	PKFK
`milestone`	String

revenue_recognition_schedule_template_sales_item

Column	Type	Keys
`id`	String	PKFK
`revenue_recognition_schedule_template_id`	String	PKFK

supplier_invoice_request_line

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`supplier_invoice_request_id`	String	FK
`billable`	Boolean
`extended_amount`	Double
`internal_memo`	String
`item_description`	String
`line_order`	String
`line_type`	String
`memo`	String
`packaging_string`	String
`quantity`	Double
`supplier_invoice_request_line_code`	String
`unit_cost`	Double

project_role_category

Column	Type	Keys
`id`	String	PK
`inactive_project_role_category`	Boolean
`project_role_category_code`	String
`project_role_category_description`	String
`project_role_category_name`	String

allocation_pool_included_hierarchy

Column	Type	Keys
`allocation_pool_hierarchy_id`	String	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_hierarchy_code`	String

bank_statement

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`bank_account_id`	String
`bank_identification_code`	String
`bank_statement_file_code`	String
`bank_statement_file_id`	String
`bank_statement_reference_code`	String
`customer_account_number`	String
`iban`	String
`routing_number`	String
`same_day_bank_statement`	Boolean
`statement_begin_date`	String
`statement_end_date`	String

spend_category_hierarchy

Column	Type	Keys
`id`	String	PK
`parent_id`	String	FK
`commodity_detail`	String
`description`	String
`display_option_code`	String
`enable_for_external_website`	Boolean
`hierarchy_level_code`	String
`hierarchy_level_id`	String
`inactive`	Boolean
`spend_category_hierarchy_code`	String
`spend_category_hierarchy_names`	String

allocation_pool_worktag_override_rule_worktag

Column	Type	Keys
`rule_item_index`	Long	PK
`worktag_id`	String	PK
`worktag_override_rule_id`	String	PKFK
`worktag_code`	String
`worktag_override_rule_name`	String

customer_contact_email

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`email_address`	String
`email_code`	String
`email_comment`	String

request_for_quote_participant_list

Column	Type	Keys
`index`	Int	PK
`request_for_quote_id`	String	PKFK
`supplier_id`	String	FK
`issue_option`	String

account_posting_rule_condition

Column	Type	Keys
`index`	Long	PK
`account_posting_rule_index`	Long	PKFK
`account_posting_rule_set_id`	String	PKFK
`account_ledger_code`	String	FK
`account_ledger_id`	String
`order`	String
`resulting_worktag_id`	String
`resulting_worktag_reference`	Json

customer_contact_subregion

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`descriptor`	String
`subregion`	String
`type`	String

customer_invoice_adjustment

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`original_customer_invoice_id`	String	FK
`payment_terms_id`	String	FK
`payment_type_id`	String	FK
`ship_to_customer_id`	String	FK
`sold_to_customer_id`	String	FK
`statutory_invoice_type_id`	String	FK
`accounting_date`	LocalDate
`additional_reference_number`	String
`adjustment_date`	LocalDate
`auto_apply_adjustment_to_invoice`	Boolean
`bill_to_address`	String
`cancel_accounting_date`	LocalDate
`collection_date`	LocalDate
`control_amount_total`	Double
`currency_rate_date_override`	LocalDate
`currency_rate_manual_override_reference`	Double
`currency_rate_type_override_reference`	String
`customer_invoice_adjustment_code`	String
`customer_invoice_type`	String
`customer_po_number`	String
`dispute_amount`	Double
`dispute_date`	LocalDate
`document_link`	String
`document_status`	String
`due_date_override`	LocalDate
`followup_date`	LocalDate
`from_date`	LocalDate
`gapless_invoice_number`	String
`include_customer_worktags`	Boolean
`increase_amount_due`	Boolean
`invoice_number`	String
`is_excluded_from_dunning_letter`	Boolean
`locked_in_workday`	Boolean
`memo`	String
`on_hold`	Boolean
`payment_amount_promised`	Double
`payment_status`	String
`populate_with_default_bill_to_contacts`	Boolean
`pre_notification_sent_date`	LocalDate
`ship_to_address`	String
`submit`	Boolean
`tax_calculation_details`	String
`tax_code`	String
`to_date`	LocalDate

revenue_recognition_installment_milestone

Column	Type	Keys
`id`	String	PK
`revenue_recognition_installment_id`	Long	PKFK
`revenue_recognition_schedule_id`	String	PKFK
`milestone`	String

requisition_service_request_line_split

Column	Type	Keys
`index`	Long	PK
`service_request_line_index`	Long	PK
`requisition_id`	String	PKFK
`budget_date`	LocalDate
`business_document_line_split_id`	String
`extended_amount`	Double
`line_split_allocation_id`	String
`memo`	String
`quantity`	Double

allocation_group

Column	Type	Keys
`allocation_group_name`	String	PK
`group_order`	String	PK
`allocation_group_set_name`	String	PKFK
`allocation_time_frame_id`	String	PKFK
`allocation_group_dependency_id`	String
`allocation_group_id`	String

allocation_pool_snapshot

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_method_code`	String
`allocation_method_id`	String
`allocation_pool_worktag_override_rule_id`	String
`effective_date`	LocalDate
`final_allocation_pool`	Boolean

ledger_account_summary

Column	Type	Keys
`id`	String	PK
`account_set_id`	String	FK
`effective_date`	LocalDate
`hierarchy_level`	String
`ledger_account_summary_code`	String
`ledger_account_summary_name`	String

resource_forecast_configuration

Column	Type	Keys
`index`	Long	PK
`resource_forecast_id`	String	PKFK
`estimated_hours_forecast_source`	Boolean
`forecast_decimal`	Boolean
`forecast_frequency_day`	Boolean
`forecast_frequency_month`	Boolean
`forecast_frequency_week`	Boolean
`forecast_whole_number`	Boolean
`percent_allocation_forecast_source`	Boolean
`project_forecast_level`	Boolean
`task_forecast_level`	Boolean

receipt_adjustment

Column	Type	Keys
`id`	String	PK
`advanced_ship_notice_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`purchase_order_id`	String	FK
`receipt_id`	String	FK
`supplier_id`	String	FK
`bill_of_lading_for_receipt`	String
`bill_of_lading_quantity_for_receipt`	Double
`carrier_tracking_number`	String
`document_status`	String
`memo`	String
`receipt_adjustment_date`	LocalDate
`receipt_adjustment_number`	String
`shipment_ref`	String
`supplier_order_ref`	String

supplier_refund_currency_rate

Column	Type	Keys
`index`	Int	PK
`supplier_refund_id`	String	PKFK
`currency_rate_date_override`	LocalDate
`currency_rate_lookup_override`	Double
`currency_rate_manual_override`	Double
`currency_rate_type_override`	String
`default_currency_rate`	Double
`default_rate_type`	String
`document_currency_conversion_rate`	Double
`is_primary`	Boolean
`manual_override_percent`	Double
`rate_basis_date`	LocalDate

return_line

Column	Type	Keys
`index`	Int	PK
`return_id`	String	PKFK
`line_company_id`	String	FK
`extended_amount`	Double
`item_id`	String
`memo`	String
`packaging_string`	String
`quantity`	Double
`unit_cost`	Double
`unit_of_measure_code`	String

customer_deposit

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`currency_rate_type_id`	String	FK
`customer_payment_id`	String	FK
`control_total_amount`	Double
`currency_rate_override`	Double
`deposit_reference_number`	String
`electronic_file_information`	String
`locked_in_workday`	Boolean
`payment_deposit_date`	LocalDate
`submit`	Boolean
`total_deposit_amount`	Double

order_fulfillment_transaction

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`customer_contract_line_id`	String	FK
`customer_id`	String	FK
`ship_to_address_id`	String	FK
`ship_to_customer_id`	String	FK
`asset_reference`	String
`fulfillment_date`	LocalDate
`memo`	String
`order_fulfillment`	String
`quantity_fulfilled`	Int
`tracking_code`	String

supplier_refund_application

Column	Type	Keys
`supplier_refund_application_id`	String	PK
`supplier_refund_id`	String	PKFK
`supplier_invoice_id`	String	FK
`amount_applied`	Double
`invoice_amount`	Double
`invoice_date`	LocalDate

customer_contact_web_address

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`web_address`	String
`web_address_code`	String
`web_address_comment`	String

customer_contact_address

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`address_code`	String
`country_city_code`	String
`country_region_code`	String
`country_region_descriptor`	String
`last_modified`	Instant
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String

customer_invoice_remittance

Column	Type	Keys
`customer_invoice_id`	String	PKFK
`customer_payment_id`	String	PKFK
`customer_payment_remittance_index`	Int	PKFK

purchase_order_service_line

Column	Type	Keys
`index`	Int	PK
`purchase_order_id`	String	PKFK
`commodity_code_id`	String	FK
`supplier_contract_id`	String	FK
`budget_date`	LocalDate
`description`	String
`due_date`	LocalDate
`end_date`	LocalDate
`extended_amount`	Double
`line_number`	Double
`memo`	String
`prepaid`	Boolean
`resource_category`	String
`retention`	Boolean
`service_order_line_code`	String
`start_date`	LocalDate
`supplier_contract_line_id`	String

supplier_connection

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`always_separate_payments`	Boolean
`do_not_pay_during_bank_account_updates`	Boolean
`is_default`	Boolean
`payment_memo`	String
`remit_to_email_address`	String
`supplier_connection_id`	String
`supplier_connection_name`	String

requisition_service_request_line

Column	Type	Keys
`index`	Long	PK
`requisition_id`	String	PKFK
`commodity_code_id`	String	FK
`deliver_to_location_id`	String	FK
`line_company_id`	String	FK
`ship_to_contact_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`budget_date`	LocalDate
`description`	String
`end_date`	LocalDate
`extended_amount`	Double
`fulfillment_source_code`	String
`is_line_closed`	Boolean
`item_id`	String
`mark_purchase_order_as_issued`	Boolean
`memo`	String
`order_from_connection_code`	String
`purchase_order_line_id`	String
`quantity`	Double
`rfq_required`	Boolean
`service_requisition_line_id`	String
`ship_to_address_code`	String
`source_this_line`	Boolean
`spend_category_id`	String
`start_date`	LocalDate
`tax_applicability_id`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure_code`	String

requisition_deliverables_line_split

Column	Type	Keys
`deliverables_line_index`	Long	PK
`index`	Long	PK
`requisition_id`	String	PKFK
`budget_date`	LocalDate
`business_document_line_split_id`	String
`deliverables_line_split_id`	String
`extended_amount`	Double
`line_split_allocation_id`	String
`memo`	String
`quantity`	Double

journal_entry_line

Column	Type	Keys
`index`	Long	PK
`journal_entry_id`	String	PKFK
`alternate_ledger_account_id`	String	FK
`currency_id`	String	FK
`ledger_account_code`	String	FK
`line_company_id`	String	FK
`account_set_name`	String
`budget_date`	LocalDate
`credit_amount`	Double
`currency_rate`	Double
`debit_amount`	Double
`exclude_from_spend_report`	Boolean
`external_reference_id`	String
`journal_line_number`	Double
`ledger_account_id`	String
`ledger_credit_amount`	Double
`ledger_debit_amount`	Double
`line_order`	String
`memo`	String
`quantity`	Double
`quantity_2`	Double

catalog_load

Column	Type	Keys
`id`	String	PK
`supplier_catalog_id`	String	FK
`supplier_contract_id`	String	FK
`default_lead_time_in_days`	Double
`effective_date`	LocalDate
`memo`	String

supplier_contract_lease_amendment

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`override_payment_type`	String	FK
`supplier_contract_to_amend_id`	String	FK
`amendment_description`	String
`amendment_number`	String
`amendment_signed_date`	LocalDate
`contract_end_date`	LocalDate
`contract_name`	String
`lease_additional_payment`	Boolean
`lease_fixed_payment_amount`	Double
`lease_interest_rate`	Double
`lease_liability_reassessment_date`	LocalDate
`payment_effective_date`	LocalDate
`submit`	Boolean
`supplier_contract_lease_amendment_type`	String
`total_contract_amount`	Double

requisition_ad_hoc_address_replacement_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_index`	Long	PKFK
`requisition_id`	String	PKFK
`address_component_name`	String
`text`	String
`type`	String

supplier_contract_lease_payment_line

Column	Type	Keys
`payment_date`	LocalDate	PK
`supplier_contract_id`	String	PKFK
`amount`	Double

customer_contact_submunicipality

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`address_component_name`	String
`submunicipality`	String
`type`	String

commodity_code_type

Column	Type	Keys
`id`	String	PK
`length`	Double
`name`	String

business_entity_communication_usage

Column	Type	Keys
`business_contact_id`	String	PK
`contact_type`	String	PK
`index`	Long	PK
`comment`	String
`is_primary`	Boolean
`usage_type`	String
`use_for`	Json
`use_for_tenanted`	Json
`visibility`	String

project_task_hierarchy

Column	Type	Keys
`id`	String	PK
`project_task_id`	String	PKFK
`project_task_name`	String	PKFK
`project_hierarchy_code`	String

job_family

Column	Type	Keys
`id`	String	PK
`effective_date`	LocalDate
`inactive`	Boolean
`job_family_code`	String
`job_family_short_code`	String
`summary`	String

allocation_pool_source_journal_line_offset_account

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`source_journal_line_offset_ledger_account_id`	String	FK
`source_for_journal_line_offset_account`	Boolean
`source_journal_line_offset_ledger_account_code`	String

receipt_line_service

Column	Type	Keys
`index`	Int	PK
`receipt_id`	String	PKFK
`commodity_code_id`	String	FK
`purchase_order_id`	String	FK
`deliver_to`	String
`extended_amount`	Double
`memo`	String
`purchase_order_line_id`	String
`purchase_order_line_number`	String
`ship_to_address`	String
`supplier_contract_line_id`	String

commitment_ledger

Column	Type	Keys
`id`	String	PK
`ledger_id`	String	PKFK
`create_journal_entries_for_expenses`	Boolean
`create_journal_entries_for_fringe_benefits`	Boolean
`create_journal_entries_for_payroll_transactions`	Boolean
`create_journal_entries_for_procurement`	Boolean
`enable_commitment_ledger`	Boolean
`ledger_period_roll_forward_for_procurement`	Boolean

supplier_contact_address_line

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`address_line`	String
`descriptor`	String
`type`	String

revenue_recognition_schedule_template

Column	Type	Keys
`id`	String	PK
`automatically_generate_installments`	Boolean
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedule_for_approval`	Boolean
`automatically_submit_schedule_via_contract_amendment`	Boolean
`frequency`	String
`generate_cumulative_catch_up_installments`	Boolean
`independent_revenue_processing`	Boolean
`number_of_installments`	Double
`percent_complete_method`	String
`revenue_recognition_method`	String
`revenue_recognition_schedule_template_code`	String
`revenue_recognition_schedule_template_name`	String
`schedule_description`	String
`schedule_type`	String
`use_to_date_on_contract`	Boolean

revenue_recognition_schedule_hold_reason

Column	Type	Keys
`id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`hold_reason`	String

allocation_source_worktag

Column	Type	Keys
`worktag_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK

request_for_quote_award_line_split

Column	Type	Keys
`id`	String	PK
`request_for_quote_award_line_id`	String	FK
`extended_amount`	Double
`memo`	String
`quantity`	Double
`request_for_quote_award_line_split_code`	String

allocation_definition_basis_ledger_account_summary_filter

Column	Type	Keys
`ledger_account_summary_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`ledger_account_summary_code`	String

revenue_recognition_schedule_milestone

Column	Type	Keys
`id`	String	PK
`revenue_recognition_schedule_id`	String	PKFK
`milestone`	String

default_optional_balancing_worktag

Column	Type	Keys
`default_optional_balancing_worktag_id`	String	PK
`allocation_plan_id`	String	PKFK
`default_optional_balancing_worktag_code`	String

revenue_recognition_schedule

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`intercompany_header_company_id`	String	FK
`amount_distribution_method`	String
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedule_via_contract_amendment`	Boolean
`controlling_transaction`	String
`create_reversal`	Boolean
`default_currency_rate`	String
`frequency`	String
`from_date`	LocalDate
`generate_cumulative_catch_up_installments`	Boolean
`generate_installments`	Boolean
`independent_revenue_processing`	Boolean
`number_of_installments`	Double
`percent_complete_method`	String
`revenue_recognition_schedule_code`	String
`schedule_description`	String
`schedule_on_hold`	Boolean
`schedule_override_rate`	Double
`submit`	Boolean
`to_date`	LocalDate

purchase_item_list

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`inactive`	Boolean
`name`	String
`purchase_item_list_code`	String

allocation_definition_attachment

Column	Type	Keys
`index`	Long	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`comment`	String
`compressed`	Boolean
`content_type`	String
`encoding`	String
`filename`	String

requisition_ad_hoc_address_replacement

Column	Type	Keys
`index`	Long	PK
`requisition_id`	String	PKFK
`address_code`	String
`country_city_id`	String
`country_id`	String
`country_region_descriptor`	String
`country_region_id`	String
`last_modified`	Instant
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String

purchase_order_contingent_worker_line

Column	Type	Keys
`index`	Int	PK
`purchase_order_id`	String	PKFK
`contingent_worker_id`	String	FK
`contract_pay_rate`	Double
`end_date`	LocalDate
`extended_amount`	Double
`invoice_status`	String
`line_number`	Double
`location`	String
`memo`	String
`payment_status`	String
`position_code`	String
`position_time_type_code`	String
`receiving_status`	String
`scheduled_hours`	Double
`start_date`	LocalDate
`tax_applicability_code`	String
`tax_code`	String

procurement_card_transaction_verification_line_worktag

Column	Type	Keys
`worktag_id`	String	PK
`credit_card_transaction_id`	String	PKFK
`line_index`	Long	PKFK
`procurement_card_transaction_verification_id`	String	PKFK

customer_contact_instant_messenger

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`instant_messenger_address`	String
`instant_messenger_code`	String
`instant_messenger_comment`	String
`instant_messenger_type`	String

consolidated_invoice_customer_invoice

Column	Type	Keys
`id`	String	PK
`consolidated_invoice_id`	String	PKFK
`customer_invoice`	String

procurement_card_transaction_verification

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`worker_id`	String	FK
`budget_date`	LocalDate
`document_date`	LocalDate
`procurement_card_transaction_verification_id`	String
`submit`	Boolean
`total_verification_amount`	Double
`verification_status_code`	String

supplier_invoice_assignment_rule_supplier_category

Column	Type	Keys
`supplier_category_id`	String	PKFK
`supplier_invoice_assignment_rule_id`	String	PKFK

supplier_invoice_assignment_rule_supplier_group

Column	Type	Keys
`supplier_group_id`	String	PKFK
`supplier_invoice_assignment_rule_id`	String	PKFK

customer_contact_usage

Column	Type	Keys
`contact_id`	String	PK
`contact_type`	String	PK
`index`	Long	PK
`comment`	String
`is_primary`	Boolean
`usage_type`	String
`visibility`	String

billing_installment_status

Column	Type	Keys
`id`	String	PK
`billing_installment_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`status`	String

audit_tag_segment

Column	Type	Keys
`id`	String	PK
`audit_tag_id`	String	PKFK
`code`	String

billing_schedule_interest_and_late_fee_override

Column	Type	Keys
`index`	Long	PK
`billing_schedule_id`	String	PKFK
`exempt`	Boolean
`interest_rule`	String
`late_fee_rule`	String

supplier_contact_web_address

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`web_address`	String
`web_address_code`	String
`web_address_comment`	String

customer_payment

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`customer_deposit_id`	String	FK
`invoice_currency_id`	String	FK
`payment_currency_id`	String	FK
`payment_type_id`	String	FK
`cancel_accounting_date`	LocalDate
`check_number`	String
`currency_rate_date_override`	LocalDate
`currency_rate_manual_override_reference`	Double
`currency_rate_type_override`	String
`customer_payment_for_invoice_code`	String
`do_not_apply_payment_to_invoices_on_hold`	Boolean
`document_link`	String
`electronic_file_information`	String
`locked_in_workday`	Boolean
`payment_amount`	Double
`payment_application_status`	String
`payment_date`	LocalDate
`payment_memo`	String
`payment_number`	String
`payment_status`	String
`ready_to_auto_apply`	Boolean
`show_only_matched_invoices_when_applying`	Boolean

worker

Column	Type	Keys
`id`	String	PK
`compensation_grade_id`	String	FK
`compensation_grade_profile_id`	String	FK
`academic_tenure_date`	LocalDate
`active`	Boolean
`active_status_date`	LocalDate
`annual_currency_summary_currency`	String
`annual_currency_summary_frequency`	String
`annual_currency_summary_primary_compensation_basis`	Double
`annual_currency_summary_total_base_pay`	Double
`annual_currency_summary_total_salary_and_allowances`	Double
`annual_summary_currency`	String
`annual_summary_frequency`	String
`annual_summary_primary_compensation_basis`	Double
`annual_summary_total_base_pay`	Double
`annual_summary_total_salary_and_allowances`	Double
`benefits_service_date`	LocalDate
`company_service_date`	LocalDate
`compensation_effective_date`	LocalDate
`continuous_service_date`	LocalDate
`contract_assignment_details`	String
`contract_currency_code`	String
`contract_end_date`	LocalDate
`contract_frequency_name`	String
`contract_pay_rate`	Double
`contract_supplier_reference_code`	String
`contract_vendor_name`	String
`currency_code`	String
`currency_numeric_code`	String
`date_entered_workforce`	LocalDate
`days_unemployed`	Double
`display_language_code`	String
`eligible_for_hire`	String
`eligible_for_rehire_on_latest_termination`	String
`employee_compensation_currency`	String
`employee_compensation_frequency`	String
`employee_compensation_primary_compensation_basis`	Double
`employee_compensation_total_base_pay`	Double
`employee_compensation_total_salary_and_allowances`	Double
`end_employment_date`	LocalDate
`expected_date_of_return`	LocalDate
`expected_retirement_date`	LocalDate
`first_day_of_work`	LocalDate
`has_international_assignment`	Boolean
`hire_date`	LocalDate
`hire_reason`	String
`hire_reason_descriptor`	String
`hire_rescinded`	Boolean
`home_country`	String
`hour_clock_code`	String
`hourly_frequency_currency`	String
`hourly_frequency_frequency`	String
`hourly_frequency_primary_compensation_basis`	Double
`hourly_frequency_total_base_pay`	Double
`hourly_frequency_total_salary_and_allowances`	Double
`last_datefor_which_paid`	LocalDate
`local_termination_reason`	String
`locale_code`	String
`months_continuous_prior_employment`	Double
`not_returning`	Boolean
`original_hire_date`	LocalDate
`pay_group_frequency_currency`	String
`pay_group_frequency_frequency`	String
`pay_group_frequency_primary_compensation_basis`	Double
`pay_group_frequency_total_base_pay`	Double
`pay_group_frequency_total_salary_and_allowances`	Double
`pay_through_date`	LocalDate
`preferred_language_code`	String
`primary_termination_category`	String
`primary_termination_category_descriptor`	String
`primary_termination_reason`	String
`primary_termination_reason_descriptor`	String
`probation_end_date`	LocalDate
`probation_start_date`	LocalDate
`reason_reference_descriptor`	String
`reason_reference_id`	String
`regrettable_termination`	Boolean
`rehire`	Boolean
`resignation_date`	LocalDate
`retired`	Boolean
`retirement_date`	LocalDate
`retirement_eligibility_date`	LocalDate
`return_unknown`	Boolean
`seniority_date`	LocalDate
`severance_date`	LocalDate
`simplified_view`	Boolean
`terminated`	Boolean
`termination_date`	LocalDate
`termination_involuntary`	Boolean
`termination_last_day_of_work`	LocalDate
`time_off_service_date`	LocalDate
`time_zone_code`	String
`universal_id`	String
`user_id`	String
`user_language_code`	String
`user_name`	String
`vesting_date`	LocalDate
`worker_code`	String

customer_portal_payment_session

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`external_merchant_id`	String
`external_payment_record`	String
`payment_amount_actual`	Double
`payment_amount_requested`	Double
`payment_session_timeout_timestamp`	LocalDate

customer_contract_renewal_term

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`auto_renew`	Boolean
`coterm`	Boolean
`from_date`	LocalDate
`notes`	String
`optout_period`	String
`renewal_amount`	Double
`renewal_percent`	Double
`renewal_quantity`	Double
`renewal_quantity_2`	Double
`renewal_rate`	Double
`to_date`	LocalDate

sales_item_group_mapping

Column	Type	Keys
`sales_item_group_id`	String	PKFK
`sales_item_id`	String	PKFK

purchase_order_line_split

Column	Type	Keys
`id`	String	PK
`parent_index`	Int	PK
`purchase_order_id`	String	PKFK
`budget_date`	LocalDate
`business_document_line_split_id`	String
`extended_amount`	Double
`memo`	String
`quantity`	Double
`type`	String

business_entity_address

Column	Type	Keys
`id`	String	PK
`business_entity_contact_fivetran_id`	String	FK
`address_code`	String
`city`	String
`country`	String
`country_alpha_2_code`	String
`country_region`	String
`country_region_code`	String
`effective_date`	LocalDate
`last_modified`	Instant
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String

restricted_to_journal_source

Column	Type	Keys
`restricted_to_journal_source_id`	String	PK
`allocation_plan_id`	String	PKFK
`restricted_to_journal_source_code`	String

project_worker_role

Column	Type	Keys
`id`	String	PK
`description`	String
`inactive`	Boolean
`name`	String
`project_worker_role_code`	String

business_entity_address_line

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`line_data`	String
`type`	String

supplier

Column	Type	Keys
`id`	String	PK
`currency_id`	String	FK
`minimum_order_amount_currency_id`	String	FK
`payment_term_id`	String	FK
`supplier_category_id`	String	FK
`acknowledgement_expected`	Boolean
`always_separate_payments`	Boolean
`approval_status`	String
`asn_due_in_days`	Double
`certificate_of_insurance_date`	LocalDate
`customer_account_number`	String
`default_additional_type`	String
`default_payment_type`	String
`default_tax_code`	String
`default_withholding_tax_code`	String
`disable_change_order`	Boolean
`do_not_pay_during_bank_account_updates`	Boolean
`do_not_reimburse_contingent_worker_expense_reports`	Boolean
`document_link`	String
`duns_number`	String
`edit_portal_taxes`	Boolean
`enable_asn`	Boolean
`enable_global_location_number`	Boolean
`exclude_freight_amount_from_supplier_invoice_discount`	Boolean
`exclude_other_charges_from_supplier_invoice_discount`	Boolean
`exclude_tax_amount_from_supplier_invoice_discount`	Boolean
`external_sourceable_id`	String
`fatca`	Boolean
`invoice_any_supplier`	Boolean
`irs_1099_supplier`	Boolean
`minimum_order_amount`	Double
`note_follow_up_date`	LocalDate
`overrides_tenant_setup_for_supplier_invoice_discount_exclusion`	Boolean
`procurement_credit_card`	String
`reference_code`	String
`report_1099_with_parent`	Boolean
`shipping_method`	String
`shipping_terms`	String
`submit`	Boolean
`supplier_code`	String
`supplier_name`	String
`tax_document_date`	LocalDate
`text_for_default_supplier_payment_memo`	String
`unique_entity_identifier`	String
`use_invoice_memo_as_default_supplier_payment_memo`	Boolean
`use_supplier_connection_memo`	Boolean
`use_supplier_reference_as_default_supplier_payment_memo`	Boolean
`worktag_only`	Boolean

supplier_contact_usage

Column	Type	Keys
`contact_id`	String	PK
`contact_type`	String	PK
`index`	Long	PK
`comment`	String
`is_primary`	Boolean
`usage_type`	String
`visibility`	String

project_attachment

Column	Type	Keys
`index`	Long	PK
`project_id`	String	PKFK
`comment`	String

catalog_load_item

Column	Type	Keys
`id`	String	PK
`catalog_load_id`	String	FK
`commodity_code_id`	String	FK
`purchase_item_id`	String	FK
`catalog_item_id`	String
`inactive`	Boolean
`item_description`	String
`item_identifier`	String
`item_name`	String
`item_url`	String
`lead_time`	Double
`packaging_string`	String
`un_cefact_base_uom_code`	String
`unspsc_code`	Double

business_plan_entry_line

Column	Type	Keys
`index`	Long	PK
`business_plan_detail_id`	String	PKFK
`business_plan_detail_index`	Long	PKFK
`credit_amount`	Double
`debit_amount`	Double
`ledger_account_id`	String
`ledger_account_summary_id`	String
`line_memo`	String
`line_order`	String

supplier_contact_subregion

Column	Type	Keys
`index`	Long	PK
`address_id`	String	FK
`descriptor`	String
`subregion`	String
`type`	String

tax_detail

Column	Type	Keys
`id`	String	PK
`expense_credit_card_transaction_id`	String	FK
`additional_tax_charged`	Boolean
`tax_amount`	Double
`tax_type_code`	String
`tax_type_description`	String

allocation_pool_pro_rata_option

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`allocation_pool_for_non_target_pools_code`	String
`allocation_pool_for_non_target_pools_id`	String
`default_allocation_pool_code`	String
`default_allocation_pool_id`	String
`statistic_definition_code`	String
`statistic_definition_id`	String

requisition_ad_hoc_address_replacement_subregion

Column	Type	Keys
`index`	Long	PK
`address_index`	Long	PKFK
`requisition_id`	String	PKFK
`descriptor`	String
`text`	String
`type`	String

customer_contact_address_line

Column	Type	Keys
`index`	Long	PK
`address_id`	String	PKFK
`address_line`	String
`descriptor`	String
`type`	String

ledger_account

Column	Type	Keys
`id`	String	PK
`account_set_id`	String	PKFK
`name`	String
`retired`	Boolean
`type`	String

fund

Column	Type	Keys
`id`	String	PK
`fund_type_id`	String	FK
`fund_code`	String
`fund_is_inactive`	Boolean
`fund_name`	String
`fund_type_code`	String
`include_fund_id_in_name`	Boolean

recall_reaction

Column	Type	Keys
`id`	String	PK
`recall_id`	String	FK
`document_number`	String
`inventory_task_details`	String
`issue_task_details`	String
`par_task_details`	String
`po_task_details`	String
`reaction_memo`	String

revenue_category_related_worktags

Column	Type	Keys
`worktag_type_id`	String	PK
`revenue_category_id`	String	PKFK
`default_worktag_id`	String	FK
`replace_all_allowed_values`	Boolean
`required_on_transaction`	Boolean
`required_on_transaction_for_validation`	Boolean
`worktag_type_code`	String

billing_schedule_bill_to_address

Column	Type	Keys
`address_id`	String	PK
`billing_schedule_id`	String	PKFK
`address_code`	String
`address_format_type`	String
`country_city`	String
`country_code`	String
`country_region`	String
`country_region_descriptor`	String
`defaulted_business_site_address`	Boolean
`effective_date`	LocalDate
`formatted_address`	String
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String

business_entity_contact

Column	Type	Keys
`fivetran_id`	String	PK
`supplier_id`	String	FK
`billable_entity_code`	String
`billable_entity_id`	String
`business_entity_contact_code`	String
`default_bill_to_contact`	Boolean
`financial_institution_code`	String
`financial_institution_id`	String
`id`	String
`primary_bill_to_contact`	Boolean
`tax_authority_code`	String
`tax_authority_id`	String

resource_category_allowed_worktags

Column	Type	Keys
`allowed_worktag_id`	String	PK
`resource_category_id`	String	PKFK
`worktag_type_id`	String	PKFK
`allowed_worktag_reference`	Json

allocation_pool_target_pool

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`allocation_pool_target_distribution_percentage`	Double
`target_allocation_pool_code`	String
`target_allocation_pool_id`	String

billing_schedule_prepaid_installment_and_mapping

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`prepaid_customer_contract_line`	String
`prepaid_installment_and_mapping_code`	String

project_standard_cost_rate_sheet

Column	Type	Keys
`id`	String	PK
`currency_id`	String	PKFK
`currency_code`	String
`inactive`	Boolean
`project_standard_cost_rate_sheet_code`	String
`standard_cost_rate_sheet_name`	String

requisition_ad_hoc_address_replacement_address_line

Column	Type	Keys
`index`	Long	PK
`address_index`	Long	PKFK
`requisition_id`	String	PKFK
`descriptor`	String
`text`	String
`type`	String

supplier_to_supplier_group

Column	Type	Keys
`supplier_group_id`	String	PKFK
`supplier_id`	String	PKFK

requisition_communication_method_usage

Column	Type	Keys
`index`	Long	PK
`address_index`	Long	PKFK
`requisition_id`	String	PKFK
`comments`	String
`usage_behavior_code`	String
`usage_behavior_tenanted_code`	String
`usage_type_code`	String

company_alternate_ledger_currency

Column	Type	Keys
`company_id`	String	PKFK
`currency_id`	String	PKFK
`currency_fiscal_start_year_number`	Int
`currency_rate_type_code`	String

purchase_order_procedure

Column	Type	Keys
`index`	Int	PK
`purchase_order_id`	String	PKFK
`medical_record_number`	String
`patient_id`	String
`physician_id`	String
`procedure`	String
`procedure_date`	LocalDate
`procedure_number`	String
`supplier_representative`	String
`verified_by`	String

allocation_definition

Column	Type	Keys
`allocation_definition_name`	String	PK
`basis_allocation_method_id`	String	PK
`fiscal_schedule_id`	String	PK
`source_type_id`	String	PK
`account_set_id`	String	PKFK
`currency_id`	String	FK
`currency_rate_type_id`	String	FK
`offset_account_ledger_account_code`	String	FK
`offset_company_id`	String	FK
`target_account_ledger_account_code`	String	FK
`target_company_id`	String	FK
`translation_currency_id`	String	FK
`account_set_code`	String
`account_translation_rule_set_id`	String
`allocation_definition_code`	String
`allocation_definition_id`	String
`allocation_description`	String
`allocation_reference_text`	String
`balance_or_activity_id`	String
`balancing_worktag_id`	String
`basis_book_code_id`	String
`basis_condition_rule_id`	String
`basis_type_id`	String
`budget_amendment_type_id`	String
`create_reversal`	Boolean
`fiscal_schedule_code`	String
`fixed_amount`	BigDecimal
`inactive`	Boolean
`ledger_or_budget_structure_for_basis_id`	String
`ledger_or_budget_structure_for_source_id`	String
`ledger_or_budget_structure_for_target_id`	String
`offset_account_ledger_account_id`	String
`offset_account_ledger_account_is_from_code`	String
`offset_account_ledger_account_is_from_id`	String
`offset_company_allocation_dimension_code`	String
`offset_company_allocation_dimension_id`	String
`offset_company_code`	String
`offset_company_is_from_code`	String
`offset_company_is_from_id`	String
`source_allocation_percent`	BigDecimal
`source_book_code_id`	String
`source_condition_rule_id`	String
`statistic_definition_id`	String
`target_account_ledger_account_id`	String
`target_account_ledger_account_is_from_code`	String
`target_account_ledger_account_is_from_id`	String
`target_book_code`	String
`target_book_id`	String
`target_company_code`	String
`target_company_is_from_code`	String
`target_company_is_from_id`	String

project_worker_project_hierarchy

Column	Type	Keys
`id`	String	PK
`project_worker_role_id`	String	PKFK
`project_hierarchy_code`	String

alternate_contract_interest_rate

Column	Type	Keys
`index`	Int	PK
`supplier_contract_lease_amendment_id`	String	PKFK
`alternate_supplier_contract_id`	String	FK
`interest_rate`	Double

revenue_recognition_installment_status

Column	Type	Keys
`id`	String	PK
`revenue_recognition_installment_id`	Long	PKFK
`revenue_recognition_schedule_id`	String	PKFK
`status`	String

sales_item_to_include_in_bundle

Column	Type	Keys
`sales_item_id`	String	PKFK
`sales_item_to_include_in_bundle_id`	String	PKFK

resource_category

Column	Type	Keys
`id`	String	PK
`revenue_category_id`	String	FK
`accounting_treatment_code`	String
`allocate_freight`	Boolean
`allocate_other_charges`	Boolean
`asset_class_code`	String
`asset_type_code`	String
`classification_type_name_code`	String
`commodity_detail`	String
`depreciation_profile_code`	String
`description`	String
`expense_usage`	Boolean
`inactive`	Boolean
`intangible_reference`	Boolean
`inventory_accounting_treatment_code`	String
`item_identifier_type_code`	String
`lease`	Boolean
`procurement_usage`	Boolean
`requisition_fulfillment_source_code`	String
`resource_category_code`	String
`resource_category_name`	String
`spend_category_or_hierarchy_display_option_code`	String
`spend_category_usage_id`	String
`stock_items`	Boolean
`tax_applicability_code`	String
`track_items`	Boolean

payment_term

Column	Type	Keys
`id`	String	PK
`cutoff_day`	Double
`grace_days`	Double
`payment_discount_days`	Double
`payment_discount_percent`	Double
`payment_terms_id`	String
`payment_terms_name`	String

prepaid_mapping_customer_contract_line

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`prepaid_installment_and_mapping_id`	String	PKFK
`prepaid_mapping_id`	String	PKFK
`prepaid_mapping_customer_contract_line_code`	String

billing_installment_line

Column	Type	Keys
`index`	Long	PK
`billing_installment_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`amount`	Double
`closed_installment_base_currency_amount`	Double
`contract_line`	String
`deferred_revenue`	Boolean
`from_date`	LocalDate
`line_item_description`	String
`memo`	String
`order`	String
`overrride_line`	Boolean
`quantity`	Double
`quantity_2`	Double
`to_date`	LocalDate
`unit_cost`	Double
`unit_of_measure`	String
`unit_of_measure_2`	String

supplier_invoice_assignment_rule

Column	Type	Keys
`id`	String	PK
`assign_to_creator`	Boolean
`greater_than_amount`	Double
`order`	String
`supplier_invoice_assignment_rule_code`	String
`supplier_name_range_end`	String
`supplier_name_range_start`	String

revenue_category_included_references

Column	Type	Keys
`id`	String	PK
`revenue_category_heirarchy_id`	String	PKFK
`revenue_categories_included`	String

journal_entry

Column	Type	Keys
`id`	String	PK
`cancel_reversed_by_journal_entry_id`	String	FK
`cancel_reverses_journal_entry_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`display_account_set_id`	String	FK
`functional_reversed_by_journal_entry_id`	String	FK
`functional_reverses_journal_entry_id`	String	FK
`journal_source_id`	String	FK
`ledger_id`	String	FK
`accounting_date`	LocalDate
`book_code`	String
`creation_date`	Instant
`document_link`	String
`external_reference_id`	String
`journal_entry_status`	String
`journal_number`	String
`journal_sequence_number`	String
`last_updated_date`	Instant
`ledger_period_id`	String
`memo`	String
`operational_transaction_id`	String
`operational_transaction_reference`	Json
`record_quantity`	Double
`total_ledger_credits`	Double
`total_ledger_debits`	Double
`transaction_date`	LocalDate

customer_invoice_adjustment_line_data

Column	Type	Keys
`id`	String	PK
`customer_invoice_adjustment_id`	String	FK
`intercompany_affiliate_id`	String	FK
`revenue_category_id`	String	FK
`ship_to_customer_id`	String	FK
`amount_released`	Double
`amount_retained`	Double
`analytical_amount`	Double
`calculated_tax_amount`	Double
`customer_invoice_line_code`	String
`deferred_revenue`	Boolean
`extended_amount`	Double
`from_date`	LocalDate
`line_item_description`	String
`line_order`	String
`memo`	String
`quantity`	Double
`quantity_2`	Double
`ship_to_address`	String
`tax_applicability_code`	String
`tax_code`	String
`to_date`	LocalDate
`transaction_date`	LocalDate
`unit_cost`	Double
`unit_of_measure_2_code`	String
`unit_of_measure_code`	String
`withholding_tax_code`	String

purchase_order_acknowledgement

Column	Type	Keys
`id`	String	PK
`purchase_order_id`	String	FK
`document_date`	LocalDate
`document_number`	String
`memo`	String
`origin_reference_id`	String
`purchase_order_acknowledgement_code`	String
`submit`	Boolean
`supplier_acknowledgement_number`	String

customer_contract_template_line

Column	Type	Keys
`id`	String	PK
`line_number`	Double	PK
`customer_contract_template_id`	String	FK
`delete`	Boolean
`renewable`	Boolean
`use_standard_rate_sheet`	Boolean

revenue_recognition_installment_hold_reason

Column	Type	Keys
`id`	String	PK
`revenue_recognition_installment_id`	Long	PKFK
`revenue_recognition_schedule_id`	String	PKFK
`hold_reason`	String

billing_schedule_status

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`schedule_status_code`	String

business_unit_hierarchy_contains_business_unit

Column	Type	Keys
`business_unit_hierarchy_id`	String	PKFK
`business_unit_id`	String	PKFK

revenue_adjustment_reason

Column	Type	Keys
`id`	String	PK
`default`	Boolean
`description`	String
`reason_code`	String
`revenue_adjustment_reason_code`	String

fund_type

Column	Type	Keys
`id`	String	PK
`fund_restriction_code`	String
`fund_restriction_id`	String
`fund_type_code`	String
`fund_type_name`	String
`funded_by_code`	String
`funded_by_id`	String
`inactive`	Boolean
`include_fund_type_id_in_name`	Boolean

address

Column	Type	Keys
`id`	String	PK
`personal_info_system_id`	String	PKFK
`position_id`	String	PKFK
`address_code`	String
`city`	String
`country`	String
`country_alpha_2_code`	String
`country_region`	String
`country_region_code`	String
`effective_date`	LocalDate
`last_modified`	Instant
`municipality`	String
`municipality_local`	String
`number_of_days`	Double
`postal_code`	String
`type`	String

purchase_order_schedule

Column	Type	Keys
`id`	String	PK
`payment_term_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`automatically_regenerate_installments`	Boolean
`automatically_submit_schedules`	Boolean
`day_of_month`	Double
`from_date`	LocalDate
`number_of_installments`	Double
`purchase_order_schedule_id`	String
`schedule_description`	String
`schedule_on_hold`	Boolean
`submit`	Boolean
`supplier_contract_line_id`	String
`system_generated`	Boolean
`to_date`	LocalDate

return

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`supplier_id`	String	FK
`supplier_invoice_id`	String	FK
`document_status`	String
`memo`	String
`pick_up_location`	String
`restocking_fee_amount`	Double
`return_date`	LocalDate
`return_number`	String
`return_reason`	String
`supplier_rma`	String

business_plan_entry_line_worktag

Column	Type	Keys
`business_plan_detail_id`	String	PKFK
`business_plan_detail_index`	Long	PKFK
`business_plan_entry_line_index`	Long	PKFK
`worktag_id`	String	PKFK

supplier_invoice_assignment_rule_company

Column	Type	Keys
`company_id`	String	PKFK
`supplier_invoice_assignment_rule_id`	String	PKFK

supplier_contract_amendment_service_line

Column	Type	Keys
`line_number`	String	PK
`supplier_contract_amendment_id`	String	PKFK
`companyfor_invoices_id`	String	FK
`location`	String	FK
`ship_to_contact_id`	String	FK
`cancel_supplier_contract_line`	Boolean
`description`	String
`end_date`	LocalDate
`extended_amount`	Double
`line_on_hold`	Boolean
`memo`	String
`retention`	Boolean
`ship_to_address`	String
`start_date`	LocalDate
`tax_code`	String

request_for_quote_bid_requirement

Column	Type	Keys
`index`	Int	PK
`request_for_quote_id`	String	PKFK
`memo`	String
`name`	String
`response_required`	Boolean
`sequence_number`	Double

organization_role_worker

Column	Type	Keys
`associated_worker_id`	String	PKFK
`organization_id`	String	PKFK
`role_id`	String	PKFK

project_hierarchy

Column	Type	Keys
`project_hierarchy_name`	String	PK
`currency_id`	String	FK
`description`	String
`enable_as_optional_hierarchy`	Boolean
`inactivated_by_hierarchy_code`	String
`inactivated_by_hierarchy_id`	String
`inactive`	Boolean
`include_project_hierarchy_id_in_name`	Boolean
`included_project_ids`	Json
`included_project_in_optional_hierarchy`	Json
`organization_subtype_code`	String
`organization_subtype_id`	String
`parent_code`	String
`parent_id`	String
`project_hierarchy_id`	String
`project_hierarchy_ref_id`	String
`project_hierarchy_status_code`	String
`project_hierarchy_status_id`	String
`project_resource_plan_code`	String
`project_resource_plan_id`	String
`project_scenario_groups_ids`	Json

location

Column	Type	Keys
`id`	String	PK
`altitude`	Float
`code`	String
`currency`	String
`currency_code`	String
`inactive`	Boolean
`latitude`	Float
`locale`	String
`longitude`	Float
`name`	String
`time_profile`	String
`time_zone`	String

organization_hierarchy_detail

Column	Type	Keys
`type`	String	PK
`linked_organization_id`	String	PKFK
`organization_id`	String	PKFK

revenue_recognition_installment

Column	Type	Keys
`index`	Long	PK
`revenue_recognition_schedule_id`	String	PKFK
`currency_id`	String	FK
`allocation_description`	String
`from_date`	LocalDate
`installment_date`	LocalDate
`on_hold`	Boolean
`revenue_recognition_installment_code`	String
`to_date`	LocalDate
`total_amount`	Double

credit_card_transaction_line

Column	Type	Keys
`id`	Double	PK
`expense_credit_card_transaction_id`	String	FK
`charge_date`	LocalDate
`discount_amount`	Double
`extended_amount`	Double
`flat_rate_amount`	Double
`freight_amount`	Double
`handling_amount`	Double
`item_code_description`	String
`item_description`	String
`line_item_total_amount`	Double
`lost_or_damaged_items_amount`	Double
`miscellaneous_charges_amount`	Double
`miscellaneous_charges_description`	String
`one_time_miscellaneous_charges_amount`	Double
`other_charges_amount`	Double
`product_code`	String
`purchase_order_line_number`	Double
`quantity`	Double
`tax_amount`	Double
`tax_rate`	Double
`unit_of_measure_common_code`	String
`unit_of_measure_edi_code`	String
`unit_of_measure_id`	String
`unit_price`	Double
`unspsc_code`	Double
`upc`	String
`vendor_part_number`	String

sales_item_price_list_rule_line_contract_line_type

Column	Type	Keys
`contract_line_type_id`	String	PK
`sales_item_price_list_id`	String	PKFK
`sales_item_price_list_rule_line_id`	Long	PKFK
`contract_line_type_code`	String

funds_availability_data

Column	Type	Keys
`index`	Long	PK
`parent_record_id`	String	PK
`parent_type`	String	PK
`bank_statement_id`	String	PKFK
`amount`	BigDecimal
`availability_date_time`	String
`number_of_days_until_available`	BigDecimal
`unknown_number_of_days`	Boolean

recall

Column	Type	Keys
`id`	String	PK
`date_received`	LocalDate
`distributor`	String
`due_date`	LocalDate
`fda_date`	LocalDate
`manufacturer_name`	String
`reason_for_recall`	String
`recall_code`	String
`recall_date_closed`	LocalDate
`recall_description`	String
`recall_header_memo`	String

supplier_contract_service_line

Column	Type	Keys
`line_number`	String	PK
`supplier_contract_id`	String	PKFK
`company_for_invoices_id`	String	FK
`description`	String
`do_not_auto_renew`	Boolean
`end_date`	LocalDate
`extended_amount`	Double
`line_on_hold`	Boolean
`location`	String
`maximum_charge_control_amount`	Double
`memo`	String
`minimum_charge_control_amount`	Double
`renewal_amount`	Double
`renewal_quantity`	Double
`renewed_by_line_number`	String
`renews_line_number`	String
`retention`	Boolean
`ship_to_address`	String
`spend_category`	String
`start_date`	LocalDate
`tax_applicability`	String
`tax_code`	String

customer_portal_payment_session_invoice

Column	Type	Keys
`customer_invoice_id`	String	PKFK
`customer_portal_payment_session_id`	String	PKFK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`payment_terms_id`	String	FK
`amount_due`	Double
`customer_po_number`	String
`document_number`	String
`due_date`	LocalDate
`invoice_amount`	Double
`invoice_date`	LocalDate

rfq_award_po_default

Column	Type	Keys
`index`	Int	PK
`request_for_quote_award_id`	String	PKFK
`payment_term_id`	String	FK
`bill_to_contact_detail`	String
`payment_terms_reference`	Json
`ship_to_contact_detail`	String
`shipping_instruction`	String

supplier_invoice_request_line_split

Column	Type	Keys
`id`	String	PK
`supplier_invoice_request_line_id`	String	FK
`billable`	Boolean
`extended_amount`	Double
`memo`	String
`quantity`	Double
`supplier_invoice_request_line_split_code`	String

purchase_order

Column	Type	Keys
`id`	String	PK
`bill_to_contact_id`	String	FK
`buyer_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`payment_term_id`	String	FK
`payment_type_id`	String	FK
`ship_to_contact_id`	String	FK
`supplier_contract_id`	String	FK
`supplier_id`	String	FK
`acknowledgement_expected`	Boolean
`auto_sourced`	Boolean
`bill_to_contact_detail`	String
`document_date`	LocalDate
`document_link`	String
`document_number`	String
`due_date`	LocalDate
`estimated_retention_release_date`	LocalDate
`external_po_number`	String
`freight_amount`	Double
`internal_memo`	String
`invoice_status`	String
`issue_option_code`	String
`locked_in_workday`	Boolean
`memo`	String
`order_from_supplier_connection_code`	String
`other_charges`	Double
`payment_status`	String
`percent_to_retain`	Double
`prepaid`	Boolean
`prepayment_release_type_code`	String
`purchase_order_code`	String
`purchase_order_document_status`	String
`receiving_status`	String
`retention_memo`	String
`ship_to_contact_detail`	String
`ship_to_global_location_number`	String
`ship_to_location_identifier`	String
`shipping_instruction`	String
`shipping_method_code`	String
`shipping_status`	String
`shipping_terms_code`	String
`tax_amount`	Double
`tracking_status`	String
`use_prepaid_posting_rules_for_receipt_accruals`	Boolean
`xmlname_3_rd_party_retention`	Boolean

intercompany_customer_contract_line

Column	Type	Keys
`id`	String	PK
`intercompany_customer_contract_id`	String	PKFK
`delete`	Boolean
`tax_applicability_reference`	String
`tax_code`	String
`withholding_tax_code`	String

allocation_definition_opening_balance_worktag

Column	Type	Keys
`worktag_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK

revenue_category_hierarchy

Column	Type	Keys
`id`	String	PK
`hierarchy_level`	String
`parent_revenue_category_hierarchy`	String
`revenue_category_hierarchy_code`	String
`revenue_category_hierarchy_name`	String

organization_leader

Column	Type	Keys
`organization_id`	String	PKFK
`organization_manager_id`	String	PKFK

supplier_invoice_line

Column	Type	Keys
`index`	Long	PK
`supplier_invoice_id`	String	PKFK
`commodity_code_id`	String	FK
`customer_invoice_line_id`	String	FK
`intercompany_affiliate_id`	String	FK
`purchase_item_id`	String	FK
`purchase_order_id`	String	FK
`purchase_order_line_id`	String	FK
`ship_to_contact_id`	String	FK
`supplier_contract_id`	String	FK
`accounting_treatment`	String
`billable`	Boolean
`budget_date`	LocalDate
`extended_amount`	Double
`item_description`	String
`line_order`	String
`memo`	String
`packaging_string`	String
`payment_amount`	Double
`prepaid`	Boolean
`purchase_order_line_number`	String
`quantity`	Double
`retention_amount`	Double
`ship_to_address`	String
`spend_category_code`	String
`supplier_contract_line_id`	String
`supplier_invoice_line_code`	String
`tax_applicability_code`	String
`tax_code`	String
`trackable_item`	Boolean
`unit_cost`	Double
`unit_of_measure`	String
`withholding_tax_code`	String
`worktag_split_template`	String

inventory_return_order_line

Column	Type	Keys
`id`	String	PK
`inventory_return_order_id`	String	PKFK
`memo`	String
`quantity`	Double

organization_job_family

Column	Type	Keys
`job_family_id`	String	PK
`organization_id`	String	PKFK
`job_family_group_id`	String

billing_schedule_contract_line_for_retention

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`contract_line_for_retention`	String

account_set

Column	Type	Keys
`id`	String	PK
`account_set_code`	String
`chart_of_accounts`	Boolean
`name`	String

allocation_source_ledger_account

Column	Type	Keys
`ledger_account_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`ledger_account_code`	String	FK

ledger

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`can_view_budget_date`	Boolean
`ledger_code`	String
`ledger_type`	String

purchase_order_contingent_worker_line_worktag

Column	Type	Keys
`index`	Int	PK
`worktag_id`	String	PK
`purchase_order_id`	String	PKFK

receipt_adjustment_service_line_split

Column	Type	Keys
`index`	Int	PK
`receipt_adjustment_service_line_id`	String	PKFK
`extended_amount`	Double
`line_split_allocated_from_id`	String
`memo`	String

headcount_plan_lines_worktag

Column	Type	Keys
`worktag_id`	String	PK
`headcount_plan_id`	String	PKFK
`headcount_plan_index`	Long	PKFK
`headcount_plan_line_index`	Long	PKFK

organization_position_group_position

Column	Type	Keys
`position_worker_type_id`	String	PK
`organization_id`	String	PKFK
`position_worker_type_code`	String

billing_schedule_billing_type

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`billing_type_code`	String

catalog_item

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`supplier_catalog_id`	String	FK
`base_unit_of_measure_code`	String
`catalog_item_code`	String
`current_default_unit_price`	Double
`default_ordering_unit_of_measure_code`	String
`is_catalog_item_currently_active`	Boolean
`item_description`	String
`item_identifier`	String
`item_name`	String
`item_url`	String
`packaging_string`	String
`spend_category_code`	String

billing_schedule_prepaid_installment

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`prepaid_installment_and_mapping_id`	String	PKFK
`line_item_description`	String
`memo`	String
`on_hold`	Boolean
`prepaid_installment_amount`	Double
`prepaid_installment_code`	String
`prepaid_installment_date`	LocalDate
`prepaid_installment_status`	String

customer_contract_line_discounts_and_premiums_applied

Column	Type	Keys
`contract_discount_and_premium_id`	String	PKFK
`customer_contract_id`	String	PKFK
`customer_contract_line_number`	String	PKFK

request_for_quote_award

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`request_for_quote_id`	String	FK
`request_for_quote_response_id`	String	FK
`supplier_id`	String	FK
`approved_on_date`	LocalDate
`award_date`	LocalDate
`memo`	String
`reason`	String
`request_for_quote_award_code`	String
`rfq_award_number`	String
`status`	String
`type`	String

included_ledger_account

Column	Type	Keys
`included_ledger_account_id`	String	PKFK
`ledger_account_summary_id`	String	PKFK
`included_ledger_account_code`	String

allocation_pool_allocation_offset_account

Column	Type	Keys
`index`	Long	PK
`allocation_pool_name`	String	PKFK
`allocation_pool_snapshot_index`	Long	PKFK
`offset_ledger_account_id`	String	FK
`offset_ledger_account_code`	String
`source_for_allocation_offset_account`	Boolean

advanced_ship_notice_line

Column	Type	Keys
`id`	String	PK
`advanced_ship_notice_id`	String	PKFK
`purchase_item_id`	String	FK
`advanced_ship_notice_line_code`	String
`conversion_factor`	Double
`extended_amount`	Double
`item_description`	String
`item_identifier`	String
`memo`	String
`shipment_line_reference`	String
`shipped_quantity`	Double
`shipped_unit_cost`	Double
`shipped_unit_of_measure_code`	String

supplier_contract

Column	Type	Keys
`id`	String	PK
`buyer_id`	String	FK
`company_for_purchase_order_id`	String	FK
`company_for_supplier_invoice_id`	String	FK
`company_hierarchy_id`	String	FK
`company_id`	String	FK
`contract_specialist_id`	String	FK
`currency_id`	String	FK
`payment_type_id`	String	FK
`purchase_order_payment_term_id`	String	FK
`scheduled_invoice_override_payment_type_id`	String	FK
`supplier_catalog_id`	String	FK
`supplier_connection_for_supplier_invoice_id`	String	FK
`supplier_for_supplier_invoice_id`	String	FK
`supplier_id`	String	FK
`supplier_invoice_payment_term_id`	String	FK
`accounting_method`	String
`additional_payment`	Boolean
`automatically_generate_expense_recognition_schedule_and_installments`	Boolean
`automatically_generate_supplier_invoice_schedule_and_installments`	Boolean
`automatically_renew`	Boolean
`bill_to_address`	String
`bill_to_contact_detail`	String
`catalog_discount_percent`	Double
`compound_period`	String
`contract_document_link`	String
`contract_end_date`	LocalDate
`contract_name`	String
`contract_reference`	String
`contract_signed_date`	LocalDate
`contract_start_date`	LocalDate
`contract_type`	String
`credit_card_id`	String
`default_tax_code`	String
`document_status`	String
`estimated_retention_release_date`	LocalDate
`expense_recognition_method`	String
`external_contract_reference_id`	String
`first_payment_installment_date`	LocalDate
`fixed_payment_amount`	Double
`gpo_contract_reference`	String
`initial_direct_cost`	Double
`interest_rate`	Double
`lease_liability`	Double
`lease_term`	Double
`lessor_incentive`	Double
`locked_in_workday`	Boolean
`notice_period`	Double
`number_of_payments`	Double
`on_hold`	Boolean
`order_from_connection`	String
`original_contract_amount`	Double
`overview`	String
`payment_frequency`	String
`percent_to_retain`	Double
`prepaid_lease_payment`	Boolean
`prepaid_lease_payment_date`	LocalDate
`purchase_order_issue_option`	String
`renewal_term`	Double
`retention_memo`	String
`rou_asset`	Double
`send_expiration_notification`	Boolean
`ship_to_address`	String
`ship_to_contact_detail`	String
`submit`	Boolean
`supplier_contract_code`	String
`supplier_invoice_reference_number`	String
`total_contract_amount`	Double
`total_interest`	Double
`total_lease_payments`	String
`use_default_supplier_connection`	Boolean
`xmlname_3_rd_party_retention`	Boolean

customer_invoice

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`payment_terms_id`	String	FK
`payment_type_id`	String	FK
`ship_to_customer_id`	String	FK
`sold_to_customer_id`	String	FK
`statutory_invoice_type_id`	String	FK
`accounting_date`	LocalDate
`additional_reference_number`	String
`additional_type`	String
`amount_due`	Double
`award_billing_sequence_number`	Double
`bill_to_address`	String
`billable_project_code`	String
`cancel_accounting_date`	LocalDate
`collection_date`	LocalDate
`control_amount_total`	Double
`currency_rate_date_override`	LocalDate
`currency_rate_manual_override_reference`	Double
`currency_rate_type_override`	String
`customer_invoice_code`	String
`customer_invoice_type`	String
`customer_po_number`	String
`delivery_type_origin`	String
`dispute_amount`	Double
`dispute_date`	LocalDate
`document_link`	String
`document_status`	String
`due_date_override`	LocalDate
`finance_charge`	Boolean
`followup_date`	LocalDate
`from_date`	LocalDate
`gapless_invoice_number`	String
`include_customer_worktags`	Boolean
`invoice_date`	LocalDate
`invoice_number`	String
`is_excluded_from_dunning_letter`	Boolean
`latest_interest_and_late_fee_process_date`	LocalDate
`locked_in_workday`	Boolean
`memo`	String
`on_hold`	Boolean
`payment_amount_promised`	Double
`payment_status`	String
`populate_with_default_bill_to_contacts`	Boolean
`pre_notification_sent_date`	LocalDate
`risk_score`	Double
`risk_score_date`	LocalDate
`ship_to_address`	String
`submit`	Boolean
`tax_calculation_details`	String
`tax_code`	String
`to_date`	LocalDate

supplier_contact_email

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`email_address`	String
`email_code`	String
`email_comment`	String

restricted_to_ledger_account_type

Column	Type	Keys
`restricted_to_ledger_account_type_id`	String	PK
`allocation_plan_id`	String	PKFK
`restricted_to_ledger_account_type_code`	String

customer_contract_type

Column	Type	Keys
`id`	String	PK
`default_contract_template_id`	String	FK
`customer_contract_type_code`	String
`description`	String
`inactive`	Boolean
`linked_contract`	Boolean
`name`	String

request_for_quote_line

Column	Type	Keys
`id`	String	PK
`purchase_item_id`	String	FK
`request_for_quote_id`	String	FK
`end_date`	LocalDate
`extended_amount`	Double
`item_description`	String
`lead_time_required`	Boolean
`line_number`	Double
`line_type`	String
`memo`	String
`quantity`	Double
`request_for_quote_line_code`	String
`requested_delivery_date`	LocalDate
`requisition_line`	String
`response_required`	Boolean
`spend_category_code`	String
`start_date`	LocalDate
`target_price`	Double
`unit_cost`	Double
`unit_of_measure_code`	String
`unit_price_required`	Boolean

allocation_pool_worktag_override_rule

Column	Type	Keys
`id`	String	PK
`condition_accounting_worktag_type_code`	String
`condition_worktag_type_code`	String
`condition_worktag_type_id`	String
`inactive`	Boolean
`worktag_override_rule_name`	String
`worktag_override_rule_reference_id`	String

procurement_card_transaction_verification_line

Column	Type	Keys
`index`	Long	PK
`credit_card_transaction_id`	String	PKFK
`procurement_card_transaction_verification_id`	String	PKFK
`credit_card_currency_id`	String	FK
`currency_id`	String	FK
`intercompany_affiliate_id`	String	FK
`item_id`	String	FK
`automatic_order`	String
`budget_date`	LocalDate
`conversion_rate`	Double
`converted_amount`	Double
`credit_card_amount`	Double
`distribution_method_code`	String
`extended_amount`	Double
`line_item_description`	String
`memo`	String
`purchase_order_line_id`	String
`quantity`	Double
`spend_category_code`	String
`supplier_contract_line_id`	String
`taggable_type_code`	String
`tax_applicability_code`	String
`tax_code_value`	String
`unit_cost`	Double
`unit_of_measure_code`	String

allocation_definition_offset_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`user_entered_worktag_id`	String
`worktag_type_code`	String
`worktag_value_is_from_id`	String

cost_center

Column	Type	Keys
`id`	String	PKFK
`cost_center_code`	String
`effective_date`	LocalDate

project_resource_requirement_parameter

Column	Type	Keys
`id`	String	PK
`project_worker_role_id`	String	PKFK
`business_view_proxy_field_last_entry_code`	String
`business_view_union_field_last_entry_code`	String
`calculated_field_code`	String
`computed_data_source_field_code`	String
`cube_field_last_entry_code`	String
`delete`	Boolean
`extension_computed_data_field_reference_code`	String
`external_analytics_data_source_field_code`	String
`requirement_field_id`	String
`requirement_values`	Json

project

Column	Type	Keys
`id`	String	PK
`balancing_worktag_id`	String	FK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`project_owner_id`	String	FK
`associated_templates_from_project_template_code`	String
`associated_templates_from_project_template_id`	String
`billable`	Boolean
`capital`	Boolean
`customer_contract_template_code`	String
`customer_contract_template_id`	String
`description`	String
`end_date`	LocalDate
`estimated_budget`	Double
`estimated_revenue`	Double
`external_link`	String
`external_project_reference_name`	String
`importance_rating_code`	String
`importance_rating_id`	String
`in_scope`	String
`inactive`	Boolean
`include_project_id_in_name`	Boolean
`initiative_code`	String
`initiative_id`	String
`invoice_accounting_date`	LocalDate
`locked_in_workday`	Boolean
`measures_of_success`	String
`objective`	String
`optional_balancing_worktag_ids`	Json
`optional_project_hierarchy_ids`	Json
`out_of_scope`	String
`overall_percent_complete`	Double
`payment_practices`	Boolean
`priority_code`	String
`priority_id`	String
`probability`	Double
`problem_statement`	String
`project_code`	String
`project_dependencies_ids`	Json
`project_event_status_ids`	Json
`project_group_ids`	Json
`project_hierarchy_code`	String
`project_hierarchy_id`	String
`project_name`	String
`project_overview`	String
`project_prerequisite_ids`	Json
`project_state_code`	String
`project_state_id`	String
`project_status_code`	String
`project_status_id`	String
`realized_revenue`	Double
`resource_plan_code`	String
`resource_plan_id`	String
`risk_level_code`	String
`risk_level_id`	String
`start_date`	LocalDate
`success_rating_code`	String
`success_rating_id`	String
`workday_project_code`	String
`worktag_only`	Boolean

advanced_ship_notice

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`purchase_order_id`	String	FK
`advanced_ship_notice_code`	String
`auto_submit_receipt_for_approval`	Boolean
`bill_of_lading`	String
`bill_of_lading_quantity`	Double
`canceled_on_date`	LocalDate
`cancellation_memo`	String
`carrier_tracking_number`	String
`document_number`	String
`document_status`	String
`license_plate`	String
`memo`	String
`origin_reference_id`	String
`requisition_type_code`	String
`shipment_contact`	String
`shipment_date`	Instant
`shipment_reference`	String
`supplier_order_reference`	String

supplier_invoice_history

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`supplier_id`	String	FK
`external_po_number`	String
`invoice_date`	LocalDate
`invoice_number`	String
`source_integration_system`	String
`supplier_invoice_history_code`	String
`suppliers_invoice_number`	String
`total_invoice_amount`	Double

revenue_allocation_configuration

Column	Type	Keys
`id`	String	PK
`fair_value_price_list_id`	String	FK
`allocate_revenue_at_summary_and_prorate_at_line`	Boolean
`allocation_basis`	String
`do_not_auto_allocate_revenue`	Boolean
`lower_range_percentage`	Double
`revenue_allocation_configuration_code`	String
`upper_range_percentage`	Double

cost_center_allowed_worktag

Column	Type	Keys
`allowed_worktag_id`	String	PK
`cost_center_id`	String	PKFK
`worktag_type_id`	String	PKFK
`allowed_worktag_code`	Json

procurement_card_transaction_verification_summary_attachment

Column	Type	Keys
`index`	Long	PK
`credit_card_transaction_id`	String	PKFK
`procurement_card_transaction_verification_id`	String	PKFK
`comment`	String
`compressed`	Boolean
`content_type`	String
`encoding`	String
`file_content`	String
`filename`	String

return_line_split_worktag

Column	Type	Keys
`return_line_split_id`	String	PKFK
`worktag_id`	String	PKFK

business_entity_person_name

Column	Type	Keys
`index`	Long	PK
`business_entity_contact_fivetran_id`	String	PKFK
`academic_suffix`	String
`country`	String
`first_name`	String
`full_name_singapore_malaysia`	String
`hereditary_suffix`	String
`honorary_suffix`	String
`last_name`	String
`middle_name`	String
`prefix_salutation`	String
`prefix_title`	String
`prefix_title_code`	String
`professional_suffix`	String
`religious_suffix`	String
`royal_suffix`	String
`secondary_last_name`	String
`social_suffix`	String
`social_suffix_id`	String
`tertiary_last_name`	String
`local_`

procurement_card_transaction_verification_attachment

Column	Type	Keys
`index`	Long	PK
`procurement_card_transaction_verification_id`	String	PKFK
`comment`	String
`compressed`	Boolean
`content_type`	String
`encoding`	String
`file_content`	String
`filename`	String

receipt

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`supplier_id`	String	FK
`bill_of_lading`	String
`bill_of_lading_quantity`	Double
`contingent_worker_additional_amount`	Double
`contingent_worker_amount_to_receive`	Double
`contingent_worker_memo`	String
`contingent_worker_period_end_date`	LocalDate
`contingent_worker_period_start_date`	LocalDate
`document_date`	LocalDate
`document_status`	String
`last_updated`	Instant
`license_plate`	String
`locked_in_workday`	Boolean
`memo`	String
`receipt_number`	String
`shipment_contact`	String
`shipment_date_time`	Instant
`shipment_ref`	String
`submit`	Boolean
`supplier_order_ref`	String
`tracking_number`	String

alternate_customer_contract_line

Column	Type	Keys
`line_number`	Double	PK
`alternate_customer_contract_id`	String	PKFK
`line_company_id`	String	FK
`allocation_percentage`	Double
`billable_transaction_tax`	Boolean
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`bundle_line_number`	Double
`contract_line_description`	String
`contract_line_type`	String
`customer_contract_line_end_date`	LocalDate
`customer_contract_line_start_date`	LocalDate
`deferred_revenue`	Boolean
`document_status`	String
`exclude_from_calculation`	Boolean
`extended_amount`	Double
`fair_value_extended_amount`	Double
`fair_value_unit_price`	Double
`first_installment_amount`	Double
`frequency_behavior`	String
`last_installment_amount`	Double
`line_billing_notes`	String
`line_invoice_memo`	String
`line_invoice_memo_override`	String
`line_item_description_override`	String
`list_extended_amount`	Double
`list_unit_price`	Double
`lower_range_percentage`	Double
`mid_range`	Double
`new_business`	Boolean
`number_of_installments`	Double
`quantity`	Double
`quantity_2`	Double
`range_high`	Double
`range_low`	Double
`recalculate_fv_unit_price`	Boolean
`receivable_contract_line_reference_code`	String
`regular_installment_amount`	Double
`relative_selling_price_allocation`	Double
`renewable`	Boolean
`revenue_recognition_line_notes`	String
`revenue_treatment`	String
`tax_applicability`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure`	String
`unit_of_measure_2`	String
`upper_range_percentage`	Double
`use_standard_rate_sheet`	Boolean
`withholding_tax_code`	String
`zero_revenue`	Boolean

headcount_plan

Column	Type	Keys
`id`	String	PK
`index`	Long	PK
`award_proposal_code`	String
`award_reference_code`	String
`custom_budget_code`	String
`headcount_plan_code`	String
`headcount_plan_memo`	String
`plan_name_id`	String
`project_budget_code`	String
`structure_code`	String
`structure_id`	String
`submit`	Boolean

requisition_deliverables_line_split_worktag

Column	Type	Keys
`worktag_id`	String	PK
`deliverables_line_index`	Long	PKFK
`deliverables_line_split_index`	Long	PKFK
`requisition_id`	String	PKFK

customer_contract_amendment_line_data

Column	Type	Keys
`line_number`	Double	PK
`customer_contract_amendment_id`	String	PKFK
`line_company_id`	String	FK
`allocation_percentage`	Double
`billable_transaction_tax`	Boolean
`billing_schedule_from_date`	LocalDate
`billing_schedule_to_date`	LocalDate
`bundle_line_number`	Double
`contract_line_description`	String
`contract_line_type`	String
`customer_contract_line_end_date`	LocalDate
`customer_contract_line_start_date`	LocalDate
`deferred_revenue`	Boolean
`document_status`	String
`exclude_from_calculation`	Boolean
`extended_amount`	Double
`fair_value_extended_amount`	Double
`fair_value_unit_price`	Double
`first_installment_amount`	Double
`frequency_behavior`	String
`last_installment_amount`	Double
`line_billing_notes`	String
`line_invoice_memo`	String
`line_invoice_memo_override`	String
`line_item_description_override`	String
`list_extended_amount`	Double
`list_unit_price`	Double
`lower_range_percentage`	Double
`mid_range`	Double
`new_business`	Boolean
`number_of_installments`	Double
`quantity`	Double
`quantity_2`	Double
`range_high`	Double
`range_low`	Double
`recalculate_fv_unit_price`	Boolean
`receivable_contract_line_reference_code`	String
`regular_installment_amount`	Double
`relative_selling_price_allocation`	Double
`renewable`	Boolean
`revenue_recognition_line_notes`	String
`revenue_treatment`	String
`tax_applicability`	String
`tax_code`	String
`unit_cost`	Double
`unit_of_measure`	String
`unit_of_measure_2`	String
`upper_range_percentage`	Double
`use_standard_rate_sheet`	Boolean
`withholding_tax_code`	String
`zero_revenue`	Boolean

supplier_contact_instant_messenger

Column	Type	Keys
`id`	String	PK
`supplier_id`	String	FK
`instant_messenger_address`	String
`instant_messenger_code`	String
`instant_messenger_comment`	String
`instant_messenger_type`	String

payment_message

Column	Type	Keys
`id`	String	PK
`create_date`	Instant
`create_date_sequence`	Double
`payment_count`	Double
`payment_message_id`	String
`payments_sum`	Double

allocation_definition_basis_group_by_worktag

Column	Type	Keys
`worktag_type_id`	String	PK
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`source_type_id`	String	PKFK
`worktag_type_code`	String

revenue_category_allowed_worktags

Column	Type	Keys
`allowed_worktag_id`	String	PKFK
`revenue_category_id`	String	PKFK
`worktag_type_id`	String	PKFK
`allowed_worktag_code`	Json

sales_item_fair_value_price_list_worktag

Column	Type	Keys
`effective_date`	LocalDate	PK
`accounting_worktag_type_id`	String	PKFK
`sales_item_fair_value_price_list_id`	String	PKFK

receipt_adjustment_item_line

Column	Type	Keys
`id`	String	PK
`advanced_ship_notice_line_id`	String	FK
`purchase_order_id`	String	FK
`receipt_adjustment_id`	String	FK
`actual_quantity_received`	Double
`deliver_to_location`	String
`deliver_type`	String
`extended_amount`	Double
`item_description`	String
`item_id`	String
`memo`	String
`original_quantity_received`	Double
`purchase_order_line_id`	String
`purchase_order_line_number`	String
`receipt_adjustment_reason`	String
`receipt_line_id`	String
`spend_category_code`	String
`supplier_contract_line_id`	String
`unit_cost`	Double
`unit_of_measure_code`	String

account_posting_rule_condition_value_group

Column	Type	Keys
`index`	Long	PK
`account_posting_rule_condition_index`	Long	PKFK
`account_posting_rule_index`	Long	PKFK
`account_posting_rule_set_id`	String	PKFK
`account_posting_rule_condition_reference`	Json
`account_posting_rule_condition_value_id`	String
`is_intercompany_affiliate`	Boolean
`is_interworktag_affiliate`	Boolean

organization_role

Column	Type	Keys
`role_id`	String	PK
`organization_id`	String	PKFK
`organization_role_code`	String
`organization_role_descriptor`	String

receipt_line_goods_item

Column	Type	Keys
`index`	Int	PK
`receipt_id`	String	PKFK
`commodity_code_id`	String	FK
`purchase_item_id`	String	FK
`purchase_order_goods_line_id`	String	FK
`purchase_order_id`	String	FK
`deliver_to`	String
`deliver_type`	String
`goods_delivery_line_number`	String
`memo`	String
`packaging_string`	String
`purchase_order_line_id`	String
`purchase_order_line_number`	String
`quantity`	Double
`ship_to_address`	String
`supplier_contract_line_id`	String
`unit_of_measure_code`	String

customer_contract_worktag

Column	Type	Keys
`worktag_id`	String	PKFK
`customer_contract_id`	String	FK

billing_installment

Column	Type	Keys
`index`	Long	PK
`billing_schedule_id`	String	PKFK
`invoice_type_id`	String	FK
`payment_terms_id`	String	FK
`payment_type_id`	String	FK
`billing_installment_code`	String
`delete_installment`	Boolean
`due_date`	LocalDate
`from_date`	LocalDate
`installment_date`	LocalDate
`invoice_memo`	String
`on_hold`	Boolean
`override_invoice_header`	Boolean
`po_number`	String
`to_date`	LocalDate
`total_amount`	Double

supplier_invoice_request

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`payment_term_id`	String	FK
`statutory_invoice_type_id`	String	FK
`supplier_connection_id`	String	FK
`supplier_id`	String	FK
`supplier_invoice_id`	String	FK
`additional_reference_number`	String
`canceled_on_date`	LocalDate
`control_total_amount`	Double
`due_date`	LocalDate
`freight_amount`	Double
`handling_code`	String
`invoice_date`	LocalDate
`invoice_received_date`	LocalDate
`invoice_request_document_status`	String
`invoice_request_number`	String
`invoice_request_total_amount`	Double
`memo`	String
`supplier_invoice_request_code`	String
`suppliers_invoice_number`	String
`tax_amount`	Double

billing_schedule_prepaid_mapping

Column	Type	Keys
`id`	String	PK
`billing_schedule_id`	String	PKFK
`prepaid_installment_and_mapping_id`	String	PKFK
`prepaid_mapping_code`	String
`prepaid_mapping_from_date`	LocalDate
`prepaid_mapping_to_date`	LocalDate

customer_refund_document

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`customer_id`	String	FK
`payee_id`	String	FK
`payment_type_id`	String	FK
`customer_refund_date`	LocalDate
`document_payment_status`	String
`document_status`	String
`memo`	String
`submit`	Boolean
`total_refund_amount`	Double

supplier_to_supplier_classification

Column	Type	Keys
`supplier_classification_id`	String	PKFK
`supplier_id`	String	PKFK

resource_forecast

Column	Type	Keys
`id`	String	PK
`project_code`	String
`project_id`	String
`resource_forecast_code`	String

catalog_item_pricing

Column	Type	Keys
`supplier_item_pricing_data_effective_date`	LocalDate	PK
`catalog_item_id`	String	PKFK
`conversion_factor`	Double
`default_unit_of_measure`	Boolean
`inactive`	Boolean
`just_in_time`	Boolean
`lead_time`	Double
`minimum_order_quantity`	Double
`unit_price`	Double

allocation_source_ledger_account_summary

Column	Type	Keys
`account_set_id`	String	PKFK
`allocation_definition_name`	String	PKFK
`basis_allocation_method_id`	String	PKFK
`fiscal_schedule_id`	String	PKFK
`ledger_account_summary_id`	String	PKFK
`source_type_id`	String	PKFK
`ledger_account_summary_code`	String

inventory_stock_request

Column	Type	Keys
`id`	String	PK
`freight_amount`	Double
`inventory_stock_request_code`	String
`is_high_priority`	Boolean
`memo`	String
`order_date`	LocalDate
`other_charges_amount`	Double
`target_fulfillment_date`	LocalDate
`total_order_amount`	Double

ticket_detail

Column	Type	Keys
`id`	String	PK
`expense_credit_card_transaction_id`	String	FK
`booking_date`	LocalDate
`commodity_code`	String
`computer_reservation_system`	String
`customer_code`	String
`departure_tax_amount`	Double
`domestic_indicator`	Boolean
`exchange_fee_amount`	Double
`exchange_ticket_amount`	Double
`exchange_ticket_indicator`	Boolean
`exchange_ticket_number`	String
`exchange_ticket_number_2`	String
`fare_block_four`	String
`fare_block_one`	String
`fare_block_three`	String
`fare_block_two`	String
`fare_calculation_mode_indicator`	String
`final_destination_city`	String
`iata_client_code`	String
`invoice_date`	LocalDate
`issue_date`	LocalDate
`issuing_carrier`	String
`number_of_legs`	Double
`original_issue_ticket_number`	String
`passenger_name`	String
`pnr_record_locator`	String
`refund_indicator`	Boolean
`refund_number`	String
`restricted_ticket_indicator`	Boolean
`tax_exempt_indicator`	Boolean
`ticket_number`	String
`ticket_routing_type`	String
`ticket_type`	String
`tmc_client_account_number`	String
`tmc_is_merchant`	Boolean
`total_fare`	Double
`total_fees`	Double
`total_tax_amount`	Double
`travel_agency_code`	String
`travel_agency_invoice_number`	String
`travel_agency_name`	String
`travel_agency_product_code`	String
`travel_authorization_code`	String

billing_installment_line_worktag

Column	Type	Keys
`billing_installment_id`	Long	PKFK
`billing_installment_line_id`	Long	PKFK
`billing_schedule_id`	String	PKFK
`worktag_id`	String	PKFK