{ "dataSources": [ { "SAPAribaRealm_{Realm}": { "type": "SAP Ariba Realm", "tenantId": "{Realm}", "tokenServiceURL": "***https://api-eu.ariba.com", "baseURL": "***https://eu.openapi.ariba.com", "apis": { "analytics-reporting": { "createView": "/api/analytics-reporting-view/v1/prod/viewTemplates", "jobSubmit": "/api/analytics-reporting-job/v1/prod/jobs", "apikey": "***CsXcJ7GW7K4Ppr2MpISksMNpUmnJxqKd", "credentials": "SAPAriba_{Realm}_analytics-reporting" }, "sourcing-reporting": { "createView": "/api/sourcing-reporting-view/v1/prod/viewTemplates", "jobSubmit": "/api/sourcing-reporting-job/v1/prod/jobs", "apikey": "***9DzC6uFewQdfmXrNKwRx7jteFyHgQ4NZ", "credentials": "SAPAriba_{Realm}_sourcing-reporting" }, "procurement-reporting": { "createView": "/api/procurement-reporting-view/v2/prod/viewTemplates", "jobSubmit": "/api/procurement-reporting-job/v2/prod/jobs", "apikey": "***OKRUaiIbONjMjJ1zxsXtRp1eTodoLmMZ", "credentials": "SAPAriba_{Realm}_procurement-reporting" } } } } ], "dataTargets": [ { "SAPSignavio_editor": { "type": "SAP Signavio", "tenantId": "editor", "baseURL": "https://api.eu.signavio.cloud.sap/spi/ingestions/v1/data", "apis": { "ingestion": { "piepelines": [ { "name": "sourcing", "credentials": "SAPSignavio_Sourcing_{Realm}" }, { "name": "procurement", "credentials": "SAPSignavio_Procurement_{Realm}" } ] } } } } ], "config": [ { "dataSource": "All", "api": "All", "timezone": "UTC", "delimiter": ",", "retentionPeriod": 60, "complexObjectItemsSeparator": "_", "includeTenantId": true, "tenantIdColumnName": "Realm", "formatters": { "date-time": "Timestamp" } } ], "resourceItemsConfig": [ { "dataSource": "SAPAribaRealm_{Realm}", "api": "analytics-reporting", "resourceItems": { "DES_RequisitionLineItemFact": { "type": "view", "name": "Ariba_{Realm}_requisitionLineItems__", "primaryKeys": [ "Realm", "RequisitionId", "RequisitionLineNumber", "SourceSystem.SourceSystemId", "SplitAccountingNumber" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "RequisitionLineItemFact", "selectAttributes": [ "POId", "POLineNumber", "ReqApprovedDate", "RequisitionId", "RequisitionLineNumber", "isPartialItem", "RequisitionDate", "ItemCategory", "LineType", "SourceSystem", "SplitAccountingNumber", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataSource": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "requisitionLineItems", "fields": [ { "name": "ItemCategory", "type": [ "null", "string" ] }, { "name": "LineType", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "POId", "type": [ "null", "string" ] }, { "name": "POLineNumber", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "ReqApprovedDate_Day", "type": [ "null", "long" ] }, { "name": "RequisitionDate_Day", "type": [ "null", "long" ] }, { "name": "RequisitionId", "type": [ "null", "string" ] }, { "name": "RequisitionLineNumber", "type": [ "null", "string" ] }, { "name": "isPartialItem", "type": [ "null", "boolean" ] }, { "name": "SourceSystem_SourceSystemId", "type": [ "null", "string" ] }, { "name": "SplitAccountingNumber", "type": [ "null", "int" ] } ] } } ] }, "DES_SSPPOLineItemFact": { "type": "view", "name": "Ariba_{Realm}_purchaseorderlineitems__", "primaryKeys": [ "POId", "POLineNumber", "Realm", "SourceSystem.SourceSystemId", "SplitAccountingNumber" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "SSPPOLineItemFact", "selectAttributes": [ "AccountType", "Account", "AccountingProject", "AccountingRegion", "Amount", "AmountAccepted", "AmountBilled", "AmountCleared", "AmountInvoiced", "AmountLeftToInvoice", "AmountLeftToReconcile", "AmountReconciled", "Asset", "BillToLocation", "ChargeAmount", "Commodity", "Contract", "CostCenter", "DiscountAmount", "ERPCommodity", "ItemCategory", "LineType", "NeedByDate", "NumberAccepted", "NumberBilled", "NumberCleared", "NumberConfirmedAccepted", "NumberConfirmedBackOrdered", "NumberConfirmedRejected", "NumberConfirmedSubstituted", "NumberInvoiced", "NumberReconciled", "OrderConfirmationStatus", "OrderID", "OrderType", "OrderedDate", "OrigCurrencyCode", "ParentPOLineNumber", "POId", "POLineNumber", "POTaxAmountInvoiced", "PurchaseGroup", "PurchasingCompany", "Quantity", "RequiresServiceEntry", "ServiceEndDate", "ServiceOrder", "ServiceStartDate", "ShipToLocation", "SourceSystem", "SplitAccountingNumber", "StatusString", "Supplier", "TaxAmount", "TaxCodeDescription", "TimeUpdated", "TaxCodeId", "TaxCodeName" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataSource": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "purchaseorderlineitems", "fields": [ { "name": "POId", "type": [ "null", "string" ] }, { "name": "POLineNumber", "type": [ "null", "string" ] }, { "name": "SplitAccountingNumber", "type": [ "null", "int" ] }, { "name": "AccountType", "type": [ "null", "string" ] }, { "name": "Account_AccountId", "type": [ "null", "string" ] }, { "name": "Account_CompanyCode", "type": [ "null", "string" ] }, { "name": "AccountingProject_ProjectId", "type": [ "null", "string" ] }, { "name": "AccountingRegion_RegionId", "type": [ "null", "string" ] }, { "name": "Amount", "type": [ "null", "double" ] }, { "name": "AmountAccepted", "type": [ "null", "double" ] }, { "name": "AmountBilled", "type": [ "null", "double" ] }, { "name": "AmountCleared", "type": [ "null", "double" ] }, { "name": "AmountInvoiced", "type": [ "null", "double" ] }, { "name": "AmountLeftToInvoice", "type": [ "null", "double" ] }, { "name": "AmountLeftToReconcile", "type": [ "null", "double" ] }, { "name": "AmountReconciled", "type": [ "null", "double" ] }, { "name": "Asset_AssetId", "type": [ "null", "string" ] }, { "name": "BillToLocation_LocationId", "type": [ "null", "string" ] }, { "name": "ChargeAmount", "type": [ "null", "double" ] }, { "name": "Commodity_CommodityId", "type": [ "null", "string" ] }, { "name": "Contract_ContractId", "type": [ "null", "string" ] }, { "name": "CostCenter_CompanyCode", "type": [ "null", "string" ] }, { "name": "CostCenter_CostCenterId", "type": [ "null", "string" ] }, { "name": "DiscountAmount", "type": [ "null", "double" ] }, { "name": "ERPCommodity_CommodityId", "type": [ "null", "string" ] }, { "name": "ItemCategory", "type": [ "null", "string" ] }, { "name": "LineType", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "NeedByDate_Day", "type": [ "null", "long" ] }, { "name": "NumberAccepted", "type": [ "null", "double" ] }, { "name": "NumberBilled", "type": [ "null", "double" ] }, { "name": "NumberCleared", "type": [ "null", "double" ] }, { "name": "NumberConfirmedAccepted", "type": [ "null", "double" ] }, { "name": "NumberConfirmedBackOrdered", "type": [ "null", "double" ] }, { "name": "NumberConfirmedRejected", "type": [ "null", "double" ] }, { "name": "NumberConfirmedSubstituted", "type": [ "null", "double" ] }, { "name": "NumberInvoiced", "type": [ "null", "double" ] }, { "name": "NumberReconciled", "type": [ "null", "double" ] }, { "name": "OrderConfirmationStatus", "type": [ "null", "string" ] }, { "name": "OrderID", "type": [ "null", "string" ] }, { "name": "OrderType", "type": [ "null", "string" ] }, { "name": "OrderedDate_Day", "type": [ "null", "long" ] }, { "name": "OrigCurrencyCode", "type": [ "null", "string" ] }, { "name": "ParentPOLineNumber", "type": [ "null", "double" ] }, { "name": "POTaxAmountInvoiced", "type": [ "null", "double" ] }, { "name": "PurchaseGroup_BusinessUnitId", "type": [ "null", "string" ] }, { "name": "PurchasingCompany_BusinessUnitId", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "Quantity", "type": [ "null", "double" ] }, { "name": "RequiresServiceEntry", "type": [ "null", "boolean" ] }, { "name": "ServiceEndDate_Day", "type": [ "null", "long" ] }, { "name": "ServiceOrder", "type": [ "null", "boolean" ] }, { "name": "ServiceStartDate_Day", "type": [ "null", "long" ] }, { "name": "ShipToLocation_LocationId", "type": [ "null", "string" ] }, { "name": "SourceSystem_SourceSystemId", "type": [ "null", "string" ] }, { "name": "StatusString", "type": [ "null", "string" ] }, { "name": "Supplier_SupplierId", "type": [ "null", "string" ] }, { "name": "Supplier_SupplierLocationId", "type": [ "null", "string" ] }, { "name": "TaxAmount", "type": [ "null", "double" ] }, { "name": "TaxCodeDescription", "type": [ "null", "string" ] }, { "name": "TaxCodeId", "type": [ "null", "string" ] }, { "name": "TaxCodeName", "type": [ "null", "string" ] } ] } } ] }, "DES_ReceiptFact": { "type": "view", "name": "Ariba_{Realm}_receipts__", "primaryKeys": [ "ReceiptId", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt", "TimeCreated": "CreatedAt" }, "view": { "status": "published", "documentType": "ReceiptFact", "selectAttributes": [ "ContractId", "DateOfDelivery", "ERPReceiptNumber", "LineItemNumber", "LineType", "Location", "TimeUpdated", "NumberAccepted", "NumberPreviouslyAccepted", "OrderId", "ProcessedState", "ReceiptId", "Quantity", "ReceiptDate", "ShippmentNoticeReference", "Supplier", "TimeCreated", "TotalAmount", "UnitPrice" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "receipts", "fields": [ { "name": "ContractId", "type": [ "null", "string" ] }, { "name": "CreatedAt", "type": [ "null", "long" ] }, { "name": "DateOfDelivery_Day", "type": [ "null", "long" ] }, { "name": "ERPReceiptNumber", "type": [ "null", "string" ] }, { "name": "LineItemNumber", "type": [ "null", "double" ] }, { "name": "LineType", "type": [ "null", "string" ] }, { "name": "Location", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "NumberAccepted", "type": [ "null", "double" ] }, { "name": "NumberPreviouslyAccepted", "type": [ "null", "double" ] }, { "name": "OrderId", "type": [ "null", "string" ] }, { "name": "ProcessedState", "type": [ "null", "string" ] }, { "name": "Quantity", "type": [ "null", "double" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "ReceiptDate_Day", "type": [ "null", "long" ] }, { "name": "ReceiptId", "type": [ "null", "string" ] }, { "name": "ShippmentNoticeReference", "type": [ "null", "string" ] }, { "name": "Supplier_SupplierId", "type": [ "null", "string" ] }, { "name": "Supplier_SupplierLocationId", "type": [ "null", "string" ] }, { "name": "TotalAmount", "type": [ "null", "double" ] }, { "name": "UnitPrice", "type": [ "null", "double" ] } ] } } ] }, "DES_SSPInvoiceLineItemFact": { "type": "view", "name": "Ariba_{Realm}_invoicelineitems__", "primaryKeys": [ "InvoiceId", "InvoiceLineNumber", "SplitAccountingNumber", "SourceSystem.SourceSystemId", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "SSPInvoiceLineItemFact", "selectAttributes": [ "AccountingDate", "AccrualTaxAmount", "Amount", "AmountAccepted", "AmountDisputed", "ApprovedDate", "ChargeAmount", "DiscountAmount", "EstimatedSavings", "ExpectedTaxAmount", "InvoiceDateCreated", "InvoiceDate", "InvoiceId", "InvoiceLineNumber", "InvoiceNumber", "InvoiceOrigin", "InvoicePurpose", "InvoiceSourceDocument", "InvoiceStatus", "InvoiceSubmissionMethod", "InvoiceSubmitDate", "InvoiceType", "ItemCategory", "LineType", "TimeUpdated", "NetDueDate", "OrderID", "OrigCurrencyCode", "PaidAmount", "PaidDate", "PaymentTerms", "POId", "POLineNumber", "ProcurementSystem", "Quantity", "ReconciledDate", "ReconciliationStatus", "ShipFromLocation", "SourceSystem", "SplitAccountingNumber", "TaxAmount", "TaxRate" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "invoicelineitems", "fields": [ { "name": "AccountingDate_Day", "type": [ "null", "long" ] }, { "name": "AccrualTaxAmount", "type": [ "null", "double" ] }, { "name": "Amount", "type": [ "null", "double" ] }, { "name": "AmountAccepted", "type": [ "null", "double" ] }, { "name": "AmountDisputed", "type": [ "null", "double" ] }, { "name": "ApprovedDate_Day", "type": [ "null", "long" ] }, { "name": "ChargeAmount", "type": [ "null", "double" ] }, { "name": "DiscountAmount", "type": [ "null", "double" ] }, { "name": "EstimatedSavings", "type": [ "null", "double" ] }, { "name": "ExpectedTaxAmount", "type": [ "null", "double" ] }, { "name": "InvoiceDateCreated_Day", "type": [ "null", "long" ] }, { "name": "InvoiceDate_Day", "type": [ "null", "long" ] }, { "name": "InvoiceId", "type": [ "null", "string" ] }, { "name": "InvoiceLineNumber", "type": [ "null", "string" ] }, { "name": "InvoiceNumber", "type": [ "null", "string" ] }, { "name": "InvoiceOrigin", "type": [ "null", "string" ] }, { "name": "InvoicePurpose", "type": [ "null", "string" ] }, { "name": "InvoiceSourceDocument", "type": [ "null", "string" ] }, { "name": "InvoiceStatus", "type": [ "null", "string" ] }, { "name": "InvoiceSubmissionMethod", "type": [ "null", "string" ] }, { "name": "InvoiceSubmitDate_Day", "type": [ "null", "long" ] }, { "name": "InvoiceType", "type": [ "null", "string" ] }, { "name": "ItemCategory", "type": [ "null", "string" ] }, { "name": "LineType", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "NetDueDate_Day", "type": [ "null", "long" ] }, { "name": "OrderID", "type": [ "null", "string" ] }, { "name": "OrigCurrencyCode", "type": [ "null", "string" ] }, { "name": "PaidAmount", "type": [ "null", "double" ] }, { "name": "PaidDate_Day", "type": [ "null", "long" ] }, { "name": "PaymentTerms", "type": [ "null", "string" ] }, { "name": "POId", "type": [ "null", "string" ] }, { "name": "POLineNumber", "type": [ "null", "string" ] }, { "name": "ProcurementSystem_ProcurementSystem", "type": [ "null", "string" ] }, { "name": "Quantity", "type": [ "null", "double" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "ReconciledDate_Day", "type": [ "null", "long" ] }, { "name": "ReconciliationStatus", "type": [ "null", "string" ] }, { "name": "SourceSystem_SourceSystemId", "type": [ "null", "string" ] }, { "name": "ShipFromLocation_LocationId", "type": [ "null", "string" ] }, { "name": "SplitAccountingNumber", "type": [ "null", "int" ] }, { "name": "TaxAmount", "type": [ "null", "double" ] }, { "name": "TaxRate", "type": [ "null", "double" ] } ] } } ] }, "DES_InvoiceExceptionsFact": { "type": "view", "name": "Ariba_{Realm}_invoiceexceptions__", "primaryKeys": [ "ExceptionType.ExceptionTypeId", "InvoiceId", "InvoiceLineNumber", "Realm", "SourceSystem.SourceSystemId" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "InvoiceExceptionsFact", "selectAttributes": [ "InvoiceId", "InvoiceLineNumber", "InvoiceNumber", "InvoiceWithExceptionCount", "ExceptionType", "SourceSystem", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "invoiceexceptions", "fields": [ { "name": "ExceptionType_ExceptionTypeId", "type": [ "null", "string" ] }, { "name": "InvoiceId", "type": [ "null", "string" ] }, { "name": "InvoiceLineNumber", "type": [ "null", "double" ] }, { "name": "InvoiceNumber", "type": [ "null", "string" ] }, { "name": "InvoiceWithExceptionCount", "type": [ "null", "double" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "SourceSystem_SourceSystemId", "type": [ "null", "string" ] } ] } } ] }, "DES_SourcingProjectFact": { "type": "view", "name": "Ariba_{Realm}_sourcingprojectsanalytical__", "primaryKeys": [ "ProjectId", "Realm", "SourceSystem.SourceSystemId" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "SourcingProjectFact", "selectAttributes": [ "ProjectId", "EndDate", "EventType", "SourceSystem", "Status", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "sourcingprojectsanalytical", "fields": [ { "name": "EndDate_Day", "type": [ "null", "long" ] }, { "name": "EventType_EventType", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "ProjectId", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "SourceSystem_SourceSystemId", "type": [ "null", "string" ] } ] } } ] }, "DES_RfxItemSummaryFact": { "type": "view", "name": "Ariba_{Realm}_eventitemsummary__", "primaryKeys": [ "Event.EventId", "Event.VersionNumber", "Event.ItemId", "Realm" ], "columnMappings": { "Event_EventId": "EventId", "Event_VersionNumber": "EventVersion", "Event_ItemId": "ItemId", "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "RfxItemSummaryFact", "selectAttributes": [ "AwardedHistSpend", "AwardedTotalCost", "Event", "HistTotalCost", "NumItemAwarded", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "eventitemsummary", "fields": [ { "name": "AwardedHistSpend", "type": [ "null", "double" ] }, { "name": "AwardedTotalCost", "type": [ "null", "double" ] }, { "name": "EventId", "type": [ "null", "string" ] }, { "name": "EventVersion", "type": [ "null", "int" ] }, { "name": "HistTotalCost", "type": [ "null", "double" ] }, { "name": "ItemId", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "NumItemAwarded", "type": [ "null", "int" ] }, { "name": "Realm", "type": [ "null", "string" ] } ] } } ] }, "DES_EventSummaryFact": { "type": "view", "name": "Ariba_{Realm}_eventsummary__", "primaryKeys": [ "Event.EventId", "Event.VersionNumber", "Event.ItemId", "Realm" ], "columnMappings": { "Event_EventId": "EventId", "Event_VersionNumber": "EventVersion", "Event_ItemId": "ItemId", "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "EventSummaryFact", "selectAttributes": [ "AcceptedSuppliers", "DeclinedSuppliers", "Event", "InvitedSuppliers", "ParticipSuppliers", "ProjectInfo", "SurrogateBids", "TargetSavingsPct", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "eventsummary", "fields": [ { "name": "AcceptedSuppliers", "type": [ "null", "double" ] }, { "name": "DeclinedSuppliers", "type": [ "null", "double" ] }, { "name": "EventId", "type": [ "null", "string" ] }, { "name": "EventVersion", "type": [ "null", "int" ] }, { "name": "InvitedSuppliers", "type": [ "null", "double" ] }, { "name": "ItemId", "type": [ "null", "string" ] }, { "name": "ParticipSuppliers", "type": [ "null", "double" ] }, { "name": "ProjectInfo_ProjectId", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "SurrogateBids", "type": [ "null", "double" ] }, { "name": "TargetSavingsPct", "type": [ "null", "double" ] } ] } } ] }, "DES_ProjectTaskFact": { "type": "view", "name": "Ariba_{Realm}_projecttasks__", "primaryKeys": [ "Realm", "TaskId" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "ProjectTaskFact", "selectAttributes": [ "AltStatus", "BeginDate", "DocumentId", "EndDateTime", "Project", "Status", "TaskId", "TaskType", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "projecttasks", "fields": [ { "name": "AltStatus", "type": [ "null", "string" ] }, { "name": "BeginDate_Day", "type": [ "null", "long" ] }, { "name": "DocumentId", "type": [ "null", "string" ] }, { "name": "EndDateTime_Day", "type": [ "null", "long" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "Project_ProjectId", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "Status", "type": [ "null", "string" ] }, { "name": "TaskId", "type": [ "null", "string" ] }, { "name": "TaskType", "type": [ "null", "string" ] } ] } } ] } } }, { "dataSource": "SAPAribaRealm_{Realm}", "api": "sourcing-reporting", "resourceItems": { "DES_AuditEntry": { "type": "view", "name": "Ariba_{Realm}_auditentry__", "primaryKeys": [ "Id", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "AuditEntry", "selectAttributes": [ "ContextObject", "Template", "TimeCreated", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "auditentry", "fields": [ { "name": "ContextObject_InternalId", "type": [ "null", "string" ] }, { "name": "Id", "type": [ "null", "double" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "Template_Action_Name_DefaultStringTranslation", "type": [ "null", "string" ] }, { "name": "Template_Action_UniqueName", "type": [ "null", "string" ] }, { "name": "TimeCreated", "type": [ "null", "long" ] } ] } } ] }, "DES_RFXDocument": { "type": "view", "name": "Ariba_{Realm}_rfxdocument__", "primaryKeys": [ "InternalId", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "RFXDocument", "selectAttributes": [ "EventType", "InternalId", "LastModified", "TimeCreated", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "rfxdocument", "fields": [ { "name": "EventType", "type": [ "null", "string" ] }, { "name": "InternalId", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "LastModified", "type": [ "null", "long" ] }, { "name": "TimeCreated", "type": [ "null", "long" ] } ] } } ] }, "DES_SourcingProject": { "type": "view", "name": "Ariba_{Realm}_sourcingproject__", "primaryKeys": [ "InternalId", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "SourcingProject", "selectAttributes": [ "BaselineSpend", "InternalId", "ParentDocument", "TimeCreated", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "sourcingproject", "fields": [ { "name": "BaselineSpend_Amount", "type": [ "null", "double" ] }, { "name": "InternalId", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "ParentDocument_InternalId", "type": [ "null", "string" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "TimeCreated", "type": [ "null", "long" ] } ] } } ] }, "DES_SourcingRequest": { "type": "view", "name": "Ariba_{Realm}_sourcingrequest__", "primaryKeys": [ "InternalId", "Realm" ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "SourcingRequest", "selectAttributes": [ "InternalId", "Status", "TimeCreated", "TimeUpdated" ], "filterExpressions": [ { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null }, { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "sourcing", "schema": { "type": "record", "name": "sourcingrequest", "fields": [ { "name": "InternalId", "type": [ "null", "string" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "Status", "type": [ "null", "string" ] }, { "name": "TimeCreated", "type": [ "null", "long" ] } ] } } ] } } }, { "dataSource": "SAPAribaRealm_{Realm}", "api": "procurement-reporting", "resourceItems": { "DES_Requisition": { "type": "view", "name": "Ariba_{Realm}_requisition__", "primaryKeys": [ "UniqueName", "Realm" ], "vectors": [ { "generateUUID": "Id", "vector": [ "ApprovalRecords" ], "resourceItem": "requisition_ApprovalRecords", "name": "Ariba_{Realm}_requisition_ApprovalRecords__" } ], "columnMappings": { "TimeUpdated": "ModifiedAt" }, "view": { "status": "published", "documentType": "Requisition", "selectAttributes": [ "ApprovalRecords.ActivationDate", "ApprovalRecords.Date", "ApprovalRecords.State", "OrderedDate", "SubmitDate", "TimeUpdated", "UniqueName" ], "filterExpressions": [ { "name": "updatedDateFrom", "field": "TimeUpdated", "op": ">", "defaultValue": null }, { "name": "updatedDateTo", "field": "TimeUpdated", "op": "<=", "defaultValue": null } ] }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "requisition", "fields": [ { "name": "OrderedDate", "type": [ "null", "long" ] }, { "name": "Realm", "type": [ "null", "string" ] }, { "name": "SubmitDate", "type": [ "null", "long" ] }, { "name": "ModifiedAt", "type": [ "null", "long" ] }, { "name": "UniqueName", "type": [ "null", "string" ] } ] } } ] }, "requisition_ApprovalRecords": { "type": "vector", "tenantIdColumnName": "Requisition_Realm", "primaryKeys": [ "Id", "Requisition_Realm" ], "columnMappings": { "UniqueName": "Requisition_UniqueName", "ApprovalRecords_ActivationDate": "ActivationDate", "ApprovalRecords_Date": "Date", "ApprovalRecords_State": "State" }, "extensions": [ { "type": "Signavio", "dataTarget": "All", "api": "ingestion", "pipeline": "procurement", "schema": { "type": "record", "name": "requisition_ApprovalRecords", "fields": [ { "name": "ActivationDate", "type": [ "null", "long" ] }, { "name": "Date", "type": [ "null", "long" ] }, { "name": "Id", "type": [ "null", "string" ] }, { "name": "Requisition_Realm", "type": [ "null", "string" ] }, { "name": "Requisition_UniqueName", "type": [ "null", "string" ] }, { "name": "State", "type": [ "null", "int" ] } ] } } ] } } } ] }