R31802A

-- ============================================================
-- Program: R31802A Manufacturing Accounting Journal Entries — the batch job that turns unaccounted work-in-process and completion units into G/L journal entries and updates production cost records.
-- Purpose: Manufacturing Accounting Journal Entries — the batch job that turns unaccounted work-in-process and completion units into G/L journal entries and updates production cost records. — auto-generated boilerplate from program-table-map
-- Grain  : One row per F0911
-- Tables : F0911
-- 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: F3102, F3111, F3112, F4801 are cataloged for this program, but no verified join condition connects them to F0911, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.GLDCT AS "Document type of the journal entry (JE, PV, RI, etc.).",
  h.GLDOC AS "Document number of the journal entry.",
  h.GLKCO AS "Company that assigned the document number (key company).",
  CASE WHEN h.GLDGJ IS NULL OR h.GLDGJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(h.GLDGJ AS INT) DIV 1000, 1, 1), CAST(h.GLDGJ AS INT) % 1000 - 1) END AS "G/L date driving the fiscal period the line posts to.",  -- CYYDDD Julian → DATE
  h.GLJELN AS "Line number within the journal entry.",
  h.GLEXTL AS "Line extension code completing the unique key.",
  h.GLLT AS "Ledger type the line belongs to (AA actual, CA foreign currency, etc.)."
FROM <catalog>.<schema_data>.f0911 h
WHERE
  h.GLDCT = '<DCT>'
  AND h.GLDOC = <DOC>
  AND h.GLKCO = '<KCO>'
ORDER BY h.GLDCT;