- Accounting - General (AC)
- Controlling (CO)
- Cross-Application Sources (OCA)
- Customer Service (0CS)
- Enterprise Controlling (EC)
- Financial Accounting (FI)
- Investment Management (IM)
- Logistics - General (LO)
- Materials Management (MM)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Quality Management (QM)
- Real Estate Management (0RE)
- Sales and Distribution (SD)
- Time Management (PT)
- Training and Event Management (PE)
- Treasury (TR)
0PP_PN_9
Tables used:
GHO_IFLOT_EXT, GHO_WC_OVR, GHO_ALLOCRES_H, GHO_THEO_OVR_H, UPOT_UDM_ALLOCV ... +64 more
- 🔑 Keys (17)
- 💰 Amounts
- ∑ Quantities (3)
- 📅 Dates (3)
- ☰ Categorical (5)
- Other (7)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| ALLOC_RUN_ID | Identifier for an Instance of the Allocation Engine Run | |
| DEST_NODE_ID | ID of the Node in the Network | |
| QTY_TYPE | Quantity Type | |
| THEO_ACT_IND | Theoretical Actual Indicator | Show values |
| DOI_ID | DOI Number | |
| COMPANY_CODE | Company Code | |
| CONCESSION | Concession | |
| UNIT | Unit of Measure | |
| SEQ_NO | Ownership Sequence number | |
| BEARER_GRP_NO | Ownership Bearer Group Number | |
| NETID | Network Object ID | |
| MEDIUM | Product on which Allocation is Performed (Oil, Gas, Water) | |
| ORIGIN_NODE_ID | ID of the Node in the Network | |
| ALLOC_TYPE | Allocation Type | Show values |
| FREQUENCY | Allocation Frequency | |
| PROD_TIME | Production Start Time | |
| ALLOC_PURPOSE | Allocation Purpose | Show values |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure (GRAVITY_UOM): | ||
| GRAVITY | null | |
| 📏 Unit of Measure (VOL_UNIT): | ||
| NET_VOLUME | null | |
| 📏 Unit of Measure (UNIT): | ||
| GROSS_VOLUME | null | |
| Column Name | Description | |
|---|---|---|
| PROD_TIME | Production Start Time | |
| PROD_DATE_LOW | Field of type DATS | |
| PROD_DATE_HIGH | Field of type DATS |
| Column Name | Description | |
|---|---|---|
| THEO_ACT_IND | Theoretical Actual Indicator | Show values |
| QTY_CATEGORY | Quantity Category | Show values |
| ALLOC_TYPE | Allocation Type | Show values |
| ALLOC_PURPOSE | Allocation Purpose | Show values |
| ALLOC_STATUS | Allocation Run Status | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CREATED_BY | Record Created By | USNAM | |
| CREATED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| CHANGED_BY | Record Last Changed By | USNAM | |
| CHANGED_TST | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | |
| DOI_DERIVED_FROM | Functional Location | TPLNR | |
| OWNER_NO | Ownership:Owner Number | LIFNR | |
| OWN_INT_TYPE | Owner Interest Type | GHO_OWN_PART_INT_TYPE |