| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TCY09 | List profiles (standard settings for lists) | 4 | LIVAR | List version of variable overview | nvarchar | 10 | 0 | | |
2 | TCY17 | List version - keys | 2 | LIVAR | List version of variable overview | nvarchar | 10 | 0 | | |
3 | TCY18 | Variable overview - description of overview versions | 2 | LIVAR | List version of variable overview | nvarchar | 10 | 0 | | |
4 | TCY19 | Variable overview - definition of overview versions | 2 | LIVAR | List version of variable overview | nvarchar | 10 | 0 | | |
5 | TCY20 | Variable overview - column headings for overview vers. | 2 | LIVAR | List version of variable overview | nvarchar | 10 | 0 | | |
TOPBasic Functions |
6 | TRWLVH | List of variants for FI-SL line item reports (header) | 2 | LIVAR | List variants for FI-SL line item report | nvarchar | 10 | 0 | | |
7 | TRWLVHT | List of variants for FI-SL line item reports (texts) | 3 | LIVAR | List variants for FI-SL line item report | nvarchar | 10 | 0 | | |
8 | TRWLVL | List of variants for FI-SL line item reports (fields) | 2 | LIVAR | List variants for FI-SL line item report | nvarchar | 10 | 0 | | |
TOPLogistics - General |
9 | TB2BE | Trading Contract: Trading Contract Type | 17 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
TOPPromotion |
10 | TWAA | Promotion Type, IS-R | 28 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
TOPPurchasing |
11 | WDFR_DISP | Perishables Planning Header | 105 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
TOPRetail Pricing |
12 | TWST | Sales Price Calculation: List Variants | 2 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
13 | TWSTP | Sales Price Calculation: Items in List Variant | 2 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
14 | TWSTT | Sales price calculation: list variants (text) | 3 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
15 | WKBK | Pricing document: header | 6 | LIVAR | List variant for sales price calculation | nvarchar | 2 | 0 | | |
TOPService Station Retailing |
16 | OIRAREPSUMCOL | SSR Reporting: Subtotal column definition | 3 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
17 | OIRAREPSUMCOLT | SSR Reporting: Subtotal column deinition | 4 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
18 | OIRAREPSUMCOLV | SSR Reporting: Subtotal column value assignments | 3 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
19 | OIRC_FUELS_PR | SSR - Processing profile | 76 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
20 | OIRC_PRLOG_PRM | SSR Pricing - Price update parameter log | 11 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
21 | OIRC_VCDEF | SSR Pricing - List variant/condition type definition | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
22 | OIRC_VCDEFT | SSR Pricing - List variant/condition type def. - Texts | 3 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
23 | OIRC_VCDEF_COLDF | SSR Pricing - Column definition | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
24 | OIRC_VCDEF_F | SSR Pricing - List variant/cond. type - field definition | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
25 | OIRC_VCDEF_F_VAL | SSR Pricing - List variant/condition type - field values | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
26 | OIRC_VCDEF_VAL | SSR Pricing - List variant/condition type definition heade | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
27 | OIRC_WST | SSR Pricing - List Variants | 2 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |
28 | OIRC_WSTT | SSR Pricing - List Variants - Texts | 3 | LIVAR | SSR Pricing - List variant for sales pricing | nvarchar | 2 | 0 | | |