| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdvertising Management |
1 | JHAERL | IS-M: OPM Ad Error Log for Schedule Line Generation | 12 | RASTER | IS-M: Grid for IS-M/AM Order | nvarchar | 3 | 0 | | |
2 | JHAMOT | IS-M/AM: Ad Spec | 54 | RASTER | IS-M: Grid Spacing | nvarchar | 2 | 0 | | |
3 | TJH37 | IS-M/AM: Grid Spacing for Ad Spec | 2 | RASTER | IS-M: Grid Spacing | nvarchar | 2 | 0 | | |
4 | TJH38 | IS-M: Texts for Grid Spacing (Ad Spec) | 3 | RASTER | IS-M: Grid Spacing | nvarchar | 2 | 0 | | |
5 | TJJ57 | IS-M/AM: Frequency Rule | 4 | RASTER | IS-M: Grid for IS-M/AM Order | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
6 | DFKK_DUEGRID | OI - Reclassifications | 13 | RASTER | Grid Upper Limit in Days | decimal | 4 | 0 | | |
7 | TFKBW | FICA to BW - Maintain Fields for Extraction | 7 | RASTER | Grid ID for Extraction | nvarchar | 2 | 0 | | |
8 | TFKBWC | FICA BW - Maintain Fields for Extraction (Customer View) | 7 | RASTER | Grid ID for Extraction | nvarchar | 2 | 0 | | |
9 | TFKBWT01 | FICA to BW - Interval Definition | 2 | RASTER | Grid ID for Extraction | nvarchar | 2 | 0 | | |
10 | TFKBWT01D | FICA to BW - Intervals | 2 | RASTER | Grid ID for Extraction | nvarchar | 2 | 0 | | |
11 | TFKBWT01DT | FICA to BW - Intervals | 3 | RASTER | Grid ID for Extraction | nvarchar | 2 | 0 | | |
TOPMedia Product Sales and Distribution |
12 | TJD03_MP | IS-M: Frequency Rules for Media Products | 4 | RASTER | Grid (e.g. day, week, month) | nvarchar | 3 | 0 | | |
TOPPeriodical Sales and Distribution |
13 | RJD01_RTE | IS-M: Structure Truck Route for Generation Rule | 3 | RASTER | Grid (e.g. day, week, month) | nvarchar | 3 | 0 | | |
14 | TJD03 | IS-M/SD: Frequency Rules | 4 | RASTER | Grid (e.g. day, week, month) | nvarchar | 3 | 0 | | |
TOPPurchasing |
15 | WGRC_ASS | Vendors Door/Area Appointment | 8 | RASTER | GUID in 'RAW' format | varbinary | 16 | 0 | | |
16 | WGRC_ASS_RASTER | Resource Table Grid | 2 | RASTER | GUID in 'RAW' format | varbinary | 16 | 0 | | |
17 | WGRC_RES_AREA | Resources in a Staging Area | 5 | RASTER | GUID in 'RAW' format | varbinary | 16 | 0 | | |
18 | WGRC_RES_DOOR | Door Resources for a Specific Period | 8 | RASTER | Pointer for Relevant Entry in Grid Table | varbinary | 16 | 0 | | |
19 | WGRC_RES_RASTER | Resource Table Grid | 2 | RASTER | Generic Data Element for GUID Fields (X16) | varbinary | 16 | 0 | | |
TOPResourcen Management |
20 | RMSAT_QMINSP | RMS: ATL QM List of Inspection Data for General Recipes | 39 | RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | nvarchar | 3 | 0 | | |
TOPResults Recording |
21 | QAMV | Characteristic specifications for inspection processing | 132 | RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | nvarchar | 3 | 0 | | |
TOPSamples and SPC |
22 | QDSV | Sampling procedure | 29 | RASTER | Inspection Frequency (Only for Inspection with Insp. Points) | nvarchar | 3 | 0 | | |