| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduct Safety |
1 | CCRCT_CALC | EHS: Calculated Average | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
2 | CCRCT_CO | EHS: Confirmed Consumed Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
3 | CCRCT_COPL | EHS: Planned Consumed Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
4 | CCRCT_CU | EHS: Customer List - Header Data | 9 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
5 | CCRCT_EHS_COMP | EHS: Composition (EH&S Data) | 6 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
6 | CCRCT_EHS_REG | EHS: Registration Status (EH&S Data) | 4 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
7 | CCRCT_EHS_SLIMIT | EHS: Limit Values in Substance (EH&S Data) | 3 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
8 | CCRCT_PR | EHS: Confirmed Produced Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
9 | CCRCT_PRPL | EHS: Planned Produced Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
10 | CCRCT_PU | EHS: Confirmed Purchased Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
11 | CCRCT_PUPL | EHS: Planned Purchased Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
12 | CCRCT_SO | EHS: Confirmed Sold Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |
13 | CCRCT_SOPL | EHS: Planned Sold Quantities | 7 | TRACK_SUBST | Tracked Substance | nvarchar | 12 | 0 | | |