Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Classification System New | ||||||||||
1 | CHARACTERTEXT | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
2 | CHARACTERTEXTH | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
3 | CME_ST_VAL_TXT | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
4 | CME_ST_VAL_TXTH | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
5 | DEFSCOPETEXT | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
6 | DEFSCOPETEXTH | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
7 | DTYPETEXT | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
8 | DTYPETEXTH | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
Master Data Framework | ||||||||||
9 | DML_DELIVERY_TXT | MDF Text Object | 12 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
10 | DML_ST_TEXT | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
11 | DML_ST_TEXTH | DML Text Object | 15 | POS_COUNT | Sort Order | nvarchar | 5 | 0 | ||
Media Product Sales and Distribution | ||||||||||
12 | JKSESUBPRICESETP | IS-M: Contract - Discount Group | 6 | POS_COUNT | IS-M: Count This Item in Discount Level Calculation | nvarchar | 1 | 0 |