| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S990 | Smoby: hiérarchie client | 32 | UMWAVWR | Chiffre d'affaires - prix de cession | decimal | 19 | 2 | | |
TOPData Collection |
2 | S001 | SIS: Customer Statistics | 30 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
3 | S001BIW1 | S001BIW1 * SIS: Customer Statistics | 30 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
4 | S001BIW2 | S001BIW2 * SIS: Customer statistics | 30 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
5 | S002 | SIS: Sales Office Statistics | 49 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
6 | S002BIW1 | S002BIW1 * SIS: Sales office statistics | 49 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
7 | S002BIW2 | S002BIW2 * SIS: Sales office statistics | 49 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
8 | S003 | SIS: SalesOrg/DistCh/Division/District/Customer/Product | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
9 | S003BIW1 | S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
10 | S003BIW2 | S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
11 | S004 | SIS: Product/Sales Organization/Distribution Channel | 53 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
12 | S004BIW1 | SIS: Product/Sales Organization/Distribution Channel | 53 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
13 | S004BIW2 | SIS: Product/Sales Organization/Distribution Channel | 53 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
14 | S006 | SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
15 | S006BIW1 | S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
16 | S006BIW2 | S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 54 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
17 | S409 | Contract & Billing | 29 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
18 | S521 | Test | 26 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
TOPDownstream |
19 | S410BIW1 | S410BIW1 * SIS: Business Location Statistics via 'Ship-to' ( | 31 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
20 | S410BIW2 | S410BIW2 * SIS: Business Location Statistics via 'Ship-to' ( | 31 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |
TOPMarketing Retail Network |
21 | S410 | SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR | 31 | UMWAVWR | Cost of invoiced sales | decimal | 19 | 2 | | |