| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | WGDS_FISCHCATZON | Fish Catch zone details table | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
2 | WGDS_INSRCANIMAL | Ingredient Source Animal Details | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
3 | WGDS_TI_ALLERGEN | Pricat Storage for TI related Allergen Information | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
4 | WGDS_TI_ATTRIBUT | Pricat Storage for TI related Attributes | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
5 | WGDS_TI_INGREDIE | Pricat Storage for TI related Ingredient Information | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
6 | WGDS_TI_ITEM | Pricat Storage for TI related Simple Attributes | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
7 | WGDS_TI_NUTRIENT | Pricat Storage for TI related Nutrient Information | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
8 | WGDS_TI_PAC_MARK | contains all package marks | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
9 | WGDS_TI_PREPARAT | Pricat Storage for TI related Preparation Information | 6 | WGDS_TM_SUBDIVIS | Region of a Trade Item | nvarchar | 3 | 0 | | |
TOPElectronic Data Interchange |
10 | PRICAT_K001 | PRICAT: Catalog header | 54 | WGDS_TM_SUBDIVIS | Region (State, Province, County) | nvarchar | 3 | 0 | | |