P0010

-- ============================================================
-- Program: P0010 Company Names & Numbers — set up companies and their fiscal date patterns for financial reporting
-- Purpose: Company Names & Numbers — set up companies and their fiscal date patterns for financial reporting — auto-generated boilerplate from program-table-map
-- Grain  : One row per F0010
-- Tables : F0010
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- Omitted: F0008 is cataloged for this program, but no verified join condition connects it to F0010, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.CCCO AS "Company code; the key every financial table carries as CO or KCO.",
  h.CCNAME AS "Company name as printed on reports."
FROM <catalog>.<schema_data>.f0010 h
WHERE
  h.CCCO = '<CO>'
ORDER BY h.CCCO;