© 2025 Crunchtime - All Rights Reserved | www.crunchtime.com | 1 Inventory & Labor API to Database Mapping Reference Guide Document Details Document #: 160_APIDB_250404 Overview This guide outlines which Crunchtime database tables are referenced as part of the various API Services. Related Documentation • Crunchtime Developer Hub: https://developer.crunchtime.com • Standard Interface Guide: https://links.crunchtime.com/RG-StandardInterfaceReference • Crunchtime Aha! Ideas Portal QuickStart Guide: https://links.crunchtime.com/QS-IdeasPortal • Crunchtime Data Dictionary: https://links.crunchtime.com/OpsM-DataDictionary Download the latest version of this document here: https://links.crunchtime.com/RG-InvLaborAPItoDBmapping … or scan the QR code to the left.
© 2025 Crunchtime - All Rights Reserved | www.crunchtime.com | 2 REFERENCE GUIDE Integration Inventory & Labor API to Database Mapping Introduction Initially the Crunchtime API Services were built as an alternative to flat-file imports using the Crunchtime Data Pump (CDP). As such, the primary fields exposed on the /get calls are the same fields needed in order to import and /post data. In addition to the Developer Hub, the Standard Interface Guide is a good resource to reference for data points that are exposed. Since the original creation of the APIs, additional objects have been exposed and new objects will continue to be exposed. The Aha! Ideas Portal is the correct tool to request exposure of additional data elements via API. API Service Related Database Tables Application User API t_user_hierarchy, t_hierarchy_detail, t_hierarchy, t_concept, t_dash_report, t_user_consolidator, t_franchise, t_user_franchise Category API t_category, t_gl Check Menu Mix API t_supply, t_location, t_inv_hdr_pos, t_inv_dtl_pos_check, t_inv_dtl_pos_check_plu, t_inv_dtl_pos_check_excl_cns, t_recipe, t_revenue_center, t_pos_time, t_inv_dtl_pos_check_times, t_pos_misc, t_inv_dtl_pos_check_misc, t_inv_dtl_pos_check_plu_misc Company Product Enhanced API t_product_company, t_category, t_product_company_comments, t_haccp_compliance, t_tax_table_hdr, t_shipping_type, t_package_type, t_country, t_state, t_bid_sheet, t_bid, t_product_company_upc, t_product_company_location, t_location, t_product_company_aa, t_allergens_attributes_types, t_allergens_attributes, t_product_company_co_dept, t_company_department, t_product_concept, t_concept, t_product_company_fact, t_fact Confirm Receipt Standard API t_inv_hdr_vendor_order, t_location, t_supply, t_user Currency Ratio API t_currency_ratio, t_currency Customer Order Enhanced API t_inv_hdr_customer_order, t_location, t_supply, t_daypart, t_revenue_center, t_user, t_production, t_production_catering, t_inv_dtl_customer_order, t_product_company, t_package_type, t_storage, t_tax_table_hdr Customer API t_location, t_supply, t_city, t_state, t_country Employee API t_employee, t_location, t_employee_termination, t_state, t_country, t_employee_ethnic_group, t_employee_union, t_employee_marriage_status, t_employee_status, t_employee_minor_program, t_employee_employee_position, t_employee_position, t_employee_alt_location, t_employee_audit, t_audit, t_gl, t_gl_grouping, t_employee_skill_level, t_wage_matrix_dtl, t_city, t_state, t_market, t_app_label_text, t_label_configuration (Continued) Tip: See the following related materials: • Crunchtime Developer Hub: https://developer.crunchtime.com • Standard Interface Guide: https://links.crunchtime.com/RG-StandardInterfaceReference • Crunchtime Aha! Ideas Portal QuickStart Guide: https://links.crunchtime.com/QS-IdeasPortal • Crunchtime Data Dictionary: https://links.crunchtime.com/OpsM-DataDictionary Note: Not all fields in each database table are exposed via the associated APIs.
© 2025 Crunchtime - All Rights Reserved | www.crunchtime.com | 3 Integration Inventory & Labor API to Database Mapping (Continued) API Service Related Database Tables General Ledger API t_gl, t_gl_grouping Hierarchy API t_hierarchy, t_hierarchy_detail, t_location, t_hierarchy_level Inventory Adjustment API t_inv_hdr_action, t_location, t_daypart, t_user, t_inv_dtl_action, t_lot, t_product_company, t_storage, t_qualitative, t_package_type Inventory Value Adjustment API t_inv_hdr_action, t_location, t_product_company, t_inv_dtl_action, t_qualitative Physical Inventory Standard API t_hdr_inventory_schedule, t_dtl_inventory_schedule, t_storage, t_user, t_product_company Location API t_location, t_city, t_state, t_franchise, t_country, t_country_codes, t_market, t_currency, t_loc_dash_task_posting_grp, t_location_twx_time_clock, t_location_concept, t_concept, t_location_deliver_to, t_location_uda, vw_uda Location Product Pricing API t_location, t_product_company, t_product_location, t_storage, t_sequence, t_product_pricing, t_package_type Package Type API t_package_type, t_edi_unit_codes PBI (Purchase By Invoice) API t_tran_hdr_category, t_supply, t_location, t_tran_dtl_category, t_category, t_gl Projected Consumption API t_product_location_proj_cons, t_location, t_product_company Purchase Order API t_inv_hdr_vendor_order, t_inv_dtl_vendor_order, t_inv_hdr_vendor_order_msg, t_product_company, t_storage, t_lot, t_location, t_user, t_supply, t_currency, t_location_deliver_to, t_qualitative, t_extract_history, t_tax_table_hdr, t_package_type, t_market, t_gl Recipe Enhanced API t_recipe, t_product_company, t_category, t_package_type, t_recipe_group, t_haccp_compliance, t_prep_station, t_recipe_component, t_recipe_special_inst, t_recipe_component_subst, t_product_company_upc, t_product_company_location, t_location, t_product_company_aa, t_allergens_attributes_types, t_allergens_attributes, t_product_concept, t_concept Recipe Location API t_recipe_location, t_product_company, t_recipe, t_location Sales Forecast API t_sales_forecast_15min_rev_ctr, t_revenue_center, t_location, t_times, t_sales_forecast_day, t_user_location Sales Mix API t_sales, t_pos, t_sales_breakout, t_gl, t_daypart, t_sales_sales_tax, t_sales_paid_outs, t_sales_non_cash, t_sales_comps, t_sales_deposit Scheduled Export API t_export_field, t_export_src_field, t_export_src_rec, t_extract_history, t_export_src_field, t_export_field_custom, t_inv_hdr_vendor_order, t_inv_hdr_vendor_order_files, t_supply, t_location, t_tran_hdr_category, t_tran_hdr_category_files (Continued)
© 2025 Crunchtime - All Rights Reserved | www.crunchtime.com | 4 Integration Inventory & Labor API to Database Mapping (Continued) API Service Related Database Tables Supplemental Wage API t_labor_actual_shift, t_supplemental_wage, t_employee_position, t_location, t_employee Time Clock Enhanced API t_labor_actual_day, t_labor_actual_shift, t_employee, t_location, t_employee_position, t_labor_actual_shift_unpaid UDA API t_location, t_location_uda, vw_uda, t_supply, t_supply_uda, t_uda, t_gl_uda, t_gl Vendor API t_supply, t_city, t_state, t_currency, t_country, t_country_codes, t_supply_uda, vw_uda Vendor Location API t_supply_location_schedule, t_supply, t_location, t_supply_location, t_supply_location_loc, t_vendor_bid_product, t_market_secondary Vendor Payment API t_inv_hdr_vendor_order, t_supply, t_location, t_inv_hdr_vendor_order_pay, t_tran_hdr_category, t_tran_hdr_category_pay Vendor Product Pricing API t_vendor_bid_product, t_vendor_bid_product_sec, t_market_product_master, t_contract_price, t_product_company, t_package_type, t_supply, t_market, t_bid