I_PRATstActlPrimProdCompare

Test Validn - Primary Products Compare | view: IPRATACTWCC | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting

Tables used: OIU_SB_ACTWC, OIUTV_SB_ACTWC_B, OIU_CM_MAT_PRCD, OIUTV_CA_SCEN, OIUTV_CA_TOL

🔑 Keys (13)
💰 Amounts
∑ Quantities (14)
📅 Dates (1)
☰ Categorical (2)
Other (20)
🔗 Relations (11)

Column Name	Description
PRATstAllocVersion	Unique Version ID
DeliveryNetwork FK	Delivery network number
Well FK	Well ID number
WellCompletion FK	Well Completion Number
Material FK	Material Number
PRAContract FK	Contract Number
SalesDate	Sales date
PRAOwner FK	PRA owner
OwnerInterestType FK	Participant Interest Type
OwnerInterestSequence	Owner Interest Sequence Number
OriginatingMeasurementPt FK	Original measurement point number
Transporter FK	Transporter number
AllocationFrequency	Frequency	Show values

Column Name	Description

Column Name	Description
📏 Actual Volume Units (VolumeUnit):
BaselineActualVolume	Actual Volume
ActualVolume	Actual Volume
BaselineActualHeatingValue	Heating value
ActualHeatingValue	Heating value
BaselineActualEnergy	Actual Energy
ActualEnergy	Actual Energy
BaselineEntitledVolume	Entitled Contract Volume
EntitledVolume	Entitled Contract Volume
BaselineAdjustedEntitledVol	Adjusted Entitled Contract Volume
AdjustedEntitledVol	Adjusted Entitled Contract Volume
BaselineEntitledEnergy	Entitled Contract Energy
EntitledEnergy	Entitled Contract Energy
BaselineAdjustedEntitledEngy	Adjusted Entitled Contract Energy
AdjustedEntitledEngy	Adjusted Entitled Contract Energy

Column Name	Description
SalesDate	Sales date

Column Name	Description
AllocationFrequency	Frequency	Show values
MajorProduct	Major product code	Show values

Column Name	Description	Domain name
ActualVolumeDiffPct	null
ActualHeatingValueDiffVal	null
ActualEnergyDiffVal	null
BaselineWetGasOverridePct	Wet Gas Override Percent	OIU_PERCENT98
WetGasOverridePct	Wet Gas Override Percent	OIU_PERCENT98
WetGasOverridePctDiffVal	null
EntitledVolumeDiffVal	null
AdjustedEntitledVolDiffVal	null
EntitledEnergyDiffVal	null
AdjustedEntitledEngyDiffVal	null
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
CreationDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
SequenceNumber	null
ActualVolumeToleranceInPct	Test Validation - Standard Volume Tolerance	OIUTV_TOL_ABS
ActlHeatValToleranceVal	Test Validation - Actual Heating Value Tolerance	OIUTV_TOL_ABS
ActualEngyToleranceVal	Test Validation - Actual Energy Tolerance	OIUTV_TOL_ABS
EntitledVolumeTolVal	Test Validation - Entitled Volume Tolerance	OIUTV_TOL_ABS
AdjdEntitledVolTolVal	Test Validation - Adjusted Entitled Volume Tolerance	OIUTV_TOL_ABS
EntitledEnergyTolVal	Test Validation - Standard Volume Tolerance	OIUTV_TOL_ABS
AdjdEntitledEngyTolVal	Test Validation - Standard Volume Tolerance	OIUTV_TOL_ABS

Master Data Relations	Join Conditions
Delivery network number Delivery network number Client	`I_PRATSTACTLPRIMPRODCOMPARE.DELIVERYNETWORK == OIU_PR_DN.DN_NO` `I_PRATSTACTLPRIMPRODCOMPARE.MANDT == OIU_PR_DN.MANDT`
Actual Energy Unit Actual Energy Unit Client	`I_PRATSTACTLPRIMPRODCOMPARE.ENERGYUNIT == T006.MSEHI` `I_PRATSTACTLPRIMPRODCOMPARE.MANDT == T006.MANDT`
Heating Value Unit Heating Value Unit Client	`I_PRATSTACTLPRIMPRODCOMPARE.HEATINGVALUNIT == T006.MSEHI` `I_PRATSTACTLPRIMPRODCOMPARE.MANDT == T006.MANDT`
Material Number Client Material Number	`I_PRATSTACTLPRIMPRODCOMPARE.MANDT == OIU_CM_MAT_PRCD.MANDT` `I_PRATSTACTLPRIMPRODCOMPARE.MATERIAL == OIU_CM_MAT_PRCD.MATNR`
Original measurement point number Client Original measurement point number	`I_PRATSTACTLPRIMPRODCOMPARE.MANDT == OIU_PR_MP.MANDT` `I_PRATSTACTLPRIMPRODCOMPARE.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO`
Participant Interest Type	`I_PRATSTACTLPRIMPRODCOMPARE.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD`
PRA owner PRA owner Client	`I_PRATSTACTLPRIMPRODCOMPARE.PRAOWNER == LFA1.LIFNR` `I_PRATSTACTLPRIMPRODCOMPARE.MANDT == LFA1.MANDT`
Transporter number Client Transporter number	`I_PRATSTACTLPRIMPRODCOMPARE.MANDT == KNA1.MANDT` `I_PRATSTACTLPRIMPRODCOMPARE.TRANSPORTER == KNA1.KUNNR`
Actual Volume Units Actual Volume Units Client	`I_PRATSTACTLPRIMPRODCOMPARE.VOLUMEUNIT == T006.MSEHI` `I_PRATSTACTLPRIMPRODCOMPARE.MANDT == T006.MANDT`
Well ID number Client Well ID number	`I_PRATSTACTLPRIMPRODCOMPARE.MANDT == OIU_PR_WELL.MANDT` `I_PRATSTACTLPRIMPRODCOMPARE.WELL == OIU_PR_WELL.WL_NO`
Well Completion Number Client Well Completion Number Well ID number	`I_PRATSTACTLPRIMPRODCOMPARE.MANDT == OIU_PR_WC.MANDT` `I_PRATSTACTLPRIMPRODCOMPARE.WELLCOMPLETION == OIU_PR_WC.WC_NO` `I_PRATSTACTLPRIMPRODCOMPARE.WELL == OIU_PR_WC.WL_NO`