| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPeriodical Sales and Distribution |
1 | JKEP | Sales Order: Schedule Line Data | 17 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
2 | JVSOCOMPL_DAYS | IS-M/SD: Dates and Quantities for Shipping Order Complaint | 9 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
3 | JVTNCT5 | IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.) | 12 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
4 | JVTNOTICE | IS-M/SD: Carrier Change Notifications | 18 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
5 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 34 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
6 | S450 | IS-M/SD: Customer Statistics | 16 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
7 | S450E | S450 - Structural Data | 9 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
8 | S451 | IS-M/SD: Sales Office Statistics | 17 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
9 | S451E | S451 - Structural Data | 10 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
10 | S452 | IS-M/SD: Product Statistics | 15 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
11 | S452E | S452 - Structural Data | 8 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
12 | S453 | IS-M/SD: Plant/Country Statistics | 17 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
13 | S453E | S453 - Structural Data | 10 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
14 | S454 | IS-M/SD: Sales Agents | 16 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
15 | S454E | S454 - Structural Data | 9 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
16 | S455 | IS-M/SD: Promotion Statistics | 16 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
17 | S455E | S455 - Structural Data | 9 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
18 | S456 | IS-M/SD: AR Category Statistics | 15 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
19 | S456E | S456 - Structural Data | 8 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
20 | S457 | IS-M/SD: Carrier Route Statistics | 14 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
21 | S457E | S457 - Structural Data | 7 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
22 | TJK00 | IS-M/SD: Sales: General Control Parameters | 3 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |
TOPSAP Media |
23 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 28 | ETMEINS | IS-M: Sales Unit for Sales Order | nvarchar | 3 | 0 | | |