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