Technische Dokumentation Modul SALES

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Endanwender (zur vollständigen 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

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