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