Access to add and change pages is restricted. See: https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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.

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

key summary type created updated due assignee reporter priority status resolution

JQL and issue key arguments for this macro require at least one Jira application link to be configured

  • No labels