Account Receivable Visibility for Databricks

Name: Account Receivable Visibility for Databricks
Brand: Onibex
SKU: onibex-streamingsolutions-accountreceivablevisibility-databricks

by Onibex

Invoicing visibility system that enables analysis of historical and real-time performance by plant, area, and division.

Reference: onibex-streamingsolutions-accountreceivablevisibility-databricks Platform: Databricks Created by: Onibex

TECHNICAL SPECIFICATIONS

Streaming Method	Databricks
Streaming Time	Real time
Script Language	Pipeline SQL
Implementation Time	15 Hours
Tech Layers	Data Engineering / AI Data Foundation

THIS SOLUTION CONTAINS

Customer Master by Tables

x 1

Sales Billing by Tables

x 1

Sales Order by Tables

x 1

Trading Goods by Tables

x 1

Exchange Rate by Tables

x 1

Taxes Region Text by Tables

x 1

Nielsen Indicator by Tables

x 1

Sales Group Text by Tables

x 1

Customer Group Description by Tables

x 1

Distribution Channel by Tables

x 1

Sales Division by Tables

x 1

Personnel by Tables

x 1

Sales Organization by Tables

x 1

Payment Terms by Tables

x 1

Account Receivable S4HANA by Tables

x 1

Account Receivable Clear Items by Tables

x 1

DESCRIPTION

An invoicing visibility system that enables the analysis of historical and real-time performance by plant, area, and division. It identifies consumption patterns and financial deviations to optimize commercial performance and strategic decision-making.

STREAMING SOLUTION ASSET DETAILS

DATABRICKS SCRIPTS INCLUDED:

onibex-dp-sales-s4h-gold_account_receivable_journal_entries-databricks.py
onibex-dp-sales-s4h-gold_account_receivable_sales_document_consolidation-databricks.py
onibex-dp-sales-s4h-gold_journal_entries_sales_billing_consolidation-databricks.py
onibex-dp-sales-s4h-gold_journal_entries_summary-databricks.py
onibex-dp-sales-s4h-gold_journal_entries_uom-databricks.py
onibex-dp-sales-s4h-gold_sales_document-databricks.py
onibex-dp-sales-s4h-gold_sales_document_summary-databricks.py
onibex-dp-sales-s4h-gold_sales_document_uom-databricks.py
onibex-dp-sales-s4h-silver_fi_currency-databricks.py
onibex-dp-sales-s4h-silver_fi_journal_entries-databricks.py
onibex-dp-sales-s4h-silver_hr_personnel-databricks.py
onibex-dp-sales-s4h-silver_mm_master_material-databricks.py
onibex-dp-sales-s4h-silver_sd_customer_master-databricks.py
onibex-dp-sales-s4h-silver_sd_sales_billing-databricks.py
onibex-dp-sales-s4h-silver_sd_sales_order-databricks.py

STREAMING SOLUTION SOURCE DATA PRODUCTS

FUNDATIONAL DATA PRODUCT

CATEGORY	FOUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	SALES BILLING
SALES AND DISTRIBUTION	TRADING GOODS
SALES AND DISTRIBUTION	CUSTOMER MASTER
FINANCE	ACCOUNT RECEIVABLE S4HANA
FINANCE	ACCOUNT RECEIVABLE CLEAR ITEMS
FINANCE	EXCHANGE RATE
HUMAN RESOURCES	PERSONNEL
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	TAXES REGION TEXT
ORGANIZATIONAL STRUCTURE	PAYMENT TERMS
ORGANIZATIONAL STRUCTURE	NIELSEN INDICATOR
ORGANIZATIONAL STRUCTURE	SALES GROUP TEXT
ORGANIZATIONAL STRUCTURE	CUSTOMER GROUP DESCRIPTION