Coupa

Coupa is a cloud platform for business spend management that offers value through real-time spend visibilIty, control, compliance, and agilIty.

Sync Coupa data to Sourcetable

Build reports once. Connect to Coupa and start modeling from live data.
Here's a sample of the Coupa data that will be available in your Sourcetable spreadsheets:
ACCOUNT

Helps mimic your business' financial structure

ACCOUNT_TYPE

Includes primary_address_id ,primary_contact_id ,currency_id ,created_by_id ,updated_by_id ,active ,created_at ,legal_entIty_name ,name ,updated_at

ACCOUNT_VALIDATION_RULE

Inlcudes account_type_id , created_by_id ,updated_by_id ,active ,created_at ,description ,error_message ,name ,updated_at and segment_* .

ADDRESS

Address API can be used to query, create, or update personal or supplier remIt-to address information.

APPROVAL

Approvals API can be used to create, update, or query the approval of a document and Includes specific endpoints to take action (reject/hold/approve) as well as requisition details like requestor, line items, and shipping details.

ASN_HEADER

Inlcudes created_by_id , updated_by_id , ship_to_address_id ,ship_to_user_id ,ship_to_warehouse_id , supplier_id ,asn_number ,bill_of_landing , container , created_at , delivery_date , export_flag , gross_weight , packing_slip , ship_date , ship_method , ship_note , standard_carrier_alpha_code , status , tracking_number , trailer , uom and updated_at

BUDGET_LINE

Budget line API can be used to create and update budget lines that you have associated wIth your accounts

BUSINESS_GROUP

Content groups can be assigned to users to restrict access to other objects in Coupa.

CHARGE

Includes account_type_id ,created_by_id ,merchant_currency_id ,order_header_id ,statement_id ,supplier_id ,updated_by_id ,virtual_card_id ,card_provider_account ,charge_date ,created_at ,exported ,external_ref_id ,last_exported_at ,mcc ,statement_name,supplier_name ,total ,updated_at

COMMODITY

Includes created_by_id , parent_id , updated_by_id ,active ,category ,created_at ,deductibilIty ,name ,sub_category and updated_at

COMMODITY_TRANSLATION

Includes commodIty_id ,created_at ,locale ,name and updated_at

CONTRACT

Contracts API can be used to create, update, or query a contract and includes the business groups involved, key dates, the status of the contract, and the financial terms.

CONTRACT_TEMPLATE

Includes id ,created_by_id , updated_by_id ,active , authoring_method ,created_at , description ,hierarchy_type ,name and updated_by

CURRENCY

Includes id ,created_by_id , updated_by_id ,code ,decimals ,enabled ,name and symbol

DATA_FILE_SOURCE

Includes id , created_by_id , updated_by_id , end_time ,file_content_type,file_file_name ,file_file_size ,integration_id ,integration_run_id ,progress ,records_count ,records_created ,records_updated ,result_text , source_for ,start_time ,status ,type , updated_at and upload_errors_count

DEPARTMENT

It used to mimic your business' operating structure and organize content groups and users accordingly.

EXCHANGE_RATE

It used to manage exchange rates for currencies your company uses to pay for goods.

EXPENSE_LINE

Includes id , account_id , accounting_total_currency_id ,created_by_id , currency_id , expense_category_id ,expense_line_imported_data_idexpense_line_mileage_id , expense_line_per_diem_id ,expense_line_preapproval_id ,expense_report_id ,foreign_currency_id , integration_id ,order_line_id ,period_id , receipt_total_currency_id and So on

EXPENSE_REPORT

Inlcudes id , created_by_id, currency_id ,expensed_by_id ,payment_id , reimbursable_total_currency_id , submItted_by_id , updated_by_id , audIt_score , audItor_note , created_at , exported , external_src_schema and So on

INTEGRATION

Includes id ,business_object ,code ,created_at ,direction ,end_system ,end_system_type ,integration_type ,name ,standard and updated_at

INTEGRATION_CONTACTS

Includes id ,contact_alert_type ,contactable_id ,contactable_type ,created_at ,created_by_id ,updated_at and updated_by_id

INTEGRATION_ERROR

Includes id , created_by_id , integration_id , integration_run_id , updated_by_id ,contact_alert_type, created_at, creation_method , document_id ,document_revision ,document_status , document_type ,external_id ,integration_filename , resolved ,status and updated_at

INTEGRATION_HISTORY_RECORD

Includes id ,created_by_id ,integration_id ,integration_run_id ,updated_by_id ,inventory_transaction_id ,invoice_header_id ,order_header_id ,contact_alert_type ,created_at ,creation_method ,document_id ,document_revision ,document_status ,document_type ,external_id ,resolved ,status and updated_at

INTEGRATION_RUN

Includes id , integration_id ,created_at ,end_time ,records_processed ,start_time ,status ,total_records and updated_at

INVENTORY_TRANSACTION

Includes id , account_id ,asn_header_id ,asn_line_id ,created_by_id ,currency_id ,from_warehouse_id ,from_warehouse_location_id ,inspection_code_id ,Item_id ,order_line_id ,receipt_id and to_warehouse_id

INVOICE_HEADER

Includes id , abandon_reason_id , account_type_id ,bill_to_address_id ,account_holder_type ,contract_id ,created_by_id ,currency_id ,destination_country_id ,invoice_from_address_id ,legal_destination_country_id ,origin_country_id ,payment_term_id ,remIt_to_address_id ,requested_by_id ,ship_from_address_id ,ship_to_address_id and shipping_term_id

ITEM

Item API is used to create, update, or query goods not provided by suppliers that your employees will select from when creating a requisItion.

LOOKUP_VALUE

Lookup values API is used to create a hierarchy of accounts

ORDER_HEADER

Includes id ,created_by_id ,currency_id , payment_term_id ,pcard_id ,requester_id ,requisItion_header_id ,ship_to_address_id ,ship_to_user_id ,shipping_term_id ,supplier_id ,updated_by_id ,acknowledged_at acknowledged_flag

ORDER_HEADER_CHANGE

Includes id , created_by_id , current_approval_id ,department_id ,reject_reason_id , acknowledged_at ,created_at ,exported ,justification ,order_header_id ,payment_method ,po_number ,price_hidden ,requisItion_header_id ,ship_to_attention ,status , supplier_inItiated ,transmission_emails , transmission_method_override , updated_at and version

ORDER_PAD

Includes id ,base_value_currency_id ,created_by_id ,updated_by_id ,add_all_Items ,any_supplier ,base_value ,created_at , locked ,name ,updated_at and use_base_value

PAYMENT

Includes id ,created_by_id ,updated_by_id ,amount_paid ,check_number ,created_at ,notes ,payable_id ,payable_type , payment_date and updated_at

PAYMENT_TERM

Includes id ,created_by_id ,updated_by_id ,active ,code ,created_at ,days_for_discount_payment ,days_for_net_payment description and discount_rate

PCARD

Includes id ,created_by_id ,updated_by_id ,active ,created_at ,expiry ,name ,nickname ,number ,shared and updated_at

PROJECT

Includes id , commodIty_id , created_by_id ,updated_by_id ,active ,created_at ,description ,display_date_range_warning ,end_date ,mention_name ,name ,open ,start_date and updated_at

QUOTE_REQUEST

Includes id ,allow_award_individual_line_Item ,allow_multiple_response ,automatic_bid_unsealing , comments ,description ,end_time ,event_type , sealed_bids ,sealing_type ,start_on_submIt ,start_time and timezone.

REQUISITION_HEADER

Includes id , approver_id , created_by_id , currency_id ,current_approval_id , department_id , pcard_id , receiving_warehouse_id ,requested_by_id ,ship_to_address_id ,updated_by_id , buyer_note ,created_at , exported ,justification ,line_count , mobile_total ,need_by_date ,price_hidden ,reject_reason_commentship_to_attention , status ,submItted_at , total and updated_at

REQUISITION_LINE

Includes account_id , commodIty_id ,contract_id ,created_by_id ,currency_id ,Item_id ,order_line_id ,order_pad_line_id ,payment_term_id , period_id ,punchout_sIte_id ,shipping_term_id , supplier_id , uom_id , updated_by_id , requisItion_header_id ,created_at and So on.

SHIPPING_TERM

Includes id ,created_by_id ,updated_by_id ,active , code , created_at ,description and updated_at

SUPPLIER

It used to create, update, and query the suppliers in Coupa.

SUPPLIER_RISK_AWARE_FEED

Includes id ,supplier_id ,created_at ,number_field_01 ,number_field_02 ,number_field_03 ,number_field_04 ,number_field_05 ,number_field_06 ,number_field_07 ,number_field_08 ,number_field_09 ,number_field_10 and updated_at

TAX_REGISTRATION

Includes id ,created_by_id ,country_id ,updated_by_id ,active ,created_at ,local ,number ,owner_id ,owner_type and updated_at

USER

It used to create, update, or query users and it ranges from basic demographics, to managing passwords, to managing the groups and approval permissions

USER_GROUP

Includes id ,created_by_id ,owner_id ,updated_by_id ,active , can_approve ,created_at ,description ,mention_name ,name , open ,type and updated_at

USER_GROUP_MEMBERSHIP

Includes id , user_group_id , user_id,created_at,owner,participant and updated_at

VIRTUAL_CARD

Includes id ,created_by_id ,currency_id ,order_header_id , requested_by_id ,updated_by_id ,card_number ,card_type ,coupa_pay_id created_at,credit_account, document_id ,document_type ,expiry_month , expiry_year ,external_ref_id ,name status ,total_booked ,total_charged , updated_at ,valid_from and valid_to