Customer.InvoiceValue

Purpose

The Customer Invoice Value view provides detailed financial information on customer invoices, including gross, VAT, and net amounts across multiple currencies. This view is focused on delivering a comprehensive breakdown of financial values, allowing for detailed reporting and analysis of invoice data.

Use Case

Owner: Soon Tan
Typical Use Case: Designed for financial reporting and analysis, this view supports applications that need an in-depth look at invoice values, including multi-currency calculations and critical date tracking.
Style: Fact, A single row per unique Invoice ID, capturing financial data and key identifiers.

Source

QFACT_BMT_DWH_INVOICE_TAB_IAS$

This table includes high-detail financial information, with filters applied to capture only customer-related invoices (i.e., src.PARTY_TYPE = 'CUSTOMER').

Sample Exec

For sample data execution, use the code:

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

Response

Identifiers

• COMPANY: The company issuing the invoice.
• INVOICE_ID: Unique identifier for each invoice.
• INVOICE_SEQ: A JSON-formatted field combining INVOICE_ID and INVOICE_VERSION for version tracking.

Dates

• CREATED_DATE: Date when the invoice was created.
• PAY_TERM_BASE_DATE: Base date for payment terms.
• BI_TIMESTAMP: Business intelligence timestamp for record-keeping.
• INVOICE_DATE: The date the invoice was issued.
• DUE_DATE: Payment due date for the invoice.

Financial Values

• NET_CURR_AMOUNT: Net amount in the currency of the invoice.
• VAT_CURR_AMOUNT: VAT amount in the currency of the invoice.
• NET_DOM_AMOUNT: Net amount in the domestic currency.
• VAT_DOM_AMOUNT: VAT amount in the domestic currency.
• GROSS_CURR_AMOUNT: Total gross amount (net + VAT) in the currency of the invoice.
• CURRENCY: Currency code used in the invoice.

Codes and Descriptions (JSON Format)

• INVOICE_NO: The number assigned to the invoice.
• INVOICE_TYPE: Type or category of the invoice.
• SEND_STATUS: Status of invoice dispatch or processing.
• ACC_YEAR_INVOICE_DATE and ACC_PERIOD_INVOICE_DATE: Accounting period indicators, providing context for financial reporting periods.

SQL Code

To access the full SQL structure, refer to…

BMT-DWH-DEV/Customer_InvoiceValue.sql