| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMedia Sales and Distribution |
1 | /NAM/ABC_DATES | Alternative ABC Categories for Specific Dates | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
2 | /NAM/JKOFFCODE | Selected Offer Codes for Order/Item | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
3 | JFDFS | IS-M/SD: Billing/Settlement Index | 59 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
4 | JFLIABACCREVERSE | IS-M/SD: Revenue Log for Reversal of Liability Acct Transfer | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
5 | JFREVACC | IS-M/SD: Pl.Cir.f.Rev. - Revenue per Liab.Acct + G/L Account | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
6 | JFRP | IS-M/SD: Billing Document - Item Data | 123 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
7 | JKACCADD | IS-M/SD: Additional Payments for Renewal Cycle | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
8 | JKACCADDT | IS-M/SD: Template Data for Add. Payments for Renewal Cycle | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
9 | JKACCAMOPROT | IS-M/SD: Amortization Log | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
10 | JKACCFIZUO | IS-M/SD: Payment Log - FI Document Data at Cycle Level | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
11 | JKACCOUNT | IS-M/SD: Liability Account for Subscription | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
12 | JKACCOUNT_GOLIVE | IS-M/SD: Shadow Table for JKACCOUNT After Data Transfer | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
13 | JKAMOPLAN | IS-M/SD: Amortization Plan for Billing Cycle | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
14 | JKAP | Sales Order - Item Data | 66 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
15 | JKAPRENEW | IS-M/SD: Index for Renewal of Subscriptions | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
16 | JKREMIND | IS-M/SD: Renewal Cycles for Subscription | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
17 | JNTRECH | IS-M/SD: Research | 10 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
18 | JVTNCT3 | IS-M/SD: Tab.3 of Coll.Netch.File (ChNo.-OrItem-Tr.-Asgt) | 9 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
19 | JVTNCT4 | IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS | 4 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
20 | JVTNCT5 | IS-M/SD: Tab.5 in Collective Netchange File (Sch.Line ChNo.) | 4 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
21 | JVTPOTNOTICE | IS-M/SD: Potential Carrier Change Notifications | 3 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
22 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 28 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |
23 | JVTZAEM4 | IS-M/SD: Carrier Change Notification - Excl.Orders | 4 | POSNR_UR | Original Item in Publishing Sales Order | nvarchar | 6 | 0 | | |