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

Journal Entries by Tables

x 1

Taxes Region Text by Tables

x 1

Groups Material 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

Material Pricing Group 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 SCRIPS 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	FUNDATIONAL DATA PRODUCT
SALES AND DISTRIBUTION	SALES ORDER
SALES AND DISTRIBUTION	SALES BILLING
SALES AND DISTRIBUTION	TRADING GOOD
SALES AND DISTRIBUTION	CUSTOMER MASTER
FINANCE	JOURNAL ENTRIES
FINANCE	CURRENCY
HUMAN RESOURSES	PERSONNEL
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	GROUPS MATERIALS
ORGANIZATIONAL STRUCTURE	NIELSEN INDICATOR
ORGANIZATIONAL STRUCTURE	SALES GROUP TEXT
ORGANIZATIONAL STRUCTURE	MATERIAL PRICING GROUP
ORGANIZATIONAL STRUCTURE	CUSTOMER GROUP DESCRIPTION
ORGANIZATIONAL STRUCTURE	TAXES REGION TEXT