IFS Enterprise Upstream/IFS AFE - Example JSON Messages

Following are example messages sent between IFS Enterprise Upstream and IFS AFE in the JSON (JavaScript Object Notation) format:

AFE

^{[{
"company": "P2 Energy Solutions ULC",
"corporateBusinessUnitId": "1022",
"afeNumber": "138074",
"afeVersion": "0",
"afeVersionDate": "2016-07-12T15:44:12",
"versionType": "Original",
"afeSuffix": "0",
"templateName": "FM Drill and Complete",
"templateCode": "DRILL",
"afeObjective": "Original Update AFE Viking 10-25-25-24 W5",
"type": "Capital"
"eventType": "Drill and Case"
"afeClass": "CDE",
"afeStatus": "Proposed",
"afeBudgetYear": "2016",
"afeDate": "2016-07-12T15:44:12-06:00",
"afeStartDate": "2016-07-19T15:44:12-06:00",
"operatingNwi": null,
"operatingNri": null,
"costCenterNumber": "200",
"remarks": "Drill a test well to the base of the basal quartz. Seismic shows promising rich gas play.",
"justification": "Drill to the base of the Cardium sand",
"operatorId": "188188",
"afeOperator": "P2 Energy Inc",
"closedDate": null,
"signedOffDate": null,
"propertyType": "Well",
"totalAmount": null,
"incrementalAmount": null,
"supplementalAmount": null,
"originalAmount": 0.0,
"lastApprovedAmount": 0.0,
"currentAmount": 0.0,
"sites":
[{
"name": "COTTON VALLEY 3",
"businessUnit": null,
"project": null,
"area": "Cardium",
"padsite": "",
"propertyNumber": "8062"
"wellXPrime": "164030000",
"wellType": "Gas",
"coordinateSystem": "DLS",
"location": "100/10-25-025-24-W-5/00"
}]

}]}

AFE Response

^{{
"timestamp": 1484002703806,
"status": "400",
"error": "Bad Request",
"exception": "com.p2es.rest.util.ValidationException",
"message": "Failed: Afe 13807 not in valid status for approval in Enterprise Upstream.",
"path": "/p2afeinterop/afe"
}}

AFE Actuals

^{[{
"afeNumber": "AFE016",
"accountingDate": "2010-04030T00:00:00",
"currencyCode": "USD",
"details":
[{
"majorCode": "311",
"minorCode": "33154",
"accruedCost": 1000,
"isAbsolute": null
}]
}]}

AFE Actuals Integration Status

^{[{
"errorMessage": "Error transferring AFE Actuals",
"id": "AFE016",
"success": false
}]}

AFE Estimates

^{{
"corporateBusinessUnitId": "1022",
"afeNumber": "138067",
"wellId": null,
"afeVersion": "0",
"afeSuffix": "0",
"details":
[{
"majorCode": "311",
"minorCode": "33154",
"estimate": 12000.0,
"estimateDate": null,
"incrementalAmount": 0.0,
"estimateType": "AFE"
}]
}}

AFE Estimate Response

^{{
"timestamp": 1484002703806,
"status": "400",
"error": "Bad Request",
"exception": "com.p2es.rest.util.ValidationException",
"message": "Failed: Afe 13807 not in valid status to add Budget Estimates in Enterprise Upstream.",
"path": "/p2afeinterop/afe-estimates"
}}

AFE Template

^{[{
"afeType": "Capital",
"code": "CA",
"corporateBusinessUnit": null,
"details":
   [{
      "amount": null
      "categoryDescription": "WORK_IN -PROGRESS_CAPITALIZED INTEREST INTANGIBLE",
      "dollarsPer": null,
      "initialCost": null,
      "majorCode": "311",
      "minorCode": "33991",
      "numberOf": null,
      "units": null
   }],
"effectiveDate": null,
"eventType": null,
"name": "CAPITAL ABANDONMENT",
"siteType": null
}]}

AFE Template Integration Status

^{[{
"errorMessage": "Error transferring AFE Template",
"id": "CAPITAL ABANDONMENT",
"success": false
}]}

Chart of Accounts

^{[{
"corporateBusinessUnitId": null,
"corporateBusinessUnitName": null,
"majorCode": "111",
"description": "CASH - General Accounts",
"effectiveDate": null,
"remarks": null,
"details":
   [{
      "minorCode": "10001",
      "description": "TERM DEPOSITS",
      "capitalExpense": "Expense",
      "isDryHole": null,
      "isDrillAndCase": null,
      "isComplete": null,
      "isFrac": null,
      "isMud": null,
      "isEquipment": null,
      "isWorkover": null,
   }],
}]}

Chart of Accounts Integration Status

^{[{
"errorMessage": "Error transferring Chart of Accounts",
"id": "111",
"success": false
}]}

DOI

^{[{
"afeNumber": "138062",
"afeSuffix": "Revision",
"details":
   [
{
    "participantId": "12-1",
    "participantName": "Chevron USA*1",
    "workingInterest": 0.30,
    "isOperator": false,
},
{
    "participantId": "40-1",
    "participantName": "Shell Western*1",
    "workingInterest": 0.50,
    "isOperator": false,
},
{
    "participantId": "413-1",
    "participantName": "Integrated Energy Pipelin*1",
    "workingInterest": 0.20,
    "isOperator": true,
}],
"afeVersionDate": null,
"participantsDate": null
}]}

DOI Integration Status

^{[{
"errorMessage": "Error transferring DOI",
"id": "138062",
"success": false
}]}

Facility Header (Non-Well Cost Center)

^{[{
"id": "30644",
"facilityId": "30644",
"corporateBusinessUnitId": "88",
"name": "BOSSIER FIELD 30644",
"surfaceLocation": null,
"surfaceLocationStatus": null,
"coordinateSystem": null,
"latitude": null,
"longitude": null,
"latLongStatus": null,
"provinceState": "CO",
"provinceStateId": null,
"countyParish": null,
"countyParishId": null,
"padName": null,
"padId": null,
"fieldName": null,
"operator": null,
"operatorId": null,
"isOperated": "No",
"leaseNumber": null,
"leaseName": null,
"propertyNumber": "30644",
"isTight": null,
"status": "Active",
"type": "FIELD"
}]}

Facility Header (Non-Well Cost Center) Integration Status

^{[{
"errorMessage": "Error transferring Facility Header",
"id": "30640",
"success": false
}]}

Field Estimates

^{[{
"corporateBusinessUnitId": "1022",
"afeNumber": "138070",
"wellId": null,
"afeVersion": "0",
"afeSuffix": "O",
"accountingDate": "2017-02-28T00:00:01-07:00",
"majorCodes": [
{
"majorCode": "311",
"minorCodes": [
{
"minorCode":"33154",
"costToDate":125001
},
{
"minorCode":"33888",
"costToDate":25000
},
{
"minorCode":"33920",
"costToDate":20000.45
}]
}]
}]}

Field Estimates Response

^{{
"message": "Success",
"status": 200
}}

Participants

^{[{
"address": "123 ANY St",
"city": "Denver",
"cityId": null,
"corporateBusinessUnitId": null,
"corporateBusinessUnitName": null,
"country": "US",
"countryID": null,
"county": "DENVER",
"countyId": null,
"effectiveDate": null,
"id": "7699-1",
"name": "CUSTMR ORG 1*1",
"postalZipCode": "80222"
"provinceState": "CO"
"provinceStateId": null,
}]}

Participants Integration Status

^{[{
"errorMessage": "Error transferring Participant",
"id": "7699-1",
"success": false
}]}

Vendors

^{[{
"address": "11th St Denver",
"contactName": "1dsinterest",
"contactPhoneNumber": "111-111-1111",
"corporateBusinessUnitId": null,
"corporateBusinessUnitName": null,
"id": "7723-1",
"name": "1153*1dsinterest*1",
}]}

Vendors Integration Status

^{[{
"errorMessage": "Error transferring Vendor",
"id": "7723-1",
"success": false
}]}

Well Header

^{[{
"id": "28190",
"corporateBusinessUnitId": "1022",
"name": "AZA118",
"surfaceLocation": null,
"surfaceLocationStatus": null,
"coordinateSystem": null,
"latitude": null,
"longitude": null,
"latLongStatus": null,
"provinceState": "CO",
"provinceStateId": null,
"countyParish": null,
"countyParishId": null,
"padName": null,
"padId": null,
"fieldname": null,
"operator": null,
"operatorId": "2-1",
"isOperated": "Yes",
"leaseNumber": null,
"leaseName": null,
"propertyNumber": null,
"isTight": null,
"status": null,
"type": "WELL"
}]}

Well Header Integration Status

^{[{
"errorMessage": "Error transferring Well Header",
"id": "28190",
"success": false
}]}