{ "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "ownershipBasedAccessControlForFeatures": { "allowOthersToUpdate": true, "allowOthersToQuery": true, "allowOthersToDelete": true }, "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1747330292663}, "relationships": [ { "keyField": "parentrowid", "role": "esriRelRoleDestination", "composite": true, "name": "ADM_Purchase_PowAuto_Test_item", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 1, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "item", "displayField": "objectid", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "item_nr", "length": 255, "alias": "Item number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uom", "length": 255, "alias": "UoM:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quantity", "alias": "Quantity:", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "part_num", "length": 255, "alias": "Part Number:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service_mat_descr", "length": 255, "alias": "Service or Material Description:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reason", "length": 255, "alias": "Reason of Purchase:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_price", "alias": "Unit Price ($):", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "extended_price", "alias": "Extended Price ($):", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4b4c974b611443ce8a52c44dfa5509db_cvd_scope", "type": "codedValue", "codedValues": [ { "code": "Structure d'acier", "name": "Structure d'acier" }, { "code": "Ascenseurs", "name": "Ascenseurs" }, { "code": "Protection incendie", "name": "Protection incendie" }, { "code": "Plomberie et Chauffage", "name": "Plomberie et Chauffage" }, { "code": "Evacuation de fumee et ventilation de confort", "name": "Évacuation de fumée et ventilation de confort" }, { "code": "Electricite", "name": "Électricité" }, { "code": "Coffrage du beton", "name": "Coffrage du béton" }, { "code": "Armature de beton", "name": "Armature de béton" }, { "code": "Fourniture de beton", "name": "Fourniture de béton" }, { "code": "Finition de beton", "name": "Finition de béton" }, { "code": "Beton architectural prefabrique", "name": "Béton architectural préfabriqué" }, { "code": "Maconnerie", "name": "Maçonnerie" }, { "code": "Metaux ouvres Brute", "name": "Métaux ouvrés Brute" }, { "code": "Metaux ouvres apparents", "name": "Métaux ouvrés apparents" }, { "code": "Impermeabilisation et isolation fondation", "name": "Imperméabilisation et isolation fondation" }, { "code": "Impermeabilisation des fondations", "name": "Imperméabilisation des fondations" }, { "code": "Impermeabilisation par cristallisation", "name": "Imperméabilisation par cristallisation" }, { "code": "Revêtement metallique interieur", "name": "Revêtement métallique intérieur" }, { "code": "Portes, Cadres et Quincailleries", "name": "Portes, Cadres et Quincailleries" }, { "code": "Portes et Grilles a enroulement", "name": "Portes et Grilles à enroulement" }, { "code": "Peinture", "name": "Peinture" }, { "code": "Système Interieur", "name": "Système Intérieur" }, { "code": "Planchers sureleves", "name": "Planchers surélevés" }, { "code": "Contrôle", "name": "Contrôle" }, { "code": "Travaux de Demolition", "name": "Travaux de Démolition" }, { "code": "Escalier Monumental et garde-corps", "name": "Escalier Monumental et garde-corps" }, { "code": "Mobilier ARTM", "name": "Mobilier ARTM" }, { "code": "Membrane Par-air/Vapeur et Isolation exterieur", "name": "Membrane Par-air/Vapeur et Isolation extérieur" }, { "code": "Revêtement metallique exterieur", "name": "Revêtement métallique extérieur" }, { "code": "Toiture", "name": "Toiture" }, { "code": "Murs Rideaux, lanterneaux et porte coulissante automatique", "name": "Murs Rideaux, lanterneaux et porte coulissante automatique" }, { "code": "Vitrage interieur", "name": "Vitrage interieur" }, { "code": "Revêtement sol, ceramique et terrazzo", "name": "Revêtement sol, céramique et terrazzo" }, { "code": "Accessoires de toilettes et divers", "name": "Accessoires de toilettes et divers" }, { "code": "Signalisation directionnelle pietonne", "name": "Signalisation directionnelle piétonne" }, { "code": "Equipement mobile d'entretien", "name": "Équipement mobile d'entretien" }, { "code": "Civil de surface", "name": "Civil de surface" }, { "code": "Maintien de la circulation", "name": "Maintien de la circulation" }, { "code": "Arpentage", "name": "Arpentage" }, { "code": "Conteneurs", "name": "Conteneurs" }, { "code": "Echafauds", "name": "Echafauds" }, { "code": "Grue", "name": "Grue" }, { "code": "Nacelle and Scissor Lift", "name": "Nacelle and Scissor Lift" }, { "code": "Monte-Charge", "name": "Monte-Charge" }, { "code": "Roulottes", "name": "Roulottes" }, { "code": "Laboratoire", "name": "Laboratoire" }, { "code": "Temporary electricity", "name": "Temporary electricity" }, { "code": "Temporary Ventilation", "name": "Temporary Ventilation" }, { "code": "Staff Salaries", "name": "Staff Salaries" }, { "code": "Staff professional fees expenses", "name": "Staff professional fees expenses" }, { "code": "Staff Training", "name": "Staff Training" }, { "code": "Lease (3129 Pi2) balance 54-36=18", "name": "Lease (3129 Pi2) balance 54-36=18" }, { "code": "EBC site office", "name": "EBC site office" }, { "code": "ADM office", "name": "ADM office" }, { "code": "Laptop 25", "name": "Laptop 25%" }, { "code": "Lenovo Screen", "name": "Lenovo Screen" }, { "code": "I Pad", "name": "I Pad" }, { "code": "Office Softwares", "name": "Office Softwares" }, { "code": "P6 Licences & Tilos", "name": "P6 Licences & Tilos" }, { "code": "Project Control (SAP, SAP Fiori, P6, Har", "name": "Project Control (SAP, SAP Fiori, P6, Har" }, { "code": "Aconex (Document Control support & mater", "name": "Aconex (Document Control support & mater" }, { "code": "(BIM/Assemble, Bloom, Collaborate Pro, A", "name": "(BIM/Assemble, Bloom, Collaborate Pro, A" }, { "code": "Cybersecurity (email protection, antivir", "name": "Cybersecurity (email protection, antivir" }, { "code": "Internet Usage EBC", "name": "Internet Usage EBC" }, { "code": "IPad Data Cost", "name": "IPad Data Cost" }, { "code": "Cell Phones", "name": "Cell Phones" }, { "code": "Walkie-Talkie", "name": "Walkie-Talkie" }, { "code": "Usage (per user)", "name": "Usage (per user)" }, { "code": "Telephone", "name": "Telephone" }, { "code": "Telephone Bill", "name": "Telephone Bill" }, { "code": "Printers & Plotter/EBC", "name": "Printers & Plotter/EBC" }, { "code": "Printers & Plotter/ADM", "name": "Printers & Plotter/ADM" }, { "code": "Janitorial Services Aecon", "name": "Janitorial Services Aecon" }, { "code": "Janitorial Services ADM", "name": "Janitorial Services ADM" }, { "code": "Office Supplies & Stationary per Salarie", "name": "Office Supplies & Stationary per Salarie" }, { "code": "Courier & Postage per Salaried Manhour", "name": "Courier & Postage per Salaried Manhour" }, { "code": "Engineering Supplies per Salaried Manhou", "name": "Engineering Supplies per Salaried Manhou" }, { "code": "Job Photos", "name": "Job Photos" }, { "code": "PPE", "name": "PPE" }, { "code": "Rainsuits", "name": "Rainsuits" }, { "code": "Catering", "name": "Catering" }, { "code": "Safety Training", "name": "Safety Training" }, { "code": "Water Consumption per Office Man-Month A", "name": "Water Consumption per Office Man-Month A" }, { "code": "Site Camera Monitoring", "name": "Site Camera Monitoring" }, { "code": "Guard (6pm to 6am)", "name": "Guard (6pm to 6am)" }, { "code": "Guard (Weekend 24hr)", "name": "Guard (Weekend 24hr)" }, { "code": "Escalation Staff Building", "name": "Escalation Staff Building" }, { "code": "Final clean up", "name": "Final clean up" }, { "code": "Bonds Subs", "name": "Bonds Subs" }, { "code": "Bonds - Connect Cite Batiment", "name": "Bonds - Connect Cite Batiment" }, { "code": "Security Trailer", "name": "Security Trailer" }, { "code": "Trailer (12X40)", "name": "Trailer (12X40)" }, { "code": "Washrooms", "name": "Washrooms" }, { "code": "Portable Toilet(1/15 craft) - Bloc sanit", "name": "Portable Toilet(1/15 craft) - Bloc sanit" }, { "code": "Garbage Pickup (4 time/month)", "name": "Garbage Pickup (4 time/month)" }, { "code": "Garbage Truck Disposal Fee", "name": "Garbage Truck Disposal Fee" }, { "code": "Garbage Bin Rental (4)", "name": "Garbage Bin Rental (4)" }, { "code": "Transport Camion", "name": "Transport Camion" }, { "code": "Snow dump fee", "name": "Snow dump fee" }, { "code": "Sweeper", "name": "Sweeper" }, { "code": "Chauffage Temporaire batiment", "name": "Chauffage Temporaire batiment" }, { "code": "Electricite temporaire", "name": "Électricité temporaire" }, { "code": "Bull gang (4 Labor full time 18 Month)", "name": "Bull gang (4 Labor full time 18 Month)" }, { "code": "Carpenter", "name": "Carpenter" }, { "code": "Skytrack", "name": "Skytrack" }, { "code": "Mont charge", "name": "Mont charge" }, { "code": "Installation/Demantèlement", "name": "Installation/Démantèlement" }, { "code": "Labor Mont Charge", "name": "Labor Mont Charge" }, { "code": "Etudes d'iceberg (DAC-01993)", "name": "Études d'iceberg (DAC-01993)" }, { "code": "MAFFEIS Services - Phase 1 (Iceberg)", "name": "MAFFEIS Services - Phase 1 (Iceberg)" }, { "code": "MAFFEIS Services - Phase 2 (Iceberg)", "name": "MAFFEIS Services - Phase 2 (Iceberg)" }, { "code": "Structure XL Design Support (Iceberg)", "name": "Structure XL Design Support (Iceberg)" }, { "code": "Extra Costs Caused by Lot C on Lot D: Dawco", "name": "Extra Costs Caused by Lot C on Lot D: Dawco" }, { "code": "Extra Costs Caused by Lot C on Lot D: Structure XL", "name": "Extra Costs Caused by Lot C on Lot D: Structure XL" }, { "code": "Extra Costs Caused by Lot C on Lot D: Maxi", "name": "Extra Costs Caused by Lot C on Lot D: Maxi" }, { "code": "Extra Costs Caused by Lot C on Lot D: Regulvar", "name": "Extra Costs Caused by Lot C on Lot D: Regulvar" }, { "code": "Extra Costs Caused by Lot C on Lot D: TBD1", "name": "Extra Costs Caused by Lot C on Lot D: TBD1" }, { "code": "Extra Costs Caused by Lot C on Lot D: TBD2", "name": "Extra Costs Caused by Lot C on Lot D: TBD2" }, { "code": "Extra Costs Caused by Lot C on Lot D: TBD3", "name": "Extra Costs Caused by Lot C on Lot D: TBD3" }, { "code": "Extra Costs Caused by Lot C on Lot D: TBD4", "name": "Extra Costs Caused by Lot C on Lot D: TBD4" }, { "code": "Atwill Morin (Modif+attest door bins-concrete block pallets)", "name": "Atwill Morin (Modif+attest door bins-concrete block pallets)" }, { "code": "TBD", "name": "TBD" } ] }, "name": "scope", "length": 255, "alias": "Description (by requisitioner):", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nwa", "length": 255, "alias": "NWA:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "office", "length": 255, "alias": "office based", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "service_4b4c974b611443ce8a52c44dfa5509db_cvd_gl_acc", "type": "codedValue", "codedValues": [ { "code": "ARO Utilization Expense", "name": "ARO Utilization Expense" }, { "code": "Other Expenses", "name": "Other Expenses" }, { "code": "Equipment Internal - Time Based", "name": "Equipment Internal - Time Based" }, { "code": "Equipment Internal - Perf. Based", "name": "Equipment Internal - Perf. Based" }, { "code": "Materials", "name": "Materials" }, { "code": "Royalty - Materials", "name": "Royalty - Materials" }, { "code": "Interest Expense", "name": "Interest Expense" }, { "code": "Personnel", "name": "Personnel" }, { "code": "Personnel (data conversion)", "name": "Personnel (data conversion)" }, { "code": "Contract Labour", "name": "Contract Labour" }, { "code": "Professional & Management Fees", "name": "Professional & Management Fees" }, { "code": "Subcontractors (Summary)", "name": "Subcontractors (Summary)" }, { "code": "Subcontractors (Labour)", "name": "Subcontractors (Labour)" }, { "code": "Subcontractors (Equipment)", "name": "Subcontractors (Equipment)" }, { "code": "Subcontractors (Materials)", "name": "Subcontractors (Materials)" }, { "code": "Subcontractors (Subs)", "name": "Subcontractors (Subs)" }, { "code": "Subcontractors (Indirects)", "name": "Subcontractors (Indirects)" }, { "code": "Subcontractors Service Contractors", "name": "Subcontractors Service Contractors" }, { "code": "Subcontractors Janitorial", "name": "Subcontractors Janitorial" }, { "code": "Subcontractors Grounds/Parking", "name": "Subcontractors Grounds/Parking" }, { "code": "Subcontractors Building Repair", "name": "Subcontractors Building Repair" }, { "code": "Subcontractors Waste/Recycling", "name": "Subcontractors Waste/Recycling" }, { "code": "Delivery/Freight/Courier", "name": "Delivery/Freight/Courier" }, { "code": "Haul & Deliv. Subcontractor", "name": "Haul & Deliv. Subcontractor" }, { "code": "Port & Cross Border Duties", "name": "Port & Cross Border Duties" }, { "code": "Direct Consumables", "name": "Direct Consumables" }, { "code": "Site Indirect Consumables", "name": "Site Indirect Consumables" }, { "code": "Site Facilities", "name": "Site Facilities" }, { "code": "Communications", "name": "Communications" }, { "code": "Fuel", "name": "Fuel" }, { "code": "Short term Equipment External Rent", "name": "Short term Equipment External Rent" }, { "code": "Equipment Reparis & Maintenance", "name": "Equipment Reparis & Maintenance" }, { "code": "Travel", "name": "Travel" }, { "code": "Camps & Accomodation", "name": "Camps & Accomodation" }, { "code": "Meals & Entertainment", "name": "Meals & Entertainment" }, { "code": "Meals & Entertainment- Clients", "name": "Meals & Entertainment- Clients" }, { "code": "Meals & Entertainment- Staff", "name": "Meals & Entertainment- Staff" }, { "code": "Training - Safety", "name": "Training - Safety" }, { "code": "Training - Other", "name": "Training - Other" }, { "code": "Permits & Inspections", "name": "Permits & Inspections" }, { "code": "Insurance", "name": "Insurance" }, { "code": "Bonding & LC's", "name": "Bonding & LC's" }, { "code": "Contingency", "name": "Contingency" }, { "code": "Taxable Benefits", "name": "Taxable Benefits" }, { "code": "Car Mileage Reimburs- Business Use", "name": "Car Mileage Reimburs- Business Use" }, { "code": "Tolls/Road Charges - Business Use", "name": "Tolls/Road Charges - Business Use" }, { "code": "Vehicle Maintenance & Repairs", "name": "Vehicle Maintenance & Repairs" }, { "code": "Vehicle Insurance & Licensing", "name": "Vehicle Insurance & Licensing" }, { "code": "Depreciation", "name": "Depreciation" }, { "code": "Contract Costs- Prof Subscriptions & Dues", "name": "Contract Costs- Prof Subscriptions & Dues" }, { "code": "Fleet Car Licensing", "name": "Fleet Car Licensing" }, { "code": "Contract Costs- Fleet Car Maintenance", "name": "Contract Costs- Fleet Car Maintenance" }, { "code": "Contract Costs- Gifts - Staff", "name": "Contract Costs- Gifts - Staff" }, { "code": "Legal fees", "name": "Legal fees" }, { "code": "Intercompany Labour", "name": "Intercompany Labour" }, { "code": "Intercompany Labour Mark-Up", "name": "Intercompany Labour Mark-Up" }, { "code": "Intercompany Equipment", "name": "Intercompany Equipment" }, { "code": "Intercompany Equipment Mark-Up", "name": "Intercompany Equipment Mark-Up" }, { "code": "Intercompany Material", "name": "Intercompany Material" }, { "code": "Intercompany Material Mark-Up", "name": "Intercompany Material Mark-Up" }, { "code": "Intercompany Subcontracts", "name": "Intercompany Subcontracts" }, { "code": "Intercompany Subcontracts Mark-Up", "name": "Intercompany Subcontracts Mark-Up" }, { "code": "Intercompany Other", "name": "Intercompany Other" }, { "code": "Intercompany Other Mark-up", "name": "Intercompany Other Mark-up" }, { "code": "Capital Costs", "name": "Capital Costs" } ] }, "name": "gl_acc", "length": 255, "alias": "G/L Account (Project Manager):", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "acc_num", "length": 255, "alias": "Account #:", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentrowid", "length": 38, "alias": "ParentRowID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "supportsTruncate": false, "indexes": [ { "name": "r18948_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_18948", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "types": [], "supportsCoordinatesQuantization": true, "capabilities": "Query,Create,Update,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "propagateVisibleFields": true, "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "supportsLayerOverrides": true, "serviceItemId": "46af43fe22de48af94b180faf251d199" }