Technische Dokumentation Modul SALES
Inhaltsverzeichnis
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