P03B11

-- ============================================================
-- Program: P03B11 Standard Invoice Entry — the screen where A/R invoices and credit memos are entered manually, creating the receivable and its offsetting G/L distribution.
-- Purpose: Standard Invoice Entry — the screen where A/R invoices and credit memos are entered manually, creating the receivable and its offsetting G/L distribution. — auto-generated boilerplate from program-table-map
-- Grain  : F03B11 × F0911, F03012, F0101 — 1:N joins yield one row per detail line
-- Tables : F03B11, F0911, F03012, F0101
-- 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.
-- ============================================================
SELECT
  h.RPDOC AS "Invoice document number",
  h.RPDCT AS "Invoice document type (RI standard invoice, RM credit memo, RU unapplied cash, etc.)",
  h.RPKCO AS "Document company that owns the invoice number sequence",
  h.RPSFX AS "Pay item — one invoice can split into multiple pay items with their own terms",
  h.RPADSC / POWER(10, 2) AS "Discount offered to the customer if paid by the discount due date",  -- implied decimals: 2 (verify in F9210)
  CASE WHEN f.GLDGJ IS NULL OR f.GLDGJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.GLDGJ AS INT) DIV 1000, 1, 1), CAST(f.GLDGJ AS INT) % 1000 - 1) END AS "G/L date driving the fiscal period the line posts to.",  -- CYYDDD Julian → DATE
  f.GLJELN AS "Line number within the journal entry.",
  f.GLEXTL AS "Line extension code completing the unique key.",
  f.GLLT AS "Ledger type the line belongs to (AA actual, CA foreign currency, etc.).",
  f0.AICO AS "Company this customer record applies to; company 00000 holds the default line-of-business record"
FROM <catalog>.<schema_data>.f03b11 h
LEFT JOIN <catalog>.<schema_data>.f0911 f
  ON f.GLDCT = h.RPDCT
 AND f.GLDOC = h.RPDOC
 AND f.GLKCO = h.RPKCO
LEFT JOIN <catalog>.<schema_data>.f03012 f0
  ON f0.AIAN8 = h.RPAN8
LEFT JOIN <catalog>.<schema_data>.f0101 ab
  ON ab.ABAN8 = h.RPAN8
ORDER BY h.RPDOC;