Versions Compared

Old Version 8

changes.mady.by.user Pierre Smits

Saved on

compared with

New Version 9

changes.mady.by.user Pierre Smits

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

The SalesInvoiceItem entity (or table in the data warehouse RDBMS) to have the performance measurements from the invoice transactions in the OFBiz transaction database.

The Sales Invoice Item Fact entity is intended to capture performance measurements related to sales invoices from the invoice transactions in the OFBiz transaction database.

Table of Contents

Description

The Sales Invoice Item Fact table have the transaction results from the invoice creation and handling process, in particular from entities Invoice and InvoiceItem. 

The Sales Invoice Item

Fact entity is derived from: Invoice and InvoiceItem

and consists of following elements (fields):

name

alias

type

description





dateDimIddateintegerThe date the performance measurement occurred
organisationDimIdorganisationidThe internal (accounting) organisation the performance measurement is related to.
customerDimIdcustomeridThe customer the performance measurement is related to.
currencyDimIdcurrencyidThe currency the performance measurement is related to.
productDimIdproductidThe product the performance measurement is related to.


Related tickets

Jira
serverASF JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQueryproject = OFBIZ AND component in ('bi','birt') AND labels = SalesInvoiceItemFact ORDER BY status DESC, key DESC
serverId5aa69414-a9e9-3523-82ec-879b028fb15b