| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | S523 | LIS:CopyMan-Autom.Anreicherung | 20 | UMNETWR | Umsatz Nettowert | decimal | 19 | 2 | | |
2 | S628BIW1 | S628BIW1 * APO Demand | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
3 | S628BIW2 | S628BIW2 * APO Demand | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
4 | S990 | Smoby: hiérarchie client | 20 | UMNETWR | Chiffre d'affaires - Valeur nette | decimal | 19 | 2 | | |
5 | S992 | Client/famille/article | 20 | UMNETWR | Chiffre d'affaires - Valeur nette | decimal | 19 | 2 | | |
6 | S997 | Danone | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
7 | S999 | Copy of S628 for APO Pump Demo | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
TOPAdvertising Management |
8 | S481 | IS-M/AM: View of BP Sales Areas | 21 | UMNETWR | IS-M/AM: LIS order net sales volume | decimal | 19 | 2 | | |
TOPData Collection |
9 | S001 | SIS: Customer Statistics | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
10 | S001BIW1 | S001BIW1 * SIS: Customer Statistics | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
11 | S001BIW2 | S001BIW2 * SIS: Customer statistics | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
12 | S002 | SIS: Sales Office Statistics | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
13 | S002BIW1 | S002BIW1 * SIS: Sales office statistics | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
14 | S002BIW2 | S002BIW2 * SIS: Sales office statistics | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
15 | S003 | SIS: SalesOrg/DistCh/Division/District/Customer/Product | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
16 | S003BIW1 | S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
17 | S003BIW2 | S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
18 | S004 | SIS: Product/Sales Organization/Distribution Channel | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
19 | S004BIW1 | SIS: Product/Sales Organization/Distribution Channel | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
20 | S004BIW2 | SIS: Product/Sales Organization/Distribution Channel | 18 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
21 | S006 | SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
22 | S006BIW1 | S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
23 | S006BIW2 | S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
24 | S126 | Open Variants - Basis 1 | 50 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
25 | S127 | Open Variants - Basis 2 | 43 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
26 | S128 | Open Variants - SIS | 40 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
27 | S129 | Open Variants - Planning | 31 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
28 | S137 | Variants: Basis 2 | 37 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
29 | S138 | Variants: SIS & planning | 34 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
30 | S409 | Contract & Billing | 28 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
31 | S521 | Test | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
32 | S530 | LO630 Unit 02 Solution | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
33 | S531 | LO630 Solution Unit06 | 26 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
34 | S532 | LO630 Solution Unit 08 | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
35 | S620 | IDES Data Generation | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
36 | S621 | Sales and Production | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
37 | S622 | SOP Level-by-Level | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
38 | S623 | SOP Variable Time Frames | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
39 | S624 | SOP Instructor | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
40 | S625 | SOP Instructor | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
41 | S626 | LO935: SOP without plant | 20 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
42 | S628 | APO Demand | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
43 | S630 | LO935 Group 00 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
44 | S631 | LO935 Group 01 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
45 | S632 | LO935 Group 02 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
46 | S633 | LO935 Group 03 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
47 | S634 | LO935 Group 04 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
48 | S635 | LO935 Group 05 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
49 | S636 | LO935 Group 06 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
50 | S637 | LO935 Group 07 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
51 | S638 | LO935 Group 08 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
52 | S639 | LO935 Group 09 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
53 | S640 | LO935 Group 10 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
54 | S641 | LO935 Group 11 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
55 | S642 | LO935 Group 12 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
56 | S643 | LO935 Group 13 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
57 | S644 | LO935 Group 14 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
58 | S645 | LO935 Group 15 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
59 | S646 | LO935 Group 16 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
60 | S647 | LO935 Group 17 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
61 | S648 | LO935 Group 18 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
62 | S649 | LO935 Group 19 | 21 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
63 | S991 | Hiérarchie client / Produit | 21 | UMNETWR | Chiffre d'affaires - Valeur nette | decimal | 19 | 2 | | |
64 | S998 | SMOBY | 20 | UMNETWR | Chiffre d'affaires - Valeur nette | decimal | 19 | 2 | | |
TOPDownstream |
65 | S410BIW1 | S410BIW1 * SIS: Business Location Statistics via 'Ship-to' ( | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
66 | S410BIW2 | S410BIW2 * SIS: Business Location Statistics via 'Ship-to' ( | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
TOPInformation System |
67 | S020 | SIS: Customer Potential Analysis | 23 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
TOPMarketing Retail Network |
68 | S410 | SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR | 19 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
TOPPeriodical Sales and Distribution |
69 | S450 | IS-M/SD: Customer Statistics | 27 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
70 | S451 | IS-M/SD: Sales Office Statistics | 28 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
71 | S452 | IS-M/SD: Product Statistics | 28 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
72 | S454 | IS-M/SD: Sales Agents | 27 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
73 | S455 | IS-M/SD: Promotion Statistics | 27 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
74 | S456 | IS-M/SD: AR Category Statistics | 26 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |
75 | S457 | IS-M/SD: Carrier Route Statistics | 28 | UMNETWR | Net value of invoiced sales | decimal | 19 | 2 | | |