| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaster Data |
1 | JSTAENDDOC | IS-M/SD: Orders Affected by Change Number | 2 | AENDNR | Change Number | nvarchar | 9 | 0 | | |
2 | JSTAENDER | IS-M/SD: Change Number for Structure Maintenance | 2 | AENDNR | Change Number | nvarchar | 9 | 0 | | |
3 | JSTANDLOG | IS-M/SD: Log for Changes to JSTAENDER | 2 | AENDNR | Change Number | nvarchar | 9 | 0 | | |
4 | TJS37 | IS-M: Control Table for Postal Change Service | 4 | AENDNR | Change Number | nvarchar | 9 | 0 | | |
TOPPeriodical Sales and Distribution |
5 | JDTVASYNC | IS-M: Worklist for Issue Synchronization M/SD -> M/AM | 2 | AENDNR | Seq.number of work list for issue synchronization MSD->MAM | nvarchar | 8 | 0 | | |
6 | JVTNCT1 | IS-M/SD: Tab.1 in Coll.Netchange File (Change Numbers) | 2 | AENDNR | Unique ID, Ascending Sequential Numbers | nvarchar | 24 | 0 | | |
7 | JVTNCT2 | IS-M/SD: Tab.2 in Coll.Netchange File (Change No.-Trig.Asgt) | 2 | AENDNR | Unique ID, Ascending Sequential Numbers | nvarchar | 24 | 0 | | |
8 | JVTNCT3 | IS-M/SD: Tab.3 of Coll.Netch.File (ChNo.-OrItem-Tr.-Asgt) | 2 | AENDNR | Unique ID, Ascending Sequential Numbers | nvarchar | 24 | 0 | | |
9 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 2 | AENDNR | Unique ID, Ascending Sequential Numbers | nvarchar | 24 | 0 | | |
10 | JVTNCT5 | IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.) | 2 | AENDNR | Unique ID, Ascending Sequential Numbers | nvarchar | 24 | 0 | | |
TOPSAP Media |
11 | J_1S_AEND | IS-M/SD CH/S: Orders Affected by Change Number | 2 | AENDNR | Change Number | nvarchar | 9 | 0 | | |