Technische Dokumentation Modul SALES

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Vollständig (zur Endanwender Dokumentation)
Erstellt am: 07.12.2023
Modulversion: 7
Modultyp: Basismodul
Beschreibung: Modul für Vertriebsdaten
Benötigt Administrator Rechte: Nein
Ab OCT Version: 5.10.11

Tabellen

global.tSALES_Customergroups

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 CustomergroupKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Customergroup key from the source system consisting of DataSourceKey | CompanyID | CustomergroupID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of CustomergroupKey.
5 CustomergroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customergroup. Part of CustomergroupKey.
6 CustomergroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customergroup.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Referenziert von

global.tSALES_Customers

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 CustomerKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Customer key from the source system consisting of DataSourceKey | CompanyID | CustomerID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of CustomerKey.
5 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customer. Part of CustomerKey.
6 CustomerName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customer.
7 CustomerGroupID NVARCHAR(50) highlight_off highlight_off highlight_off
ID of Customer Group.
8 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
9 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
10 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
11 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Referenziert von

global.tSALES_Productgroups

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 ProductgroupKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Productgroup key from the source system consisting of DataSourceKey | CompanyID | ProductgroupID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of ProductgroupKey.
5 ProductgroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Productgroup. Part of ProductgroupKey.
6 ProductgroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Productgroup.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Referenziert von

global.tSALES_Products

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 ProductKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Product key from the source system consisting of DataSourceKey | CompanyID | ProductID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of ProductKey.
5 ProductID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Product. Part of ProductKey.
6 ProductName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Product.
7 ProductGroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the ProductGroup.
8 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
9 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
10 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Referenziert von

global.tSALES_Salespersons

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 SalespersonKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique salesperson key from the source system consisting of DataSourceKey | CompanyID | SalespersonID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of SalespersonKey.
5 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the salesperson. Part of SalespersonKey.
6 SalespersonName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the salesperson.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Referenziert von

integration.tSALES_Customergroups

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 CustomergroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customergroup.
5 CustomergroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customergroup.
6 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tSALES_Customers

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customer.
5 CustomerName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customer.
6 CustomerGroupID NVARCHAR(50) highlight_off highlight_off highlight_off
ID of Customer Group.
7 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
8 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tSALES_Orders

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 OrderID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Order.
5 OrderName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Order.
6 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
ID of Order Group.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tSALES_Productgroups

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 ProductgroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Productgroup.
5 ProductgroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Productgroup.
6 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tSALES_Products

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 ProductID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Product.
5 ProductName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Product.
6 ProductGroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Productgroup.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tSALES_Sales

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 OrderID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the order.
5 OrderpositionID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the orderposition.
6 OrderpositionName NVARCHAR(1000) highlight_off highlight_off highlight_off
Name of the orderposition.
7 ProductID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the product.
8 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the salesperson.
9 CustomerID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the customer.
10 Amount BIGINT highlight_off highlight_off highlight_off
Sales Amount. Decimal places are eliminated through multiplication with 100.
11 Price BIGINT highlight_off highlight_off highlight_off
Price for 1 Amount. Decimal places are eliminated through multiplication with 100.
12 Sales BIGINT highlight_off highlight_off highlight_off
Sum of Sales (Amount * Price). Decimal places are eliminated through multiplication with 100.
13 SalesDate DATE check_circle highlight_off highlight_off
Date of the sale.
14 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any Sale individual informations.

Referenziert von

integration.tSALES_Salespersons

Table to store account masterdata.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company.
4 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the salesperson.
5 SalespersonName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the salesperson.
6 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

result.tSALES_Customergroups

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 CustomergroupKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Customergroup key from the source system consisting of DataSourceKey | CompanyID | CustomergroupID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of CustomergroupKey.
5 CustomergroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customergroup. Part of CustomergroupKey.
6 CustomergroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customergroup.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

result.tSALES_Customers

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of CustomerKey.
3 CustomerKey NVARCHAR(255) highlight_off highlight_off highlight_off
Unique Customer key from the source system consisting of DataSourceKey | CompanyID | CustomerID.
4 CustomerKeyMapped NVARCHAR(255) highlight_off highlight_off highlight_off
Unique Customer key from the source system consisting of DataSourceKey | CompanyID | CustomerID.
5 KundenID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Customer. Part of CustomerKey.
6 KundenName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Customer.
7 Kunde NVARCHAR(50) highlight_off highlight_off highlight_off
Customer ID and Name
8 KundengruppeID NVARCHAR(50) highlight_off highlight_off highlight_off
ID of Customer Group.
9 VertrieblerID NVARCHAR(50) highlight_off highlight_off highlight_off
ID of Sales Person

result.tSALES_Productgroups

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 ProductgroupKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Productgroup key from the source system consisting of DataSourceKey | CompanyID | ProductgroupID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of ProductgroupKey.
5 ProductgroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Productgroup. Part of ProductgroupKey.
6 ProductgroupName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Productgroup.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

result.tSALES_Products

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 ProductKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique Product key from the source system consisting of DataSourceKey | CompanyID | ProductID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of ProductKey.
5 ProductID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the Product. Part of ProductKey.
6 ProductName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the Product.
7 ProductGroupID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the ProductGroup.
8 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
9 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
10 MappingKey INT check_circle highlight_off highlight_off
MappingKey

result.tSALES_Salespersons

Table to store account masterdata. Table contains merged data from integration and planning.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 SalespersonKey NVARCHAR(114) highlight_off highlight_off check_circle
Unique salesperson key from the source system consisting of DataSourceKey | CompanyID | SalespersonID.
3 DataSourceKey INT highlight_off highlight_off highlight_off
DataSourceKey
4 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of SalespersonKey.
5 SalespersonID NVARCHAR(50) highlight_off highlight_off highlight_off
Identifier for the salesperson. Part of SalespersonKey.
6 SalespersonName NVARCHAR(255) highlight_off highlight_off highlight_off
Name of the salesperson.
7 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.
8 OwnerCODE NVARCHAR(50) highlight_off highlight_off highlight_off
OwnerCODE
9 MappingKey INT check_circle highlight_off highlight_off
MappingKey

Sichten

agent.vJSON_global_tSALES_Customergroups

This view resolves the CustomValuesJSON column in table global.tSALES_Customergroups to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_global_tSALES_Customers

This view resolves the CustomValuesJSON column in table global.tSALES_Customers to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_global_tSALES_Productgroups

This view resolves the CustomValuesJSON column in table global.tSALES_Productgroups to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_global_tSALES_Products

This view resolves the CustomValuesJSON column in table global.tSALES_Products to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_global_tSALES_Salespersons

This view resolves the CustomValuesJSON column in table global.tSALES_Salespersons to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tSALES_Customergroups

This view resolves the CustomValuesJSON column in table integration.tSALES_Customergroups to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

agent.vJSON_integration_tSALES_Customers

This view resolves the CustomValuesJSON column in table integration.tSALES_Customers to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

agent.vJSON_integration_tSALES_Productgroups

This view resolves the CustomValuesJSON column in table integration.tSALES_Productgroups to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

agent.vJSON_integration_tSALES_Products

This view resolves the CustomValuesJSON column in table integration.tSALES_Products to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

agent.vJSON_integration_tSALES_Salespersons

This view resolves the CustomValuesJSON column in table integration.tSALES_Salespersons to actual columns.

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
RowKey

Referenzierte Objekte

result.vSALES_Customergroups

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6)

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
Mandanten ID aus OCT.
2 CustomergroupKey NVARCHAR(114) highlight_off highlight_off highlight_off
CustomergroupKey
3 KundengruppeID NVARCHAR(50) highlight_off highlight_off highlight_off
ID der Kundengruppe
4 KundengruppeName NVARCHAR(255) highlight_off highlight_off highlight_off
Name der Kundengruppe
5 Kundengruppe NVARCHAR(306) highlight_off highlight_off highlight_off
Kombination aus KundengruppeID und KundengruppeName
6 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSALES_Customers

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6)

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
Mandanten ID aus OCT.
2 CustomerKey NVARCHAR(114) highlight_off highlight_off highlight_off
CustomerKey
3 KundenID NVARCHAR(50) highlight_off highlight_off highlight_off
ID des Kunden
4 KundenName NVARCHAR(255) highlight_off highlight_off highlight_off
Name des Kunden
5 Kunde NVARCHAR(306) highlight_off highlight_off highlight_off
Kombination aus KundenID und KundenName
6 KundengruppeID NVARCHAR(50) highlight_off highlight_off highlight_off
ID der Kundengruppe
7 VertrieblerID NVARCHAR(50) highlight_off highlight_off highlight_off
ID des Vertrieblers
8 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSALES_Productgroups

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6)

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
Mandanten ID aus OCT.
2 ProductgroupKey NVARCHAR(114) highlight_off highlight_off highlight_off
ProductgroupKey
3 ProduktgruppeID NVARCHAR(50) highlight_off highlight_off highlight_off
ID der Produktgruppe
4 ProduktgruppeName NVARCHAR(255) highlight_off highlight_off highlight_off
Name der Produktgruppe
5 Produktgruppe NVARCHAR(306) highlight_off highlight_off highlight_off
Kombination aus ProduktgruppeID und ProduktgruppeName
6 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSALES_Products

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6)

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
Mandanten ID aus OCT.
2 ProductKey NVARCHAR(114) highlight_off highlight_off highlight_off
ProductKey
3 ProduktID NVARCHAR(50) highlight_off highlight_off highlight_off
ID des Produkts
4 ProduktName NVARCHAR(255) highlight_off highlight_off highlight_off
Name des Produkts
5 Produkt NVARCHAR(306) highlight_off highlight_off highlight_off
Kombination aus ProduktID und ProduktName
6 ProduktgruppeID NVARCHAR(50) highlight_off highlight_off highlight_off
ID der Produktgruppe
7 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

result.vSALES_Salespersons

View stellt Stammdaten zu Konten bereit. Falls ein Standardkontenrahmen in den Mandantenstammdaten gesetzt ist, wird der Kontenrahmen automatisch zu den Konten zugeordnet (Level0 - Level6)

# Name Datentyp NULL Identity Berechnet
1 MandantenID NVARCHAR(50) check_circle highlight_off highlight_off
Mandanten ID aus OCT.
2 SalespersonKey NVARCHAR(114) highlight_off highlight_off highlight_off
SalespersonKey
3 VertrieblerID NVARCHAR(50) highlight_off highlight_off highlight_off
ID des Vertrieblers
4 VertrieblerName NVARCHAR(255) highlight_off highlight_off highlight_off
Name des Vertrieblers
5 Vertriebler NVARCHAR(306) highlight_off highlight_off highlight_off
Kombination aus VertrieblerID und VertrieblerName
6 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenzierte Objekte

Referenziert von

Prozeduren

agent.pDeleteIntegrationValuesSALES

This stored procedure is used to delete data from all tables of the module "SALES".

# Parameter Datentyp
1 @DataSourceKey INT
DataSourceKey
2 @CompanyID NVARCHAR(50)
OCT identifier for the company. Part of AccountKey.
3 @PeriodFrom INT
PeriodFrom
4 @PeriodTo INT
PeriodTo
5 @Username NVARCHAR(255)
Username
6 @IsDeltaloadBool BIT
IsDeltaloadBool
7 @Module NVARCHAR(255)
Module

Referenzierte Objekte

agent.pPostBulkloadSALES

This the post bulkload procedure of module "FIN". The procedure triggers the sync of master data from integration to global schema including foster parent handling.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
List of CompanyKeys, semicolon separated.

Referenzierte Objekte

agent.pSyncSALES

Procedure to transfer data of module SALES to result schema.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
CompanyKeys
3 @FullRebuild BIT
Force full rebuild of fact tables.

Referenzierte Objekte