Generates a JIB Suspense report showing Joint Interest Billing charges held in suspense pending resolution. Displays charges awaiting division orders, ownership dispute resolution, or other clearing items. Queries gold_fct_jib_suspense from Snowflake and exports to Excel with well grouping and suspense reason analysis.
JIB charges held in suspense pending resolution. Tracks charges awaiting division orders, ownership disputes, or other clearing items that prevent posting to the general ledger.
as_of_date (optional): Report date for suspense aging (YYYY-MM-DD); defaults to todaycompany_code (optional): Filter by company code (default: '200')well_code (optional): Filter by specific well codepartner_code (optional): Filter by specific partner codeJIB Suspense - {as_of_date}.xlsxThe gold_fct_jib_suspense model is currently under development. This skill will be fully functional once the model is promoted to production.