| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIncentive and Commission Management ICM |
1 | CACSCP_RCP_BUFF | RCP: Buffer Table for RCP Processing | 7 | POS_ID | Position Number | nvarchar | 4 | 0 | | |
2 | YSVMA_RCP_BUFF | RCP: Buffer Table for RCP Processing | 7 | POS_ID | Position Number | nvarchar | 4 | 0 | | |
3 | YTEL05_RCP_BUFF | RCP: Buffer Table for RCP Processing | 7 | POS_ID | Position Number | nvarchar | 4 | 0 | | |
TOPManufacturer Part Number |
4 | ADPIC_HOLD_MPN | Store MPN subitems for MIGO hold / restore functionality | 3 | POS_ID | Row Index of Internal Tables | int | 10 | 0 | | |
TOPMaster Data |
5 | VDDISBTEMP | Disbursements That Were Not Released | 5 | POS_ID | Row Index of Internal Tables | int | 10 | 0 | | |
TOPMedia Product Sales and Distribution |
6 | JKSDEVENTTEXT | IS-M: Comment Table for Event Management | 3 | POS_ID | IS-M: Counter for Comment Row | nvarchar | 6 | 0 | | |
7 | JKSDSQPEVENTTEXT | IS-M: Comment Table for Event Management | 3 | POS_ID | IS-M: Counter for Comment Row | nvarchar | 6 | 0 | | |
TOPPortfolio Analyzer |
8 | PFAIM_MDATMANU | Master Data: Pos. Managed Externally and Entered Manually | 2 | POS_ID | ID for Positions Entered & Managed Externally | nvarchar | 13 | 0 | | |