| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCommodity Pricing Engine |
1 | CPEC_FORMULA | CPE Formula | 9 | FORMUOM | CPE Formula - Unit of Measure | nvarchar | 3 | 0 | | |
2 | CPED_FORMDOC | CPE Formula - Grouping and General Result | 16 | FORMUOM | CPE Formula - Unit of Measure | nvarchar | 3 | 0 | | |
3 | CPED_FORMINPUT | CPE Formula - Changed Input for General Data | 10 | FORMUOM | CPE Formula - Unit of Measure | nvarchar | 3 | 0 | | |
TOPExchanges |
4 | OIAF7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 12 | FORMUOM | Displayed unit of measure for Formula and Average conditions | nvarchar | 3 | 0 | | |
TOPMarketing, Accounting and Pricing |
5 | OICF1_MIGR | Results from Pattern Analysis for Structure OICF1 | 8 | FORMUOM | Displayed unit of measure for Formula and Average conditions | nvarchar | 3 | 0 | | |
6 | OICQ1 | Formula Repository - Formula Header | 9 | FORMUOM | Displayed unit of measure for Formula and Average conditions | nvarchar | 3 | 0 | | |
7 | OICQ4 | Formula Condition Data - Formula Header | 10 | FORMUOM | Displayed unit of measure for Formula and Average conditions | nvarchar | 3 | 0 | | |
8 | OICQ7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 12 | FORMUOM | Displayed unit of measure for Formula and Average conditions | nvarchar | 3 | 0 | | |