| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCommodity Pricing Engine |
1 | CPEC_FORMULA | CPE Formula | 7 | FORMCURR | CPE Formula - Currency | nvarchar | 5 | 0 | | |
2 | CPED_COVERAGE | Coverage - General Master Data | 15 | FORMCURR | CPE Formula - Currency | nvarchar | 5 | 0 | | |
3 | CPED_FORMDOC | CPE Formula - Grouping and General Result | 14 | FORMCURR | CPE Formula - Currency | nvarchar | 5 | 0 | | |
4 | CPED_FORMINPUT | CPE Formula - Changed Input for General Data | 8 | FORMCURR | CPE Formula - Currency | nvarchar | 5 | 0 | | |
TOPExchanges |
5 | OIAF7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 9 | FORMCURR | Currency for formula condition | nvarchar | 5 | 0 | | |
TOPMarketing, Accounting and Pricing |
6 | OICQ1 | Formula Repository - Formula Header | 6 | FORMCURR | Currency for formula condition | nvarchar | 5 | 0 | | |
7 | OICQ4 | Formula Condition Data - Formula Header | 7 | FORMCURR | Currency for formula condition | nvarchar | 5 | 0 | | |
8 | OICQ7 | Formula Condition Txn Data-Header (enhance CI-Incl.in OICF1) | 9 | FORMCURR | Currency for formula condition | nvarchar | 5 | 0 | | |