| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 188 | PVA | Edition | nvarchar | 8 | 0 | | |
| 2 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 51 | PVA | Edition | nvarchar | 8 | 0 | | |
| 3 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 48 | PVA | Edition | nvarchar | 8 | 0 | | |
| 4 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 20 | PVA | Edition | nvarchar | 8 | 0 | | |
| 5 | JJCPFREESUB | IS-M: Free Subscription - Contact Person Relationship | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 6 | JJCPRESPONSIB | IS-M: Responsibility in Contact Person Relationship | 11 | PVA | Edition | nvarchar | 8 | 0 | | |
| 7 | JJTAF | IS-M/AM: Free Subscription for Media Contact Person | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 8 | JJTAZ | IS-M/AM: Media Contact Person Responsibility | 11 | PVA | Edition | nvarchar | 8 | 0 | | |
| 9 | JJTBE | IS-M/AM: Booking Units | 66 | PVA | IS-M: AI edition elements for basic BU | nvarchar | 8 | 0 | | |
| 10 | JJTBEPART | IS-M/AM: Booking Unit Elements (AI) | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 11 | JJTPVAPE | IS-M/AM: Edition Element | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 12 | JJTVAPE | IS-M/AM: Issue Element | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 13 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 21 | PVA | Edition | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 14 | JSTROUPVA | IS-M/SD: Truck Route-Publication/Edition Assignment | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| TOPMedia Product Sales and Distribution |
| 15 | JSDVA_MIG | IS-M: Issue Worklist for Media Product Migration | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 16 | JVTPACKGROUPPROD | IS-M: Common Odd Bundle Group (Products Contained) | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 17 | A458 | IS-M/SD: Employee Renewal Commission | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 18 | A462 | IS-M/SD: SC Commission Settlement - Renewal Commission | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 19 | A465 | IS-M/SD: Special Retail Prices for Customer | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 20 | A466 | IS-M/SD: Special Retail Prices | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 21 | A467 | IS-M/SD: Retail Purchase Prices | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 22 | C450 | IS-M/SD: SOrg./Publ./Edit./CGrp./AKey/BFreq. | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 23 | C460 | IS-M/SD: POrg./Publ./Edit./SC/AKey | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 24 | C461 | IS-M/SD: POrg./Publ./Edit./AKey | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 25 | C465 | IS-M/SD: SC/Publ./Edit./EEAcGrp./AKey | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 26 | C466 | IS-M/SD: SC/Publ./Edit./AKey | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 27 | JDTBZANG | IS-M/SD: Mix Offer | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 28 | JDTPVA | IS-M/SD: Editions | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 29 | JDTPVAVTR | IS-M/SD: Edition Sales Data | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 30 | JDTPVAWERK | IS-M/SD: Edition Plant (Printing Works) Data | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 31 | JDTPVAWGRP | IS-M/SD: Edition Plant Assignment to Bundle Group | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 32 | JDTSTVOPA | IS-M: Bundling Rule | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 33 | JDTVAENQ | Dummy Table for (Generic) Issue Lock | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 34 | JDTVASYNC | IS-M: Worklist for Issue Synchronization M/SD -> M/AM | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 35 | JDTVAUSGB | IS-M/SD: Issues | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 36 | JDTWGHVOPA | IS-M/SD: Bundling Rule - Weight Scale | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 37 | JFREVVA | IS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct | 6 | PVA | Edition | nvarchar | 8 | 0 | | |
| 38 | JFREVVA_REVERSE | IS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 39 | JFVA | IS-M/SD: Accrual Table Revenue Distribution at Issue Level | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 40 | JFXJFVADL | IS-M: Backup Transfer Internal Table XJFVA | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 41 | JITOMITTEDDAYS | ABC Exclusion | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 42 | JITSTAT | IS-M/SD: Daily IVW Statistics | 18 | PVA | Edition | nvarchar | 8 | 0 | | |
| 43 | JITSTATMT | IS-M/SD: Audit Reports to the Company Responsible | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 44 | JKAMOPLAN | IS-M/SD: Amortization Plan for Billing Cycle | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 45 | JKAP | Sales Order - Item Data | 15 | PVA | Edition | nvarchar | 8 | 0 | | |
| 46 | JKAPRV | IS-M/SD: Sales Order - Retroactive Shipping Data | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 47 | JKAP_INACTIVE | Publishing Sales Order: Inactive Item Data | 16 | PVA | Edition | nvarchar | 8 | 0 | | |
| 48 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 49 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 21 | PVA | Edition | nvarchar | 8 | 0 | | |
| 50 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 51 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 56 | PVA | Edition | nvarchar | 8 | 0 | | |
| 52 | JKWWWTEMP_SUSP | IS-M: Temporary Internet Table: Suspension Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 53 | JKWWWTEMP_TRNSF | IS-M: Internet Temporary Table: Transfer Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 54 | JLRP | IS-M/SD: Item Data for Settlement | 128 | PVA | Edition | nvarchar | 8 | 0 | | |
| 55 | JLTP1PVA | IS-M/SD: Postal Settlement Data on an Issue (New) | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 56 | JRENQABLG | IS | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 57 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 58 | JRTABLRGLA | IS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes) | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 59 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 60 | JVTANN00 | IS-M: Technical Order Deadline Limit | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 61 | JVTANNSTAT | IS-M/SD: Status Table for Order Finalization Deadline | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 62 | JVTASTAT01 | IS-M/SD: Supplements to Shipping Status | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 63 | JVTBEZHPVA | IS-M/SD: Main Edition in Carrier Route | 4 | PVA | IS-M: Main Edition in Carrier Route | nvarchar | 8 | 0 | | |
| 64 | JVTDSPTR | IS-M/SD: Planning trigger | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 65 | JVTFEHLER | IS-M: Distribution Error Message | 14 | PVA | Edition | nvarchar | 8 | 0 | | |
| 66 | JVTFRGLART | IS-M/SD: Determination of Postal Packing Rule | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 67 | JVTLFSTAT | IS-M/SD: Daily Delivery Statistics | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 68 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 10 | PVA | Edition | nvarchar | 8 | 0 | | |
| 69 | JVTMCI_ITEM | IS-M: TMCI Household Addresses for AI Schedule Lines | 13 | PVA | Edition | nvarchar | 8 | 0 | | |
| 70 | JVTMODZEBU | IS-M/SD: Modified ZEBU Records | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 71 | JVTNCT2 | IS-M/SD: Tab.2 in Coll.Netchange File (Change No.-Trig.Asgt) | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 72 | JVTNCT3 | IS-M/SD: Tab.3 of Coll.Netch.File (ChNo.-OrItem-Tr.-Asgt) | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 73 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 20 | PVA | Edition | nvarchar | 8 | 0 | | |
| 74 | JVTPRDGR03 | IS-M/SD: Fixed Elements of a Production Group | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 75 | JVTPROD | IS-M/SD: Production Units | 11 | PVA | Actual edition delivered | nvarchar | 8 | 0 | | |
| 76 | JVTPSQ0001 | IS-M/SD: Production Sequence - Elements: Publication/Edition | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 77 | JVTPSQ0002 | IS-M/SD: Production Sequence - Elements: Publ./Edit./Insert | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 78 | JVTREFPVA | IS-M/SD: Reference Edition for Edition, Media Product or AI | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 79 | JVTVARZPVA | IS-M/SD: Assignment of Edition to Shipping Schedule Variant | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 80 | JVTVSPDIR | IS-M/SD: Shipping Document Directory | 11 | PVA | Edition | nvarchar | 8 | 0 | | |
| 81 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 25 | PVA | Edition | nvarchar | 8 | 0 | | |
| 82 | JVTZUSTM | IS-M/SD: Carrier Notification (Shipping Documents) | 6 | PVA | IS-M: Main Edition in Carrier Route | nvarchar | 8 | 0 | | |
| 83 | S450 | IS-M/SD: Customer Statistics | 13 | PVA | Edition | nvarchar | 8 | 0 | | |
| 84 | S450E | S450 - Structural Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 85 | S451 | IS-M/SD: Sales Office Statistics | 14 | PVA | Edition | nvarchar | 8 | 0 | | |
| 86 | S451E | S451 - Structural Data | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 87 | S452 | IS-M/SD: Product Statistics | 9 | PVA | Edition | nvarchar | 8 | 0 | | |
| 88 | S452E | S452 - Structural Data | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 89 | S453 | IS-M/SD: Plant/Country Statistics | 12 | PVA | Edition | nvarchar | 8 | 0 | | |
| 90 | S453E | S453 - Structural Data | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 91 | S454 | IS-M/SD: Sales Agents | 13 | PVA | Edition | nvarchar | 8 | 0 | | |
| 92 | S454E | S454 - Structural Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 93 | S455 | IS-M/SD: Promotion Statistics | 13 | PVA | Edition | nvarchar | 8 | 0 | | |
| 94 | S455E | S455 - Structural Data | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 95 | TJD45 | IS-M/SD: Edition-Odd Bundle Group Assignments | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 96 | TJF50 | IS-M/SD: Wage Type Determination for Billing | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 97 | TJIABCZONES | Definition of ABZ Zones per Edition | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 98 | TJKAB | IS-M/SD: Sales Document Type-Mix Offer Assignment | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 99 | TJKWWW_VAR | IS-M/SD: WWW, Combinations of Variable Order Values | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 100 | TJL50 | IS-M/SD: Wage Type Determination for Home Delivery (new) | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 101 | TJL52 | IS-M/SD: Wage Type Determination for Commission (new) | 5 | PVA | Edition | nvarchar | 8 | 0 | | |
| 102 | TJV41 | IS-M/SD: Type of Shipping Problem Message | 14 | PVA | IS-M: Relevancy of Edition | nvarchar | 1 | 0 | | |
| 103 | TJV53 | IS-M/SD: Destination Determination for Shipping Documents | 6 | PVA | Edition | nvarchar | 8 | 0 | | |
| 104 | TJV54 | IS-M/SD: Shipping Document Type Usage | 7 | PVA | Edition | nvarchar | 8 | 0 | | |
| 105 | TJV62 | IS-M/SD: Sales Data for Goods Arrival Record | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 106 | TJV69 | IS-M/SD: Function Modules for Bundling (Customer) | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| TOPSAP Media |
| 107 | J_1SGEWAUL | IS-M/SD CH: No.Taxable Issues by Weight Groups - Foreign | 3 | PVA | Actual edition delivered | nvarchar | 8 | 0 | | |
| 108 | J_1SGEWBTE | IS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic | 3 | PVA | Actual edition delivered | nvarchar | 8 | 0 | | |
| 109 | J_1SGEWINL | IS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic | 3 | PVA | Actual edition delivered | nvarchar | 8 | 0 | | |
| 110 | J_1SGEWPLA | IS-M/SD CH: No.Taxable Issues by Weight Groups - Domestic | 3 | PVA | Actual edition delivered | nvarchar | 8 | 0 | | |
| 111 | J_1SPAUFG | IS-M/SD-CH: Postal Dispatch Lists | 8 | PVA | Edition | nvarchar | 8 | 0 | | |
| 112 | J_1SPTAXPVA | IS-M/SD-CH: Edition Data for Postal Charges | 3 | PVA | Edition | nvarchar | 8 | 0 | | |
| 113 | J_1SVARIEV | IS-M/SD CH: Variants for Global Changes in Retail | 4 | PVA | Edition | nvarchar | 8 | 0 | | |
| 114 | J_1SWEMF00 | IS-M/SD CH/W: Daily WEMF Statistics | 18 | PVA | Edition | nvarchar | 8 | 0 | | |
| 115 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 10 | PVA | Edition | nvarchar | 8 | 0 | | |
