| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S990 | Smoby: hiérarchie client | 40 | UMKZWI2 | Facture - Valeur nette 2 | decimal | 17 | 2 | | |
TOPAdvertising Management |
2 | S481 | IS-M/AM: View of BP Sales Areas | 24 | UMKZWI2 | IS-M/AM: LIS order ST2 total | decimal | 17 | 2 | | |
TOPData Collection |
3 | S001 | SIS: Customer Statistics | 38 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
4 | S001BIW1 | S001BIW1 * SIS: Customer Statistics | 38 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
5 | S001BIW2 | S001BIW2 * SIS: Customer statistics | 38 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
6 | S002 | SIS: Sales Office Statistics | 34 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
7 | S002BIW1 | S002BIW1 * SIS: Sales office statistics | 34 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
8 | S002BIW2 | S002BIW2 * SIS: Sales office statistics | 34 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
9 | S003 | SIS: SalesOrg/DistCh/Division/District/Customer/Product | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
10 | S003BIW1 | S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
11 | S003BIW2 | S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
12 | S004 | SIS: Product/Sales Organization/Distribution Channel | 33 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
13 | S004BIW1 | SIS: Product/Sales Organization/Distribution Channel | 33 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
14 | S004BIW2 | SIS: Product/Sales Organization/Distribution Channel | 33 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
15 | S006 | SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
16 | S006BIW1 | S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
17 | S006BIW2 | S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 35 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
18 | S409 | Contract & Billing | 32 | UMKZWI2 | Billing Document: Condition Subtotal 2 | decimal | 17 | 2 | | |
TOPDownstream |
19 | S410BIW1 | S410BIW1 * SIS: Business Location Statistics via 'Ship-to' ( | 39 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
20 | S410BIW2 | S410BIW2 * SIS: Business Location Statistics via 'Ship-to' ( | 39 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
TOPMarketing Retail Network |
21 | S410 | SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR | 39 | UMKZWI2 | Invoiced sales: net 1 | decimal | 17 | 2 | | |
TOPPeriodical Sales and Distribution |
22 | S450 | IS-M/SD: Customer Statistics | 32 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
23 | S451 | IS-M/SD: Sales Office Statistics | 33 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
24 | S452 | IS-M/SD: Product Statistics | 33 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
25 | S454 | IS-M/SD: Sales Agents | 32 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
26 | S455 | IS-M/SD: Promotion Statistics | 32 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
27 | S456 | IS-M/SD: AR Category Statistics | 31 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |
28 | S457 | IS-M/SD: Carrier Route Statistics | 33 | UMKZWI2 | Sales volume pricing subtotal 2 | decimal | 17 | 2 | | |