| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S990 | Smoby: hiérarchie client | 43 | AEKZWI3 | Entrée cdes client - Valeur nette 2 | decimal | 17 | 2 | | |
TOPData Collection |
2 | S001 | SIS: Customer Statistics | 41 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
3 | S001BIW1 | S001BIW1 * SIS: Customer Statistics | 41 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
4 | S001BIW2 | S001BIW2 * SIS: Customer statistics | 41 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
5 | S002 | SIS: Sales Office Statistics | 23 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
6 | S002BIW1 | S002BIW1 * SIS: Sales office statistics | 23 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
7 | S002BIW2 | S002BIW2 * SIS: Sales office statistics | 23 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
8 | S003 | SIS: SalesOrg/DistCh/Division/District/Customer/Product | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
9 | S003BIW1 | S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
10 | S003BIW2 | S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
11 | S004 | SIS: Product/Sales Organization/Distribution Channel | 22 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
12 | S004BIW1 | SIS: Product/Sales Organization/Distribution Channel | 22 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
13 | S004BIW2 | SIS: Product/Sales Organization/Distribution Channel | 22 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
14 | S006 | SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
15 | S006BIW1 | S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
16 | S006BIW2 | S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
17 | S126 | Open Variants - Basis 1 | 30 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
18 | S127 | Open Variants - Basis 2 | 29 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
19 | S128 | Open Variants - SIS | 26 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
20 | S129 | Open Variants - Planning | 21 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
21 | S137 | Variants: Basis 2 | 27 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
22 | S138 | Variants: SIS & planning | 24 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
23 | S409 | Contract & Billing | 24 | AEKZWI3 | Discount | decimal | 17 | 2 | | |
TOPDownstream |
24 | S410BIW1 | S410BIW1 * SIS: Business Location Statistics via 'Ship-to' ( | 42 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
25 | S410BIW2 | S410BIW2 * SIS: Business Location Statistics via 'Ship-to' ( | 42 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |
TOPMarketing Retail Network |
26 | S410 | SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR | 42 | AEKZWI3 | Incoming orders: net 2 | decimal | 17 | 2 | | |