| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | TJH06 | IS-M/AM: Billing: Document Types: Texts | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 2 | TJJ82 | IS-M/AM: Settlement Calendar for Media Sales Agent Texts | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| TOPBasic Functions |
| 3 | T604B | Preference: Preference Zone Description | 5 | BEZEI30 | Description | nvarchar | 30 | 0 | | |
| TOPMaster Data |
| 4 | TJG06 | IS-M/SD: Texts for Occupation | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 5 | TJG08 | IS-M/SD: Texts for Carrier Grouping Type | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 6 | TJG10 | IS-M/SD: Texts for Additional Carrier Deployment Options | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 7 | TJG12 | IS-M/SD: Texts for Sales Agent Type | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 8 | TJG14 | IS-M/SD: Texts for Absence Type | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 9 | TJG16 | IS-M/SD: Texts for Material Provision Systems | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 10 | TJG18 | IS-M/SD: Texts for Point of Sale Type (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 11 | TJG20 | IS-M/SD: Texts for Point of Sale Name Key (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 12 | TJG22 | IS-M/SD: Texts for Sales Area Key (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 13 | TJG24 | IS-M/SD: Texts for Service Type (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 14 | TJG26 | IS-M/SD: Texts for Sales Influence (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 15 | TJG28 | IS-M/SD: Texts for Customer Frequency per Week (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 16 | TJG30 | IS-M/SD: Texts for Retailer Opening Times (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 17 | TJG32 | IS-M/SD: Texts for Retailer Closing Times (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 18 | TJG34 | IS-M/SD: Texts for Retailer Opening Types (POS) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 19 | TJG36 | IS-M/SD: Texts for Carrier Status | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 20 | TJG38 | IS-M/SD: Texts for Business Partner Account Group | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 21 | TJG42 | IS-M/SD: Texts for BP Origin | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 22 | TJG44 | IS-M: Texts for Form-of-Address Key | 5 | BEZEI30 | IS-M: Form-of-Address Text (for Formatting) | nvarchar | 15 | 0 | | |
| 23 | TJG46 | IS-M/SD: Texts for Marital Status | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 24 | TJG48 | IS-M/SD: Texts for Vendor Procedure | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 25 | TJG62 | IS-M/SD: Texts for BP Billing Calendar | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 26 | TJG64 | IS-M/SD: Texts for Settlement Calendar | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 27 | TJGPOS02T | IS-M: POS Internal Sales Influence (Text) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 28 | TJGPOS03T | IS-M: POS Scanner Cash Desk (Texts) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 29 | TJGPOS04T | IS-M: POS Origin of Customer Frequency (Texts) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 30 | TJGR1T | IS-M: EDI Participant Type Texts | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 31 | TJS42 | IS-M: Texts for Direction Specifications | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 32 | TJS44 | IS-M: Text for Abbreviations for Secondary Address Texts | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 33 | TJFKT | IS-M/SD: Texts for Billing Document Types | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 34 | TJKUDREASONT | IS-M/SD: Reason for Notification from Shipping Agent (Text) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 35 | TJL06 | IS-M/SD: Texts for Document Types | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 36 | TJL18 | IS-M/SD: Texts for IS-M/SD Tax Code | 5 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 37 | TJL56 | IS-M/SD: Texts for Vehicle Types (HR) | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 38 | TJN02 | IS-M/SD: Text for Research Type | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 39 | TJN04 | IS-M/SD: Text for Research Method | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 40 | TJN10 | IS-M/SD: Text for Bank Return Reason | 4 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
| 41 | TJYCNYTXT | IS-M: Texts for Country Version | 3 | BEZEI30 | IS-M: General Description of Objects (Length 30) | nvarchar | 30 | 0 | | |
