F40205

-- ============================================================
-- Table  : F40205 Line type control constants - defines how each order line type behaves against G/L, inventory, A/R, A/P, and taxes
-- Purpose: Column-selected read of F40205 — auto-generated from field metadata
-- Grain  : One row per LFLNTY
-- 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.LFLNTY AS "Line type code (e.g. S stock, N non-stock, F freight, T text)",
  f.LFLNDS AS "Line type description",
  f.LFLND2 AS "Second description line",
  f.LFGLI AS "Flag: line writes G/L distribution",
  f.LFIVI AS "Inventory interface - whether the line updates on-hand and costs",
  f.LFARI AS "Flag: line posts to accounts receivable",
  f.LFAPI AS "Flag: line posts to accounts payable",
  f.LFRSGN AS "Flag: reverse the sign for credit processing",
  f.LFTXYN AS "Flag: line is text only",
  f.LFPRFT AS "Include the line in sales/COGS gross profit",
  f.LFCDSC AS "Include the line in cash discount calculation",
  f.LFTX01 AS "Line participates in tax calculation 1",
  f.LFTX02 AS "Line participates in tax calculation 2",
  f.LFGLC AS "Default G/L offset class for the line type",
  f.LFPDC1 AS "Print the line on document 1",
  f.LFPDC2 AS "Print the line on document 2",
  f.LFPDC3 AS "Validate non-stock lines against the item master",
  f.LFPDC4 AS "Record variances for the line type",
  f.LFIDC1 AS "Generate a purchase order from the line (direct ship / transfer)",
  f.LFIDC2 AS "Interface to job cost / projects",
  f.LFIDC3 AS "Include the line in document total 3",
  f.LFIDC4 AS "Include the line in document total 4",
  f.LFCSJ AS "Sales journal column the line reports under",
  f.LFDCTO AS "Override order type tied to the line type",
  f.LFART AS "Apply retainage to the line",
  f.LFAFT AS "Apply freight to the line",
  f.LFGWO AS "Generate a work order from the line",
  f.LFEXVR AS "Recognize exchange rate variance for the line",
  f.LFCMI AS "Call materials issue processing",
  f.LFPRRQ AS "Receipt required before the line can be vouchered",
  f.LFEV01 AS "Event point flag 01",
  f.LFEV02 AS "Event point flag 02",
  f.LFEV03 AS "Event point flag 03",
  f.LFEV04 AS "Event point flag 04",
  f.LFEV05 AS "Event point flag 05",
  f.LFNEWR AS "Expense the line at voucher time",
  f.LFSRUF AS "Allow service units on procurement lines",
  f.LFNBRU AS "Non-billable retainage in use"
FROM <catalog>.<schema_data>.f40205 f
ORDER BY f.LFLNTY;