new_0222_0325|NAPA|Short Name|0|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|sga_expense|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return
new_0222_0325|NAPA|Long Name|1|1|The Duckhorn Portfolio Inc Total Current Assets (Quarterly) (USD)|The Duckhorn Portfolio Inc Cash and Short Term Investments (Quarterly) (USD)|The Duckhorn Portfolio Inc Inventories (Quarterly) (USD)|The Duckhorn Portfolio Inc Net PP&E (Quarterly) (USD)|The Duckhorn Portfolio Inc Goodwill and Intangibles (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Current Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Long Term Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Deposits (Quarterly) (USD)|The Duckhorn Portfolio Inc Book Value (Quarterly) (USD)|The Duckhorn Portfolio Inc Retained Earnings (Quarterly) (USD)|The Duckhorn Portfolio Inc Treasury Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc EV to Revenues|The Duckhorn Portfolio Inc EV to Earnings|The Duckhorn Portfolio Inc EV to Free Cash Flow|The Duckhorn Portfolio Inc EV to Assets (Quarterly)|The Duckhorn Portfolio Inc PS Ratio|The Duckhorn Portfolio Inc PE Ratio|The Duckhorn Portfolio Inc Price to Book Value|The Duckhorn Portfolio Inc PEG Ratio|The Duckhorn Portfolio Inc Debt to Equity Ratio|The Duckhorn Portfolio Inc Dividend Yield|The Duckhorn Portfolio Inc Shareholder Yield (TTM)|The Duckhorn Portfolio Inc Percent of Shares Outstanding Short|The Duckhorn Portfolio Inc Total Receivables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Payables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Return on Invested Capital|The Duckhorn Portfolio Inc Quality Ratio Score|The Duckhorn Portfolio Inc Momentum Score|The Duckhorn Portfolio Inc Beta (1Y)|The Duckhorn Portfolio Inc Sustainable Growth Rate (TTM)|The Duckhorn Portfolio Inc Institutional Investor Ownership Percentage|The Duckhorn Portfolio Inc Average Diluted Shares Outstanding (Quarterly)|The Duckhorn Portfolio Inc Total Employees (Annual)|The Duckhorn Portfolio Inc EPS Diluted (Quarterly) (USD)|The Duckhorn Portfolio Inc Shares Outstanding|The Duckhorn Portfolio Inc Repurchase of Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Ordinary Shares Number (Quarterly)|The Duckhorn Portfolio Inc Payout Ratio|The Duckhorn Portfolio Inc Quick Ratio (Quarterly)|The Duckhorn Portfolio Inc Normalized Diluted EPS (Quarterly) (USD)|The Duckhorn Portfolio Inc Stock Buybacks (Quarterly) (USD)|The Duckhorn Portfolio Inc Effective Tax Rate (TTM)|The Duckhorn Portfolio Inc Return on Equity|The Duckhorn Portfolio Inc Net Income (TTM) (USD)|The Duckhorn Portfolio Inc Revenue (TTM) (USD)|The Duckhorn Portfolio Inc Dividend Per Share (Quarterly) (USD)|The Duckhorn Portfolio Inc Revenue (Quarterly) (USD)|The Duckhorn Portfolio Inc Gross Profit (Quarterly) (USD)|The Duckhorn Portfolio Inc SG&A Expense (Quarterly) (USD)|The Duckhorn Portfolio Inc Pre-Tax Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Interest Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Price (USD)|The Duckhorn Portfolio Inc Total Return Price (USD)|The Duckhorn Portfolio Inc Enterprise Value (USD)|The Duckhorn Portfolio Inc 30-Day Average Daily Volume|The Duckhorn Portfolio Inc 1 Year Price Returns (Daily)
new_0222_0325|NAPA|Unit|2|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric
new_0222_0325|NAPA||4|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|quarterly
new_0222_0325|NAPA||5|5|109.8|109.8|109.8|109.8|109.8|109.8|109.8|109.8|0|109.8|109.8|0|1.43137254902|92|1.42857142857|92|1.43137254902|1.43137254902|1.43137254902|1.44210526316|91.5|1.44268774704|92|15.1818181818|109.8|109.8|109.8|92|92|0|0|92|30.3636363636|91.375|181|91.375|35.5|0|109.8|91.4|91.5|91.375|92|91.4|92|91.4|91.4|0|91.375|91.375|91.375|91.375|91.375|91.375|1.44268774704|1.44268774704|1.43137254902|1.44196428571|0
new_0222_0325|NAPA||6|6|5|5|5|5|5|5|5|5|0|5|5|0|255|3|161|3|255|255|255|95|6|253|3|22|5|5|5|3|3|0|0|3|11|8|1|8|10|0|5|5|6|8|1|5|3|5|5|0|8|8|8|8|8|8|253|253|255|224|0
new_0222_0325|NAPA||7|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily
new_0222_0325|NAPA|202001|201912|201912||||||||||||||||||||||||||||||||||110.5859||0.1326||||||0.105|||||||76.993|38.313|18.104|19.917|14.665|-4.854|||||
new_0222_0325|NAPA|202004|202003|202003||||||||||||||||||||||||||||||||||110.5859||0.1051||||||0.1049|||||||68.72|36.342|13.156|15.806|11.619|-4.221|||||
new_0222_0325|NAPA|202007|202006|202006|280.713|6.252|245.311|242.751|633.439|503.987|51.807|452.18||654.047|117.658||||||||||0.5794||||26.464|3.733|1.017|||||||110.5859||-0.0246|||115.0468||0.6315|0.0535|||||||52.231|25.923|16.205|-4.881|-2.723|-4.019|||||
new_0222_0325|NAPA|202010|202009|202009||||||||||||||||||||||||||||||||||110.5859||0.1585||||0||0.1689||24.633||41.084|289.582||91.638|44.275|16.805|23.658|17.523|-3.58|||||
new_0222_0325|NAPA|202101|202012|202012|321.018|9.274|271.674|242.591|629.597|500.359|59.547|440.812||694.149|157.184||||||||||0.5282||||29.736|8.296|1.017|||||||115.0468|413|0.1913|||115.0468|0|0.6551|0.1416||24.9605||48.422|296.246||83.657|41.757|17.471|29.935|22.003|-3.612|||||
new_0222_0325|NAPA|202103|202103|202012|||||||||||||7.7248||||6.327|39.0093|2.7811|||0||1.0711|||||||||24.1178||||115.0468||||||||||||||||||16.78|16.78|2288.4443||
new_0222_0325|NAPA|202104|202103|202103|326.361|5.027|268.825|240.975|627.677|403.494|63.976|339.518||792.957|66.206||7.5508|52.39||2.0056|6.541|46.1877|2.6989||0.3344|0|-2.4781|0.9653|43.955|14.417|1.15|4.3593|3|||-7.5905|24.1582|108.404||0.08|114.3814||114.3814|218.2215|0.7656|0.0776|-187.5|27.6812|6.4206|45.825|317.951||90.425|46.929|31.142|14.645|9.022|-3.755|18.71|18.71|2400.77|644501.3|
new_0222_0325|NAPA|202105|202103|202103|||||||||||||7.3601||||6.3557|44.8794|2.6224|||0||0.8627|||||||||24.0719||||||||||||||||||||||18.18|18.18|2340.1479|287519.9333|
new_0222_0325|NAPA|202106|202106|202103|||||||||||||8.7559||||7.7122|54.4576|3.1821|||0||1.6242|||||||||28.5782||||114.3814||||||||||||||||||22.06|22.06|2783.9477|550565.7|
new_0222_0325|NAPA|202107|202106|202106|314.401|4.244|267.737|240.939|625.756|380.879|56.781|324.098||801.687|73.634||8.2325|49.5066|54.7849|2.3423|7.3344|44.8634|||0.3085|0|-1.9568|1.8626|33.253|3.556|1.15|5.3271|4|||-5.9839|28.3967|115.4604|474|0.06|115.0468||115.0468|178.648|0.6604|0.0606|0|27.2909|7.6084|55.976|336.613||70.893|34.387|24.398|8.74|7.428|-2.671|21.97|21.97|2771.1822|521111.3667|
new_0222_0325|NAPA|202108|202106|202106|||||||||||||8.0685||53.6931||7.1742|43.8832|3.0839|||0||1.5542|||||||||28.3453||||||||||||||||||||||21.49|21.49|2715.9597|292086.8333|
new_0222_0325|NAPA|202109|202109|202106|||||||||||||8.547||56.8773||7.6416|46.742|3.2849|||0||1.5727|||||||||30.6709||||115.0468||||||||||||||||||22.89|22.89|2877.0253|320716.1667|
new_0222_0325|NAPA|202110|202109|202109|392.782|5.247|319.224|244.397|623.835|438.084|129.837|308.247||824.419|94.907||7.0232|41.0575|33.7773|1.9414|6.2911|37.8286|||0.2812|0|1.3222|1.7723|59.618|56.701|1.15|5.6526|3|||-5.3453|30.6901|115.396||0.18|115.0468||115.0468|167.4313|0.4996|0.1803||27.1296|7.927|59.726|349.156||104.181|52.41|23.158|28.69|21.273|-1.606|19.34|19.34|2452.1991|949709.6667|
new_0222_0325|NAPA|202111|202109|202109|||||||||||||6.9804||33.5713||6.2488|37.5744|2.6807|0.999||0||1.2296|||||||||31.3652||||115.0468||||||||||||||||||19.21|19.21|2437.243|659616|
new_0222_0325|NAPA|202112|202112|202109|||||||||||||8.3412||40.1161||7.5923|45.6525|3.2571|1.2137||0||1.3718|||||||||45.6078||||||||||||||||||||||23.34|23.34|2912.3863|588122.6333|
new_0222_0325|NAPA|202201|202112|202112|354.833|4.77|297.531|255.845|621.914|391.227|61.414|329.813||843.498|112.839||6.9898|45.7447|85.8513|2.061|6.2287|41.5833|2.7228|3.5885|0.3004|0|-2.2067|1.2926|43.008|12.171|1.151|5.2269|2|||-5.6038|45.61|115.3895||0.16|115.0652||115.0652|179.6784|0.778|0.1602||27.1185|7.033|55.655|364.235||98.736|49.477|23.814|24.334|17.932|-1.636|19.96|19.96|2545.9214|415218.4|
new_0222_0325|NAPA|202202|202112|202112|||||||||||||6.8824||84.5321||6.1226|40.875|2.6764|3.5274||0||1.4333|||||||||45.6473||||115.0652||||||||||||||||||19.62|19.62|2506.7992|276953.0333|
new_0222_0325|NAPA|202203|202203|202112|||||||||||||6.3643||78.1687||5.6108|37.4583|2.4527|3.2325||0|||||||||||||||||||||||||||||||||17.98|17.98|2318.0923|263449.9333|4.6566