Skip to main content

Celonis Product Documentation

Catalog Tables - OCPM

Description

OCPM Catalog Tables allow accessing metadata about a object centric process mining perspective (former: data model) including registered tables.

Syntax
 "OCPM":"Object_Type"

 "OCPM":"Event_Type"

 "OCPM":"Event_Object_Type_Relations"

  • "OCPM":"Object_Type": Access the object catalog that lists all object types in a OCPM datamodel. Has a "Name" column with all the objects in an OCPM datamodel.

  • "OCPM":"Event_Type": Access the event catalog that lists all event types in a OCPM datamodel. Has a "Name" column with all the event types in an OCPM datamodel.

  • "OCPM":"Event_Object_Type_Relations": Access the table listing all static Event-Object-Type-Relations which have been modeled within a perspective. Additional relations which have not been defined in the perspective (e.g. by using PROJECT_ON_OBJECT) are not listed. The table has the following columns:

    • "Object_Name" - Name of the object type.

    • "Event_Name" - Name of the event type. It can be directly connected to the object type or with using a mapping table in between the object and the event type.

The catalog tables behave like regular tables, but they are not joined to the data model (or to each other).

Examples

[1]

In this example we use the OCPM Object_Type to list all object types existing in the current data model.

Query

Column1 

         "OCPM":"Object_Type"."Name"

Input

Output

Act A

ID : string

TIMESTAMP : date

'001'

Sat Jan 01 2022 00:00:00.000

'002'

Sun Jan 02 2022 00:00:00.000

'003'

Mon Jan 03 2022 00:00:00.000

Act B

ID : string

TIMESTAMP : date

'007'

Sun Jan 02 2022 00:00:00.000

'008'

Sat Jan 08 2022 00:00:00.000

'009'

Sun Jan 09 2022 00:00:00.000

Act C

ID : string

TIMESTAMP : date

'020'

Tue Jan 04 2022 00:00:00.000

'030'

Fri Jan 07 2022 00:00:00.000

'040'

Sun Jan 09 2022 00:00:00.000

Act D

ID : string

TIMESTAMP : date

'051'

Mon Jan 10 2022 00:00:00.000

'052'

Tue Jan 11 2022 00:00:00.000

'053'

Wed Jan 12 2022 00:00:00.000

Act E

ID : string

TIMESTAMP : date

'061'

Wed Jan 12 2022 00:00:00.000

'062'

Fri Jan 14 2022 00:00:00.000

'063'

Sat Jan 15 2022 00:00:00.000

Act F

ID : string

TIMESTAMP : date

'071'

Fri Jan 14 2022 00:00:00.000

'072'

Tue Jan 18 2022 00:00:00.000

'073'

Wed Jan 19 2022 00:00:00.000

M_Mapping_1

OBJECT_ID : int

ID : string

0

'001'

0

'002'

0

'003'

M_Mapping_2

OBJECT_ID : int

ID : string

0

'007'

0

'008'

0

'009'

M_Mapping_3

OBJECT_ID : int

ID : string

0

'020'

0

'030'

0

'040'

M_Mapping_4

OBJECT_ID : int

ID : string

0

'051'

0

'052'

0

'053'

M_Mapping_5

OBJECT_ID : int

ID : string

0

'061'

0

'062'

0

'063'

M_Mapping_6

OBJECT_ID : int

ID : string

0

'071'

0

'072'

0

'073'

O_Object

ID : int

0

Foreign Keys

O_Object.ID

M_Mapping_1.OBJECT_ID

Act A.ID

M_Mapping_1.ID

O_Object.ID

M_Mapping_2.OBJECT_ID

Act B.ID

M_Mapping_2.ID

O_Object.ID

M_Mapping_3.OBJECT_ID

Act C.ID

M_Mapping_3.ID

O_Object.ID

M_Mapping_4.OBJECT_ID

Act D.ID

M_Mapping_4.ID

O_Object.ID

M_Mapping_5.OBJECT_ID

Act E.ID

M_Mapping_5.ID

O_Object.ID

M_Mapping_6.OBJECT_ID

Act F.ID

M_Mapping_6.ID

Result

Column1 : string

'O_Object'

[2]

In this example we use the OCPM Event_type table to list all event type (tables) in the current data model. Note that all event type tables are listed only once, even if they are connected to more than one object type.

Query

Column1 

         "OCPM":"Event_Type"."Name"

Input

Output

BillingDocumentItem

ID : string

Type : string

'0'

'Billing Document Item'

'1'

'Billing Document Item'

'2'

'Billing Document Item'

'3'

'Billing Document Item'

'4'

'Billing Document Item'

'5'

'Billing Document Item'

'6'

'Billing Document Item'

'7'

'Billing Document Item'

ChangeSalesOrder

ID : string

Type : string

Time : date

'0'

'Change Sales Order'

Thu Feb 20 2020 08:11:15.000

'1'

'Change Sales Order'

Thu Feb 20 2020 08:43:04.000

'2'

'Change Sales Order'

Fri Feb 21 2020 08:31:15.000

'3'

'Change Sales Order'

Fri Feb 21 2020 12:11:15.000

'4'

'Change Sales Order'

Fri Feb 21 2020 15:11:15.000

ClearInvoiceItem

ID : string

Type : string

Time : date

'0'

'Clear Invoice Item'

Mon Feb 24 2020 10:11:15.000

'1'

'Clear Invoice Item'

Tue Feb 25 2020 14:43:04.000

'2'

'Clear Invoice Item'

Tue Feb 25 2020 08:31:15.000

'3'

'Clear Invoice Item'

Wed Feb 26 2020 12:11:15.000

'4'

'Clear Invoice Item'

Wed Feb 26 2020 15:11:15.000

CreateBillingDocument

ID : string

Type : string

Time : date

'0'

'Create Billing Document'

Sun Feb 23 2020 10:11:15.000

'1'

'Create Billing Document'

Sun Feb 23 2020 14:43:04.000

'2'

'Create Billing Document'

Mon Feb 24 2020 08:31:15.000

'3'

'Create Billing Document'

Mon Feb 24 2020 12:11:15.000

'4'

'Create Billing Document'

Mon Feb 24 2020 15:11:15.000

'5'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

'6'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

'7'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

CreateDelivery

ID : string

Type : string

Time : date

'0'

'Create Delivery'

Sat Feb 22 2020 10:11:15.000

'1'

'Create Delivery'

Sat Feb 22 2020 14:43:04.000

'2'

'Create Delivery'

Sun Feb 23 2020 08:31:15.000

'3'

'Create Delivery'

Mon Feb 24 2020 12:11:15.000

'4'

'Create Delivery'

Mon Feb 24 2020 15:11:15.000

'5'

'Create Delivery'

Mon Feb 24 2020 12:34:15.000

'6'

'Create Delivery'

Mon Feb 24 2020 18:11:15.000

'7'

'Create Delivery'

Mon Feb 24 2020 21:11:15.000

CreateSalesOrder

ID : string

Type : string

Time : date

'0'

'Create Sales Order'

Thu Feb 20 2020 08:11:15.000

'1'

'Create Sales Order'

Thu Feb 20 2020 08:43:04.000

'2'

'Create Sales Order'

Fri Feb 21 2020 08:31:15.000

'3'

'Create Sales Order'

Fri Feb 21 2020 12:11:15.000

'4'

'Create Sales Order'

Fri Feb 21 2020 15:11:15.000

DeliveryItem

ID : string

Type : string

'0'

'Delivery Item'

'1'

'Delivery Item'

'2'

'Delivery Item'

'3'

'Delivery Item'

'4'

'Delivery Item'

'5'

'Delivery Item'

'6'

'Delivery Item'

'7'

'Delivery Item'

'8'

'Delivery Item'

'9'

'Delivery Item'

ExecutePicking

ID : string

Type : string

Time : date

'0'

'Execute Picking'

Mon Feb 24 2020 10:11:15.000

'1'

'Execute Picking'

Tue Feb 25 2020 14:43:04.000

'2'

'Execute Picking'

Tue Feb 25 2020 08:31:15.000

'3'

'Execute Picking'

Wed Feb 26 2020 12:11:15.000

'4'

'Execute Picking'

Wed Feb 26 2020 15:11:15.000

Mapping

EventType : string

EventID : string

ObjectType : string

ObjectID : string

'Create Sales Order'

'0'

'Sales Order Item'

'0'

'Create Sales Order'

'1'

'Sales Order Item'

'0'

'Create Sales Order'

'2'

'Sales Order Item'

'3'

'Create Sales Order'

'3'

'Sales Order Item'

'4'

'Create Sales Order'

'4'

'Sales Order Item'

'4'

'Create Sales Order'

'0'

'Sales Order'

'0'

'Create Sales Order'

'1'

'Sales Order'

'1'

'Create Sales Order'

'2'

'Sales Order'

'2'

'Create Sales Order'

'3'

'Sales Order'

'3'

'Create Sales Order'

'4'

'Sales Order'

'4'

'Change Sales Order'

'0'

'Sales Order Item'

'0'

'Change Sales Order'

'1'

'Sales Order Item'

'0'

'Change Sales Order'

'2'

'Sales Order Item'

'2'

'Change Sales Order'

'3'

'Sales Order Item'

'5'

'Change Sales Order'

'4'

'Sales Order Item'

'8'

'Execute Picking'

'0'

'Delivery Item'

'0'

'Execute Picking'

'1'

'Delivery Item'

'2'

'Execute Picking'

'2'

'Delivery Item'

'3'

'Execute Picking'

'3'

'Delivery Item'

'5'

'Execute Picking'

'4'

'Delivery Item'

'7'

'Create Billing Document'

'0'

'Billing Document Item'

'0'

'Create Billing Document'

'1'

'Billing Document Item'

'2'

'Create Billing Document'

'2'

'Billing Document Item'

'3'

'Create Billing Document'

'3'

'Billing Document Item'

'5'

'Create Billing Document'

'4'

'Billing Document Item'

'7'

'Create Billing Document'

'5'

'Billing Document Item'

'2'

'Create Billing Document'

'6'

'Billing Document Item'

'3'

'Create Billing Document'

'7'

'Billing Document Item'

'6'

'Create Billing Document'

'0'

'Sales Order Item'

'1'

'Create Billing Document'

'1'

'Sales Order Item'

'1'

'Create Billing Document'

'2'

'Sales Order Item'

'3'

'Create Billing Document'

'3'

'Sales Order Item'

'5'

'Create Billing Document'

'4'

'Sales Order Item'

'6'

'Create Billing Document'

'5'

'Sales Order Item'

'8'

'Create Billing Document'

'6'

'Sales Order Item'

'9'

'Create Billing Document'

'7'

'Sales Order Item'

'9'

'Create Delivery'

'0'

'Delivery Item'

'0'

'Create Delivery'

'1'

'Delivery Item'

'0'

'Create Delivery'

'2'

'Delivery Item'

'3'

'Create Delivery'

'3'

'Delivery Item'

'5'

'Create Delivery'

'4'

'Delivery Item'

'7'

'Create Delivery'

'5'

'Delivery Item'

'8'

'Create Delivery'

'6'

'Delivery Item'

'9'

'Create Delivery'

'7'

'Delivery Item'

'9'

'Create Delivery'

'0'

'Sales Order Item'

'0'

'Create Delivery'

'1'

'Sales Order Item'

'1'

'Create Delivery'

'2'

'Sales Order Item'

'2'

'Create Delivery'

'3'

'Sales Order Item'

'5'

'Create Delivery'

'4'

'Sales Order Item'

'6'

'Create Delivery'

'5'

'Sales Order Item'

'7'

'Create Delivery'

'6'

'Sales Order Item'

'9'

'Create Delivery'

'7'

'Sales Order Item'

'9'

'Clear Invoice Item'

'0'

'Quotation'

'0'

'Clear Invoice Item'

'1'

'Quotation'

'0'

'Clear Invoice Item'

'2'

'Quotation'

'2'

'Clear Invoice Item'

'3'

'Quotation'

'3'

'Clear Invoice Item'

'4'

'Quotation'

'4'

Quotation

ID : string

Type : string

'0'

'Quotation'

'1'

'Quotation'

'2'

'Quotation'

'3'

'Quotation'

'4'

'Quotation'

SalesOrder

ID : string

Type : string

SalesDocument : string

'0'

'Sales Order'

'0001152080'

'1'

'Sales Order'

'0001152081'

'2'

'Sales Order'

'0001152082'

'3'

'Sales Order'

'0001152083'

'4'

'Sales Order'

'0001152084'

SalesOrderItem

ID : string

Type : string

SalesOrderId : string

'0'

'Sales Order Item'

'0'

'1'

'Sales Order Item'

'1'

'2'

'Sales Order Item'

'1'

'3'

'Sales Order Item'

'1'

'4'

'Sales Order Item'

'2'

'5'

'Sales Order Item'

'3'

'6'

'Sales Order Item'

'4'

'7'

'Sales Order Item'

'4'

'8'

'Sales Order Item'

'0'

'9'

'Sales Order Item'

'3'

Foreign Keys

SalesOrderItem.ID

Mapping.ObjectID

SalesOrderItem.Type

Mapping.ObjectType

SalesOrder.ID

Mapping.ObjectID

SalesOrder.Type

Mapping.ObjectType

BillingDocumentItem.ID

Mapping.ObjectID

BillingDocumentItem.Type

Mapping.ObjectType

DeliveryItem.ID

Mapping.ObjectID

DeliveryItem.Type

Mapping.ObjectType

Quotation.ID

Mapping.ObjectID

Quotation.Type

Mapping.ObjectType

ChangeSalesOrder.ID

Mapping.EventID

ChangeSalesOrder.Type

Mapping.EventType

CreateSalesOrder.ID

Mapping.EventID

CreateSalesOrder.Type

Mapping.EventType

CreateDelivery.ID

Mapping.EventID

CreateDelivery.Type

Mapping.EventType

ClearInvoiceItem.ID

Mapping.EventID

ClearInvoiceItem.Type

Mapping.EventType

CreateBillingDocument.ID

Mapping.EventID

CreateBillingDocument.Type

Mapping.EventType

ExecutePicking.ID

Mapping.EventID

ExecutePicking.Type

Mapping.EventType

Result

Column1 : string

'ChangeSalesOrder'

'ClearInvoiceItem'

'CreateBillingDocument'

'CreateDelivery'

'CreateSalesOrder'

'ExecutePicking'

[3]

In this example an Event_Object_Type_Relations table is generated. It lists all existing objects and all corresponding event types which are present in an OCPM data model.

Query

Column1 

         "OCPM":"Event_Object_Type_Relations"."Object_Name"

Column2 

         "OCPM":"Event_Object_Type_Relations"."Event_Name"

Input

Output

Act A

ID : string

TIMESTAMP : date

'001'

Sat Jan 01 2022 00:00:00.000

'002'

Sun Jan 02 2022 00:00:00.000

'003'

Mon Jan 03 2022 00:00:00.000

Act B

ID : string

TIMESTAMP : date

'007'

Sun Jan 02 2022 00:00:00.000

'008'

Sat Jan 08 2022 00:00:00.000

'009'

Sun Jan 09 2022 00:00:00.000

Act C

ID : string

TIMESTAMP : date

'020'

Tue Jan 04 2022 00:00:00.000

'030'

Fri Jan 07 2022 00:00:00.000

'040'

Sun Jan 09 2022 00:00:00.000

Act D

ID : string

TIMESTAMP : date

'051'

Mon Jan 10 2022 00:00:00.000

'052'

Tue Jan 11 2022 00:00:00.000

'053'

Wed Jan 12 2022 00:00:00.000

Act E

ID : string

TIMESTAMP : date

'061'

Wed Jan 12 2022 00:00:00.000

'062'

Fri Jan 14 2022 00:00:00.000

'063'

Sat Jan 15 2022 00:00:00.000

Act F

ID : string

TIMESTAMP : date

'071'

Fri Jan 14 2022 00:00:00.000

'072'

Tue Jan 18 2022 00:00:00.000

'073'

Wed Jan 19 2022 00:00:00.000

M_Mapping_1

OBJECT_ID : int

ID : string

0

'001'

0

'002'

0

'003'

M_Mapping_2

OBJECT_ID : int

ID : string

0

'007'

0

'008'

0

'009'

M_Mapping_3

OBJECT_ID : int

ID : string

0

'020'

0

'030'

0

'040'

M_Mapping_4

OBJECT_ID : int

ID : string

0

'051'

0

'052'

0

'053'

M_Mapping_5

OBJECT_ID : int

ID : string

0

'061'

0

'062'

0

'063'

M_Mapping_6

OBJECT_ID : int

ID : string

0

'071'

0

'072'

0

'073'

O_Object

ID : int

0

Foreign Keys

O_Object.ID

M_Mapping_1.OBJECT_ID

Act A.ID

M_Mapping_1.ID

O_Object.ID

M_Mapping_2.OBJECT_ID

Act B.ID

M_Mapping_2.ID

O_Object.ID

M_Mapping_3.OBJECT_ID

Act C.ID

M_Mapping_3.ID

O_Object.ID

M_Mapping_4.OBJECT_ID

Act D.ID

M_Mapping_4.ID

O_Object.ID

M_Mapping_5.OBJECT_ID

Act E.ID

M_Mapping_5.ID

O_Object.ID

M_Mapping_6.OBJECT_ID

Act F.ID

M_Mapping_6.ID

Result

Column1 : string

Column2 : string

'O_Object'

'Act A'

'O_Object'

'Act B'

'O_Object'

'Act C'

'O_Object'

'Act D'

'O_Object'

'Act E'

'O_Object'

'Act F'

[4]

In this example an Event_Object_Type_Relations table is generated from a OCPM data model having multiple Object - Event relationships. For each object, the connected events are listed.

Query

Column1 

         "OCPM":"Event_Object_Type_Relations"."Object_Name"

Column2 

         "OCPM":"Event_Object_Type_Relations"."Event_Name"

Input

Output

BillingDocumentItem

ID : string

Type : string

'0'

'Billing Document Item'

'1'

'Billing Document Item'

'2'

'Billing Document Item'

'3'

'Billing Document Item'

'4'

'Billing Document Item'

'5'

'Billing Document Item'

'6'

'Billing Document Item'

'7'

'Billing Document Item'

ChangeSalesOrder

ID : string

Type : string

Time : date

'0'

'Change Sales Order'

Thu Feb 20 2020 08:11:15.000

'1'

'Change Sales Order'

Thu Feb 20 2020 08:43:04.000

'2'

'Change Sales Order'

Fri Feb 21 2020 08:31:15.000

'3'

'Change Sales Order'

Fri Feb 21 2020 12:11:15.000

'4'

'Change Sales Order'

Fri Feb 21 2020 15:11:15.000

ClearInvoiceItem

ID : string

Type : string

Time : date

'0'

'Clear Invoice Item'

Mon Feb 24 2020 10:11:15.000

'1'

'Clear Invoice Item'

Tue Feb 25 2020 14:43:04.000

'2'

'Clear Invoice Item'

Tue Feb 25 2020 08:31:15.000

'3'

'Clear Invoice Item'

Wed Feb 26 2020 12:11:15.000

'4'

'Clear Invoice Item'

Wed Feb 26 2020 15:11:15.000

CreateBillingDocument

ID : string

Type : string

Time : date

'0'

'Create Billing Document'

Sun Feb 23 2020 10:11:15.000

'1'

'Create Billing Document'

Sun Feb 23 2020 14:43:04.000

'2'

'Create Billing Document'

Mon Feb 24 2020 08:31:15.000

'3'

'Create Billing Document'

Mon Feb 24 2020 12:11:15.000

'4'

'Create Billing Document'

Mon Feb 24 2020 15:11:15.000

'5'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

'6'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

'7'

'Create Billing Document'

Tue Feb 25 2020 15:11:15.000

CreateDelivery

ID : string

Type : string

Time : date

'0'

'Create Delivery'

Sat Feb 22 2020 10:11:15.000

'1'

'Create Delivery'

Sat Feb 22 2020 14:43:04.000

'2'

'Create Delivery'

Sun Feb 23 2020 08:31:15.000

'3'

'Create Delivery'

Mon Feb 24 2020 12:11:15.000

'4'

'Create Delivery'

Mon Feb 24 2020 15:11:15.000

'5'

'Create Delivery'

Mon Feb 24 2020 12:34:15.000

'6'

'Create Delivery'

Mon Feb 24 2020 18:11:15.000

'7'

'Create Delivery'

Mon Feb 24 2020 21:11:15.000

CreateSalesOrder

ID : string

Type : string

Time : date

'0'

'Create Sales Order'

Thu Feb 20 2020 08:11:15.000

'1'

'Create Sales Order'

Thu Feb 20 2020 08:43:04.000

'2'

'Create Sales Order'

Fri Feb 21 2020 08:31:15.000

'3'

'Create Sales Order'

Fri Feb 21 2020 12:11:15.000

'4'

'Create Sales Order'

Fri Feb 21 2020 15:11:15.000

DeliveryItem

ID : string

Type : string

'0'

'Delivery Item'

'1'

'Delivery Item'

'2'

'Delivery Item'

'3'

'Delivery Item'

'4'

'Delivery Item'

'5'

'Delivery Item'

'6'

'Delivery Item'

'7'

'Delivery Item'

'8'

'Delivery Item'

'9'

'Delivery Item'

ExecutePicking

ID : string

Type : string

Time : date

'0'

'Execute Picking'

Mon Feb 24 2020 10:11:15.000

'1'

'Execute Picking'

Tue Feb 25 2020 14:43:04.000

'2'

'Execute Picking'

Tue Feb 25 2020 08:31:15.000

'3'

'Execute Picking'

Wed Feb 26 2020 12:11:15.000

'4'

'Execute Picking'

Wed Feb 26 2020 15:11:15.000

Mapping

EventType : string

EventID : string

ObjectType : string

ObjectID : string

'Create Sales Order'

'0'

'Sales Order Item'

'0'

'Create Sales Order'

'1'

'Sales Order Item'

'0'

'Create Sales Order'

'2'

'Sales Order Item'

'3'

'Create Sales Order'

'3'

'Sales Order Item'

'4'

'Create Sales Order'

'4'

'Sales Order Item'

'4'

'Create Sales Order'

'0'

'Sales Order'

'0'

'Create Sales Order'

'1'

'Sales Order'

'1'

'Create Sales Order'

'2'

'Sales Order'

'2'

'Create Sales Order'

'3'

'Sales Order'

'3'

'Create Sales Order'

'4'

'Sales Order'

'4'

'Change Sales Order'

'0'

'Sales Order Item'

'0'

'Change Sales Order'

'1'

'Sales Order Item'

'0'

'Change Sales Order'

'2'

'Sales Order Item'

'2'

'Change Sales Order'

'3'

'Sales Order Item'

'5'

'Change Sales Order'

'4'

'Sales Order Item'

'8'

'Execute Picking'

'0'

'Delivery Item'

'0'

'Execute Picking'

'1'

'Delivery Item'

'2'

'Execute Picking'

'2'

'Delivery Item'

'3'

'Execute Picking'

'3'

'Delivery Item'

'5'

'Execute Picking'

'4'

'Delivery Item'

'7'

'Create Billing Document'

'0'

'Billing Document Item'

'0'

'Create Billing Document'

'1'

'Billing Document Item'

'2'

'Create Billing Document'

'2'

'Billing Document Item'

'3'

'Create Billing Document'

'3'

'Billing Document Item'

'5'

'Create Billing Document'

'4'

'Billing Document Item'

'7'

'Create Billing Document'

'5'

'Billing Document Item'

'2'

'Create Billing Document'

'6'

'Billing Document Item'

'3'

'Create Billing Document'

'7'

'Billing Document Item'

'6'

'Create Billing Document'

'0'

'Sales Order Item'

'1'

'Create Billing Document'

'1'

'Sales Order Item'

'1'

'Create Billing Document'

'2'

'Sales Order Item'

'3'

'Create Billing Document'

'3'

'Sales Order Item'

'5'

'Create Billing Document'

'4'

'Sales Order Item'

'6'

'Create Billing Document'

'5'

'Sales Order Item'

'8'

'Create Billing Document'

'6'

'Sales Order Item'

'9'

'Create Billing Document'

'7'

'Sales Order Item'

'9'

'Create Delivery'

'0'

'Delivery Item'

'0'

'Create Delivery'

'1'

'Delivery Item'

'0'

'Create Delivery'

'2'

'Delivery Item'

'3'

'Create Delivery'

'3'

'Delivery Item'

'5'

'Create Delivery'

'4'

'Delivery Item'

'7'

'Create Delivery'

'5'

'Delivery Item'

'8'

'Create Delivery'

'6'

'Delivery Item'

'9'

'Create Delivery'

'7'

'Delivery Item'

'9'

'Create Delivery'

'0'

'Sales Order Item'

'0'

'Create Delivery'

'1'

'Sales Order Item'

'1'

'Create Delivery'

'2'

'Sales Order Item'

'2'

'Create Delivery'

'3'

'Sales Order Item'

'5'

'Create Delivery'

'4'

'Sales Order Item'

'6'

'Create Delivery'

'5'

'Sales Order Item'

'7'

'Create Delivery'

'6'

'Sales Order Item'

'9'

'Create Delivery'

'7'

'Sales Order Item'

'9'

'Clear Invoice Item'

'0'

'Quotation'

'0'

'Clear Invoice Item'

'1'

'Quotation'

'0'

'Clear Invoice Item'

'2'

'Quotation'

'2'

'Clear Invoice Item'

'3'

'Quotation'

'3'

'Clear Invoice Item'

'4'

'Quotation'

'4'

Quotation

ID : string

Type : string

'0'

'Quotation'

'1'

'Quotation'

'2'

'Quotation'

'3'

'Quotation'

'4'

'Quotation'

SalesOrder

ID : string

Type : string

SalesDocument : string

'0'

'Sales Order'

'0001152080'

'1'

'Sales Order'

'0001152081'

'2'

'Sales Order'

'0001152082'

'3'

'Sales Order'

'0001152083'

'4'

'Sales Order'

'0001152084'

SalesOrderItem

ID : string

Type : string

SalesOrderId : string

'0'

'Sales Order Item'

'0'

'1'

'Sales Order Item'

'1'

'2'

'Sales Order Item'

'1'

'3'

'Sales Order Item'

'1'

'4'

'Sales Order Item'

'2'

'5'

'Sales Order Item'

'3'

'6'

'Sales Order Item'

'4'

'7'

'Sales Order Item'

'4'

'8'

'Sales Order Item'

'0'

'9'

'Sales Order Item'

'3'

Foreign Keys

SalesOrderItem.ID

Mapping.ObjectID

SalesOrderItem.Type

Mapping.ObjectType

SalesOrder.ID

Mapping.ObjectID

SalesOrder.Type

Mapping.ObjectType

BillingDocumentItem.ID

Mapping.ObjectID

BillingDocumentItem.Type

Mapping.ObjectType

DeliveryItem.ID

Mapping.ObjectID

DeliveryItem.Type

Mapping.ObjectType

Quotation.ID

Mapping.ObjectID

Quotation.Type

Mapping.ObjectType

ChangeSalesOrder.ID

Mapping.EventID

ChangeSalesOrder.Type

Mapping.EventType

CreateSalesOrder.ID

Mapping.EventID

CreateSalesOrder.Type

Mapping.EventType

CreateDelivery.ID

Mapping.EventID

CreateDelivery.Type

Mapping.EventType

ClearInvoiceItem.ID

Mapping.EventID

ClearInvoiceItem.Type

Mapping.EventType

CreateBillingDocument.ID

Mapping.EventID

CreateBillingDocument.Type

Mapping.EventType

ExecutePicking.ID

Mapping.EventID

ExecutePicking.Type

Mapping.EventType

Result

Column1 : string

Column2 : string

'BillingDocumentItem'

'ChangeSalesOrder'

'BillingDocumentItem'

'ClearInvoiceItem'

'BillingDocumentItem'

'CreateBillingDocument'

'BillingDocumentItem'

'CreateDelivery'

'BillingDocumentItem'

'CreateSalesOrder'

'BillingDocumentItem'

'ExecutePicking'

'DeliveryItem'

'ChangeSalesOrder'

'DeliveryItem'

'ClearInvoiceItem'

'DeliveryItem'

'CreateBillingDocument'

'DeliveryItem'

'CreateDelivery'

'DeliveryItem'

'CreateSalesOrder'

'DeliveryItem'

'ExecutePicking'

'Quotation'

'ChangeSalesOrder'

'Quotation'

'ClearInvoiceItem'

'Quotation'

'CreateBillingDocument'

'Quotation'

'CreateDelivery'

'Quotation'

'CreateSalesOrder'

'Quotation'

'ExecutePicking'

'SalesOrder'

'ChangeSalesOrder'

'SalesOrder'

'ClearInvoiceItem'

'SalesOrder'

'CreateBillingDocument'

'SalesOrder'

'CreateDelivery'

'SalesOrder'

'CreateSalesOrder'

'SalesOrder'

'ExecutePicking'

'SalesOrderItem'

'ChangeSalesOrder'

'SalesOrderItem'

'ClearInvoiceItem'

'SalesOrderItem'

'CreateBillingDocument'

'SalesOrderItem'

'CreateDelivery'

'SalesOrderItem'

'CreateSalesOrder'

'SalesOrderItem'

'ExecutePicking'