Jib Prelist

JIB Prelist (ODA Report 720)

Preview of JIB charges before posting to the general ledger. Useful for validating charges, reviewing partner splits, and planning for the billing cycle close.

Data Source

• Model: gold_fct_jib (GOLD_FINANCIAL schema)
• System: Snowflake FO_PRODUCTION_DB via MCP

Parameters

• jib_cycle_start (required): Start date of JIB billing cycle (YYYY-MM-DD)
• jib_cycle_end (required): End date of JIB billing cycle (YYYY-MM-DD)
• company_code (optional): Filter by company code (default: '200')
• well_code (optional): Filter by specific well code
• partner_code (optional): Filter by specific partner code

Output Columns

• Company