| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | WGDS_D_MSG_HDR | Header information of a message | 7 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
TOPAssortment |
2 | WRF_APC_PABD | Planned Article Basic Data | 21 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
3 | WRF_APC_PAVAR | Planned Article Variants | 6 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
TOPElectronic Data Interchange |
4 | PRICAT_K001 | PRICAT: Catalog header | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
5 | PRICAT_K002 | PRICAT: Catalog item product groups | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
6 | PRICAT_K003 | PRICAT: Catalog item basic data | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
7 | PRICAT_K003S | PRICAT: Status of the Catalog Item per Customer | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
8 | PRICAT_K003Z | PRICAT: Catalog item basic data extras | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
9 | PRICAT_K004 | PRICAT:Cat. item units of measure, dimensions, weights,EANs | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
10 | PRICAT_K005 | PRICAT: Catalog item texts | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
11 | PRICAT_K006 | PRICAT: Catalog item characteristics | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
12 | PRICAT_K007 | PRICAT: Catalog item bills of material | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
13 | PRICAT_K008 | PRICAT: Catalog item prices / conditions / taxes | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
14 | PRICAT_K008C | PRICAT: Catalog Item Prices/Conditions/Taxes per Customer | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
15 | PRICAT_K009 | PRICAT: Catalog Item Scales for Condition | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
16 | PRICAT_K009C | PRICAT: Catalog Item Scales for Condition for Customer | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
17 | PRICAT_K00A | PRICAT: Assortments of the Price Catalog | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
18 | PRICAT_K00C | PRICAT: Customer of a Price Catalog | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
19 | PRICAT_K010 | Price Catalog: Additional Catalog Fields | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
20 | PRICAT_K010S | Price Catalog: Last Structure of Structures | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
21 | WRF_GDS_SHARE | Definition for Shared Objekt | 5 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
22 | WRF_PRICAT_010 | Price Catalog Inbound: Generic Field Storage | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
23 | WRF_PRICAT_010A | Price Catalog Generic Structures per Catalog | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
24 | WRF_PRICAT_010S | Price Catalog Generic Structures and Fields per Catalog | 2 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |
25 | WRF_PRICAT_TRIG | Price Catalog Inbound: Trigger Table for Scheduled Data | 3 | PRINBR | PRICAT: Unique internal catalog number | nvarchar | 10 | 0 | | |