| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClaims Management |
1 | ICLPROCURE | Claim Item Groupings | 60 | XFINISHED | Complete/Approved/Finished | nvarchar | 1 | 0 | | |
2 | ICSPROCURE | Claim Item Groupings | 60 | XFINISHED | Complete/Approved/Finished | nvarchar | 1 | 0 | | |
TOPCollections Management |
3 | UDM_PR_HEAD | Parallel Program Runs | 6 | XFINISHED | Task Completed | nvarchar | 1 | 0 | | |
4 | UDM_PR_INTV | Intervals for Parallel Processing of Program Runs | 9 | XFINISHED | Task Completed | nvarchar | 1 | 0 | | |
TOPMedia Product Sales and Distribution |
5 | JVTSDHDORDER | IS-M: M/SD Home Delivery Data for SD Orders | 12 | XFINISHED | IS-M/SD: Home Del. Settlement Performed for SD Order Items | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
6 | JVTMCP_HEADER | IS-M: TMCP Issue | 12 | XFINISHED | Indicator: Market Coverage Completed | nvarchar | 1 | 0 | | |
7 | JVTMCP_ITEM | IS-M: TMCP Structures (CRoute/GUnit) | 8 | XFINISHED | Indicator: Market Coverage Completed | nvarchar | 1 | 0 | | |
8 | JVTMCP_MERGE_RES | IS-M: TMCP Merge Result for Ship-To Party Address | 10 | XFINISHED | Indicator: Market Coverage Completed | nvarchar | 1 | 0 | | |
9 | JVTMCP_PROT | IS-M: TMCP Logs | 18 | XFINISHED | Indicator: Market Coverage Completed | nvarchar | 1 | 0 | | |
10 | JVTMCP_SCHEDULE | IS-M: TMCP Household Addresses for Structures | 9 | XFINISHED | Indicator: Market Coverage Completed | nvarchar | 1 | 0 | | |