| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P01E2_UMMELDUNG | ELStAM Procedure: Table of Change of Registration Data | 5 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
| TOPAdvertising Management |
| 2 | JHTTBED | IS-M/AM: OPM - Rate Requirements | 6 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
| 3 | JJTKS | IS-M/AM: Business Partner Hierarchy | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 4 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 6 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
| 5 | JJTVB | IS-M/AM: Requirement in Media Sales Agent Contract | 4 | GUELTIGAB | IS-M: "Valid From" Date | nvarchar | 8 | 0 | | |
| TOPBasic Data |
| 6 | QMTB | Inspection method master record | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 7 | QMTT | Inspection Method Texts | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 8 | QPAC | Inspection catalog codes for selected sets | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 9 | QPMK | Inspection characteristic master | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 10 | QPMT | Master Inspection Characteristics Texts | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 11 | QPMZ | Assignment table - insp. methods/master insp. characteristic | 9 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPBasic Data for Certificates |
| 12 | QCVK | Certificate profile header | 6 | GUELTIGAB | Field Not Used Field Reserved for SAP | nvarchar | 8 | 0 | | |
| TOPCatalog |
| 13 | QPCD | Inspection catalog codes | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 14 | QPCT | Code texts | 7 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPInspection Planning |
| 15 | PLMK | Inspection plan characteristics | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 16 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 9 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPMaster Data |
| 17 | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | 3 | GUELTIGAB | IS-M: Date from Which Change Number is Valid | nvarchar | 8 | 0 | | |
| 18 | JSTALIAS | IS-M: Alias Table for Streets | 32 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 19 | JSTANDLOG | IS-M/SD: Log for Changes to JSTAENDER | 9 | GUELTIGAB | IS-M: Date from Which Change Number is Valid | nvarchar | 8 | 0 | | |
| 20 | JSTBEZBEZ | IS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 21 | JSTCOUNTY | IS-M: Counties or Administrative Districts from USPS (USA) | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 22 | JSTGEOBEZ | IS-M/SD: Assignment of Carrier Routes to Geographical Units | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 23 | JSTGEOHIE | IS-M/SD: Geographical Hierarchy | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 24 | JSTGEOORG | IS-M/SD: Assignment of Geographical to Organizational Units | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 25 | JSTGEOPST | IS-M/SD: Assignments of Geographical to Postal Units | 7 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 26 | JSTKGSPRO | IS-M/SD: District Municipality File | 18 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 27 | JSTKGSUPDA | IS-M/SD: Table for Upgrade of Table JSTKGSPRO | 22 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 28 | JSTLAUF | IS-M/SD: Round Sequence | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 29 | JSTORGHIE | IS-M/SD: Organizational Plan Hierarchy | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 30 | JSTORTPRO | IS-M/SD: City File (Post) | 24 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 31 | JSTORTUPDA | IS-M/SD: Table for Upgrade of Table JSTORTPRO | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 32 | JSTOTLPRO | IS-M: City District File | 19 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 33 | JSTOTLUPDA | IS-M/SD: Table for Upgrade of Table JSTOTLPRO | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 34 | JSTPLOUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZORT | 21 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 35 | JSTPLZORT | IS-M/SD: Assignment of Postal Codes to Cities | 16 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 36 | JSTPLZPRO | IS-M: Postal Codes | 22 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 37 | JSTPLZUPDA | IS-M/SD: Table for Upgrade of Table JSTPLZPRO | 26 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 38 | JSTPOFPRO | IS-M/SD: PO Box Rack File | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 39 | JSTPOFUPDA | IS-M/SD: Table for Upgrade of Table JSTPOFPRO | 29 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 40 | JSTROUPVA | IS-M/SD: Truck Route-Publication/Edition Assignment | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 41 | JSTSTRPRO | IS-M/SD: Street File (Post) | 33 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 42 | JSTSTRUPDA | IS-M/SD: Table for Upgrading Table JSTSTRPRO | 35 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 43 | JST_KGS_CONS | IS-M: Table for DMK Consolidation | 23 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 44 | JST_ORT_CONS | IS-M: Table for City Consolidation | 29 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 45 | JST_OTL_CONS | IS-M: Table for City District Consolidation | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 46 | JST_PLZ_CONS | IS-M: Table for Postal Code Consolidation | 27 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 47 | JST_POF_CONS | IS-M: Table for PO Box Consolidation | 32 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 48 | JST_STR_CONS | IS-M: Table for Street Consolidation | 37 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPPeriodical Sales and Distribution |
| 49 | JRTABLDBAR | IS-M/SD: Unloading Viability Set | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 50 | JRTABLRGL | IS-M/SD: Unloading Rule (no longer used) | 13 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 51 | JRTABLRGLA | IS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes) | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 52 | JRTABLRGLB | IS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts) | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 53 | JRTROUBEA | IS-M/SD: Truck Route Unloading Point Sequence | 5 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 54 | JRTROUHIE | IS-M/SD: Truck Route Hierarchy | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 55 | JVTBEZGP | IS-M/SD: Delivery Round - Business Partner | 8 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 56 | JVTLIEFBAR | IS-M/SD: Delivery/Home Delivery/Pickup Viability Sets | 3 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 57 | JVTPSTFEHL | IS-M/SD: Postal Units not Delivered | 6 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPQuality Inspection |
| 58 | QALS | Inspection lot record | 89 | GUELTIGAB | Key Date for Selecting Records or Changing Task Lists | nvarchar | 8 | 0 | | |
| TOPSample Management |
| 59 | QPRVK | Sample-drawing procedure | 4 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPSAP Media |
| 60 | J_1SBOTPRO | IS-M/SD CH/S: CH Carrier Data | 8 | GUELTIGAB | IS-M: CH/S: Validity Date | nvarchar | 8 | 0 | | |
| 61 | J_1SSTRKUN | IS-M/SD CH/S: Assign Street Data for Individual Customers | 40 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| 62 | J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet | 45 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | |
| TOPTax |
| 63 | P01E2_ANMELDUNG | ELStAM Procedure: Table of Registration Data | 5 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
| 64 | P01E2_ELSTAM | ELStAM Procedure: Table of Change Lists | 4 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
| 65 | P01T_ELSTAM | ETStmt: ELStAM (as of 2012) | 6 | GUELTIGAB | ELStAM: Key Date of Validity of Change List | nvarchar | 8 | 0 | | |
| TOPTransaction Manager |
| 66 | AT200 | Rules for Determining a Tax Indicator | 2 | GUELTIGAB | Valid From | nvarchar | 8 | 0 | | |
| 67 | AT210 | Rules for Determining a Taxes for CFM postings | 2 | GUELTIGAB | Valid From | nvarchar | 8 | 0 | | |
