Project.SupplierInvoice

Purpose

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

Use Case

Owner: Martyn Cole
Typical Use Case: Provide Supplier Invoice data for Projects
Style: Fact, meaning it consists of the measurements, metrics or facts of a business process

Source

FACT_SUPPLIER_INVOICE_OL

Key Parameters

Company
Supplier
Project
Voucher No

Sample Exec

EXEC get.myView @dataMart = 'Project', @viewName = 'SupplierInvoice', @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,
	src.VOUCHER_NO,
	INVOICE_VERSION,

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/Project_SupplierInvoice.sql