F0010

-- ============================================================
-- Table  : F0010 One row of setup constants per company: fiscal calendar assignment, current periods, base currency, and A/R and A/P aging configuration.
-- Purpose: Column-selected read of F0010 — auto-generated from field metadata
-- Grain  : One row per CCCO
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. 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.
-- ============================================================
SELECT
  f.CCCO AS "Company code; the key every financial table carries as CO or KCO.",
  f.CCNAME AS "Company name as printed on reports.",
  f.CCALTC AS "Longer alternate company name.",
  CASE WHEN f.CCDFYJ IS NULL OR f.CCDFYJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.CCDFYJ AS INT) DIV 1000, 1, 1), CAST(f.CCDFYJ AS INT) % 1000 - 1) END AS "Start date of the company's current fiscal year.",  -- CYYDDD Julian → DATE
  f.CCPNC AS "Current G/L accounting period for the company.",
  f.CCCRYR AS "Flag controlling whether multi-currency processing is active for the company.",
  f.CCCRCD AS "Company base (domestic) currency; compare against transaction currency for FX analysis.",
  f.CCCALD AS "Number of accounting periods in the company's normal year.",
  f.CCDTPN AS "Fiscal date pattern the company follows; joins to F0008.",
  f.CCPNF AS "Current period used for financial reporting, which can trail the G/L period.",
  f.CCDFF AS "Fiscal year used for financial reporting.",
  f.CCTXBM AS "Month the company's tax year begins.",
  f.CCABIN AS "Flag to keep account balances by currency in F0902.",
  f.CCBKTX AS "Flag enabling detailed currency restatement processing.",
  f.CCAGEM AS "Aging method the company uses for receivables buckets.",
  f.CCAGE AS "Which date (invoice, due, or G/L) drives receivables aging.",
  CASE WHEN f.CCDAG IS NULL OR f.CCDAG = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.CCDAG AS INT) DIV 1000, 1, 1), CAST(f.CCDAG AS INT) % 1000 - 1) END AS "As-of date used when aging receivables.",  -- CYYDDD Julian → DATE
  f.CCCRDY AS "Day span of the current (not yet aged) receivables bucket.",
  f.CCAGR1 AS "Upper day boundary of aging bucket 1.",
  f.CCAGR2 AS "Upper day boundary of aging bucket 2.",
  f.CCAGR3 AS "Upper day boundary of aging bucket 3.",
  f.CCAGR4 AS "Upper day boundary of aging bucket 4.",
  f.CCAGR5 AS "Upper day boundary of aging bucket 5.",
  f.CCAGR6 AS "Upper day boundary of aging bucket 6.",
  f.CCAGR7 AS "Upper day boundary of aging bucket 7.",
  f.CCARPN AS "Current accounts receivable period.",
  f.CCAPPN AS "Current accounts payable period.",
  CASE WHEN f.CCARFJ IS NULL OR f.CCARFJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.CCARFJ AS INT) DIV 1000, 1, 1), CAST(f.CCARFJ AS INT) % 1000 - 1) END AS "Start date of the A/R fiscal year.",  -- CYYDDD Julian → DATE
  CASE WHEN f.CCAPFJ IS NULL OR f.CCAPFJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.CCAPFJ AS INT) DIV 1000, 1, 1), CAST(f.CCAPFJ AS INT) % 1000 - 1) END AS "Start date of the A/P fiscal year.",  -- CYYDDD Julian → DATE
  f.CCAN8 AS "Address book number representing the company itself; joins to F0101."
FROM <catalog>.<schema_data>.f0010 f
WHERE
  f.CCCO = '<CO>'
ORDER BY f.CCCO;