Data Model

ERD

Figure 1. ERD

Table	Description
PROD_HAUL_EVENT	This table contains the major information about oil/liquid haul event.
PROD_HAUL_VOLUME_DETAIL	This table record the measurement for volume calculation. They are secondary information for gross and net volume.
PROD_SALE_STATEMENT	This table contains the sale volume, price and purchaser information.
R_HAUL_EVENT_TYPE	Specify the haul event type, such as Hot Injection, Transfer in, Transfer out, Truck Sale, Water Draw, Other
R_FLOW_PART	Specifies the kinds of subdivisions of a flow related to the stock balance.
R_NET_VOLUME_METHOD	Lists the net volume methods, such as adjusted gross only, BSW correction only, Manual Entry, Standard, Temperature Correction Only
REPORTING_ENTITY	The entity that the event or sale statement volume is reported to.
R_REPORTING_PRODUCT	The reporting product reference.
ORG_UNIT	The organization unit associated to the event or sale statement, such as seller, buyer is the company associated with the sale.
R_REPORTING_FLOW	The disposition kind associated to the liquid in the haul event.

Table

Description

PROD_HAUL_EVENT

This table contains the major information about oil/liquid haul event.

This table record the measurement for volume calculation. They are secondary information for gross and net volume.

This table contains the sale volume, price and purchaser information.

Specify the haul event type, such as Hot Injection, Transfer in, Transfer out, Truck Sale, Water Draw, Other

Specifies the kinds of subdivisions of a flow related to the stock balance.

Lists the net volume methods, such as adjusted gross only, BSW correction only, Manual Entry, Standard, Temperature Correction Only

The entity that the event or sale statement volume is reported to.

The reporting product reference.

The organization unit associated to the event or sale statement, such as seller, buyer is the company associated with the sale.

The disposition kind associated to the liquid in the haul event.