Supplier.Invoice

Purpose

The Supplier Invoice (value) fact table is designed to display quantitative data related to invoices generated. This table integrates with dimension tables, such as supplier_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support financial analysis and reporting across the organisation.

Use Case

Owner: Sarah Martino
Typical Use Case: For the purpose of Order Tracking
Style: Fact, meaning it consists of the measurements, metrics or facts of a business process

Data Marts

Company
Supplier
Project

Source

FACT_SUPPLIER_INVOICE_OL

Sample Exec

EXEC get.myView @dataMart = 'Supplier', @viewName = 'Invoice', @token = '<myToken>', @version = '<202404>'

Response

	src.DIM_COMPANY_ID AS COMPANY,
	src.[DIM_SUPPLIER_ID] AS [SUPPLIER_ID], ent_supp.[SUPPLIER_NAME],
	src.PROJECT_ID,

SEQ

	INVOICE_ID_KEY,
	INVOICE_VERSION,

Entity

Dates

	CAST(src.[DIM_INVOICE_DATE_ID] AS DATE) AS [INVOICE_DATE],
	CAST(src.[DIM_DUE_DATE_ID] AS DATE) AS [DUE_DATE],
	CAST(src.[DIM_PL_PAY_DATE_ID] AS DATE) AS [PAY_TERM_BASE_DATE],
	CAST(src.[VOUCHER_DATE] AS DATE) AS [VOUCHER_DATE],
	CAST(src.[ACC_PERIOD_FROM] AS DATE) AS [ACC_PERIOD_FROM],

Measures

	try_convert(NUMERIC(15, 3), CAST(src.[GROSS_AMOUNT] AS FLOAT)) AS [GROSS_AMOUNT],
	try_convert(NUMERIC(15, 3), CAST(src.[OPEN_AMOUNT] AS FLOAT)) AS [OPEN_AMOUNT],
	try_convert(NUMERIC(15, 3), CAST(src.[NET_AMOUNT] AS FLOAT)) AS [NET_AMOUNT],
	try_convert(NUMERIC(15, 3), CAST(src.[VAT_AMOUNT] AS FLOAT)) AS [VAT_AMOUNT],
	try_convert(NUMERIC(15, 3), CAST(src.[GROSS_AMOUNT_DOM] AS FLOAT)) AS [GROSS_AMOUNT_DOM],
	try_convert(NUMERIC(15, 3), CAST(src.[OPEN_AMOUNT_DOM] AS FLOAT)) AS [OPEN_AMOUNT_DOM],
	try_convert(NUMERIC(15, 3), CAST(src.[NET_AMOUNT_DOM] AS FLOAT)) AS [NET_AMOUNT_DOM],

Codes

	src.[INVOICE_NO],
	src.[INVOICE_TYPE],
	src.[STATUS],
	--src.SEND_STATUS,
	--src.[PAY_TERM_ID],
	src.CURRENCY,
	src.[NOTES],

SQL

BMT-DWH-DEV/Supplier_Invoice.sql